web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS - Inter-Store Tran...
Microsoft Dynamics RMS (Archived)

RMS - Inter-Store Transfers customizations.

(0) ShareShare
ReportReport
Posted on by Daniel Mesquita 295

I'm trying to modify the Inters-Store transfers print outs and ADD the regular price of the entries (not the cost) being transferred. Modifying the file POXfr.xml, I managed to display other information about the entry (like the sub-description 3 that we use here in our system), but I can't find the right "field" in the array for the price.  This is the part of my XML file displays the right info about the entries:

<FOR each = "PurchaseOrderEntry">           
   <ROW>PurchaseOrder.Entry.QuantityOrdered "|" PurchaseOrder.Entry.LookUpCode "|" PurchaseOrder.Entry.Description "|" PurchaseOrder.Entry.SubDescription3 </ROW>        
</FOR>

 Does anybody know how can I do this?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Try PurchaseOrder.Entry.ItemPrice

  • Daniel Mesquita Profile Picture
    Daniel Mesquita 295 on at

     Hey Matt, thanks man it worked... that was easy!!

  • Community Member Profile Picture
    Community Member on at

    Any idea how to add a column for extended ItemPrice?  I tried ExtendedItemPriceReceived and get an error when running the report.

  • Alwani Profile Picture
    Alwani 710 on at

    Did you try:

    Purchaseorder.Entry.ExtendedPriceOrdered

    Supplier's price for all ordered quantities of the item in the specified purchase order entry.

    Purchaseorder.Entry.ExtendedPriceReceived

    Supplier's price for all received quantities of the item in the specified purchase order entry.

    Purchaseorder.Entry.ExtendedPriceRTD

    Supplier's price for all quantities received to date of the item in the specified purchase order entry.

  • Community Member Profile Picture
    Community Member on at

    What I'm after is extended retail price(ItemPrice not UnitPrice.)  Looks like all these refer to cost and not retail.

  • Alwani Profile Picture
    Alwani 710 on at

    PurchaseOrder.Entry.ItemPrice : Price at which the store sells the item in the specified purchase order entry.

    Purchaseorder.Entry.UnitPrice : Supplier's price for a single unit of the item in the specified purchase order entry.

    I HOPE THIS WILL WORK FOR YOUR.

  • Community Member Profile Picture
    Community Member on at

    I understand that however what I am trying to do is change the PurchaseOrder.Entry.ExtendedPriceReceived which is the extended cost(supplier price times quantity received to reflect extended retail price(selling price times quantity received.)  I tried PurchaseOrder.Entry.ExtendedItemPriceReceived which did not work as well as PurchaseOrder.Entry.ExtendedItemPrice...also didn't work.

  • Alwani Profile Picture
    Alwani 710 on at

    First time you said you want to show the files, which I already listed you but now you are saying you wanted to change the price, what exactly you mean do you want to some update to database?

    "I'm trying to modify the Inters-Store transfers print outs and ADD the regular price of the entries" These are your wording

  • Community Member Profile Picture
    Community Member on at

    Akber...if you'll notice the quoted text you're referencing is from another user not me.  I found this thread because I was also looking to ADD that info as well as adding the Extended Retail Price.  I have the ItemPrice I am just looking to add ExtendedItemPrice.  Thank you for your help.

  • EkS Profile Picture
    EkS 25 on at

    Hi All,

    Does anyone know How can I get the UnitOf Measure of Item to show in PO.xml or POfr.xml?

    <FOR each = "PurchaseOrderEntry">          

      <ROW>PurchaseOrder.Entry.QuantityOrdered "|" PurchaseOrder.Entry.LookUpCode "|" PurchaseOrder.Entry.Description "|" <<Unit of Measure?????>> </ROW>        

    </FOR>

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans