[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.

[Author]

Posts