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 :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Best discounts to be picked and applied to the order lines.

(0) ShareShare
ReportReport
Posted on by 40

If multiple line discounts are defined through trade agreements, is there any way that system will automatically pick the best discount and apply it to the sales order line.

Currently system is combining the multiple line discounts and calculating the discount percentage and sales price.'

Example:

  • Line discount  agreement 1: Item A To Customer 1 - Line discount at 42%
  • Line discount agreement 2 : Item A to Customer 1 - Line discount at 60%
  • If Item A is included in the sales order then system is showing the discount percentage as 102%.

Any suggestions please?

I have the same question (0)
  • Suggested answer
    AR-01121610-0 Profile Picture
    4,973 Moderator on at

    this depends on multiple settings.

    First be aware there is an option at the trade agreement "find next". If this is set to yes, D365FO will seach for further discount lines and us this in addition to the first agreement line found. So what sense does it make sende setting up two discount". What should happen?

    Second there are parameters at the AR parameters/prices page to determine how different discount type should be combined.

    2021_2D00_10_2D00_20_5F00_20_2D00_47_2D00_03.jpg

  • HarshithaR Profile Picture
    40 on at

    Thanks Andreas for responding,

    In our scenario firstly we are providing the discount to the customers, Later if we get any add on promotional discounts from vendors we want that to be benefited apart to the customer as well, this is the place where second discount is coming into the picture.

    Tried editing the existing discounts but the case is we have multiple combinations for discounts(item to vendor, vendor to group of items) hard to pick the existing and edit them. Because of "find next" enabled system is accumulating the discounts which is not apt solution to us.

    For second parameter as mentioned that is working in a case if line and multi line discounts exist - our scenario is all are line discounts.

    Upon any suggestions please post back.

  • Suggested answer
    AR-01121610-0 Profile Picture
    4,973 Moderator on at

    Hy HarshithaR,

    if you want to show the multiple discounts to the customer I think you need to do a modification.

    Currently you can enter two discounts at the trade agrreement journal of type discount. This will be applied to the unit price. On Sales order it is only visible as the combined discount percentage.

    May be this fullfills your requirement.

    2021_2D00_10_2D00_21_5F00_07_2D00_36_2D00_53.jpg

    2021_2D00_10_2D00_21_5F00_07_2D00_38_2D00_05.jpg

    More options to find the best sales price are given within the Retail and Commerce price engine, which works quite in another way than "traditional" pricing. But it also does not have more options to show multiple discounts to the customer. But you could create different affiliations to model the sales prices with multiple discounts. Not sure whether this would be an option.   

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 141 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 116 Super User 2026 Season 1

#3
Zain Mehmood Profile Picture

Zain Mehmood 89 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans