Re: CEA Question

the file GCR is the cross reference between the external account number 
(segment values) and the internal account number. most of the balances and 
activity are kept in the G/L file using the internal account number. select the 
desired GCR record using the segment values that you are interested in and join 
to the various G/L file by internal account number field (GCIAN). 

chick doe
barton instrument systems

>>> tshaw@felkerbrothers.com 04/12/01 07:45AM >>>
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
+---