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 for item backorders, inventory, and order history: Subquery magic possible?
You know you've got a doozy of a saved search when ChatGPT offers a solution that requires SuiteScript rewrite with a subquery!
I could use some advice--even if the advice is "can't do that from a saved search".
SETUP: We are using multi-location inventory. Goal is to have a saved search returning one line per assembly/inventory item, with the SUM of their available stock at selected locations only, and the past 30 days of their quantities sold on order confirmation lines.
What I'm finding is the order confirmation search ends up getting quantities multiplied by the number of inventory locations