Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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
Tagged:
0