Scenario:
The user wanted to retrieve the unit conversion multiplier used by an Item’s Stock Unit (for example, a Gross unit equal to 144 Each units) within a Saved Search. The goal was to compare quantities such as Quantity On Hand and Quantity On Hand Base using the underlying unit conversion multiplier.
Solution:
Currently, NetSuite Saved Searches do not natively expose the Unit Type conversion multiplier field through the standard Saved Search UI.
The multiplier information is stored within a related Unit Type subrecord and cannot be directly retrieved using a traditional Item Saved Search.
Recommended alternative:
Use SuiteAnalytics Workbooks or Analytics Datasets instead.
To retrieve the unit conversion multiplier:
- Create a new Analytics Workbook or Dataset.
- Use the Item record as the primary dataset.
- Join the related:
- Add the following fields:
- Save and run the workbook.
The Conversion Rate field represents the multiplier between the selected unit and the base unit.
Example:
Unit Name | Conversion Rate |
|---|
Each | 1 |
Gross | 144 |
This allows users to retrieve and analyze unit conversion multipliers that are not accessible through standard Saved Searches.