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

Community site session details

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

Trade agreement for purchase price, when creating two different prices depending on the ordered quantity

(0) ShareShare
ReportReport
Posted on by

Hello, Dear community,

Please, Could you help me with this?

I'm using trade agreements to define purchase prices for items:

Example:

For vendor A, Item B and for a quantity from 1 to 100 the unit price is 50$ (without any other specification of inventory dimension in the trade line)

For same vendor A, same Item B and for a quantity from 101 to 500 the unit price is 45$ (without any other specification of inventory dimension in the trade line)

When I created a purchase order for the vendor A, I've added two lines with the same item B:

First line: I ordered quantity of 60 units so the price unit displayed was 50$ 

Second line: I ordered quantity of 70 units so the price unit displayed was also 50$

Is there a parameter that can we change in the system, so it will update the unit price in both of the lines to 45$ (because I've ordered in total 130 units)

I 've noticed that we can do that with multiline discount (but that's only for the discounts, not the unit prices), If it's out of the box and the system works line by line, is there a solution to workaround this? 

Thank you in advance, 

I have the same question (0)
  • Suggested answer
    huijij Profile Picture
    19,811 on at
    RE: Trade agreement for purchase price, when creating two different prices depending on the ordered quantity

    Hi Iheb,

     

    According to the question you mentioned, you can consider using total discount to achieve this.

     

    The total discount trade agreement type is a discount that is applied to the entire order amount. You can set a total discount amount or a discount percentage. Unlike the multi-line discount, you do not need to click the calculate button for the discount to be applied, the system will do it as soon as the trade agreement conditions are met.

     

    You can check out the total discount section in the link with relevant examples that you can use to create the trade agreement you want.

    https://dynamics-tips.com/trade-agreements/

    1488.png

    4578.Capture.PNG

    Best Regards,

  • Dogan Adiyaman Profile Picture
    690 User Group Leader on at
    RE: Trade agreement for purchase price, when creating two different prices depending on the ordered quantity

    Hi, there is no such thing, you have to use multi-line discount.  You may consider to combine order lines to be able to use a new trade agreement for the quantity more than 130 lines.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,056

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans