Re: GL summary records

After stuff is posted to GJH summary record and GJD detail record, the source GJW should be purged in regular BPCS file reorganization.

There's all kinds of GL reports, but none of them show all the data that is stored in GJD records. Unless you are doing summarization where all of a type of transaction for a data entry session goes into total records, there are fields of GJD that point back to customer#s, vendor#s, PO#s, item #s, etc. associated with the transactions. These are not documented or labeled clearly, but if you are familiar with the # systems in your data base, you can look down various columns of what ends up there based on various journal entries & say "Aha, that must be a ninvoice #"

When it is a summary record, you can look in the system paramters to figure out what transactions they came from. There's a place in GL maintenance ... GLD119 in our version, that sets up the rules ... what type of activity in BPCS will flow into what GL Journal prefixes. If you look at the inventory transaction effects, reason codes, and item class codes, you can then see how GL accounts are constructed based on what kinds of transactions, and reverse engineer from there. This will be time consuming.

In our version of BPCS I wrote a modification that does the reverse engineering. It took me like forever to research each thread, then program to have the computer program report show where the data came from. I tried & failed to have our auditors buy the BPCS Guide for Auditors.

Hello,

I'm working on a very old version of BPCS (v3.4A). I have some auditors
here asking if I can give them the detail of a GL summary record. This
record is in the GJE file. From what I can gather this record is posted
from the work (GJW) file as a summary record if the account is marked to
do so. The problem is I can't seem to find a link back to the detail that
made up the summary record. Is the link lost once the entry is posted?

Thanks for any help,
Bill Van Dusen

--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: macwheel99@xxxxxxxxxx