Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to show the Inventory Transfer's 'Quantity On Hand' in a saved search
Please help me how to show the Inventory Transfer's 'Quantity On Hand' in a saved search. I can display the 'Quantity To Transfer' but not the 'Qty On Hand'. Requirement is to show the quantity on hand at the time the transaction was saved, not the item's current quantity on hand. Below is the specs of the saved search (but missing the Quantity On Hand):
Saved Search Type: Transaction
Criteria:
Type is Inventory Transfer
Main Line is false
Results:
1.) Number
Summary Type = Group
Label = 'Inventory Transfer #'
2.) Date
Summary Type = Group
3.) Formula (Text)
CASE WHEN (MOD({linesequencenumber},2)=0) THEN {location} END
0