Discussions
Our service partner for bank feeds integration in U.S. and Canada will undergo four (4) hours of planned maintenance on April 13 - 14, 2025.
Please be advised that our authorized Account Information Service Provider for the NetSuite Bank Feeds SuiteApp will undergo approximately four hours planned outage. Standard maintenance will take place to perform a database upgrade.
The schedule of the planned outage is on Sunday, 13 April 2025, from 11:00 p.m. Pacific Daylight Time (UTC – 7) to 3:00 a.m. Pacific Daylight Time (UTC – 7), Monday, 14 April 2025.
During the maintenance window, all connections and import requests to your financial institutions in the United States and Canada through the Bank Feeds SuiteApp will be unavailable. If you try to connect a new U.S. or Canada financial institution to NetSuite or manually initiate an import request, you will receive an error message.
To view the most recent bank feeds maintenance schedule, see Bank Feeds SuiteApp Maintenance Schedule, SuiteAnswers ID 94347.
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.