|
GCR file will give you the IAN link. GHH is the journal header file. GLA is the journal analysis line file. This should get you what you need. Mark ----- Original Message ----- From: Jesus Maynez <bpcsmaynez@yahoo.com> To: <BPCS-L@midrange.com> Sent: Monday, February 07, 2000 11:29 AM Subject: Account Inquiry, Period Detail, Query > > Hello Everybody > > I'm struggling pretty bad trying to make a query to > get the same information that appears in the Period > Detail Windows from the Account Inquiry. > By mistake, we did not summarized the Journal Entries > for this year, then we have thousands of lines for the > first two weeks of January. When we try to get this > information through the Account Inquiry is taking > forever. Then, I tough on create a query and get the > information directly from the files. > I found out, Journal Entries are in the GLH file, > however I do not how to make reference to the Event > Number and Account Number. This files has a IAN > Internal Account Number, I'm pretty sure this field > can be used to link the Event Number and Account > Number, but I dont know in what other files I have to > look up. > > I hope you can help me out. > > Thanks > Jesus Maynez > __________________________________________________ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com > +--- > | 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 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.