How do you force close a PO?

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Lawsonnubcake
Advanced Member
Posts: 25
Advanced Member

    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)

    Archiving line 1 (in test environment, 'FC' 'V' and change), has shown to close the line, 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?

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
      You could use Sql to modify the flag in the PURCHORDER table.
      Lawsonnubcake
      Advanced Member
      Posts: 25
      Advanced Member

        Thank you for a quick reply. I have zero SQL experience. There may be someone else in my organization that's on my team to ask about SQL. Aside from that person,any other thoughts or avenue's I could take to do this? Someone mentioned something about 'painting' over, but I don't think PO49-49.9 is accessible...(I think years ago this is where we created any paint overs, can't remember for sure)

        Jay S
        Basic Member
        Posts: 6
        Basic Member

          Have you ran the PO190?  This job closes the Header

          Lawsonnubcake
          Advanced Member
          Posts: 25
          Advanced Member

            That's what I needed to hear. Thank you! PO closed.

            JonA
            Veteran Member
            Posts: 1163
            Veteran Member

              Do you run PO190 as part of your month end close process?

              Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              Lawsonnubcake
              Advanced Member
              Posts: 25
              Advanced Member

                We do run PO190 for month end close. But this MNR process was bigger than I though as I had a webex with Infor to get it sorted out. Many screens were utilized to get it right and closed correctly.