Employee Import Errors
This section describes errors that you might see on an employee import. See the following:
Please enter value(s) for: Currency
This error occurs when you add a new Expense Report and Use Multicurrency is checked, but you didn’t map or provide currency information in the Import Assistant.
To fix it, try one of these options:
Option 1: Disable the Use Multicurrency Expense Reports preference.
-
Go to Home > Set Preferences.
-
On the General subtab, in the Defaults field group, clear the Use Multicurrency Expense Reports box.
-
Click Save.
Option 2: Add a Currency column to your CSV file.
Option 3: Set a default value for Expenses 1 : Currency on the Field Mapping page.
-
On the Field Mapping page, click the edit icon beside Expenses 1 : Currency.
-
Click Provide Default Value.
-
Select USD from the dropdown list.
-
Click Done.
Option 4: Add a Use MultiCurrency column to your CSV and set the value to No.
Option 5: Set a default value for Use MultiCurrency on the Field Mapping page.
-
On the Field Mapping page, click the pencil button beside MultiCurrency.
-
Click Provide Default Value.
-
Select No from the dropdown list.
-
Click Done.
Invalid category reference key xx
To fix the error:
-
Make sure that the Expense Category is active. Go to Setup > Accounting > Expense Categories. Check the Show Inactives box.
-
If you’re using Expense Category Names, make sure the format matches what you see in the Category dropdown on the Expense Report Form. Go to Transactions > Employees > Enter Expense Reports > Expenses.
-
You can use Expense Category internal IDs instead of names. On the Field Mapping page, click the edit icon beside the Category field, click Choose Reference Type, and select Internal ID.
Expense Categories – The field name contained more than the maximum number (61) of characters allowed
The Expense Account field on expense category records can’t be longer than 61 characters (including spaces and symbols). Edit your CSV to make sure it fits.
Invalid employee reference key xx
This error can happen when importing time track records. To fix it, make sure the Employee value in your CSV is either the Employee Internal ID (to avoid name errors) or the Employee Name (using the same format as in the Time Tracking Form).
Depending on what you used in your CSV, go to the Field Mapping page, click the edit icon next to Employee, and set the reference type to either Internal ID or Names.