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 On Order only by location?
I am working on a saved search to show what inventory is available in two locations
Inventory Balance search
Criteria:
Location: Location A & Location B
Results:
Item (Group)
Item : Display Name (Group)
Location
Formula Numeric (Max) CASE WHEN {location} = 'Location A' THEN {onhand} ELSE 0 END
Formula Numeric (Max) CASE WHEN {location} = 'Location A' THEN {available} ELSE 0 END
Formula Numeric (Max) CASE WHEN {location} = 'Location A' THEN {item.quantityonorder} ELSE 0 END
I get the correct results with On Hand & Available - however the On Order is the amount on order for both locations.