Upload Incoming Payment using DTW

[Former Member]

Dear Expert,

My client want to upload incoming payment based on invoice but i have received error *Confirmation amount must be greater then Zero*

I am using two templates

1.Payments

2.Payments_Invoice.

Guide me that how many coulmn must be filled in both templates.

BR

Manvendra

[Former Member · Accepted solution]

Dear Manvendra,

As the error message indicated, you need to set confirmation amount > 0.

You may run query on ORCT and RCT2 to find out what is mandatory.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank you Gordon,

I have tried all combination in both templates(Even i have filled all amount column in sheet but did not get success) but got same error .

Now is it possible or not I dont know let me clear on my point ?

I felt that we can only import on account payment by incoming templats.

Yes We can import and finally i have imported incoming payment based invoice.

For reference find attached file.

BR

Manvendra

ORCT - Payments1.csv.zip

RCT2 - Payments_Invoices1.csv.zip