
All,
I am unreconciling a certain bank.Am using bank management.
I have manupilated the below tables for that chequebook.
cb900025
cb200001
cm00100
CB110001
CB600001
CBINT001
But the fields for last reconciled date and last reconciled balance are inactive so I cant redo the reconciliation
.
RomRyan
*This post is locked for comments
I have the same question (0)Hello Romryan
Both fields; last reconciled balance and last reconciled date, can be modified after setting up the checkbook. Once you complete a bank reconciliation for the first time, they both get updated and locked accordingly.
The values are stored in CM00100
SELECT CHEKBKID ,
Last_Reconciled_Balance ,
Last_Reconciled_Date
FROM dbo.CM00100
Your feedback is highly appreciated,