RE: BPCS Accounts Problems -- BPCS-L

Mark

We've been on BPCS  about 10 months now.  I had a very hard time figuring
out how to reconcile our accrued payables account, but finally did it.  Some
of my experiences may help you.  

One thing to remember is that purchase order receipts for commodities go
into the general ledger account at the expected cost (pecst).  But purchase
order receipts for BPCS items go in at the cost set you have identified in
your parameters for CST820.  So if you have a mix of both items and
commodities, you must look at both costs to match the ledger.  

Second, do you use any service commodities?  Service commodities do not
generate any PO receipt journal entries since they are automatically
received and do not require an inventory transaction.  If you want them
included in your accrual balance you will have to write a manual journal
entry from a report of uncosted service commodities.  

Third, and I truly hope this did not happen to you.  We had some folks in
purchasing who decided they should change the expected cost on the PO after
the receipt was done if they saw the invoice and the price was different
than expected.  So the receipt was done at one expected cost, but the
expected cost at invoice entry was different.  So debits and credits to the
accrued liability account were different.  They don't do that any more and
just let the purchase price variance functionality do its job.

PO invoices should never be posted to your COGS account.  Check the model
and check the procedures in your payables department if you still think that
is happening.

I can't help with your second question.  We also go through maintain events.
But we have relatively few events of different currencies so it hasn't been
a problem.

        -----Original Message-----
        From:   Mark Curtis [SMTP:mark.curtis@hafele.co.uk]
        Sent:   Wednesday, June 02, 1999 7:44 AM
        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
+---