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.
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,
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.