Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Deleting old Match Purchase Orders

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Boyd
Advanced Member Send Private Message
Posts: 39
Advanced Member
7/29/2010 6:00 PM
We have Match Purchase Orders that require receipt. Closing these requires toggling between multiple screens, obtaining receiver numbers in PO64.1 and reversing the receivers in PO33. A mass job here capturing the receiver numbers, reversing the receivers and essentially closing the PO’s would be great. If not, a job that could at least automatically capture and reverse the receivers is would be very helpful.
knystrom
New Member Send Private Message
Posts: 2
New Member
8/1/2010 7:50 PM
You can use MA80 or MA180 to archive receivers and this will close the po lines. I have used these programs and you have to be careful. Read up on these programs on My Lawson and make sure you understand what if anything happens to the GL and the RNI PO135 report. I work the RNI report throughout the month. If I have po's that we have not been invoiced for, I look at the receivers (we scan these) and verify we did receive the item. If we received the Item I call the vendor and ask for open invoices for the po and verify they sent the item. If we will not be invoiced for the item and we did receive it, for non stock and special items we create a dummy invoice to match to the po and close it and then create a credit memo to offset the invoice and the entries to the GL. (this process in on mylawson.com) If they are inventory items and we are not charged for them, we have receiving unreceive them and change the po line to a no charge and the line closed when they receive the item back in. We have found if you don't work the PO135 report aggressively you can end up with a mess. Good Luck!
Bill Ianni
Veteran Member Send Private Message
Posts: 111
Veteran Member
8/2/2010 11:22 AM
lLook at PO529. It creates a Receipt file for anything that's open. Then, MA531 loads the Receipt file. You can reverse the receipts by running MA531 with the Adjustment option. However, you will need to designate the quantities in the POO529FILE with a minus (-) sign. Another way to reverse the receipts is to use MS Addin's with the parameter OPERATOR=PO529. Then upload PO33's.
Boyd
Advanced Member Send Private Message
Posts: 39
Advanced Member
8/19/2010 5:13 PM
This worked well for items that were received. We have serveral PO's that are marked as service and do not have any receivers. These items are not included in the MA80/180 job. Any thoughts on easily archiving these items?
DebE
Basic Member Send Private Message
Posts: 8
Basic Member
8/23/2010 8:53 PM
For those lines marked as service type, I created a push in MS Add ons that will cancel the quantity and automatically closes the line. Once that is completed run PO190 and the po will close.
Boyd
Advanced Member Send Private Message
Posts: 39
Advanced Member
9/8/2010 7:01 PM
Thank you for the information. I don't have much experience with PO. Can you send me your upload template or if not point me to the tables/fields that need to be updated?
DebE
Basic Member Send Private Message
Posts: 8
Basic Member
9/9/2010 2:49 PM
Let me put something together and I will send it by early next week