Skip to Content
Menu
This question has been flagged
1 Reply
2150 Views

Hallo all,

I have following scenario:

Define Pricelist in this way:


Open the "Other Pricelist":





When I now create a Sales Order I see this price calculated:


In my opinion this is wrong. I expect to see following price: 128,25.

You get this by first getting 10% from €150,00 which is €135.

Then get 5% of from €135,00 which is then €128,25

Is my calculation wrong?

Thanks in advance for your help.

Thanks and greetings

Michael


Avatar
Discard

The ordering of the pricelist maybe important here, as I think the calculations are done sequentially based on the pricelist rules. Have you tried switching them around in the list?

Author
Hello,
thanks for your advise. I did this but this did not the trick. The only way I get the correct Unit Price calculated in my opinion is when using for both pricelists the configuration:
image.png

I expect that independent of using the Discount policy when using the same discounts that I get the same result.
Thanks and greetings
Michael

Am Mi., 18. Jan. 2023 um 12:03 Uhr schrieb Lindari Solutions <notifications@mail.odoo.com>:
The ordering of the pricelist maybe important here, as I think the calculations are done sequentially based on the pricelist rules. Have you tried switching them around in the list? ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​

The ordering of the pricelist maybe important here, as I think the calculations are done sequentially based on the pricelist rules. Have you tried switching them around in the list?


Odoo S.A.

+32 81 81 37 00 | info@odoo.com | https://www.odoo.com

Powered by Odoo

Best Answer

Hi Michael,

Please check this calculation.

Let sales price of product1 is x.

p1 is the 1st pricelist: discount 10%(based on sales price)
             rounding .1
             so price of product  v1=(X * 10)/100
             round(v1)

p2 is the second pricelist: discount 5%(based on p1)
                 rounding 10
                 so price of product v2= (v1*5)/100
                 round(v2) based on 10

Regards

Avatar
Discard
Author

Hello,
thanks for your update.
When I calculated the price following your logic I get this price:
Unit Price €150,00
Discount 1 10%
Discount 2 5%

First price list will calculate a new price by this:
150 - (150*10)/100 = 135

So will now take the new calculated Unit Price:
135 - (135*5)/100 = 128,25

This is what I would expect. But the code is calculating 130,01 with a displayed discount of 13,33%

Thanks for your help.
Greetings
Michael

Related Posts Replies Views Activity
1
Dec 24
818
0
Apr 24
245
1
May 23
1193
1
Nov 22
4771
0
Aug 22
740