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).

Troubleshooting

Scan the left column for your symptom. Rows are ordered roughly by how often they come up.

IssueWhat 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.
  • Go to the Modify Accruals page and process the modification created from your adjustment. That step books the adjusting JE.
  • If you refreshed the Adjust Accruals page and adjusted the same accrual again, you likely created duplicate modifications. Process or discard the extras so you don't double-adjust.
  • See Modify Accruals and Match, Adjust, and Auto Approve Accruals Concurrently.
"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.
  • On the Adjust Accruals page, create the modification for the matched lines, then process it on Modify Accruals.
  • Or unmatch the transactions you don't intend to process.
  • Matching links the transaction to the accrual; it does not by itself move the balance.
An automated accrual calculated the wrong amount.Almost always a mapping issue between the automation and its saved search.
  • The Amount Column Label on the automation must name the saved search column that holds the value you want to accrue. If it points at a raw amount column, the accrual books that raw amount instead of your formula (for example, the invoice line amount instead of "2% of gross sales").
  • Open the saved search and confirm the column returns the value and rows you expect for the period.
  • Any field sourced from a name column instead of an ID column produces an "Invalid Field Value" error rather than a wrong number (see Tips).
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.
  • To use an automation on Create from Search, clear its Execution Relative Date field. Automations with that field set run through the scheduled workflow instead.
  • After a major SuiteApp update, confirm you're on the latest version - a March 2026 update briefly affected this page, and follow-up patches resolved it.
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").
  • Open Customization > Scripting > Script Execution Logs, set Script to NetClose | Accrual Automation | MR, and read the latest error and the User column (-SYSTEM- means a scheduled deployment is running it).
  • If you don't use accrual automation, remove or disable the script's scheduled deployment (it may be a leftover from install).
  • If you do use it, fix the automation record's column mapping so no label is blank or invalid.
An auto-reversal JE was never created.Auto-reversal depends on configuration and the daily schedule.
  • The accrual has a reversing date ("Auto Reversing Day") set, and it has been approved/commenced. Accruals with no reversing date never auto-reverse.
  • The NetClose | Accrual Auto Reversal | MR script has an active scheduled deployment running daily (see Viewing Script Errors).
  • The reversing date has actually arrived - the reversal posts on or after that date, not before.
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.
  • The source transaction must be fully approved - one still pending in an approval workflow can't be matched and adjusted.
  • If matching throws "This record has been blocked by a user defined workflow," your own approval workflow is locking the record. Edit it to remove Context = Suitelet and User Event Script so NetClose can post to it.
  • To match a transaction type other than a vendor bill (for example an Expense Report), customize its form to expose the NetClose Accrual field, the same way it appears on vendor bills.
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.
  • Edit the accrual form (or create a new Preferred form) so Accrual Type is not required, if you don't want it mandatory. As a best practice we still recommend populating it.
  • Saved CSV import maps are prospective, not retrospective - after changing the form, create a new CSV import; an existing saved import still reflects the old form. See Upload Accruals.
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.
  • Confirm you're on the latest NetClose SuiteApp version. Production is updated by Netgain - if you suspect you're behind, contact support.
  • Reproduce once after updating; these were resolved by version fixes, not by a configuration change on your side.

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:

  1. Go to Customization > Scripting > Script Execution Logs.
  2. Filter Type to Error (and Date to today) to see only failures.
  3. 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.

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)TypeWhat it doesWhen it runs
NetClose | Accrual Automation | MRMap/ReduceCreates accruals from a saved-search-based accrual automation for the current or prior periodOn its scheduled deployment (daily), and when you generate from Create from Search
NetClose | Accrual Auto Reversal | MRMap/ReduceBooks reversing journal entries for accruals whose reversing date has arrivedOn its scheduled deployment (daily)
NetClose | Accrual Approve | MRMap/ReduceApproves the accruals you selected, booking the accrual journal entryWhen you approve accruals from the Approve Accruals page
NetClose | Accrual Commence | MRMap/ReduceCommences the accruals you selected (accreting / target-amount accruals)When you commence accruals
NetClose | Accrual Gen Schedule | MRMap/ReduceGenerates and updates accrual schedules and processes modificationsWhen schedules are generated or a modification is processed
NetClose | Accrual Run Journals | MRMap/ReduceBooks the period journals for accrual schedule linesWhen you run journals for accretion / target-amount accruals
NetClose | Accrual App | SLSuiteletServes the accrual pages - New Accruals, Approve, Match, Adjust, Modify, and Create from SearchWhenever 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

QuestionAnswer
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.


Was this article helpful?