Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Closing Old Received Not Matched PO's

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Brian Berenger
Basic Member
Posts: 11
Basic Member
5/8/2017 5:44 PM
    Hello

    We have a bunch of PO's where payments were made on the PO but the lines were not matched. In other words there is no open amount on the PO and the lines are received. Many of these go back years and years and majority are non-stocks or specials (X,N type) Way back I recall someone telling me about having to create a dummy AP credit and match against that or something along those lines (I'm not an AP person, more a WH/PO/IC and technical person). Due to the huge volume that are out there a manual process would be super ugly so hopefully there are some options.

    Any guidance highly appreciated. Thanks in advance!
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    5/9/2017 8:44 PM
      With Lawson v9 there is a function code on the PO Line called Archive that will archive the remaining open to match quantity and remove it from the RNI. We use it all the time for all item types and no issues.

      For single records, go to PO20, use FC V (Archive) on the PO line, click change. Go to PO64. Line should now be closed, Open to Match Qty should be 0)

      To upload map, Company, Procurement Group (a hidden field), PO Number, PO Release, PO Code, Line Number, FC: V (Archive) and upload as change only.
      Lawsonnubcake
      Advanced Member
      Posts: 25
      Advanced Member
      1/22/2020 3:00 PM

        This was great information as it pertains to a situation I'm currently in. However I have a follow up question in relation.

        First the scenario...

        5 lines on the PO, lines 2-5 were received and matched, line 1 was received and AP did a chargeback leaving the line open, (except in PO64 where it shows matched)

        Your scenario here has proven itself to close the line by archiving line 1 (in test environment), and also make it not show up on RNI report as well (test environment)

        Now all lines on the PO are closed, but the PO is still open...how do you force close the PO so it doesn't show up on any open PO reports?

        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        1/28/2020 10:06 PM
          PO190 should close the header. If not - you'll need to look at the PO99 to see what's going on.

          We run a PO190 nightly - the header closing also affects activity and asset management - but at the very least it should run monthly to keep everything tidy.
          Lawsonnubcake
          Advanced Member
          Posts: 25
          Advanced Member
          2/12/2020 9:27 PM

            I had a webex with Infor. We navigated a multitude of screens to get MNR sorted out. PO64, PO99.2, MA75, AP90.4, PO33, PO20, PO30, AP20, MA43, MA66.3, AP90.4.

            Thanks to you all for helping.