PO Confirmations and Auditing

Stace Webley

I would like to hear how other organizations are recording PO confirmations within Lawson and if you are putting confirmations in Lawson how are you auditing those for expediting and follow-up?

We are currently putting confirmations in the Comments to Print on Purchase Order option for the PO after we get them and are thinking about using an SSIS package to query comments and send a daily e-mail to buyers showing which PO's don't have a confirmation recorded from the day before. Not sure this is the best way...now we do have GHX, but of course that only accounts for EDI orders. We don't have a lot of MetaTrade, but then again the vendor has to manually confirm those which doesn't always happen. Either way Lawson doesn't pull the confirmation number from the 855 and put it on the PO anywhere. The only way that I am aware of for knowing a PO has been acknowledge in Lawson is by looking at PO66.1 PO Revision History. Thanks in advance for your responses.

[Updated on 11/5/2014 10:07 AM]

Legacy Contributor

We use a PF to parse our EDI file from GHX and pull 855 data. That info is then put into USERFIELD 2 in the PO header. Each time the job runs, an email is sent to our purchasing group so they can double check the info. Other ways, we have a COGNOS report that runs every night checking against that USER Field 2 = "" and the buyers work that report each day. It is a simply audit process because we can track average PO confirmation turnover based on the day before #, the next day#, and the volume of POs.