How can I import a csv to apply a large posted payment to multiple invoices

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi there,

I have a customer that sends in 1 lump sum payment for hundred of invoices. They do send int he backup as a CSV sheep.

After the payment was posted to the customers account, I go to the payment, click apply, and then I press the Import button. After I pick the spreadsheet, I get the attached error.

0245.import-error.JPG

Am I doing something wrong?

It takes me hours to post 1 payment, would be great if I can import the application.

Thank you in advance

Emily

All responses (1)

Answers (0)

Suggested answer

T.I.A 1,760 on at

Like (0)

Report

RE: How can I import a csv to apply a large posted payment to multiple invoices

There's an issue with length. The Document no. has more digits or characters than the field it's trying to map to. Go to the field definition for this field and make its length or number higher