CSV Import of new Customer and Vendor Payments > error: Unable to find a matching line for sublist apply with key: [doc,line].

Scenario:

•        ImportCustomer Payment / Vendor Bill Payment viaTransactions > Sales > Import CSV Records with Import Type = Transactions > Record Type = CustomerPayment / Vendor Payment

•        CSVImport fails

•        CSVresult shows error:  Unable to find a matching line for sublist apply with key: [doc,line].

 

 

Findings:

Either:

•        The payment being imported is applied to a transactionthat already has Status = Paid in Full

•        Only open A/R(e.g. Customer Invoices) or A/P (e.g. VendorBills, Journals) transactions are available for payment

•        Thereis no existing open transaction with the InternalId or External Id specified in the CSV file

•        Theincorrect Line number was entered inthe CSV file

•        Userdid not map:

•        Customer Payment : Undep. Funds field, or

•        Vendor Payment : Account field, or

•        Currency field (if applicable)

        •         If the payment amount is greater than the remainingbalance on the transaction that the payment is being applied to (overpayingaccidentally).

Solution:

A.    Use the Internal ID encoded in the CSV file toverify if the A/R or A/P transaction is still open(available to be paid) or if it exists in the system:

1.    Navigate to Home > Set Preferences > General tab> Defaults portlet > Show Internal IDs = True

2.    Navigate to Transactions > Sales > CreateInvoices > List or Transactions> Payables > Enter Bills > List

3.    Sort the list by Internal ID then look for the CSV file's Internal ID (s) in the list

 

B.    Use the External ID encoded in the CSV file toverify if the A/R or A/P transaction is still open(available to be paid) or if it exists in the system:

 

1.    Navigate to Transactions > Sales > CreateInvoices > List or Transactions> Payables > Enter Bills > List

2.    Click the Customize View button

3.    Add External ID in the Results tab

4.    Hit the Save button (renaming the Search Titleis optional)

5.    Sort the list by External ID then look for the CSV file's External ID (s) in the list

 

C.    Use the Transaction saved search to look forthe Internal ID / External ID encoded in the CSV file toverify if it is tagged to an A/R or A/P transaction that is still open(available to be paid) or if it exists in the system:

1.    Navigate to Lists > Search > Saved Searches >New > Transaction

2.    Use the Internal ID or Internal ID (Number) or ExternalID or External ID (text) as afilter in the Criteria tab > Standard sub tab

 

D.    Line column value should be tagged to the Line ID of the A/R or A/P Account inthe open transaction

•        Basedon Lists > Search > Saved Searches> New > Transaction with these filters under the Criteria tab > Standardsub tab > Line ID = 0 (zero).

                                         i.    Type = Vendor Bill +Account Type = Accounts Payable

                                        ii.    Type = Invoice +Account Type = Accounts Receivable

 

E.    Make sure to map the following:

1.    Customer Payment : Undep.Funds field, or

2.    Vendor Payment : Accountfield, or

3.    Currency field (if applicable)