Should you Summarize?

["Paul Holstein" <holstein13@xxxxxxxxxxx>]

I forgot to mention in my previous post, I don't recommend anyone on BPCS 6 
to summarize.  I like to capture important information from the subsystem in 
my reference fields.  For instance, Vendor, Invoice, and Check number.

If you summarize, you lose the ability to tie down individual transactions 
from the Ledger to the Subsystem.  This can make it extremely difficult to 
reconcile the G/L to the subsystem.  With inventory, A/P, A/R, and cash to 
reconcile, it is much better to post in detail.  You can always summarize 
later.

Of course, as you mentioned, the system performance can suffer if you post 
all that detail.  In that case, I would look at performance enhancements 
rather than summarize the journal entries.

I am curious as to other users' opinions.

___ //// _________________________________________________
   |--00               Paul Holstein
   C   ^               E-Mail: pholstein@iworksoftware.com
___ \ ~/ _________________________________________________



----Original Message Follows----
From: Jesus Maynez <bpcsmaynez@yahoo.com>
Reply-To: BPCS-L@midrange.com
To: BPCS-L@midrange.com
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
+---

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.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
+---