Automatization of payments reversals

[Marc-Alexandre Lavoie]

Hi, 

We use an other ERP to generate the sales and the payment methods. This information is then sent with the different templates to Sage intacct. We work with a lot of pre-authorized debit that are on 12 instalments. When it is the due date for those PAD, our other system sends information to Sage with the client payment template to allocate payments to those client. It often happens that there were issues with the payment and that a NSF is generate with our bank. In those instances we would like to reverse the payment that were put into Sage but never occured. To do this manually you need to do these steps:

To reverse you need to go into the accounts receivable => Subledger => Payment summaries => (you then need to find the payment) Payments => Reverse => (A pop up window will appear, you need to enter the reversal date, you can also add text in the memo section) 2024-07-04 =>submit

We would like to know if there would be a script that we can create + a trigger that we add so that the payments reversal process can be done automatically. Do we need to add something on the import template that will trigger the reversal of specifics payments?

Thank you,

Marc-Alexandre