Cash Manager Bank Reconciliation out of balance to GL

(0) Share

Report

Posted on by SandyF

412

Bank Recon for the current month show the GL balance as 29554.17, if you look at the GL Trial Balance and Detail report the GL balance is 4554.17. Which balances to my CASH Manager and Bank Statement. If I run the Bank Reconciliation report and look at the wrkcabalances the glbalance is 4554.17 but the curyglbalance is 29554.17. This is consistent with entries I found in the CATRAN table that did not have a CURYIID. The question is how to fix? what tables should I be updating and rebuilding to get the correct CURYGLBalance in the wrkCABalances table.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Carolyn Kolpien on at

Like (0)

Report

Hi Sandyf,

The Bank Reconciliaton screen looks at the CuryAcct table to get the GL balance that it displays in the screen. You could try and update the CuryAcct table by making a small change in the Account History screen (in Init Mode) for that account/subaccount/fiscal year. Save that change and then change it back to what it was. Maybe just change a balance by $1 or something and then change it back. Sometimes this refreshes the CuryAcct table. Otherwise, you may need to fix it in SQL.

Let me know how else I can assist.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I had the same issue, GL was out of balance in Bank Reconciliation. I changed the balance in Initialize mode like Carolyn suggested and it worked!

Thanks Carolyn!

Was this reply helpful? Yes No
Butch Adams 4,763 on at

Like (0)

Report

Weird. I fixed this exact problem for a client this week. (Using the solution Carolyn suggested)

It's almost like an epidemic.

Was this reply helpful? Yes No
Sherry Whitten 329 on at

Like (0)

Report

Carolyn,

I confirmed that ACCTHIST and CURYACCT tables both have the correct balance for YTDBAL06 and CURYYTDBAL06. When I first looked in these tables, the ACCTHIST had a balance of 10,075, but the CURYACCT had 10,075.00000001. I used initialize mode to tweak a period balance for this account, and that changed CURYACCT to 10,075. So the two tables are now the same.

But when I generate the Bank Rec Detail report, WrkCABalances has a CURYGLBALANCE and GLBALANCE of 0.00. I cannot determine why it is not picking up the GL Balance. The Bank Rec Detail report is not customized.

Never mind - CA Setup was not marked to show GL Bank Recon Information.

Any ideas? Thanks.

Was this reply helpful? Yes No