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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Zero price on PO if no...
Finance forum

Zero price on PO if no trade agreement

(0) ShareShare
ReportReport
Posted on by Community Member

Hello everyone,

I understand a vendor's trade agreement price for a given item will trump a standard cost value, and this is what is happening today. What I would like to do is, if a vendor does not have a trade agreement price on an item, I'd like to return a zero cost value back to the PO creation form on the line. I don't know if there's a method which would me to simply find if a given item has a trade agreement price or if there's a setting somewhere which would force a trade agreement price only and throw an error / warning if one does not exist for the given vendor.

Thanks in advance!

Categories:
Development / Customization / SDK
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,259 Super User 2026 Season 2 on at

    Hi DHeisman,

    If you don't setup a purchase price on the item master and don't have an actual price from a certain vendor, the price will already be zero on the purchase order lines. A warning/error should be customized.

    We do offer a data validation framework where such rule can be setup instead of using coding for it.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    On the released products there is a price under the purchase section. I understand that to be an "average cost" of all purchase order costs for this item. And this same cost value appears to be what gets pulled by default when creating a PO line if no trade agreement value exists. I assume a cost is always required so the hierarchy would always fall to this "average cost", and there's no override.

    I apologize for straying a bit off the topic above. In code, I'm currently exploring looking up the trade agreement cost and the standard cost, and if both are the same, then I assume there is no trade agreement cost. I'm extending SalesPurchLineInterface.setPriceDiscMarkup() to do this, but I'm not quite sure how to override the price value in _priceDisc as none of the fields can be accessed directly, nor are there methods available to update.

    Thank you.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,259 Super User 2026 Season 2 on at

    Hi DHeisman,

    The purchase price on the item master is not your cost price and also not related. It can be left blank. Then also ensure that it will not get updated automatically based on the latest purchases. Depending on the inventory costing model, the real invoiced value will be used for costing or a fixed price is you are using standard cost.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    I'm not quite sure why you say the released product purchase price is not related. I may not have been clear.

    When I add a PO line for an item and a vendor who does not have a trade agreement price for that item, I see the PO line populate the price with the released product purchase price. As another point of verification, I modified this price value on the released product and added another purchase order line to verify. Perhaps I misinterpretted your response.

    Thank you. 

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    Apologies for leaving you hanging. After some internal discussions and understanding (getting comfortable) of the purchase cost, we're going with the approach of keeping the purchase cost blank as you had suggested. However, when a new purchase price is activated, that field is populated with the purchase price amount. Is there a configuration which would bypass this feature OR is a modification required to achieve it?

    Thank you!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,259 Super User 2026 Season 2 on at

    Hi DHeisman,

    Apologies from my side. There was an open question. You can disable the Latest price updates for this purpose on the released product details.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans