When running a Bank Reconciliation Report: I get the following error after clicking "Yes" on the "Do you want to remove cleared documents as of 7/31/2024?" prompt.
Program: BR_ReconciliationRegister_upd.pvc
Is there a way I can correct this?
When running a Bank Reconciliation Report: I get the following error after clicking "Yes" on the "Do you want to remove cleared documents as of 7/31/2024?" prompt.
Program: BR_ReconciliationRegister_upd.pvc
Is there a way I can correct this?
This can happen when there are multiple records that start with the same key values. I would look to see if you have multiple instances of the same check number, same bank code during the period you are working on.
Thank you, turned out to be a blank record in the GL_Bank table.
We've seen that cause problems with BR too (most especially with rebuild sort files for BR).
Sage really needs to add a check for blank rows in that table, to prevent errors / data corruption. It would be nice if the blank rows could be prevented (AFAIK the cause is unknown), but when it happens, the program should still work properly.
Thanks!
Thanks!
*Community Hub is the new name for Sage City