I often come across this request from GP Users:
This happens when the User try to reconcile from CBM Reconcile. And once he/she selects the Checkbook which needs to be reconciled.
After some SQL Profiling & Dex Script Log, I found the following:Cause
The table CB100006 contains the User Checkbook Activity records, as and when a User reconciles a Checkbook. This table for some reason is not cleared properly. Sometimes:
1. If you open the form, enter the Checkbook ID and just close it without any activity, this record is not cleared.
2. If you open the…