RE: Accrued AP reconciliation. 4.05 CD

You could write a report based on the HPO file which looks at Qty Received
and Quantity costed fields however we find that there is not enough detail
in a report based on this file.  

We are using 4.03 (MS4 for Y2K) and have a good Accrued Liability
"subsystem" based on ITH transactions.  We extract all transactions that
have a "L" flag in the How to Post to the GL field in the ITH and all "C"
transactions to 2 files, one for receipts and one for Invoices, we then run
a matching program to match receipts to invoices based on Vendor, PO, Item
and qty which then changes the record id to TM for matched so that we only
report on open items.  This is a solution which has been developed in the
company I am currently working for which has large volumes and a shared
service centre setup which means that the ACP Invoice entry is located far
away from the stock receiving locations and thus communication of issues is
sometimes hindered.

I would recommend that you look at the Three Way Match (3WM) product
developed in the UK by SSA Acclaim, now fully integrated into SSA.  This
product gives the ability to match PO Invoices directly to GRN (Goods
Receipt No.) which then link back to PO Lines.  The benefits are quicker and
more accurate matching of purchase orders and improved receipt management
with the creation of a GRN that can be linked directly back to a suppliers
despatch note.  Standardised reports and material status screen enquiries
provide greater detail and ensures accurate 3 way matching - something that
does not exist in standard BPCS.

Rgds
John

-----Original Message-----
From: Zzbpcs@aol.com [mailto:Zzbpcs@aol.com]
Sent: Friday, September 29, 2000 6:08 PM
To: BPCS-L@midrange.com
Subject: Accrued AP reconciliation. 4.05 CD



BPCS 4.05 CD
PO receipts go to the G/L Accrued Accounts Payable account.
AP entry removes it from the Accrued AP account

Other than the "Received But Uncosted POs Report  ( PUR210)" 
on the Purchasing Menu,
is there an 'easy' way to verify / reconcile the dollars remaining in the 
Accrued AP account ?

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