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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

vendor based purchase price to be shown in purchase order

(2) ShareShare
ReportReport
Posted on by 244
Dear members,
 
Kindly help me to meet my requirement in the matter referred below.
 
Consider that I am making a purchase order for an item "X". I had purchased the same item with multiple vendors. When I am creating a new purchase order, the item's unit price is auto populated(based on the last purchase price). But I need the purchase price to be populated based on the vendor which I purchased from him last. In simple words, If I purchase the item 'X' for an amount "Y", this amount has to be displayed when I choose that vendor.
 
Is there any inbuilt functionality exists that will help me out to meet out my requirement ? Is there any setups that has to be enabled to make this happen ?
 
Thanks in advance,
M Saravanan
 
I have the same question (0)
  • Suggested answer
    sagar_patil Profile Picture
    918 Super User 2025 Season 2 on at
    Yes. You can make of Trade Agreement Journal.
     
     
    Account selection use - Table and select the desired vendor and Item combination.
     
    Note: Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
  • Suggested answer
    Bill Ngo Profile Picture
    372 on at
    Hi,
     
    Current purchase price can be supported for purchase orders by following functions:  
    - Option 1: Default Purchase Price on Item Master
    - Option 2: Purchase Price Type Trade Agreement Journals
    - Option 3: Purchase Agreements
     
    And last purchase price is supported only for master items not relating to vendor. If your company usually works with a single vendor for each item, this approach populates automated lastest prices on the purchase order lines. But if you use a different vendor, you’ll only have to manually adjust your purchase order lines. Can not approach latest price of each vendor.   
     
    Conclusion: All the above functions are not available for your requirement (purchase price to be populated last purchse price based on the vendor).
     
    Therefore, you need a customization for this requirement.
     
    Bill
    Rgds,
     
     

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…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 118 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans