Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / vendor based purchase ...
Supply chain | Supply Chain Management, Commerce
Suggested answer

vendor based purchase price to be shown in purchase order

(1) ShareShare
ReportReport
Posted on by M Saravanan 180
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
 
  • Suggested answer
    Bill Ngo Profile Picture
    Bill Ngo 368 on at
    vendor based purchase price to be shown in purchase order
    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,
     
     
  • Suggested answer
    sagar_patil Profile Picture
    sagar_patil 735 Super User 2025 Season 1 on at
    vendor based purchase price to be shown in purchase order
    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.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,000 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,850 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans