Re: CEA Question

["Chick Doe" <Cdoe@xxxxxxxxxxxxxxxxxxxxxx>]

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