Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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