ANS-0028 · SAVED SEARCHES & FORMULAS
How to Display Item Quantity for UOM and Non-UOM Items in NetSuite Saved Searches?
Learn how to accurately retrieve item quantities from transaction lines in NetSuite saved searches, regardless of whether items use Units of Measure.
Short answer
To accurately display item quantities from transaction lines in NetSuite saved search results, utilize the column search field 'Quantity In Transaction Units' with internal ID `{quantityuom}`. This field correctly reflects the quantity entered on the line item, ensuring accuracy for both items configured with Units of Measure and those without.
Scenario
Users often need to display item quantities from transaction lines in NetSuite saved searches. A common challenge arises when transactions include a mix of items that utilize Units of Measure (UOM) and items that do not. Standard quantity fields may not consistently reflect the intended transaction line quantity for both types of items.
Solution
To ensure the correct display of item quantities in NetSuite saved search results, use the column search field 'Quantity In Transaction Units'. This field, identified by the internal ID {quantityuom}, accurately reflects the number set in the quantity column field on the transaction line item. It functions correctly for both items configured with Units of Measure (UOM) and items that do not use UOM, providing a consistent quantity output.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support