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 Send Private Message
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 Send Private Message
Posts: 510
Veteran Member
You could use Sql to modify the flag in the PURCHORDER table.
Lawsonnubcake
Advanced Member Send Private Message
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 Send Private Message
Posts: 6
Basic Member

Have you ran the PO190?  This job closes the Header

Lawsonnubcake
Advanced Member Send Private Message
Posts: 25
Advanced Member

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

JonA
Veteran Member Send Private Message
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 Send Private Message
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.