How to Calculate Item Weight with Multiple Units of Measure in NetSuite

To calculate the weight of line items on transactions, a combination of custom fields and formula fields can be implemented. This approach leverages NetSuite's Multiple Units of Measure feature to handle various weight units and conversions.Custom fields are often utilized to capture specific item weight details. Examples include:

• {custcol_itemweightunit}: A custom column field to store the weight unit set on the item record, typically sourced from the item. While NetSuite offers standard 'weightunit' fields, custom fields provide flexibility for specific business logic.
• {custcol_itemweight}: A custom column field to store the weight set on the item record, typically sourced from the item. While NetSuite offers standard 'weight' fields, custom fields provide flexibility for specific business logic.

Other fields used in the calculation include:

• {custbody_weight_by}: A custom body field that copies the transaction's selected unit, with list values identical to the Units of Measure names.
• {custbody_weightunitconversion}: This custom body field can store a unit conversion rate for the selected transaction. While the standard {unitconversionrate} field is often available for direct use in formulas, a script may be employed to retrieve and populate this custom field for more complex conversion scenarios involving the Units of Measure feature.
• {unitconversionrate}: The standard line item conversion rate for the line's selected Unit of Measure.

Once these fields are configured, the following formulas can be used in custom transaction line fields to calculate item weight:

Item Unit Weight (weight of 1 UOM)

ROUND(CASE WHEN {custcol_itemweightunit}  {custbody_weight_by} THEN {custcol_itemweight} ELSE {custcol_itemweight} / {custbody_weightunitconversion} END * CASE WHEN {unitconversionrate} IS NULL THEN 1 ELSE {unitconversionrate} END,2)

Net Weight (weight of the line item's total quantity)

ROUND(CASE WHEN {custcol_itemweightunit}  {custbody_weight_by} THEN {custcol_itemweight} ELSE {custcol_itemweight} / {custbody_weightunitconversion} END * CASE WHEN {unitconversionrate} IS NULL THEN 1 ELSE {unitconversionrate} END,2) * {quantity}