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.
Simple Transaction search to find entries with account on any line
I have been struggling with this, basically the need is pretty simple, i want to search for all transactions in which a particular account (lets say 001) is used on any line.
e.g.
there are 100 transactions with 500 account lines in a search
i want to get the list of 2 transactions containing all 5 account lines which has account 001 in any line atleast once.
so my result set would be something like this
doc num account amount
abc 001 10.00
abc 009 20.00
abc 122 30.00
xyz 002 15.00
xyz 001 25.00
Note : that each trasaction contains one line of 001 atleast (can be more but 001 should be present in the transaction)
this is doable in sql by using window functions and partition by clause but it gives mostly unexpected error in NetSuite.