Price Lists - Alternate Discount calculation method needed.

We need Price List Discount "Scaling/Tiered"?, not just straight Discount on total quantity.


Sample current pricing structure.

Base / Current Cost on Product is 0.3 cents

Discount Levels created

1-500 = 0.3 cents

501-1000 = 0.25 cents (.05 Discount)

1001-2000 = 0.20 cents (.10 Discount)

2001 – 10000000 = .18 cents (.12 Discount)



I created Discount Lists, but currently the “Total$” calculation is based on the total Qty * Discounted price.

Sample, for Qty of 1500 of this Product, Doing a Quote in D365 calculates as 1500* (.3-.1) = $300

Our current accounting system does the math as below. Trying to mimic this in D365.

All the calculation data in the defined discount lists, just need to do the math differently!

This is the math we need!
(500 *.3) + (500 * .25) + (500 * .20) = $375


Thanks for considering.