Forums › Cached › CSV Import
This topic contains 6 replies, has 3 voices, and was last updated by Steven Yurkas 5 years, 3 months ago.
-
AuthorPosts
-
snature- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
RE: Import customer payments
Any resolution on these customer payment imports?
-
fjannelle- Contributions: 0
- Level 1
- ☆
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.
-
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?
-
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.
-
AuthorPosts
You must be logged in to reply to this topic.