Determine sales price using Formula

Description

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

Activity

Show:
Akhil Malhotra
May 7, 2019, 4:17 PM

Sales price for a product is entered manually at the time of receiving a new batch of products.

Anand Patel
May 22, 2019, 6:58 AM

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.

Anand Patel
May 29, 2019, 12:04 PM

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.

Fixed

Assignee

Anand Patel

Reporter

Angshuman Sarkar

Labels

None

Units

None

PercentDone

None

DueTime

None

Clients

None

External issue ID

None

UAT Assignee

Rajashri Pritam Khobragade

Reviewer

None

Components

Sprint

0.92 Product

Fix versions

Configure