Skip to main content

Notifications

Microsoft Dynamics RMS forum

Add a Column to PO Receipt Screen

Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    RE: Add a Column to PO Receipt Screen

    Still not sure how to modify the data source of the Reorder field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans