Calculation Of a Field

Question

Hi,

I have a field that I have created in the quote page that is supposed to do a calculation by multiplying sale line item quantity by a number that is stored against the product in the product profile.  The filter mechanism is based on the product category.

Example:
Total Weight of Order (New Calculation Field) = Weight (of the specific item (i.e. XYZ CHAIR) in the sales order line) * Quantity (of the specific item (i.e. XYZ CHAIR) in the sales order line)

Thanks

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
By defining a computed field at the order level, you can easily achieve this. Inside the compute function you can add the logic to compute the value from the lines.
For example, see the amount_total field which computes the sub total from the lines and display the total at order level.
Similarly in your case, define a computed field from the ui or from the code and just add the logic.

Thanks

BASANT SALES PVT LTD · Answer

Hi did you figure this out? I have the same question for calculation of surface area using the dimensions Length and Width entered on the quotation.

This question has been flagged

Enjoying the discussion? Don't just read, join in!