PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/09/2017 5:26 PM by  Kat V
RNI Cleanup - PO33 Upload?
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
rcates
lawson team
Private
Basic Member
(13 points)
Basic Member
Posts:5


Send Message:

--
12/16/2016 9:53 AM

    Hi,

     

    I'm trying to clean up RNI and back out receiving--anyone have an upload for PO33 they wouldn't mind sharing?

     

    Thanks!

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    12/19/2016 8:02 AM
    We don't upload to PO33. We upload FC V(Archive) to the PO Line on PO20. This will close the PO line and remove the RNI, instead of PO33 to remove the receipt and then having to cancel the PO line.
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    12/19/2016 3:28 PM
    If a lot of lines were received in error it might be beneficial to do an upload to PO33 but you can't release the documents with Addins.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    rcates
    lawson team
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    12/22/2016 1:52 PM
    Thanks Jon--I don't mind releasing it manually, but I want to upload the adjustments. Do you have an upload to create the line adjustments?
    rcates
    lawson team
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    12/22/2016 1:55 PM
    Kat V Does this remove it from your accruals?
    rcates
    lawson team
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    12/22/2016 2:03 PM
    Posted By JonA on 12/19/2016 3:28 PM
    If a lot of lines were received in error it might be beneficial to do an upload to PO33 but you can't release the documents with Addins.

    Thanks Jon--I don't mind releasing it manually, but I want to upload the adjustments. Do you have an upload to create the line adjustments?
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    12/22/2016 2:55 PM
    Yes, uploading FC V to PO20 stops the accruals from the monthly PO135.

    Map for that is:
    _f4, PCR-COMPANY
    (H)_f5 PCY-PROCURE-GROUP
    _f12 PCR-PO-NUMBER
    _f31 PT-PLI-LINE-NBR
    _f223:0 LINE-FC1

    I'm on v10.0.6 so check field numbers.
    rcates
    lawson team
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    12/23/2016 12:50 PM

    Thank you so much! You may have saved as a TON of time

     

    Becca

     

    Posted By Kat V on 12/22/2016 2:55 PM
    Yes, uploading FC V to PO20 stops the accruals from the monthly PO135.

    Map for that is:
    _f4, PCR-COMPANY
    (H)_f5 PCY-PROCURE-GROUP
    _f12 PCR-PO-NUMBER
    _f31 PT-PLI-LINE-NBR
    _f223:0 LINE-FC1

    I'm on v10.0.6 so check field numbers.



    Tanya_D
    Consultant, Managing
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:4


    Send Message:

    --
    01/03/2017 8:42 AM
    Kat,

    What table did you use to run the query in order to get the criteria for the upload? Or, did you just go to the PO20 screen and determine what fields are required? Do you not need a release number? I'm wanting to build an upload template for my client as I've run into this issue at many places. Thanks.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    01/09/2017 5:26 PM
    We do not use release numbers here, but yes, if there are release numbers, they will have to used. You'll also need PO Code if necessary. We created the map by going to PO20 and figuring out the fields we were touching. For PO20 the only "gotcha" is the hidden Procurement Group, but we've only got the one so it's not a big issue for us.

    You are not authorized to post a reply.