Discussions
SuiteWorld is where the NetSuite community comes together to learn, connect, and discover what’s next.
Whether you’re looking for product updates, practical tips, new ways to improve efficiency, or insights from other customers, SuiteWorld offers something for every stage of your NetSuite journey.
■ NetSuite 2026.2 Release Notes
■ NetSuite SuiteApps Release Notes
■ NetSuite Sneak Peeks
■ Release Preview Guide
■ Release Preview Test Plan Template
Invoice Group Saved Search Performance when including Transaction Fields
I am having significant performance issues with Invoice Group Saved Searches when I include Transaction fields...
This is the simple search I am running:
As you would expect, running this search opens the results in approx. 2-3 seconds:
That particular Invoice Group contains 4 Invoices, which are relatively small (1, 2 or 3 lines on each).
If I include the Transaction field to show the items:
Then the search takes slightly longer, maybe 3-5 seconds:
And this performance is consistent as you add in other fields from the Transaction subtable - up to a point.
After various testing (where I thought a specific field may be causing performance issues), I now believe that there is simply a threshold of the number of Transaction Fields that can be included before there is a dramatic drop in performance. I think it is 13 (but I'm not 100% sure) - but once you go past this, the Search then takes over