Most finance teams on NetSuite end up living in NetSuite saved searches. They feed the AP aging your controller checks every Monday, the dashboard your CFO opens before board meetings and the exception lists that keep month-end on track. When a search is built well, nobody thinks about it. When it isn't, people stop trusting the numbers and go back to exporting everything into spreadsheets.
Key takeaways
- A saved search is a reusable query with criteria, result columns and sharing settings, and most reporting problems trace back to one of those three.
- Duplicate rows on transaction searches usually mean the search is returning every transaction line when you wanted one row per transaction.
- If a search total disagrees with a financial report, check posting status, the date field you filtered on and which subsidiaries are included before anything else.
- Slow searches are almost always caused by broad date ranges, "contains" filters on text fields or a long list of formula columns.
- Name, document and share searches deliberately, or you will end up with five versions of the same report.
Need saved searches your team can rely on? Book a free NetSuite review
What are NetSuite saved searches?
A saved search is a stored query against NetSuite records such as transactions, customers, vendors or items. You choose the record type, set criteria to filter it, pick the columns to show and decide who can see the result. The search reruns every time someone opens it, so the data is always current.
Saved searches are different from NetSuite's built-in financial reports. Reports like the Income Statement and Balance Sheet follow accounting rules for periods and consolidation. A saved search returns exactly what you ask for, which is why it can show a different number when the criteria are slightly off.
How to build a saved search that finance can trust
Start from the question the search has to answer, written as one sentence. "Show me every open vendor bill over $5,000 for the US subsidiary, oldest first" is a good brief. "AP report" is not.
- Pick the right record type. For anything involving amounts, use a Transaction search and filter by type rather than starting from the customer or vendor record.
- Set the main line criterion on purpose. Main Line = Yes gives one row per transaction (the header). Main Line = No gives the individual lines. Most duplicate-row complaints come from leaving this out.
- Exclude system lines you don't want. Line-level searches can also pick up tax, shipping and COGS lines. Add criteria for those where they would distort totals.
- Filter on the right date. Transaction Date and Accounting Period can put the same bill in different months. Match whatever the people reading the search will compare it against.
- Use summary types for totals. In a summary search every column needs a summary type, such as Group, Sum or Count. One column without a summary type will break the layout.
- Add available filters. Letting users change the subsidiary or period on the results page saves you from building a copy for every variation.
Formula columns are useful for aging buckets or flags, and they use SQL expressions such as CASE WHEN and NVL. Keep them few and give each one a clear label so the next person can read the search.
Fixing the problems that come up most
When a saved search gives an answer nobody believes, the cause is usually one of these:
- Duplicate rows: add Main Line = Yes, or switch to a summary search grouped by document number.
- Totals don't match the income statement: check that you are only including posting transactions, that the period filter matches the report and that the subsidiary filter includes the same entities.
- Foreign currency amounts look wrong: in a multi-currency account, Amount is in the subsidiary's base currency and Amount (Foreign Currency) is in the transaction currency. Pick one and label the column.
- Someone can't see results you can see: their role may be restricted by subsidiary or department, or they are missing permission for that record type.
- The search times out: narrow the date range, replace "contains" text filters with exact matches or lists, and remove formula columns you don't use.
- Scheduled emails stopped arriving: check that the owner of the search is still an active employee with the right role.
If you are coming from another system, our guide to a QuickBooks to NetSuite migration covers which reports usually need to be rebuilt as saved searches after go-live.
Keeping saved searches under control
Accounts that have run NetSuite for a few years often have hundreds of saved searches, many of them near duplicates. A simple naming convention helps, for example a team prefix and the question it answers ("AP: open bills over 5k, US"). Add a short description on each search saying who owns it and what it is for.
Review the list once a quarter. Make old searches inactive rather than deleting them straight away, because dashboards, workflows and scripts can depend on a search without that being obvious from the search itself.
Talk to our NetSuite team about cleaning up your saved searches
This is routine work for an offshore NetSuite team, and it's easy to hand over in small pieces. If you are deciding who should own it, our article on hiring an offshore NetSuite consultant covers what to look for. You can also see the rest of our NetSuite consulting services.
Frequently asked questions
Why does my NetSuite saved search show the same transaction several times?
Transaction searches return one row per line by default, so a bill with five lines appears five times. Add Main Line = Yes to get one row per transaction, or use a summary search grouped by document number.
Can I schedule a saved search to email results automatically?
Yes. On the Email tab you can send results to recipients on a schedule, as a link or an attached file. The search runs with the owner's permissions, so keep the owner's role and status up to date.
What is the difference between a saved search and a financial report in NetSuite?
Financial reports follow accounting rules for periods, posting and consolidation. A saved search returns whatever records match its criteria, so it is more flexible but can disagree with the reports if the filters are not set carefully.
Can I show saved search results on a NetSuite dashboard?
Yes. You can add a saved search to a dashboard as a portlet, so the results refresh each time the page loads. Keep dashboard searches narrow, because a slow search makes the whole dashboard slow.
Get help from Oakridge Global
Our in-house NetSuite team builds and repairs saved searches, dashboards and reports for finance teams in the US and elsewhere. Schedule a consultation with Oakridge Global and tell us which reports your team has stopped trusting.