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
When importing a new invoice, the error is received if a default value was entered in the Items : Item (Req) NetSuite field on the Field Mapping page of the Import Assistant.
If you are 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 then 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]
The error occurs when there are multiple invoice numbers being matched to a single credit memo. If the invoice internal ID is listed multiple times, NetSuite looks for corresponding amounts for the other lines, which do not exist.
For example, there are three items on a credit memo and it is being applied to a single invoice. The CSV file contains the following information:
|
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 resolve the error, 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 |
— |
There should be 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.