Add a Column to PO Receipt Screen

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I'm needing to add a column to the PO Receipt in Store Operations. We use Oracle EBS, and currently don't have a column for the Item Number. I've looked at the PO.xml and am unsure where or how to modify the code to add that column. Any tips?

*This post is locked for comments

All responses (6)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

You said you believe the process being used here with RMS is creating the Items in Oracle EBS and inserting them into RMS. If so, your programmer would have tables and triggers set up already to do this for the other RMS Item fields, and they should be able to replicate this process to insert the EBS Item # field into the Reorder # field.

If not, then I would need to do some actual consulting for you to see that you are doing now, and what needs to be done to accomplish what you want to do to improve yourprocesses to save time and errors.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

Still not sure how to modify the data source of the Reorder field.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

After loooking at the Receive screen, the Reorder No. field would be perfect, as it seems like we don't use it. How does one go about "inserting" the data into that field? Will I be editing an XML file? If so which one?

Thanks.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

Sorry, don't know the custom programming, but I can direct you if no one answers. I am a Business Roles and Processes, Operations etc. analyst and consultant, and can often show people how to use different systems much better right off-the-shelf. Then if a customization is needed, I can help figure out the requirements.

Most of my customers insert the Item Number from the ERP into the ILU field in RMS. Would be difficult to reset the process? Or to insert it into the Supplier Reorder # field if you don't use that a lot, since that already shows up on the PO window as well?

If not, we had the process of adding an existing RMS field to the PO and Transfer windows outlined for a customer who was sure he would need it, so I suppose the programmers would be able to add another. Or maybe use the ALU field?

He didn't end up doing it after I showed him how to set up his items with Logical ILU's and descriptions and he was able to identify his items sufficiently in the POS, PO and Transfer windows without adding custom programming.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

I would be adding the column to the Receiving screen so that I can see and reference those EBS Item numbers. We are creating the items in EBS and inserting them I believe.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add a Column to PO Receipt Screen

Are you talking about adding the column to the Receiving screen so you can see and reference those EBS Item numbers, or for a Receiving voucher document for printing, or both?

And are you running this like most of my customers with large-scale ERP integrations where the Items are created in the ERP and inserting them into RMS, or are you creating them in RMS and just passing certain data back to EBS?