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:
-
Go to Lists > Accounting > Items.
-
Check the Show Inactives box.
-
Clear the Inactive box beside the item name.
-
Click Submit.