Common Errors When Importing Expense Reports
The “Results” file for a failed expense report import might include any of the following messages.
‘Please enter value(s) for: Amount’
This error can indicate that you failed to provide a value for one of the following sublist fields:
Problems with any of these fields are referred to as problems with “Amount” because, depending on the exact details of the record, all of these fields can be critical for determining the amount of the expense.
‘You must enter at least one line item for this transaction’
This error indicates that you failed to include sublist data for every expense report record. Each expense report record must have at least one sublist record. If you are doing a multiple-file import, this error might point to a problem with the key column you are using to link the files. For example, one of the files might include a typo in this column, preventing proper linking of the expense report’s body data to its sublist data.
‘Invalid postingperiod reference key for subsidiary 1’
This error indicates a problem with the Posting Period value. Double-check that you entered the name of an existing posting period. After you have done that, make sure that your CSV files formatting is not set up to add any punctuation or special handling to the text in this column.
If you are using Microsoft® Excel, set the formatting of the Posting Period column to “Text.”