RNI Cleanup - PO33 Upload?

 9 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
rcates
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1163
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 Send Private Message
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 Send Private Message
Posts: 5
Basic Member
Kat V Does this remove it from your accruals?
rcates
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.