Example for calculation of Sales price
Purchase Price Markup % Avg purchase cost/unit Selling cost/unit Units for Rs 1000 purchase Selling cost
0.01 - 1.00 10% 0.5 0.55 2000 1100
1.01 - 3.00 9% 2 2.18 500 1090
3.01 - 6.00 8% 4.5 4.86 222.2222 1080
6.01 - 15.00 7% 10 10.7 100 1070
15.01 - 35.00 6% 25 26.5 40 1060
35.01 - 100.00 5% 67 70.35 14.92537 1050
100.01 - 250.00 4% 175 182 5.714286 1040
250.01 - 600.00 3% 425 437.75 2.352941 1030
600.01 - 1000.00 2% 800 816 1.25 1020
1000.01+ 1% 1000 1010 1 1010
Sales price for a product is entered manually at the time of receiving a new batch of products.
Can you please let me know how we can achieve this as we need some formula for the same.
And also we need the parameters in that formula and i am not sure it will be same to every organization. so can you please suggest me the what will be the parameters and the formula for this card.
I realize that this feature is already there. Previously ERP it was hard coded but in Odoo we have configuration to define the price range and markup percentage.
We can define the Price Markup Table from below path
Purchase / Configuration / Price Markup Table
And i have also check when we are receiving product and assign Serial/Batch nos that time sale price is coming automatically based on the markup percentage we have set.