Auto reconciliation problem

Hi All,

In our project, initially, the bank statements which were imported had no reference to the payments like payment reference number and therefore the auto reconciliation seeded program used to reconcile only about 5% of the lines and the rest had to be reconciled manually.

Therefore a custom program was developed to enrich the bank statement lines with a suitable payment reference number while they are present in the interface table, so that the auto reconciliation program would auto reconcile these.

The system being followed currently is as follows:

1) For direct debits, a single bank statement line is created in Cash management.