This topic describes typical problems you might experience when using the CSV Import Assistant to create or update inventory cost revaluation records.
Field Mapping Error
When you click Next on the Field Mapping page, you might encounter an error that says “You must map one of the following NetSuite fields to a column in your CSV file, to be a unique identifier: External ID, Internal ID, or a transaction number field, such as Order # or Invoice #.” This error occurs when you are trying to add records, and you have not mapped a unique identifier for the records. Specifically, you must map a value for either ExternalId or Ref. No.
Mandatory Field Missing
You may see the “Mandatory Field Missing” error after clicking Next on the mapping page. This error can occur in cases where you have chosen a data handling option of Add on page 2 of the Import Assistant, and one of the following problems occurred:
You mapped a required field to a column in your CSV file, but one of the rows in your file is missing a value in that column.
The Import Assistant is trying to process a row in your file that you intended to be empty. If you are using Microsoft® Excel, select the first few empty rows following the last row where you intended to include data. Right-click, and select Delete > Entire Row. Save your file, then try the import again.
An Inventory Cost Revaluation Already Exists for this Item, Location, and Date
Each inventory cost revaluation record must use a unique combination of item, location, and date. In other words, if you are trying to create an inventory cost revaluation record for Widget A in your East Coast Warehouse, you can only submit one revaluation for any specified date.