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
Answered

Line discount issue

(2) ShareShare
ReportReport
Posted on by 150
Hello everyone
 
I am facing an issue with 2 different Line discount Trade agreements posted for the same item and same period, however D365 does not pick the best Line discount %.
 
Trade agreement #1: 
 
Party code type: Group
Account selection for Line discount group: TestDIS
Product code type: Table
Item A
Line Discount: 40%
Period:1/8/2024 to 1/8/2025
Find next: No
 
Trade agreement #2: 
 
Party code type: Table
Account selection for Customer: Customer 123
Product code type: Table
Item A
Line Discount: 20%
Period:1/8/2024 to 1/8/2025
Find next: No
 
I created a new Sales order for Customer 123 and added Item A.
 
The Line discount is populated as 20%
 
Now I go to the Sales order header and add the Line discount group as "TestDIS".
 
I toggle the option to "Yes" for  - Transfer settings from the header to the lines Line discount group(attached screenshots), and then click on "Save".
 
Now when I go back to the Sales order lines, the Line discount percent should have changed from 20% to 40% as per the Line discount group, but it still remains as 20%.
 
Please could someone let me know if D365 can populate the best Line discount % as per the above scenario.
 
I have the same question (0)
  • Guy Terry Profile Picture
    28,866 Moderator on at
    Line discount issue
    As mentioned by Adis, this is working as documented. D365 FO will first search for a discount at the Party Code = Table, Product code = Table level. Since it finds one it uses that, and since your 20% trade agreement line has Find next = No, it does not continue searching for a better discount.
     
    If you have Find next = Yes on your T/A lines then I think it would work as you want.
  • Verified answer
    Adis Profile Picture
    5,555 Super User 2025 Season 2 on at
    Line discount issue
    Hey,
     
    In my opinion it works by design. Every table where you enter records from which the information is then pulled works in such a way that the most specific record for your case (line) is being pulled.
     
    Hence, the "Party code type: Table" is more specific than  "Party code type: Group",  The idea is to give a general discount for all customers that are linked to the discount group "TestDIS", in order to apply exceptions you can assign a more specific discount group to a specific customer, what you did.
     
    In your case you can either manually change the discount on the sales line and\or you need to remove the condition  with the 20%. 
     
    Kind regards, Adis

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 406

#2
André Arnaud de Calavon Profile Picture

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

#3
Yng Lih Profile Picture

Yng Lih 149

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans