Importing Landed Cost Template Mappings

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

To prepare for your import of landed cost template mappings, see the following guidelines:

• Estimated landed cost can be imported through CSV, scheduled script, and web service only. Other contexts are not supported.

• When updating import files:

  • Be sure to use the internal ID of the landed cost mapping records to be edited. For 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 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 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 the option to add the file, update it, or both.

   To view the instructions, see Choose Data Handling for Import.

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

   For instructions, 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 instructions, 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.

   Note:

   For import files with errors, only records with valid data are added or updated on Landed Cost Template Mapping records. You can download the CSVResponse.xls file to view the error details, which are listed in the first column of the file.

To view landed cost template mapping records:

1. Go to Lists > Accounting > Landed Cost Template Mapping.

2. Click View to open a record.

   • On the Landed Cost Template Mapping record, you cannot edit the details, create a new record, or make a copy of it.

     For information about adding or editing landed cost template mappings per item, see Assigning Landed Cost Templates to Items.

   • You can delete existing records through scheduled script or web service only. When a mapping is deleted, 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

Setting up Landed Cost Templates

Assigning Landed Cost Templates to Items

Setting up Estimated Landed Cost

General Notices