We are 405 CD mixed mode on V5R1 AS/400 model 170.

   Recently I was tasked with helping reconcile "unvouchered payables" where
   we have received raw material but not yet been vendor invoiced.  I am
   finding lots of problems, wondering how other BPCS places deal with this
   stuff.   The last time I had any formal education in accounting, that was
   maybe 45 years ago.

   We have a General Ledger Account to track this total which never agrees
   with PUR210 total.  These two are off by $ 3 k one day, $ 12 k the next
   (out of grand total around $ 120 k).  We use standard cost, summarize
   inventory to GL.  Our stocking UM is same as selling and purchasing.  We
   are multi-facility.

   PUR210 "standard cost" times uncosted quantity equals "extended" NOT
   always but extended is correct (agrees with CST300) more often than unit
   cost does.  I tried to dig into the logic to figure out what it is doing &
   seems to me it starts with premise that facility costs are to be ignored.

   We have not modified PUR210, but I have a clone PUR210B sequencing the
   report by vendor name, and other readability enhancements.

   As of tonite's input to GL,
   The "corrected" totals (based on CST300 math) are $ 2,827.19 below the
   PUR210 vanilla totals of extended cost.  The GL balance is between the

   I find a few cases of data entry error & try to fix, using negative U & C
   to back out what was done wrong, notifying relevant persons with item #s I
   fixed why, but when a PO line is completed, BPCS won't accept a
   correction, so I use A to correct the inventory, which means General
   Ledger stays off by the el typo.  Can a reason code be added to "A" for
   this kind of scenario to get G/L right?

   New items are typically uncosted until after a successful 3 way match
   completion, then we make standard cost a copy of the actual.  This means
   the purchasing process went into Gen Led at zero cost inventory, with
   material variance through the roof.  It seems to me unreasonable burden to
   intercept A/P invoices on items whose standard cost is zero, do the BPCS
   ACP500 math manually to get standard cost fixed, then go ahead and enter
   the invoices.

   Al Macintyre
   BPCS/400 Computer Janitor ... see

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.