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.
Have questions or experiences to share? Post your Release 2026.1 questions and join discussions in the Release 2026.1 category.
Intelligent Payment Automation, powered by BILL (formerly 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 with formula comparing results to that of another formula
I've created a saved search that calculates the gross margin of a certain group of products and divides it by a certain group of applicable transactions.
I'm trying to figure out how to divide the results of one formula by the other so I can see the overall gross margin per applicable transaction.
Gross Margin (formula sum)
CASE WHEN {account} = '-Accessory' OR {account} = '-Aftermarket and OEM' OR {account} = 'Bluetooth' THEN {amount}-{cogsamount} ELSE 0 END
# Applicable Transactions (formula sum)
CASE WHEN {custcolphone_act_type} = 'New Activation' OR {custcolphone_act_type} = 'Upgrade' THEN {quantity} ELSE 0 END
What I need to do is create another column that divides the gross margin by the # of applicable transactions. This is easy to do in a scorecard but I need to include it as a column in my saved search.