Service | Customer Service, Contact Center, Fie...

Price Lists - Discount calculations

(0) Share

Report

Posted on by Gene Glenn

125

We need Price List Discount "Scaling"?, not just straight Discount.

Sample current pricing structure.

Base cost on Product is 0.3 cents

Discount

1-500 = .3 cents

501-1000 = .25 cents (.05 Discount)

1001-2000 = .20 cents (.10 Discount)

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

I created Discount Lists, but that does the “Total” calculation based on the total Qty * Discounted price.

Sample, for Qty of 1500, D365 calculates the Quote as1500* (.3-.1) = $300

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

(500 *.3) + (500 * .25) + (500 * .20) = $375

All responses (6)

Answers (0)

Suggested answer

Vilcor 5 on at

Like (0)

Report

RE: Price Lists - Discount calculations

Hello. I don't think your calculations are correct. Partly because it doesn't work that way. In general, if you want to actively engage in discount coupons, you can use discount coupon services. The main thing is not to fall into the hands of scammers, because they often pretend to be representatives of the store and can steal not only your data, but also money from you. Terrible, isn't it? Be careful. Hope this information helps you. It helped me save a lot of money for the Christmas holidays. Good luck to you!
Gene Glenn 125 on at

Like (0)

Report

RE: Price Lists - Discount calculations

With J.C. suggestion, I submitted to Application Ideas at experience.dynamics.com/.../

Thanks much.
JCo 305 on at

Like (0)

Report

RE: Price Lists - Discount calculations

This seems like it has potential.

Please consider raising an idea for this feature so we can better understand if there's demand for this to be included in the product.

experience.dynamics.com/.../
Gene Glenn 125 on at

Like (0)

Report

RE: Price Lists - Discount calculations

So, my Sales/Settings default was set to Per Line, I changed to per Unit and it had no effect on my calculated price.

Base Current Cost .38, tried Quote with a qty 750 (Discount list set to .05 discount on qty 500-1000)

It does the math as .33 * 750 = 247.40 with per Line or per Unit in the setting area.

What I want, should yield ( .38 x 500 ) + ((.38-.05) *250) = 190 + 82.5 = $272.50

Guess I'm looking for options/customizations at this point. Anyone?

Thanks for the input.
Suggested answer

Gabriel Dias Junckes 2,428 on at

Like (0)

Report

RE: Price Lists - Discount calculations

Hi Gene.

You can choose how the discounts are applied, per line (default) or per unit. It might resolve your case.

blog.magnetismsolutions.com/.../discount-calculation-method-for-product-line-items-in-dynamics-365
Community Member on at

Like (0)

Report

RE: Price Lists - Discount calculations

Hi Gene Glenn,

The discount list isn't suitable for this situation. You can use manual discount. Please refer to this thread:

community.dynamics.com/.../quote-products-discount-in-and-mapping-to-manual-discount-field