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.
Weird (Wrong) Formula Results
The situation:
We've got several Items that we need to pay Royalties on. We created a custom Item field to store the Royalty amount. We've created a Qty Sold report that includes the following fields.
[LIST]
[*]Item Name
[*]Royalty Fee (the custom item field)
[*]Qty Sold
[*]Royalty Due (= Royalty Fee * Qty Sold)
[/LIST]
The weird behavior: when the report is first created and previewed the Royalty Due values are OK but after it is saved or after further customization of the report the amount is calculated incorrectly. Instead of multiplying the two columns the formula field displays Qty * Qty.
Furthermore, the grand total of the Royalty Due column is never correct! :eek: Rather than showing the total of all the rows above, it shows the total Qty multiplied by itself.