Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Pricelist rule price calculation formula

By
Shahar Or
on 4/24/13, 7:53 AM 1,938 views

Hi,

I think I don't get. I think that because I'm not getting expected results and documentation's example is confusing me.

New Price = Base price * ( 1 + X ) + Y

So, for example, if base price is cost price which is 10, X is a %50 margin I want and Y is 0 so:

New Price = 10 * ( 1 + 0.5 ) + 0
New Price = 10 * 1.5 + 0
New Price = 15

Is this correct, please?

The example in the above linked documentation is beyond my comprehension:

Also note that to fix a price of 60 for the 5 Berrel Keyboards, the formula Price = Base Price x (1 + 1.0) + 60 has been used.

So if Base Price is, like in the example, 100, then:

Price = 100 * ( 1 + 1.0 ) + 60
Price = 100 * 2 + 60
Price = 200 + 60 = 260

But they wanted it to be 60. So I don't get it...

1

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 4/24/13, 9:23 AM

I just read the documentation you linked to.

I am under the impression, that there is a small typo. If you change the 1 to -1, it reads:

50 * (1 + -1) + 60 = 50 * 0 + 60 = 60

or

100 * (1 + -1) + 60 = 100 * 0 + 60 = 60

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/24/13, 7:53 AM
Seen: 1938 times
Last updated: 3/16/15, 8:10 AM