RE: CEA Question

All financial journals in BPCS are kept in the GHH (journal header) and GLH (journal lines) files. The GLH file contains two reference, and two description field that can, with the use of macro's, be filled with all kinds of data during the journal creation.  By example these field can be used for reference to vendor / customer name, order number and purchase order number. The GLH file contains an internal account number which in the GCR file can be related to various segment value combinations (the segment string). Next to the GHH and GLH files BPCS also contains a file for additional references (GLA). This file contains another 6 fields available for references which can be filled with macro's . The GLA file is one on one related to the GLH file.

Another  file in BPCS , the GXR file,  contains journal – subsystem cross references. This file  which can be linked to the GLH or the GHH file depending on the kind of subsystem, contains the needed reference to the invoices you want to get back to.  

Hope this helps you out,

 

Menno Krijgsman

Sagax Software Consultants, the Netherlands

menno.krijgsman@sagax.nl

 

 -----Original Message-----
From: Terri Harteau [mailto:tshaw@felkerbrothers.com]
Sent: donderdag 12 april 2001 16:46
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.
------------------------------------------------------------------------------------------------------------------