ANS-0036 · SAVED SEARCHES & FORMULAS
How to Get Sales Order Line Item Quantities in Transaction Units of Measure?
NetSuite offers a field to get sales order line item quantities, including their unit of measurement.
Short answer
The "Quantity in Transaction Units" field, or {quantityuom}, provides the quantity of an item on a sales order with its unit of measurement already applied. To determine the item's unit of measurement value, divide the standard quantity by this field using the formula {quantity}/{quantityuom}.
Scenario
Users often need to retrieve the exact quantity of items on a NetSuite sales order, specifically expressed in terms of their assigned unit of measurement. Standard quantity fields may not always reflect this unit-adjusted value directly, leading to potential discrepancies in reporting or calculations.
Solution
To obtain the quantity of an item on a sales order with its unit of measurement applied, utilize the field named "Quantity in Transaction Units". This field is internally referenced as {quantityuom}. If there is a need to explicitly calculate the unit of measurement value for the item, it can be derived by dividing the standard item quantity by the value from the "Quantity in Transaction Units" field. This calculation can be performed using the formula field: {quantity}/{quantityuom}.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support