1. SCM (Supply Chain Management)
  2. Vendors, Purchasing, and Receiving
  3. Purchasing and Receiving
  4. Expenses
  5. Landed Cost
  6. Estimated Landed Cost
  7. Setting up Estimated Landed Cost
  8. Importing Landed Cost Template Mappings

Importing Landed Cost Template Mappings

You can import mappings of landed cost templates to inventory or assembly items where you track landed cost. Through CSV import, you can assign and update landed cost templates to items in bulk, instead of adding them to item records one at a time.

Guidelines for Importing Landed Cost Template Mappings

Before you import landed cost template mappings, see the following guidelines:

  • Estimated landed cost can be only imported through CSV import, scheduled script, and web service.

  • When updating import files, take note of the following:

    • Make sure that you use the internal ID of the landed cost mapping records to be edited. For more information about locating the internal ID, see Finding the Internal ID of Records

    • You can generate a list of records to update by exporting the existing list of landed cost template mappings to a CSV file.

      To access the Landed Cost Template Mappings list, go to Lists > Accounting > Landed Cost Template Mapping. For more information about exporting records, see Exporting Lists.

    • All landed cost mapping details can be edited, except for the currency.

    • You cannot set editable fields to blank through CSV import. Existing details on the record are retained if their corresponding fields or columns in the CSV file are left blank.

    For more information about creating CSV files for import, see General CSV File Conventions.

  • Setting of a preferred currency is limited to one template per currency. If there are multiple preferred settings for a template in your file, the setting for the last row for the template is applied. For other guidelines and validations when assigning landed cost templates, see Assigning Landed Cost Templates to Items.

  • For required preferences to use import, see Setting CSV Import Preferences.

To import landed cost template mappings:

  1. Go to Setup > Import/Export > Import CSV Records.

  2. On the Import Assistant page, complete the following tasks for Step 1 Scan & Upload CSV File.

    1. In the Import Type field, select Custom Records.

    2. In the Record Type field, select Landed Cost Template Mapping.

    3. In the CSV File(s) section, select the mode and file to upload. For instructions, see Choose CSV Column Delimiter.

    4. Click Next.

  3. For Step 2 Import Options, select one of the following options:

    • Add

    • Update

    • Add or Update

    For more information, see Choose Data Handling for Import.

  4. If you are importing multiple files, complete the tasks for Step 3 File Mapping.

    For more information, see Step Three File Mapping.

  5. For Step 4 Field Mapping, ensure the fields on your CSV file are correctly mapped to the fields on the Landed Cost Template Mapping record.

    For more information, see Step Four Field Mapping.

  6. When you have completed all the import steps, click Save & Run to save the import settings and start the import job.

After running an import, the job is placed in a queue for processing. On the Finished page, click Import Job Status to view the status of the import job. For more information, Checking CSV Import Status.

Only records with valid data are added or updated on the Landed Cost Template Mapping records. If the import file contains errors, you can download the CSVResponse.xls file to view the error details.

To view the available landed cost templates for an item record:

Important:

You cannot view or edit a Landed Cost Template Mapping through the NetSuite user interface. For more information about adding or editing landed cost template mappings per item, see Assigning Landed Cost Templates to Items.

  1. Go to Lists > Accounting > Items.

  2. Click View next to the item you want to view.

  3. On the Landed Cost Template subtab, the available landed cost templates for the item record are listed.

  4. (Optional) If you want to set a Landed Cost Template to preferred, check the box in the Preferred column.

You can delete existing landed cost template mapping records through a scheduled script or web service only. When a mapping is deleted, the estimated landed cost details on associated transactions are retained. However, you cannot select the template when you create or edit transactions, including related transactions such as item receipts generated from purchase orders.

Related Topics

General Notices