Loading Account Reconciliation Reports into NetSuite

If you have Transaction Matching or Reconciliation Compliance reports in your Account Reconciliation application, you can load them into NetSuite. To do that, you can use a post-processing plug-in script in NetSuite. The Account Reconciliation Sync SuiteApp provides a sample plug-in script that you can customize and attach to an Account Reconciliation Report job in NetSuite.

To use a plug-in script to load reports into NetSuite:

In NetSuite, go to NetSuite EPM > Account Reconciliation > Integration Artifacts.
Click Download to save the required plug-in script to your disc.
Customize the plug-in script per your needs.
Go to Customization > Plug-ins > Plug-in Implementations.
Click New Plug–in Implementation.
Click the plus (+) sign to upload the plug-in script, and then click Save.
Click Create Plug–in Implementation.
From the list of plug-in types, select NSAR | PI Job Post Process.
In the Name field, enter a name for your custom plug-in script.
Set the Status field to Released.
Click Save.
Add the plug-in script to an Account Reconciliation Report job in NetSuite:
1. Go to NetSuite EPM > Account Reconciliation > Manage Jobs.
2. On the Account Reconciliation: Manage Jobs page, do one of the following:
  - In the list of jobs, click Edit next to a job of your choice.
  - If you do not see the job in the list, and you have the Administrator role, click the Add Job button. Then, follow steps 3 through 6 in Adding a Job in NetSuite.
3. Click the Options subtab.
4. From the Post–Processing Plug-in list, select the plug-in you want to use to process data.
5. Click Save.
Note:
The plug-in script is applicable only if the report format is CSV/CSV2.

You can find the generated report in the job execution logs. See Viewing the Job Execution Logs.

To use a plug-in script to load reports into NetSuite:

Related Topics