22,782
*This post is locked for comments
What should i do from here, there is a difference when i run the first script
Thanks Vinutha,
Turns out the issue was between CB20001 and CB90025 which I caused when trying to resolve another issue. I'd struggled to find the exact table with the balance causing the conflict so thanks very much.
Ian
Hi Ian,
The system will essentially use two calculations when you select the chequebook within the Bank Statement Reconcile window. If these two calculations do not match, then the result is the error message stating "There is a problem with this Chequebooks balances." In order to determine the source of this error message, it will be important to look at the following:
1. Can you please run the following statement in SQL against the company database and see if there is a difference returned:
select
(CB_Opening_Balance - CB_Payments + CB_Deposits) as calc1,
(CB_Statement_Balance - CB_Outstanding_Payments + CB_Outstanding_Deposits) as calc2,
((CB_Opening_Balance - CB_Payments + CB_Deposits) - (CB_Statement_Balance - CB_Outstanding_Payments + CB_Outstanding_Deposits)) as diff from cb900025
where chekbkid = 'XXXX'
and cb_period = 'YYYY'
NOTE: You will need to replace XXXX with the checkbook ID that you are trying to reconcile, and you will need to replace YYYY with the period that you are trying to reconcile.
2. When you look at the CB900025 table for the checkbook ID in question, does the closing balance (CB_Closing_Balance) value match with the next period's opening balance (CB_Opening_Balance) value?
3. When you look at the CB400005 table (CB Recon History), do you see any transactions that have dates which belong to the current open period?
4. If you check the Reconciled Date Field in the CB900035 table, do you see any transactions that have a current period closing date in the Reconciled Date field?
5. Are there any records in the CB900036 for the checkbook ID?
It will be important to look at each of these items to determine the source of the error message that the client is experiencing.
Regards,
Vinutha
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (