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 can"t 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.

Related Topics

• Estimated Landed Cost Template Setup Guide
• Creating Landed Cost Templates
• Guidelines for Assigning Landed Cost Templates to Items
• Assigning Landed Cost Templates to Items
• Importing Landed Cost Template Mappings
• Viewing Landed Cost Templates on Item Records

General Notices