Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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