Integration Guidelines
To integrate NetSuite Account Reconciliation with NetSuite, you must have the Administrator role and complete the following consecutive steps:
-
Install the Oracle EPM Connector Foundation SuiteApp.
See the help topic Installing the EPM Connector Foundation SuiteApp.
-
Install the Oracle EPM Connector SuiteApp and set it up for Account Reconciliation.
See the following help topics:
Note:If you have the NSPB Sync SuiteApp installed on your NetSuite account, read the following:
-
You do not need to install the Oracle EPM Connector SuiteApp.
-
Make sure you add the customsearch_nsar_ prefix for Account Reconciliation Sync saved search IDs to the allowlist in NSPB Sync. For instructions, see the help topic Saved Search Allowlist.
-
-
Install the Account Reconciliation Sync Foundation SuiteApp.
See the help topic Installing the Account Reconciliation Sync Foundation SuiteApp.
-
Install the Account Reconciliation Sync SuiteApp.
See the help topic Installing the Account Reconciliation Sync SuiteApp.
-
Create the NetSuite Account Reconciliation application.
See the help topic Creating the NetSuite Account Reconciliation Application.
-
Set up an integration user with proper permissions in NetSuite. You can either use the NSAR Integration role, or customize and duplicate this role to better suit your needs.
See the help topic Using the NSAR Integration Role.
-
Create or customize Account Reconciliation Sync saved searches in NetSuite.
See the help topic Managing the Account Reconciliation Sync Saved Searches.
-
Set up token-based authentication.
See the help topic Setting Up Token-Based Authentication.
-
Set up the connection between your NetSuite Account Reconciliation application and NetSuite.
See the help topic Setting Up the Connection to Account Reconciliation.
-
Export data from NetSuite, and import it into your NetSuite Account Reconciliation application.
See the help topic Account Reconciliation Data Export and Import.
-
Add accounts into groups of accounts that are reconciled together in your NetSuite Account Reconciliation application.
See the help topic Accounts for Group Reconciliation.
-
Select accounts that you identified for transaction matching tasks in your NetSuite Account Reconciliation application.
See the help topic Transaction Matching Accounts.
-
To load data into your Account Reconciliation application, manually execute the data load or schedule the job in NetSuite. You can also execute the data load in your Account Reconciliation application.
See the following help topics:
-
Create reconciliations for the data load related period in your NetSuite Account Reconciliation application.
See the help topic Creating Reconciliations in the Oracle Help Center.