Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Intelligent Payment Automation, powered by BILL (aka Bill.com), lets you automate payments, manage vendor details, and bank account information within NetSuite.
The SuiteApp is available to organizations based in the U.S. with a valid U.S. address, or to global customers (except Canada, China, and Japan) with U.S. business subsidiaries. It only supports payments to vendors operating in the United States.
For more information, visit this thread.
Saved Search Formula > How do I Get SUM of values based on a field
Hi NetSuite Community,
I am working on a Saved Search that displays the total Invoiced Amount, total Booked Orders (Sales Orders) and Gross Profit % per Item Category. For context, Item Category is related to the Items of the Sales Transactions. It is like a Segment.
Here is the sample:
I used Sum to summarize the currency fields and Average to summarize the Percentage fields
However, in the Gross Percentage columns (YTD and MTD), the users want to see a different thing. They want to extract the Sum of the Invoiced Amount per Item Category, then Sum of the COGS amount in the Item Fulfillment to get the Gross Percentage (Invoiced Amount (Sum) - COGS Amount ((Sum))/Invoiced Amount (Sum)
John Michael Benitez
NetSuite Systems Administrator
AllFasteners USA