Uploading a Plug-in Script

To import Transaction Matching adjustments using a data load rule, you first need to upload a plug-in script.

To upload a plug-in script:

  1. In NetSuite, Go to NetSuite EMP > Account Reconciliation > Integration Artifacts.

  2. Use the Plug-in Code Generator to create a custom plug-in script. See Using the Plug-in Code Generator. Alternatively, follow the steps below:

    • Download a sample Import Journal Entries pi_journal_entry_v1.js plug-in script.

    • Open the file in a text editor, for example, Notepad++.

    • In the section shown on the screenshot that defines the CSV file location, enter the path to the CSV file created in Creating a New Folder. For example, inbox/journal_entries/journal_entry.csv.

                          /**
      * @public
      * @description Return configuration parameters of this plugin that are required by calling code
      * eg: path to csv file in ARCS to be downloaded
      * @returns {Object} options configuration parameters
      */
      function getConfiguration() {
        log.audit('getConfiguration', 'import journal entries plugin getConfiguration called');
        const options = {
          jobParams: {
            dataFilePath: 'inbox/journal_entries/journal_entry.csv', // path to csv file in ARCS to be downloaded
            dataFileHeaderLines: 1 // optional, number of header lines in data file
          }
        };
        return options;
      } 
      
                        
    • Save the file.

  3. Go to Customization > Plug-ins > Plug-in Implementations > New, and do the following:

    1. Click the plus (+) sign.

    2. Upload the saved plug-in file.

    3. Click Save.

    4. Click the Create Plug-in Implementation button.

    5. In the Type field, select NSAR | PI Job Post Process.

    6. Enter a unique name for the plug-in implementation.

    7. In the Status field, select Released.

    8. Click Save.

      Note:

      The plug-in script file can be changed later, for example, if you want to add new fields. See Loading Account Reconciliation Data into NetSuite.

Related Topics

General Notices