[snature]

I am trying to import by csv customer invoice payments but I keep getting the error message:

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

I have mapped these fields from a csv saved search of customer payments:

Commonwealth Bank Account

Company Name Customer (Req)

Internal ID ExternalId

Memo Memo

Date Date (Req)

Amount Invoices : Payment (Req)

Invoice Number Invoices : Invoice (Req)

Number Invoices : Line

Can anyone advise what I am doing wrong?

Thank you

Nigel
This is a cached copy. Click here to see the original post.

[jean-remi.gagne]

Hi Nigel,

Your invoice number is not pointing at the right transaction. I would remove the last mapping that you have which is the Line column and only have the Invoice Internal ID instead of the assigned Invoice Number.

Thanks!

[ddestefano@bit9.com]

RE: Import customer payments

I am having the same problem and tried everything and cannot get it to work. I have imported a bunch of invoices and now I want to import the payments to mark them paid.

I’m getting the same error message:

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

Can’t figure it out. Is anyone successfully importing payments? Any tips would be appreciated.

Derek

[corbin@tatt.ly]

RE: Import customer payments

Any resolution on these customer payment imports?

[fjannelle]

The key to make it work is to map the ‘Internal ID’ to the ‘Invoices : Invoice (Req)’ field. Mapping it to the Invoice number will simply not work. You will need to export the Internal ID of each invoice you want to pay and cross reference them in your CSV file.

Also, do not map the ‘Line’ field unless you know for certain on which line the invoice is situated in the customer payment sublist.

[Efi Iskandar ZainuddinMember @efi_iskandar_zainuddin]

I am facing the same problem.

Mapped the invoice id with invoice internal id but still get the same error.

Has anyone solved this issue?

[Steven YurkasMember @steven_yurkas]

I was able to solve this issue by adjusting a few things:

1) Make sure that you select something for undeposited funds. It doesn’t say that this field is required, but it is

2) Make sure that the AR account matches with the AR account on the invoice that you are applying to. If these differ then this error will come up.

[Author]

Posts