Custom Saved Searches for Use-Restriction Releases
Customize automatic use-restriction release searches while preserving required formulas, posting criteria, and groupings that prevent duplicate releases.
A customized saved search can change which transactions qualify for automatic release from use restriction. Copy the locked default search, preserve its supplied formulas, and finalize supported groupings before the first script run. Changing groupings later, including when switching searches, can create duplicate releases because historical released amounts use the original grouping.
When Should You Customize the Default Search?
The SuiteApp identifies automatic-processing candidates through a locked default saved search, selected during installation or upgrade. If you need different criteria, copy that search and customize the copy rather than attempting to modify the locked original.
This configuration controls candidate selection within the broader automatic use-restriction release process. Before enabling or scheduling processing, decide which transactions should qualify and which supported fields define each intended release combination.
What Must the Customized Saved Search Include?
Before selecting the search, verify every requirement below.
| Component | Required configuration |
|---|---|
| Search type | Transaction saved search |
| Results | Summary results |
| Grouping fields | Fields defining each intended release combination |
| Currency formula column | Exactly one Formula (Currency) column |
| Formula summary type | Sum |
| Formula custom label | Revenue to be Released |
| Formula output | A numeric amount |
| Posting criterion | Always set to Yes |
Keep the supplied calculation formulas unchanged. The requirement for numeric output is not permission to rewrite the calculation. You may change search criteria and supported grouping fields before enabling or scheduling automatic processing, but not the supplied formula logic.
As a preflight check, review results configuration separately from criteria. The intended transaction filters do not replace the required summary structure, exact formula label, or single currency-formula column. The posting criterion must remain Yes in the saved search, including a customized copy.
Which Groupings Can You Use?
Group results only by custom segments, Department, Class, or Location. Do not group by Subsidiary or Restriction. The script uses consolidated parent results and assigns restriction values when creating each transaction.
Finalize grouping fields before the first script run. Do not change them afterward, including when switching to another saved search. Historical released amounts are calculated using the original grouping, so changing that structure can create duplicate releases. Switching searches is not an opportunity to redefine release combinations after processing begins.
Parent-subsidiary check: When Classification is selected as a grouping field, the selected classification value must be available on the parent subsidiary. The Release from Restriction transaction is created at that level. Check that availability before processing.
How Do You Select the Customized Search?
After confirming the requirements:
- Go to Setup > Company > General Preferences.
- Open the Custom Preferences subtab.
- Select your search in Release from Use Restriction Saved Search.
The selected search’s label appears as a center label under NFP Financial Center > Financial. Select that name to view the release from restriction report.
Who This Affects
- Administrators selecting the search: Verify its configuration before selecting it in company preferences.
- Search developers: Preserve formulas, summary settings, and supported groupings.
- Accounting reviewers: Confirm candidate criteria, intended release combinations, and parent-subsidiary classification availability.
Related reading: Intelligent Close Manager accounting task criteria.
Key Takeaways
- Customize a copy of the locked default Transaction search.
- Use summary results, the required currency formula, and Posting = Yes.
- Never alter supplied formulas or group by Subsidiary or Restriction.
- Finalize groupings before the first run and preserve them when switching searches.
Frequently Asked Questions (4)
Can I edit the locked default saved search for use-restriction releases?
What configuration must a custom release search retain?
Which fields can I use to group use-restriction release results?
Where do I select a customized saved search, and how can I view its report?
Weekly Update History (1)
Added the topic Automatic Release from Use Restriction in Non-Profit Financial Management.
View Oracle DocsWas this article helpful?
More in Searches
- Creating Searches with SuiteScript in NetSuite
Create and manage searches in NetSuite with SuiteScript, utilizing filters, columns, and settings effectively.
- Filter Object Members for N/Search Module in NetSuite
Filter Object Members enhance search capabilities in NetSuite SuiteScript. Learn to create and configure filters effectively.
- Error Handling in Searches with SuiteScript 2.0 Features
Gain insights into error handling in SuiteScript searches, including codes and common issues that arise when loading saved searches.
- search.load Method for Saved Searches in SuiteScript
The search.load method allows developers to load existing saved searches in SuiteScript, enhancing data retrieval and management.
Also from NetSuite 2026.2
- Bank Matching and Reconciliation Enhancements in NetSuite 2026.2
Bank matching and reconciliation pages in NetSuite 2026.2 receive critical UI enhancements for improved transaction management.
- System Notes Enhancement for Reconciliation in NetSuite 2026.2
System notes enhancement tracks GL transaction events in NetSuite 2026.2, improving reconciliation auditing and review.
- SuiteCloud CLI License Acceptance for Automation
Set SUITECLOUD_CLI_ACCEPT_LICENSE=true to suppress the SuiteCloud CLI license prompt during scripted npm installation.
- NetSuite Next: Readiness, Preview, and Ask Oracle
Eligible administrators can request a NetSuite Next preview, set up Ask Oracle, and prepare data, roles, customizations, and navigation.
Advertising
Reach Searches Professionals
Put your product in front of NetSuite experts who work with Searches every day.
Sponsor This Category