Tue, 14 Dec 2021 17:30:21 GMT
–
Dynamics 365 Field Service
–
Needs Votes
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.