Account Inquiry, Period Detail, Query

[Jesus Maynez <bpcsmaynez@xxxxxxxxx>]

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