Invoice Import Errors

This section describes errors that you might see on an invoice import. See the following:

You must enter at least one line item for this transaction

This error happens when you import a new invoice and set a default value for the Items : Item (Req) field on the Field Mapping page.

If you're importing an invoice with a single item, it must be referenced in the CSV file as a separate column.

Set Data Handling to Add and on the Field Mapping page map the following fields:

Customer

Customer (Req)

External ID

External ID

Location

Location (Req)

Date

Date (Req

Item

Items: Item (Req)

Unable to find a matching line for sublist apply with key: [doc,line]

This error happens when you try to match multiple invoice numbers to a single credit memo. If the invoice internal ID shows up more than one time, NetSuite expects matching amounts for each line, which aren’t there.

For example, if you have three items on a credit memo and you’re applying it to one invoice, your CSV might look like this:

Invoice Internal ID

Credit Memo Internal ID

Customer Name

Amount Applied

1234

5678

John Smith

300

1234

5678

John Smith

1234

5678

John Smith

This will generate the error. To fix it, modify the CSV file as follows:

Invoice Internal ID

Credit Memo Internal ID

Customer Name

Amount Applied

1234

5678

John Smith

300

5678

John Smith

5678

John Smith

You should have one invoice internal ID for each line item. Since the invoice has one line item, the invoice is listed one time and the corresponding total amount being applied is also listed one time.

Invalid item reference key xx

The CSV file should contain the same Item Name format as shown in the Item dropdown list shown in Transactions > Sales > Create Invoices > Items > Items.

The internal ID can be used instead of the item name. On the Field Mapping page, click the edit icon beside the Item field, click Choose Reference Type, and then select Internal ID.

Determine if the item is inactive. If the item record is inactive, set its status to active:

  1. Go to Lists > Accounting > Items.

  2. Check the Show Inactives box.

  3. Clear the Inactive box beside the item name.

  4. Click Submit.

Related Topics

General Notices