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 displayed in Suitelet--Amount remaining on PO to be displayed
Hi There
i am trying to create a suitelet which shows the amount remaining on a purchase order and shows the detail by project the PO line is coded to.
For example
Project | Total Vendor Bills | Total Purchase Orders |
|---|---|---|
PRJ123 | 75000 | 5000 |
The total vendor bills figure is made up of invoice:
AAINV001, $35000
AAINV002, $40000
There is a single purchase order:
PO001, which is $80,000 against project PRJ123.
For the purposes of this suitelet, the $5,000 shown under 'Total Purchase Orders' is calculated as the Total Purchase Order coded against the project less the Total Billed against the purchase orders.
However, I cannot see a way of doing this as using the sum of purchase orders less the sum of billing amounts against the purchase orders returnings $80,000.