Payment entry and payment reconciliation with thousands of invoices

Hello, we are facing following issue while try to enter payment or do payment reconciliation.

Some of our customers has thousands of invoices with small balances.

When we making payment entry or do payment reconciliations, ERPN tried to fetch the invoices balance for hours, just to make $50 payment entry or reconcile payments.

Is there any other way to make this process smoother or faster? Can we do it through a Journal entry? I do not see any Payment in journal entry reference type though.

Appreciate your input.

If you know the invoices that need to be reconciled and also the payment entries, maybe you can try a script from the console to do this OR if you are facing performance issues on the Payment Reconciliation screen you can try to enable slow query log and tune the queries or add indexes.

1 Like