• Subject: RE: CEA Question
  • From: "Hasan Ali" <hasana@xxxxxxxxxxxxxx>
  • Date: Thu, 12 Apr 2001 13:03:37 -0400
  • Importance: Normal


The required details are available from the following files.

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


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

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

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page