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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
SuiteWorld | October 25–28, 2026 | Las Vegas
Registration opens June 9. Be ready when passes drop. Get the green light now - Convince your boss
Registration opens June 9. Be ready when passes drop. Get the green light now - Convince your boss
AE: Saved Search > Blanket Purchase Order > Quantity Doubled
Hello,
I try to make a save search for open BO's ( Blanket Purchase orders). I want to see all open BO's with the total quantiy and amount. But I cannot use the quantity ordered which is normally displayed in the BO.
as it is not visible in the drop down. So I did a little research and found out you can acces quantity ordered with "applying transaction -> quantity". See below the Criteria and Results:
Result:
Problem is, when I group the Blanket Orders and Sum the Quantity and Total Open Quantity, the Quantity is no longer correct. the Saved Search takes all the lines and will calculate:
0