RE: BPCS Accounts Problems

Ideally, that's what you want it to equal. Because CEA is completely
end-user configured, however, it's possible that models other than the ones
you intended are writing to the account. If the numbers are strange, look at
the journal source code and reason code on the journal records and verify
that only the receiving transaction (U or LL) from INV920 (entered through
PUR550) and AP Invoice (ACP500) transactions are going into that account.

Another area of confusion is that the AP invoicing program is usually used
to relieve the Accrued AP Liability account not the C transaction in the ITH
file, which should be set to 'Bypass Journal' in Subsystem Event
Determination. The C transaction is created at the time of AP invoice entry,
but in order for the AP invoice transaction to balance, most people relieve
Accrued Liabilities by the posting of the invoice, not the posting of the
inventory 'C' transaction. The questions become:

"How do I reconcile the inventory subsystem receiving transactions (ITH) to
the GL (GLH)?"
"How do I reconcile the AP subsystem transactions (ASD) to the GL (GLH)?"
"How do I reconcile my inventory subsystem (ITH) with my AP subsystem
(ASD)?"
"How do I reconcile my PO status (pqrec - pcqty) with my inventory
transactions (ITH)?

Some reconciliation points:

pqrec = SUM('U' transactions from ITH)
pcqty = SUM('C' transactions from ITH)
(pqrec * Std Cst) - (pcqty * Std Cst) = ('U' transactions * Std Cst) - ('C'
transactions * Std Cst)
Credits to Accrued Liabilities = SUM('U' transactions from ITH)
Debits to Accrued Liabilities = SUM(ASD records where the SDSG01-14 column
corresponding with your natural account segment equals your Accrued
Liabilities Account #)

Start by reconciling subsystem transactions and correcting them using the
subsystem rather than DFU or SQL. This will naturally clean up the journals.

Complicateder and complicateder.

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com
PrimeSource Technologies
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM
 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  Curtis
.  Sent: Wednesday, June 02, 1999 11:41 PM
.  To: BPCS-L@midrange.com
.  Subject: RE: BPCS Accounts Problems
.
.
.  Thanks for the tips.
.
.  Will be using the P.O. # / line # as statistics ASAP, should
.  help in future.
.
.  For now can somebody confirm that the accrued liability account
.  should equal
.  (pqrec - pcqty) * standard from CMF.  We only use BPCS items (no
.  commodities
.  etc).
.
.  ALSO
.
.  Nobody got any ideas on question 2 regarding f.c. rounding ?
.
.  Rgds
.  Mark Curtis
.
.  PS For info we are using 6.0.04 Sep 98 / HP-UX / Informix
.
.
.
.  -----Original Message-----
.  From:        Mark Curtis [mailto:mark.curtis@hafele.co.uk]
.  Sent:        02 June 1999 13:44
.  To:  'BPCS-L@midrange.com'
.  Subject:     BPCS Accounts Problems
.
.  I have a question for all you clever folks out there;
.
.  We are a recent convert to BPCS (2 months) and have a couple of
.  question in
.  the finance area but can get no sensible answers from our usual
.  contacts :
.
.  Question 1
.
.  We run the usual 3 way may on purchase orders using a single accrued
.  liability account.
.
.  If I value the contents of HPO received not costed (pqrec -
.  pcqty) * pscst
.  OR (pqrec - pcqty) * standard from CMF I get a very different
.  figure to the
.  one shown in the general ledger account.
.
.  I guess some PO invoices have been posted as expense invoices
.  direct to our
.  'cost of sales' account.
.
.  Is it sensible to journal of the discrepancy between the recd. not costed
.  and accrued liability or am I missing something ?
.
.  Question 2
.
.  When posting foreign currency invoices we get a large number (10
.  % ish) that
.  when converted to base currency (GBP) leave debits and credits
.  out by more
.  than 1p.  Anything out by a penny is rounded by the system for us.
.
.  Does anyone know of any 'tricks of the trade' to help, as
.  currently we have
.  to use maintain events and manually correct the journal (not the
.  fastest job
.  in the world)
.
.  Regards
.  Mark Curtis
.  IT Director
.  Hafele U.K. Limited
.  Tel : +44 (0)1788 542020
.  Fax : +44 (0)1788 541860
.  email : mailto:mark.curtis@hafele.co.uk
.  Web : http://www.hafele.co.uk
.
.
.  +---
.  | 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
+---