Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
i have the following tariff scheme: the consumption of certain product is divided in consumption categories, for example
category 1: from 1 to 50, costs $10 each unit category 2: from 51 to 150, costs $11 each unit category 3: from 151 to 250, costs $12 each unit
i tried using pricelists but it doesn't work the way i need it:
if i consume 200 units pricelists give me a total of 200*12=$2400 instead i need the following calculation:
50 * 10 = $500 (first 50 units use cat1 price)
100 * 11 = $1100 (the next 100 units use cat2 price)
50 * 12 = $600 (the last 50 units use cat3 price)
total = $500+$1100+$600 = $2200
so, is there anyway to implement this?
Just compensate each price with the amount you are overcharging for the lower quantities.
A fixed price per unit for 51 and above will overcharge by $1 per unit for the first 50 ($50), so subtract $50.
A fixed price per unit for 151 and above will overcharge by $2 per unit for the first 50 ($100) and $1 per unit for the next 100 ($100), so subtract $200
No Min Qty: Price = Baseprice * ( 1 + 0 ) + 0 Min Qty 51: Price = Baseprice * ( 1 + .1 ) + -50 Min Qty 151: Price = Baseprice * ( 1 + .2 ) + -200
200 units = 200 x $12 minus 200 = $2,200
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 platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 10/24/13, 8:45 PM|
|Seen: 1124 times|
|Last updated: 3/16/15, 8:10 AM|