NetClose - Export Close Control audit trail
Overview
Close Control records track which transactions are locked for each accounting period. NetSuite logs every change to these records in System Notes, so you can build a saved search that shows who locked or unlocked a period and when, then export it to share with auditors or your controller.
This article covers transaction locks set on the NetClose Close Control record. The history for module locks (Tasks, Reconciliations, Flux) is on the NetClose Lock Modules record, so it is not part of this export. To see who locked or unlocked a module, build the same kind of saved search on that record.
Prerequisites
- A role that can view the NetClose Close Control custom record and create saved searches.
Step-by-step process
In the NetSuite global search, enter NetClose Close Control and open the record list from the results.
To add fields to the search results, select Customize View.
On the Criteria tab, add any filters you need, for example the accounting period or subsidiary.
On the Results tab, add the fields that identify the lock, such as:
- Name
- Accounting period
- Subsidiary
- System Notes: Date
- System Notes: Set by
- System Notes: Field
- System Notes: Old Value
- System Notes: New Value
To add multiple fields at once, select Add Multiple and multi-select fields.
5. To show only lock and unlock events, add a criteria filter on System Notes: Field for the Is Subsidiary Locked field.
6. Click Preview to check the results. A lock shows Old Value F and New Value T. An unlock shows the reverse.
7. Click Save & Run, or Save and run it later. Give the search a clear title such as Close Control audit trail.
8. In the results, use the export options at the top of the list to download as CSV, Excel, or PDF.
