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
回覆
886
瀏覽次數
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.
