Vendor Bills Import Errors

This section describes errors that you might see on a vendor bills import. See the following:

• You must enter a line item for this transaction

• Multiple rows in your primary CSV file have the same value for the key column. Please edit this file to eliminate rows with duplicate key column values for field "ExternalId"

• Your transaction does not balance. Please Adjust Expenses/Items.: userTotal:xx: totalField:xx

• Invalid location reference key xx for subsidiary xx

• You have entered an invalid field value for the following field: amount

You must enter a line item for this transaction

If you are importing vendor bills with expenses, use two files for the import.

1. One file for the bills that contains the following fields:

   • External ID (match to Vendor Bill: External ID)

   • Date

   • Memo

   • Reference No.

   • Vendor Internal ID

   • Posting Period

   • Terms

   • Due Date

2. One file for the expenses line that contains the following fields:

   • External ID (match the external ID in your file to the Line field of the Vendor Bill Expenses sublist)

   • Account

   • Total (Do not enter Amount as the column name.)

   • Memo

Multiple rows in your primary CSV file have the same value for the key column. Please edit this file to eliminate rows with duplicate key column values for field "ExternalId"

You may encounter the error if you are using multiple files to import vendor bills with expense line items, and you are using the external ID as the reference key.

Make sure that the Primary File - Vendor Bill does not contain more than one row with the same external ID.

Sample Correct CSV Import Files

*Primary File - Vendor Bill

*Linked File (Optional) - Vendor Bill Expenses

Your transaction does not balance. Please Adjust Expenses/Items.: userTotal:xx: totalField:xx

When importing vendor bills, there are three Amount fields available on the Field Mapping page:

• Vendor Bill folder > Amount – The Amount field on the header of the bill record. This value is automatically computed by the system.

• Vendor Bill Expenses folder > Amount – The amount of each expense line added on the bill.

• Vendor Bill Items folder > Amount – The amount of each item added on the bill.

On the Field Mapping page, remove the mapping for the Amount field taken from the Vendor Bill folder. This value is automatically computed by the system, depending on the total of Expenses:Amount and/or Items:Amount fields.

Invalid location reference key xx for subsidiary xx

The xx in the error message refers to the internal ID of the location and subsidiary.

In a OneWorld account, this error occurs when the subsidiary of the location selected does not match the transaction subsidiary. Choose another location for the vendor subsidiary that is valid.

To confirm, perform the following steps:

1. Go to Lists > Relationships > Vendors.

2. Open the vendor used in the CSV file.

3. On the vendor record, take note of the subsidiary assigned.

4. Go to Setup > Company > Locations.

5. Open the record of the location used in the CSV file.

6. In the location record, the subsidiary assigned does not match the vendor's subsidiary.

You have entered an invalid field value for the following field: amount

Make sure that the Amount column does not contain a comma (,) as a separator or any currency symbols, for example, $.

General Notices