RNI Cleanup - PO33 Upload?

Sort:
You are not authorized to post a reply.
Author
Messages
rcates
Basic Member
Posts: 5
Basic Member

    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
    Veteran Member
    Posts: 1020
    Veteran Member
      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
      Veteran Member
      Posts: 1162
      Veteran Member
        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 - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        rcates
        Basic Member
        Posts: 5
        Basic Member
          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
          Basic Member
          Posts: 5
          Basic Member
            Kat V Does this remove it from your accruals?
            rcates
            Basic Member
            Posts: 5
            Basic Member
              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
              Veteran Member
              Posts: 1020
              Veteran Member
                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
                Basic Member
                Posts: 5
                Basic Member

                  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
                  Basic Member
                  Posts: 4
                  Basic Member
                    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
                    Veteran Member
                    Posts: 1020
                    Veteran Member
                      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.