PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/12/2020 4:29 PM by  Lawsonnubcake
How do you force close a PO?
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lawsonnubcake
Senior Supply Chain Analyst
Private
Advanced Member
(58 points)
Advanced Member
Posts:24


Send Message:

--
01/22/2020 10:08 AM

    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
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    01/22/2020 10:56 AM
    You could use Sql to modify the flag in the PURCHORDER table.
    Lawsonnubcake
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (58 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    01/22/2020 11:38 AM

    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
    Application Analyst III - Lawson
    Sutter Health
    Basic Member
    (15 points)
    Basic Member
    Posts:5


    Send Message:

    --
    01/22/2020 3:26 PM

    Have you ran the PO190?  This job closes the Header

    Lawsonnubcake
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (58 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    01/23/2020 9:35 AM

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

    JonA
    Private
    Private
    Veteran Member
    (3179 points)
    Veteran Member
    Posts:1121


    Send Message:

    --
    01/28/2020 12:04 PM

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

    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Lawsonnubcake
    Senior Supply Chain Analyst
    Private
    Advanced Member
    (58 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    02/12/2020 4:29 PM

    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.

    You are not authorized to post a reply.