Getting this error when CSV uploading bill payment...
# administration
e
Getting this error when CSV uploading bill payments to open bills - unable to find a matching line for sublist apply with key. We are matching by external ID. Anyone else having this issue?
n
Have you successfully done this previously using the same lines you are targeting this scenario?
e
yes we do this every month end, our field mapping originally didn't have any line ID, then tried adding Line 0 but still failed so we went back to having no line mapping. Tried 3 times on Thursday last week but failed, tried 1 time on Friday last week and failed. Last attempt was on Monday and it went through, no changes made....
just wanted to narrow down what's causing the failure. We want to know root cause so we can avoid it the next time we have a bigger payment batch
n
My suggestion is to begin by running a saved search against the bills you are trying to import against, and expose the External ID for the lines, and ensure that matches your upload file of Bill Payments. If you are trying this process on lines you have never done it for previously, it’s possible they don’t have external IDs.
e
I will try that. Thank you
1