PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/12/2020 4:27 PM by  Lawsonnubcake
Closing Old Received Not Matched PO's
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Brian Berenger
Private
Private
Basic Member
(23 points)
Basic Member
Posts:11


Send Message:

--
05/08/2017 1: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2612 points)
    Veteran Member
    Posts:892


    Send Message:

    --
    05/09/2017 4: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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    01/22/2020 10:00 AM

    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2612 points)
    Veteran Member
    Posts:892


    Send Message:

    --
    01/28/2020 5: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
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (51 points)
    Advanced Member
    Posts:21


    Send Message:

    --
    02/12/2020 4: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.

    You are not authorized to post a reply.