Re: Should you Summarize?

I absolutely agree with Paul - DO NOT SUMMARISE.  We implemented BPCS 1
year ago for 4 companies, 1 of which chose to summarise and it was a very
traumatic time trying to reconcile the subsystems with the GL (we have
subsequently changed this for this year).  Having detail in the GL means
you have a one to one match and makes it much easier to trace any possible
"lost" transactions that did not post to the GL (and believe me it does
happen).  We have a recon program that runs on a daily basis checking all
the transactions have posted to the GL and you can only do this if you use
the analysis fields for cross referencing.





"Paul Holstein" <holstein13@hotmail.com> on 08/02/2000 02:15:59 AM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Rosalie Ducasse/ITS/Omnia Group)

Subject:  Should you Summarize?




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






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