My product is priced per square foot. So on the quotation I need to add a 2 custom fields, Width and Height, then times them together to get the sq foot per product line item. Then I need to add up all the lines and divide by 144 to get the total square footage then times them by the cost. How do I do this? I am new to Odoo. TIA
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
2
回复
872
查看
Hii,
This is a development if you want then please contact i'll share you.
Thanks
1. Create Custom Fields for Width and Height:
Add custom fields for Width and Height to the sales order line (sale.order.line).
2. Create a Computed Field for Square Footage:
Define a computed field that multiplies the Width and Height to calculate the square footage. Divide the result by 144 to convert it to square feet.
3. Modify the Unit Price Calculation:
Create a computed field that calculates the total price based on the square footage and the unit price of the product.
Adjust the subtotal calculation on the sales order line to reflect the computed total price.
4. Update the Sales Order Line View:
Modify the sales order line form view to display the new Width, Height, Square Footage, and Total Price fields.
