Shared Transactions Mass Uploading Allocation Templates

Overview

Shared Transaction templates allow pre-determined allocations to quickly be applied to a single expense or to an entire bill. You can mass upload all your unique templates and their allocation lines with the Data Import Wizard (recommended) or with NetSuite's CSV Import Assistant. For a full walkthrough of each wizard step, see Shared Transactions Data Import Wizard.

Step-by-step process

Uploading templates takes two imports. The first creates the templates (names and descriptions) and does not contain any information on the actual allocation of the expense or journal. The second adds the allocation lines that determine how each template allocates expenses to different departments, classes, locations, or subsidiaries.

1. Import the template names

  1. Open a new Excel spreadsheet and add the two following columns:
    1. Template Name
    2. Template Description
  2. Under the first column, list all names of the templates you want to create.
  3. Under the column ‘Template Description’ give a brief description of the template (optional). This could include details on when you would expect this template to be used.

Then import the file using one of the options below.

Option 1: Data Import Wizard (recommended)
  1. Navigate to Netgain > Setup > System Setup, open the Shared Transactions Import Tools subtab, and click the Link under Data Import Wizard. For details on each wizard step, see Shared Transactions Data Import Wizard.
  2. Select the Shared Transaction Template record type, upload the file, and choose the Add operation.
  3. On the Map Columns step, map Template Name to the Name field and Template Description to the Description field. Work through the wizard to Submit.
  4. On the Data Import Status page, wait for the import to show Complete and confirm the Errored count is zero. If rows failed, use Download → Errors to see why, correct them, and import them again.
Option 2: NetSuite CSV Import
  1. Save the file as a CSV.
  2. Within NetSuite, navigate to the CSV upload page Setup > Import/Export > Import CSV Records.
  3. With the Import Assistant open, update the Import Type to ‘Custom Records’ and the Record Type drop-down to ‘Shared Transaction Template.’
  4. Under the CSV files section, click Select and upload the .csv file you saved.
  5. Select 'Next' to progress to the Step 2-Import Options.
  6. Within the Import Options section, make sure Add is selected and "Run Server SuiteScripts and Trigger Workflows" is checked.
  7. After progressing through File Mapping, you will be prompted for Field Mapping.
  8. Once mapped, select 'Next' and then 'Run'.
  9. If the fields are mapped correctly and the field contents match the field values in NetSuite, the upload will show complete, and the templates will be available.
  10. In the event of a failed upload, review the logs for the specific reasons for the failed load and repeat the steps above.

If this was successful, you can navigate to Netgain > Setup > Shared Transactions Templates and you will be able to view the list of all the templates you just uploaded along with the template internal IDs. Please remember that at this point we have only uploaded template names but no information on allocations.

2. Import the allocation lines

Open a new Excel spreadsheet and add the following columns as desired:

ColumnDescription
Template Name (required)The name of the template from the first import. Template names must match exactly and are listed once for each allocation line. Not needed if every line belongs to one template and you select that template in the Data Import Wizard (see Option 1, step 3 below).
Weight (required)The desired weight for this allocation line. Note that weight does not need to equal 100 as weight is relative.
DepartmentThe Department that the allocation should go to, as a name or internal ID.
ClassThe Class that the allocation should go to, as a name or internal ID.
LocationThe Location that the allocation should go to, as a name or internal ID.
SubsidiaryThe Subsidiary that the allocation should go to, as a name or internal ID.

Your Excel spreadsheet should look something like this:

Then import the file using one of the options below.

Option 1: Data Import Wizard (recommended)
  1. Open the Data Import Wizard from Netgain > Setup > System Setup > Shared Transactions Import Tools. For details on each wizard step, see Shared Transactions Data Import Wizard.
  2. Select the Shared Transaction Allocation record type, upload the file, and choose the Add operation.
  3. Link each line to its template in one of two ways:
    • Select a template in the Associated Shared Transaction Template field to attach every row in the file to that template, or
    • Leave that field blank and, on the Map Columns step, map Template Name to the Source Template field with Lookup By set to Name.
  4. Map the remaining columns. For Department, Class, Location, and Subsidiary, set Lookup By to match what the column holds: Name or Internal ID. The Match Lookups step flags any value that does not match a NetSuite record so it can be matched or skipped before the import runs.
  5. Work through the wizard to Submit, then confirm the import shows Complete with no errors on the Data Import Status page.
Option 2: NetSuite CSV Import
  1. Save the file as a CSV.
  2. With NetSuite open navigate to the CSV upload page: Setup > Import/Export > Import CSV Records.
  3. With the Import Assistant open, update the Import Type to ‘Custom Records’ and the Record Type drop-down to ‘Shared Transaction Allocation.’
  4. Under the CSV files section, click Select and upload the .csv file you saved.
  5. Select Next to progress to the Step 2 Import Options.
  6. Within the Import Options section, make sure Add is selected and "Run Server SuiteScripts and Trigger Workflows" is checked.
  7. After progressing through File Mapping, you will be prompted for Field Mapping. Map Template Name to the Source Template field.
  8. For Department, Class, Location, and Subsidiary, click the pencil/edit button and make sure the reference type matches what the column holds (Name or Internal ID).
  9. Once mapped, select 'Next' and then 'Run'.
  10. If the fields are mapped correctly and the field contents match the field values in NetSuite, the upload will show complete, and the final templates will be available.
  11. In the event of a failed upload, review the logs for the specific reasons for the failed load and repeat the steps above.

If this was successful, you can navigate to Netgain > Setup > Shared Transactions Templates and you will be able to view the list of all the templates you just uploaded along with the individual allocation lines.

Related links


Was this article helpful?