Grant Management SuiteApp: Scheduled Script Automates Release from Restriction Transactions
The Grant Management SuiteApp now includes a scheduled script deployment that automatically creates Release from Restriction transactions based on a configurable saved search, eliminating repetitive manual entry for organizations managing multiple grants.
What changed
The Grant Management SuiteApp adds an Auto Release from Restriction scheduled script that evaluates grant amounts against use-restriction rules and creates balanced Release from Restriction transactions without manual intervention.
How the script works
- The script runs on a schedule you configure via its Script Deployment record (
Customization > Scripting > Script Deployments). - It queries a saved search selected in
Setup > Company > Preferences > General Preferences(field: Grant Management Release from Restriction Saved Search) to identify candidate grant amounts. - For each row where the amount satisfies the use-restriction rule and is greater than zero, the script creates a separate, balanced transaction:
- Debit line — posted to the With Sponsor Restrictions classification, using the first valid active Release from Restriction account.
- Credit line — posted to Without Sponsor Restrictions, same account and amount.
- Segment values (Program, Grant, Region, Subsidiary, and other supported segments) are copied from the saved search result row onto both transaction lines.
- The script is idempotent: subsequent runs consider amounts already released. Partially released amounts are evaluated for the remaining eligible balance only.
- If a candidate fails, the error is logged and the script continues processing remaining candidates. Successfully created transactions are not rolled back.
Default saved search
A locked default saved search is installed or updated with the SuiteApp. It cannot be edited, renamed, or deleted. If you need different criteria, create an independent copy of the default search and select it in General Preferences. The custom search must satisfy the SuiteApp's requirements for record type, fields, aliases, formulas, and data types — Oracle does not document the exact schema in this note, so inspect the default search to understand the required columns and aliases before customizing.
Reviewing results
Use the Grant Release from Restriction Workbook (SuiteAnalytics) to review overall grant funding, amounts released, and amounts still available for release. Check this workbook before creating any manual Release from Restriction transactions to avoid duplicates.
What to do
- Verify the Release from Restriction account. Before enabling automatic processing, confirm that a valid, active account is configured for Release from Restriction. If no matching account exists, the script silently skips all candidates.
- Review the default saved search. Navigate to the locked default search installed by the SuiteApp. Note its record type, columns, aliases, and formula fields — this is your contract for any custom replacement.
- Configure or run the script deployment. Go to
Customization > Scripting > Script Deploymentsand open the Auto Release from Restriction deployment. Either click Save and Execute for an on-demand run or set a recurring schedule. - (Optional) Substitute a custom saved search. If the default criteria do not fit your grant structure, copy the default search, modify it (keeping required columns/aliases intact), then select it at
Setup > Company > Preferences > General Preferences > Grant Management Release from Restriction Saved Search. - Monitor the workbook. After each scheduled run, review the Grant Release from Restriction Workbook for any discrepancies or errors. Because the script logs errors per candidate without halting, check the script execution log (
Customization > Scripting > Script Status) for failed candidates.
Gaps in this note
- Oracle does not specify the script ID or saved search ID for the default deployment and search. Inspect your SuiteApp bundle post-install to identify them.
- The exact column aliases, formulas, and data types required for a compatible custom saved search are not documented here. Copy the locked default as your starting template.
- No governance-unit cost or concurrency details are provided for the scheduled script. If you process a large volume of grants, test in Sandbox to gauge execution time and governance consumption.
- The release version for this feature is not stated in the source. Confirm which Grant Management SuiteApp bundle version introduced this capability in your account's SuiteApp release notes.
Source: Oracle NetSuite Release Notes