External Customer Payment

@Jeje , We you able to solve your problem? If so, appreciate it if you can provide the solution. Because, I am too facing this issue currently and don’t know the way to resolve it.

Hi @DarshiG

Yes I solved the problem. I used the file type : ExtMixedPayment with the template “MXP” that i have duplicate. 

Now i can match directly/automaticaly my file with the invoice and create a mix payment. 

Thanks for your reply! 

Best Regards, 

Jérémy  

@Jeje Thanks a lot for your prompt reply

@Jeje , I would really appreciate it if you can share the screenshot of the MXP template which you defined.

Hi, 

For sure, here you are Sir : 

Example of excel file (CSV) : 

Process with the external file assistant 

Your file is transfered if there is no error and you will find it on this path menu below : 

Then you will be able to create a mixed payment 

Basic Data : Create a Payment Format ID ; Create Payment Method and set payment method per institute 

Best Regards, 

Jérémy

Dear @Jeje  ,  

Thank you for helping today.

Hi Jeremy,

Thank you very much for the detailed explanation, it helped me setup the payment file successfully.

Have you had a scenario where there is a single payment for multiple invoices? if so, how was the upload file configured and was there a change in the file template?

Regards

Pamith

Hi Pamith, 

Did you try to set multiple invoice lines (detail line on the CSV file) and then to import the file on IFS? 

I know that if you want in your file import few customer payment invoice, you have to create one line H fot one line D. Example : 

With the screenshoot up you will have 2 customer payment on IFS.  

So if for one payment you have multiple invoice i think that you have to test one line H - Head and then 2 or 3 or X lines D - Details. 

Best Regards, 

Jeremy, 

@Jeje  Have you tired uploading a direct cash payment using the same method. If you did can you advise how you setup the external payment parameters.

Wanted to add some info to this conversation about one payment that covers multiple invoices that I found helpful

...If several invoices are included in the matching reference, the first invoice, identified in the matching reference, determines the customer for the payment. Subsequent invoices in the matching reference are matched only, if the invoice belong to the same customer ID.

Would love a direct message if anyone is interested in comparing notes on the more complex matching. 

Attaching a PDF that may be helpful.

Hi ​@Jeje 

Were you able to pay for invoices of other companies than header company?

I'm struggling with it.  External mixed payment format does not have a field for company in the line level.

Hello Jeje.

I read your previous post about external payment import in IFSCLOUD, and it was very helpful to me. However, when I'm importing now, it prompts that INSTALLMENT ID is missing. (I understand that this ID can be obtained through association with the invoice number.) But I haven't found this ID item in the payment format. Have you encountered this issue before? Thank you.