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!
Saved search to show quantity sold + quantity available at multiple locations within a date range
Hi,
I tried to produce a saved search which details the quantities sold plus available quantities at multiple locations.
I can not find a logical way to do this and am not even sure if it is possible.
Essentially the users would like to see 2 things:
a. stock level at location a and location b
b. number of sales orders from location a and locations b of a particular order type
I tried the following formulas:
CASE WHEN {transaction.type} = 'Sales Order' AND {transaction.custbody1} = 'Direct' THEN {transaction.Quantity} end CASE WHEN {transaction.type} = 'Sales Order' AND {transaction.custbody1} <> 'Direct' THEN {transaction.Quantity} end