ANS-0004 · SAVED SEARCHES & FORMULAS
How to Filter Extra Item Lines in NetSuite Transfer Order Saved Searches?
Users may encounter duplicate item lines and incorrect quantity calculations when building saved searches for NetSuite Transfer Orders, requiring specific filtering.
Short answer
To resolve duplicate item lines and incorrect quantity sums in NetSuite Transfer Order saved searches, filter the results using the "Transaction Line Type" field. Specifically, include only "Shipping Line" to ensure accurate item quantities and prevent double counting caused by "Item" and "Receiving" line types.
Scenario
When creating a saved search for NetSuite Transfer Orders, users may observe multiple line entries for each item, specifically "Item", "Shipping", and "Receiving" lines. This duplication leads to quantities being summed multiple times, resulting in inflated totals. Furthermore, the system may incorrectly sum quantities based on the base unit rather than the item's Unit of Measure (UoM).
Solution
To correctly display item lines and ensure accurate quantity calculations in a NetSuite Transfer Order saved search, it is necessary to filter the results using the Transaction Line Type field. The solution involves configuring the saved search to include only the Shipping Line type. This filtering prevents the inclusion of redundant 'Item' and 'Receiving' lines, thereby resolving issues with duplicate entries and incorrect quantity summation.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support