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

Tiered Total Discount

(3) ShareShare
ReportReport
Posted on by 13
Hello everyone, firstly thank you for such a platform to be able to view and ask questions.
 
I wanted some help setting up a tiered Total discount on the Purchase order, where if quantity is X, discount is 40%, and if the quantity is Y, discount is 50%. Currently when I use the Calculate section on the PO, only the first applicable discount of 40% is being applied, even though my quantity thresholds are being met (the from and to in trade agreements for total discount).
 
Here are some screenshots of my setup:

 
 
 
The PO is unable to pick up the 50% in the header (yes, I've tried deleting and adding the line back as well!):

 
 
Any help or pointing me in the right direction will be greatly appreciated. Thank you!
 
 
On a side note, another question I've had is that we have no option of setting up a Total discount whereby it is only applied when a certain PO value is met, say 3000, and anything below 3000 has no total discount? I know we can simply not click on the calculate button, but if I'm able to work out the tiered system, I'd like for the system to auto-pick the Total discounts based on the order value as well, not just the ordered quantity.
I have the same question (0)
  • Verified answer
    Holly Huffman Profile Picture
    6,522 Super User 2025 Season 2 on at
    Tiered Total Discount
    Good morning, afternoon, or evening depending on your location!
     
    Based on your description and screenshots, here are some insights and steps to address the issues:
     
    Issue 1: Tiered Total Discount Not Applying Correctly
    The system is applying only the first discount (40%) despite meeting the quantity threshold for the second discount (50%).
    Steps to Resolve:
    1. Trade Agreement Validation:
      • Double-check the "From" and "To" quantity ranges in your trade agreement setup. Ensure there are no overlaps or gaps between the ranges.
      • Verify that the Total Discount relation is correctly selected in the trade agreement journal.
    2. Calculation Parameters:
      • Confirm that the "Calculate" button is configured to consider all applicable discount tiers.
      • Check the Procurement and Sourcing Parameters to ensure the system is set to apply the highest applicable discount.
    3. Testing:
      • Create a new Purchase Order with quantities that clearly fall within the second tier (e.g., 60 units for 50% discount).
      • Test whether the discount is applied correctly after recalculating.
    Issue 2: Total Discount Based on PO Value
    Currently, there is no option to apply a Total Discount based on the Purchase Order value (e.g., $3000 threshold).
    Suggested Approach:
    1. Custom Trade Agreement Setup:
      • Consider creating a custom trade agreement that includes a monetary threshold for discounts.
      • Use the "Amount" field in the trade agreement journal to define the minimum PO value required for the discount.
    2. Customization:
      • If the standard functionality does not support this, customization may be required.
      • A developer can create a rule to auto-pick discounts based on the PO value and quantity thresholds.
    3. Power Automate Integration:
      • Leverage Power Automate to trigger workflows that apply discounts based on PO value.
    Hope this helps some!
  • CU18040716-0 Profile Picture
    13 on at
    Tiered Total Discount
    Many thanks, @Holly Huffman. Seems it was simply a configuration issue on my part. Much appreciated you taking the time and helping with the reply. Thanks!

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 838

#2
André Arnaud de Calavon Profile Picture

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

#3
Sagar Suman Profile Picture

Sagar Suman 235 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans