Deleting old Match Purchase Orders

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Boyd
Advanced Member
Posts: 39
Advanced Member
    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
    Posts: 2
    New Member
      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
      Posts: 111
      Veteran Member
        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
        Posts: 39
        Advanced Member
          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
          Posts: 8
          Basic Member
            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
            Posts: 39
            Advanced Member
              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
              Posts: 8
              Basic Member
                Let me put something together and I will send it by early next week