Vendor Payment Import Errors
This section describes errors that you might see on a vendor payment import. See the following:
-
Invalid account reference key Accounts Payable xx for entity xx
-
Unable to find a matching line for sublist apply with key: [doc,line]
-
One or more bills or invoices has had a payment made on it since you retrieved the form
-
Unparseable Internal Id, did you mean to lookup this field by Name or External ID? for field xx
Invalid account reference key Accounts Payable xx for entity xx
The Accounts Payable account listed on the Transactions > Payables > Pay Bills page serves as the filter for bills available for payment.
If you use the internal ID to map the bill to be paid, you do not need to map the Accounts Payable account since the system will search for the bill and then in turn encounter the applicable AP account for the bill.
To resolve the error, remove the AP account from the field mapping.
Unable to find a matching line for sublist apply with key: [doc,line]
The error can occur when importing new customer or vendor payments and there are no open invoices with the internal ID or external ID specified in the CSV file.
In this situation you need to verify if:
-
The payments being imported are applied to invoices that are open and not already paid with a status of Paid in Full.
-
The internal ID or external ID specified in the CSV file corresponds to an existing open invoice in the system.
You can search for invoices using the external ID or internal ID. These are the only two reference fields that can be used to import vendor or customer payments, so use either the internal ID or external ID of the bill in the CSV file.
Perform one or more of the following procedures to verify the status of the invoices and resolve the error.
Use a Saved Search
To create a saved search that uses the external ID or internal ID of the invoice as a filter:
-
Go to Lists > Search > Saved Searches > New.
-
Click Transaction.
-
On the Criteria > Standard subtab, add Internal Id (Number) to use the internal ID of the invoice. You can also enter the external ID as a filter.
-
Click Save and Run. Look for the invoice and check its status.
Use the Invoice List
If you know the internal ID of the invoice that you want to verify, look for the invoice on the invoice list.
To use the invoice list:
-
Go to Home > Set Preferences > General.
-
Check Show Internal Ids and save.
-
Go to Transactions > Sales > Create Invoices > List. Look for the invoice and check its status.
Use Accept Customer Payments
-
Go to Transactions > Customers > Accept Customer Payments.
-
In the Customer field, enter the name of the customer.
-
Select the correct A/R account. Only open invoices appear on the Apply > Invoices subtab.
Use Vendor Bill Payments
-
Go to Home > Set Preferences > General.
-
Check Show Internal Ids and save.
-
Go to Transactions > Purchases/Vendors > Enter Bills > List. Look for the bill and check its status.
Use Pay Single Vendor
-
Go to Transactions > Purchases/Vendors > Pay Single Vendor.
-
Enter the name of the Vendor in the Payee field.
-
Select the correct A/P account. Notice only open Bills appear on the Apply subtab.
Use Pay Bills
-
Go to Transactions > Purchases/Vendors > Pay Bills.
-
Select the correct A/P Account. Only open bills appear on the Apply subtab.
One or more bills or invoices has had a payment made on it since you retrieved the form
The error usually occurs when the vendor bill has a term and a discount amount.
To resolve, consider the following:
-
Update the CSV import file. Payment amount should be equal to the actual payment amount due, that is, the net amount (Amount – Discount Amount = Payment Amount Due).
-
If there should not be a discount on the vendor bills, update the bill records and clear out the Terms and Disc. Amt. fields.
This error also applies when importing customer payments.
Adding new line to sublist apply is not allowed
The error occurs when trying to import vendor payments and apply existing vendor credits simultaneously. Also, the following conditions apply.
-
Vendor credits are already posted in NetSuite, and the CSV file contains the following fields:
-
External ID
-
Vendor ID
-
Payment Amount
-
ID of the Bill
-
-
The Payment Amount for the vendor bill is positive and for the bill credit the amount is negative.
-
The Vendor Bill Credit Internal ID and the Vendor Bill Internal ID are used on the ID of the Bill column.
The error will be encountered if:
-
Data Handling is set to Add. Set it to Add/Update.
-
The Vendor Bill is no longer Open or has already been paid with status Paid in Full.
-
The Bill Credit has already been applied.
-
The Vendor Bill and Bill Credit do not have the same A/P Account.
Unparseable Internal Id, did you mean to lookup this field by Name or External ID? for field xx
The xx in the error message refers to the mapped field name in the CSV file.
The value of the field mapped onto the NetSuite field Bill (Req) could not be found. Ensure that the value corresponds to the internal ID of the bill being paid. The internal ID can be taken from the URL of the bill or via a saved bill search that includes the internal ID column.