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 create a Saved Item Search Showing Inventory by Location?
I want to create an item search that uses Case When formulas to return a column for on-hand quantity by inventory location. I am able to create the formula I want except for the "location on hand" portion. Is there a way in this formula to specify "location on hand at specified location"? Current formula is returning the correct quantity, but I'm still getting lots of lines per item, one for each inventory location.
Current formula: CASE {inventorylocation} WHEN 'Tennessee' THEN {locationquantitybackordered} ELSE 0 END
Basically, I want to return one column for "X location on hand" and another column for "Y location on hand", without multiple lines for each item.