Closing old PO's and PO lines

Lawson has a set of tools (Data Verification Toolkit) that will audit your PO's and let you know what needs to be done to clean up your files. If, however, you just haven't completed your receivings then you really need to Cancel Remaining on each PO. You can create a ProcessFlow to run the Cancel Remaining AGS call on the PO's by date range.

If you try to do a receipt on a PO you did the Cancel Remaining on you will get a receiving Buyer Message.

Do you work where I do? This is basically word for word an issue we came across last year when we were starting our upgrade. We were not able to clear them through any system functions. Our last resort was to create paintscreens of PURCHORDER & POLINE. We had to change the MNR quanity, the closed flag and add a close date to POLINE, then we had to go to PURCHORDER and change the number of closed lines to equal the number fo lines. It is not a very quick process, but it was the only way we were able to get them to a closed status. Your scenario may be different, but it sounds just like ours.

Yes I can use paint screens to do this.....I was hoping there was a way to capture an entire date range of PO's and close the buggers! Kind of like what the MA180 will do with writing off/archiving receipts! Thanks for your feedback.

There are Lawson paint screens that were devloped into PO49 forms. There are PO49.1 thru PO 49.9 which are for PO Header, PO Line, PO Receipt Header, PO Receipt Line, etc.

If you use Lawson add ins you could run queries to identify various sets of PO scenarios and then upload changes through PO49 forms.

You just need to remember that PO49 forms don't update other tables so you need to use with extreme caution. Testing first in your test environment is always a good idea.

Have you tried archiving with MA180 (Open Receipt Archive). I believe this is exactly what this form/program was designed to do...??

Hey Sue,

I have worked with many clients over the past few years to write programs that keep the RNI and INR reports clean and your PO220 managable. Biggest issue is defining business rules for these invoices. We have developed processes to close PO by creating an invoice and a credit invoice so that the process of closing a recieved PO is captured in AP incase someone calls looking for it, and we have also developed processes that just put that put the PO's balanace by mosting moving the open qty to cancl qty and closing the PO programitacly. These programs can be date or PO number based and we usually implement a business process to close it on a monthly basis so that it is a rolling 6 month or so report again depending on business requirements on how old a PO can be at your company.

If you would like further info you can email me at kcompton@reveregroup.com. Regards,