NetClose - Accruals Tips and Troubleshooting
Overview
This article collects practical tips for working with NetClose Accruals, fixes for the issues we see most often, and a reference for the background scripts that run the module. If an adjustment "succeeded" but the balance didn't change, an automated accrual calculated the wrong amount, the Create from Search page came up empty, or an auto-reversal never posted, start here.
Tips
Set up accrual types before you create accruals. Accrual types drive account mapping (accrual liability account, expense account) and how each accrual is processed. Getting them right up front prevents most posting-to-the-wrong-account surprises. See NetClose - Create Accrual Types.
Know the accrual lifecycle: create, approve, match, adjust, process. An accrual is created (manually, by CSV, or by automation), then approved - which books the accrual JE. When the real transaction lands, you match it to the accrual, then adjust to true up the balance. Each of these is a distinct step, and the last one is where most confusion starts (see the callout below). See the Accruals Overview.
For automation, the Amount Column Label must point at the right saved search column. An accrual automation reads the amount from the saved search column named in its Amount Column Label. If that label points at a raw transaction amount instead of your calculated column (for example a "2% of gross sales" formula column), the accrual books the raw amount, not the formula result. Match the label to the column that holds the value you actually want to accrue. See NetClose - Automate Accruals from Saved Search.
Use ID fields, not name fields, when a saved search feeds a record field. When an automation sources a field like the vendor, the saved search column has to return the internal ID, not the display name. A text name column produces an "Invalid Field Value" error because NetClose can't resolve it to a record. If you only have the name, add a formula column that returns the ID.
Preview before you commit. On the Create from Search page, filter to the accounting period to see exactly what the saved search will turn into accruals before you finalize. On the automation record, the Preview Create button shows what will generate for the current period. Both let you validate the calculation without booking anything.
Populate Accrual Type even when it isn't required. Even where the field is optional, filling it in makes accrual reporting and filtering far more useful. It is worth treating as a standard step.
Auto-reversal needs a reversing date and an active schedule. An accrual only auto-reverses if it has a reversing date set and it has been approved/commenced. The reversal JE is posted by a scheduled script that should run daily - if reversals aren't appearing, that's the first thing to check (see Troubleshooting).
Adjusting is a two-step process
When you adjust an accrual on the Adjust Accruals page, NetClose does not change the balance immediately. It creates a modification, which then has to be processed on the Modify Accruals page - that is where the adjusting JE is booked. So an adjustment can report "success" while the balance still looks unchanged, because the modification is only prepared, not processed. Refreshing the Adjust Accruals page and adjusting again creates a second modification. Adjust once, then go to Modify Accruals to process it. See Adjust Accruals and Modify Accruals.
Troubleshooting
Scan the left column for your symptom. Rows are ordered roughly by how often they come up.
| Issue | What to check |
|---|---|
| An adjustment said "success" but the accrual balance didn't change. | Expected behavior - adjusting creates a modification, and the balance changes only after you process it.
|
| "There are matched transactions that have not been processed yet" when you Match & Adjust. | The full message is: "You must create a modification to process those lines from the adjust page or unmatch the transactions."The accrual has matched transactions whose modification hasn't been processed.
|
| An automated accrual calculated the wrong amount. | Almost always a mapping issue between the automation and its saved search.
|
| The Create from Search page is empty, or an automation has no Preview option. | By design, accrual automations that have an Execution Relative Date set are treated as scheduled (automated) records and are excluded from the manual Create from Search page.
|
| You get a daily "NetClose | Accrual Automation | MR" error email but you don't use automation. | The scheduled automation script is erroring, usually on a leftover automation record or a bad column mapping (for example, an Unknown identifier "NAN" search error from a column label of "NAN").
|
| An auto-reversal JE was never created. | Auto-reversal depends on configuration and the daily schedule.
|
| Matching or Match & Adjust is blocked, or a non-bill transaction won't match. | Two related causes, both on the transaction rather than on the accrual.
|
| After a CSV import, "NetClose Accrual: Accrual Type" is suddenly required. | A SuiteApp update can reset your Preferred accrual form to the default, where Accrual Type is mandatory.
|
| Editing or saving an accrual JE throws a SuiteScript error. | A handful of accrual UI and JE-save errors (for example an Adjust Accruals page with fields out of place, or an SSS_SEARCH_ERROR_OCCURREDon JE save) were product defects fixed in SuiteApp updates.
|
After a major update, check your forms
A major SuiteApp update can reset custom accrual forms to their defaults - re-flagging fields as required, or changing which fields appear on a page. If a field that used to be optional is suddenly required, or a page looks reorganized right after an update, check your Preferred form and the field's requirement setting before assuming it's a bug.
Viewing Script Errors
Everything the Accruals module automates - creating accruals from a saved search, approving, reversing, processing modifications, and booking journals - runs as NetSuite scripts. When something doesn't happen, the script log usually says why.
To view logs across all scripts:
- Go to Customization > Scripting > Script Execution Logs.
- Filter Type to Error (and Date to today) to see only failures.
- Read the Details column for the message.
To check a specific job:
- For the Map/Reduce jobs (anything ending in | MR), open Customization > Scripting > Map/Reduce Script Status to see whether the run is Pending, Processing, Complete, or Failed.
- Or open the script directly at Customization > Scripting > Scripts, click the script, open its Deployments, and review the Execution Log subtab.
NetClose writes errors in the form script id | stage | error name: message (for example, customscript_nact_accrual_automation_mr | Get Input Data | SSS_SEARCH_ERROR_OCCURRED: ...), so the log tells you which script and which phase failed.
If you have the Netgain Tools SuiteApp, there's a faster way. The Netgain Tools SuiteApp - the same one that delivers Shared Transactions and Cross-Validation Rules - adds Netgain's own log viewer at Netgain > Development > Script Logs. It reads the same execution logs but is built for troubleshooting: you can search the log message text directly (an error name or a record ID), filter across several scripts, log types, and a date range at once, and see timestamps in your local time instead of server time. A companion Scripts view lists every script with its deployments and log levels. The Netgain menu only appears when that SuiteApp is installed, so it is not available on a NetClose-only account.
When you contact support
Copy the full error text from the Detail column and note the script name, the timestamp, and the accrual (and period/subsidiary) involved. With the script, stage, and message, Netgain support can pinpoint the cause quickly. To grant access for a support case, see NetClose - Providing Access to NetSuite Account for Support Cases.
Accruals Module Scripts
These are the scripts behind the Accruals module. You don't run them by hand - NetClose triggers them from the accrual pages or on a schedule - but knowing what each one does helps when you're reading a log or asking support a question. Find any of them at Customization > Scripting > Scripts, searching by the name below.
| Script (NetSuite name) | Type | What it does | When it runs |
|---|---|---|---|
| NetClose | Accrual Automation | MR | Map/Reduce | Creates accruals from a saved-search-based accrual automation for the current or prior period | On its scheduled deployment (daily), and when you generate from Create from Search |
| NetClose | Accrual Auto Reversal | MR | Map/Reduce | Books reversing journal entries for accruals whose reversing date has arrived | On its scheduled deployment (daily) |
| NetClose | Accrual Approve | MR | Map/Reduce | Approves the accruals you selected, booking the accrual journal entry | When you approve accruals from the Approve Accruals page |
| NetClose | Accrual Commence | MR | Map/Reduce | Commences the accruals you selected (accreting / target-amount accruals) | When you commence accruals |
| NetClose | Accrual Gen Schedule | MR | Map/Reduce | Generates and updates accrual schedules and processes modifications | When schedules are generated or a modification is processed |
| NetClose | Accrual Run Journals | MR | Map/Reduce | Books the period journals for accrual schedule lines | When you run journals for accretion / target-amount accruals |
| NetClose | Accrual App | SL | Suitelet | Serves the accrual pages - New Accruals, Approve, Match, Adjust, Modify, and Create from Search | Whenever you open an Accruals page |
Several user-event and client scripts also run automatically as you work in the module (maintaining the accrual record, modifications, and form behavior when a record is created or edited).
Frequently Asked Questions
| Question | Answer |
|---|---|
| How do I find the saved search behind a monthly accrual automation? | Open NetClose > Setup > Accrual Automations, click the automation, and look at its Saved Search field - that names the exact saved search it uses. (Searching the saved search list directly for "NetClose Accrual" won't necessarily find it, because it's named whatever the person who built it chose.) To validate what it will produce, use the Preview Create button on the automation or the Create from Search page filtered to the period. |
| Why don't vendor bills linked to a NetClose accrual show up in the native Purchase by Vendor report? | This is expected NetSuite behavior, not a NetClose issue. Bills booked to an accrual liability account (an Other Current Liability account type) don't appear on the Purchase by Vendor Summary or Detail reports, because those reports are designed to show bills posting to Asset and Expense account types. Use a saved search or a different report if you need those bills included. |
| Can I match transactions other than vendor bills - like Expense Reports - to an accrual? | Yes, but the transaction form has to expose the NetClose Accrual field (customize the form the same way it works on vendor bills), and the transaction must be fully approved and not locked by a custom approval workflow. See the "Matching or Match & Adjust is blocked" row in Troubleshooting. |
| Does an accrual automation run for prior periods? | An automation with an Execution Relative Date set runs on the scheduled workflow for its target period and is excluded from the manual Create from Search page. If an automation isn't generating for the period you expect, check its Execution Relative Date and preferred-period configuration, and use Create from Search (with the relative date cleared) to generate manually for a specific period. |
| Can NetClose approve adjustments automatically instead of making me process each modification? | NetClose supports approving and processing accruals concurrently in some flows - see Match, Adjust, and Auto Approve Accruals Concurrently. Outside those flows, an adjustment creates a modification that you process on the Modify Accruals page, which is where the adjusting JE is booked. |
| Can I split one accrual across multiple expense accounts? | Not within a single native accrual - an accrual maps to the accounts on its accrual type. To split an accrual across accounts or segments, use Shared Transactions to allocate the accrual; otherwise book a manual journal entry for the split. |
Still Need Help?
If these steps don't resolve the issue, or you're seeing an error that isn't covered here, contact Netgain support at support@netgain.tech. Include the script name, the error message and timestamp from the execution log, and the accrual, period, and subsidiary involved. Keeping your SuiteApp up to date also resolves some issues, since fixes ship in updates.
