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
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
Share
Report
All responses (
Answers (
SELECT CHEKBKID ,
Last_Reconciled_Balance ,
Last_Reconciled_Date
FROM dbo.CM00100
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156