Hello dear community,
each month my company generates direct debit files for thousands of customers. Following that, the customer payment journals are posted, invoices are settled and set in stone.
After a few days we receive notification from the bank that among the thousands of direct debits, several hundred failed. These failed customer payments come to us in the form of a standard CAMT.054 file that is easily imported in a customer payment journal.
My issue is that the import of the camt.054 file only creates "opposite" payment transactions (debit instead of credit), which balance the customer accounts, without any link to the invoices which payment were rejected. Therefore I need to find a way to repoen these customer invoices in bulk.
The monthly amount of failed direct debit (several hundreds) makes the manual cancellation not efficient at all.
My question are:
- is it possible to make the payment journal reopen paid and settled past customer invoices in bulk?
- if not, is there a way to use the "cancel payment" functionnality
Thanks in advance for your help,
Alexis
