Terri,
The required details are available from the following files.
GCR, GSV, GLH
GCR: Stores the internal account numbers and the account string (in terms of
the segment values).
GSV: Stores the segment values for all the segments that are defined in the
chart of accounts.
GLH: Contains the detail journal vouchers processed against individual
account strings.
You need to link GSV file to GCR and GCR to GLH
GSV.SVSGMN=’ACCOUNT’ Or whatever is the Segment ID for Natural
account. (you may qualify the Char of A/c as well).
GSV.SVSGVL = GCR.CRSG0x (CRSG0x is the natural account segment field in
GCR)
GCR.CRIAN = GLH.LHIAN (the internal A/c fields in GCR & GLH)
Selecting the appropriate fields from GLH can give you the Amounts in Book
or Transaction currency.
You’d need to filter the required Ledger, Book, period etc from GLH.
Regards,
Hasan
-----Original Message-----
From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On Behalf
Of Terri Harteau
Sent: Thursday, April 12, 2001 10:46 AM
To: bpcs-l@midrange.com
Subject: CEA Question
Hi,
Has anyone figured out the files used in CEA? I have an account number I
would like to get the detail on using a query product. I'm having a problem
finding our account number in any of the BPCS file beginning with a G. The
account is generated at billing and at AP vouchering. I want to get back to
the individual invoices that created this entry. I know there is an internal
account number that comes into play, but I'm not even sure what files to
look at. I would appreciate any help you have. Thanks.
Terri Harteau
tshaw@felkerbrothers.com
Felker Brothers Corp.
----------------------------------------------------------------------------
--------------------------------------
Whoever said nothing is impossible never tried slamming a revolving door.
----------------------------------------------------------------------------
--------------------------------------
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---
