RE: CEA Question

["Hasan Ali" <hasana@xxxxxxxxxxxxxx>]

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
+---