Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor Base Price
Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor Base Price

(0) ShareShare
ReportReport
Posted on by KellenWise 9
Hello,
 
My company has several requirements around pricing.  
1. Vendor base price  -  the company needs to update a base price that would be for all vendors/site/wh/items combination on a monthly basis.
      - trade agreements wont work because its one agreement per vendor, the vendor needs just a base price (commodity for metal) then add additional vendor specific pricing on top  of that. Trade agreements is one agreement per
      - Anyone know of a way to have two costs associate on a purchase order?
             - would the only way is export monthly a trade agreement (maybe leave monthly unposted lines for each vendor) export that monthly, update the vendor specific agreement pricing with the monthly commodity price, import that in, post,                       and the one agreement will include monthly base and the annual vendor specific pricing
              - does a positive discount group? 
2.  Using the new pricing management module is really confusing and even though says base price version and vendor list price, those are only for the customer pricing.  
     - the vendor price list, anyone know of a way to link that towards the vendor pricing agreements? Too me it appears no relationship so I would have to load figure out my vendor price list (first question), export monthly, then reimport into the vendor price list in new module, add my margin on top, calculate in the base price version for that functionality to work
 
Any ideas without customization would be must appreciated.  
 
 
Thank you,
  • Suggested answer
    Community member Profile Picture
    Community member 32 on at
    Vendor Base Price
    Hi 
    Base price version calculates three different prices. Base price inventory, Base price sales and Base price purchase price. Base price purchase price is used in purchase orders. Any of the three could be used as the basis for sales prices.
     
    Base price version is calculated using the following:
    - Vendor list prices. This is the vendors list price (before discounts/allowances) per vendor, per item. Site is optional. 
    - Vendor price term agreements. This represents different pricing terms that can impact (positive or negative) the Vendor list price. Site is optional. Term agreements can post individual terms (term codes) to different ledger accounts if required.  
     
    Base price version calculation stores the Base price purchase price (Per Site, Site is mandatory), and is retrieved when the combination of Vendor account, Item and Site matches in the PO line. 
     
    A vendor list price & price term agreement would need to be created for each vendor x item (and Site, if Site prices/terms are different). Data entities are available for import via DMF.  
     
    All pricing (list price, term agreements, base prices) are date controlled. 
     
    Hope this can assist with determining if the pricing module can provide the solution you are after.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Vendor Base Price
    You likely won't find the functionality you need out of the box.  We're doing a customization to Trade agreements for a client now who needs "Mode of delivery"-based pricing per item/vendor combination.  There may also be an ISV product that meets your requirements as noted by Hana.
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Vendor Base Price
    Hi,
    There are limitations to the standard functions. For your specific needs, you can find a third-party partner in this link for customization. Find the right app | Microsoft AppSource   or wait for responses from other experienced experts.
    Best Regards,
    Hana

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans