跳至內容
選單
此問題已被標幟
2 回覆
217 瀏覽次數

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!

頭像
捨棄
作者

Hello Lakhan

Thank you, can this be done by Studio?

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

最佳答案

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

頭像
捨棄
最佳答案

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

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
0
3月 15
3188
3
10月 24
3377
2
3月 24
7213
1
6月 23
3971
1
2月 23
4599