CSV Import > Adding an Expense Report throws the error: Please enter value(s) for: Currency.

When adding a new Expense Report the CSV response a user encounters the CSV Response error: Please enter value(s) for: Currency.

 

The error is encountered if the Use Multicurency box by default is showing as checked in the Expense Report form and no currency information was mapped or manually provided in the Import Assistant.

 

To resolve the error the user can choose any of the option shown below:

 

Option 1: Disable the preference Use Multicurrency Expense Reports.

a. Navigate to Home > Set Preferences.

b. Go to the General subtab > Defaults > Use Multicurrency Expense Reports = False(un-checked).

c. Click Save.

 

Option 2: Edit the CSV file and add a column for currency or provide a default value to the Expenses 1 : Currency NetSuite field in the Field Mapping page of the Import Assistant.

 

2. 1 CSV file:

 

Currency

USD

 

2.2 Import Assistant > Step 4 Field Mapping.

 

-- Click the pencil icon to the row Expenses 1 : Currency to open a pop-up.

-- Choose Provide Default Value.

-- Select the USD value from the dropdown or popup list.

-- Click Done.

 

Option 3: Edit the CSV file and add a column for Use MultiCurrency having the value "No" or provide a default value to the Use MultiCurrency NetSuite field in the Field Mapping page of the Import Assistant.

 

3. 1 CSV file:

 

User MultiCurrency

No

 

3.2 Import Assistant > Step 4 Field Mapping.

 

-- Click the pencil icon to the row Use MultiCurrency to open a pop-up.

-- Choose Provide Default Value.

-- Select the No value from the dropdown or popup list.

-- Click Done.