Skip to Content
This question has been flagged
2 Replies
877 Views
Avatar
Window Armour

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

Avatar
Discard
Avatar
Yahoo Baba Innovations Pvt.Ltd
Best Answer

Hii,

This is a development if you want then please contact i'll share you.

Thanks

Avatar
Discard
Avatar
CodeWasher
Best Answer

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.

Avatar
Discard