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 compare inventory values in two locations in summary search?
I have a summary search that looks at total inventory on hand, available, committed, etc. across multiple locations. I want to build a flag to identify an item that is backordered at our primary location, but is on hand elsewhere. I have tried a decode and case when function to look at the criteria of location, but end up with two lines for the item on the report instead of one.
Is there a better way to write a formula that can be used in a summary report for if backorder qty at location A is greater than 0 and on hand quantity at location B is greater than 0 then true else false.
Betsy Vance, Versare Portable Solutions, Minneapolis MN