Skip to Content
Menu
This question has been flagged
2 Replies
120 Zobrazenia

Hello,

We have a company that manufactures uPVC windows and doors.

When visiting a customer’s site, our team takes measurements (Height and Width) to determine the exact size of the glass panel required.

For example:

If the height = 5m and width = 7m, then the area = 35 m².

We would like Odoo to automatically calculate the area when we enter the Height and Width, instead of doing it manually.

What we want to achieve:

  • Add two fields on the sales order line: Height and Width (Done).
  • Have Odoo automatically compute Area = Height × Width.
  • Optionally, use this calculated area for pricing (e.g., product priced per m²).

Questions:

  1. Is there a standard way to achieve this ?
  2. Or do we need a customization?
  3. Can this value also be passed to Manufacturing (MRP) when creating a Manufacturing Order?

Any advice, examples, or existing modules that can help automate this process would be greatly appreciated.

Thank you in advance!

Avatar
Zrušiť
Autor

Hello Lakhan

Thank you, can this be done by Studio?

Hello,
I don’t have much idea about Studio customization.

Best Answer

It is possible to have spreadsheet with the calculations as a 'quote calculator' linked to a quotation template.

Sales > Configuration > Quotation template

Link and configure a spreadsheet to quote calculator dropdown.

https://www.odoo.com/documentation/19.0/applications/productivity/spreadsheet.html

Avatar
Zrušiť
Best Answer

Hello Zuhair,

You need to do the customization for this, like calculation of the your custom field at Sale Order Line level and store it into the Area field, also you can pass all the values when MO automatically created from SO. Also it’s also a good idea to check how Odoo manages the “m²” unit of measure, so everything stays consistent when calculating and pricing by area.

Hope it helps

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
mar 15
3186
3
okt 24
3369
2
mar 24
7168
1
jún 23
3966
1
feb 23
4593