Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

CA and GL balances out?, all entries match except for total

Posted on by 20

Anyone encountered CA balances not matching GL balances even when all individual entries are equal?

What table can I use to correct the $0.20 that it is off by?

Thanks

Eric

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: CA and GL balances out?, all entries match except for total

    Hi Eric - You might take a look at two tables in SQL.  The AcctHist table and the CuryAcctHist.  I found that the CA Balance pulls from the CuryAcctHist table but the GL Data pulls from the AcctHist Table.  If the GLBalance in the Cash Manager module does not match the GLBalance on say your Trial Balance, then the CuryAcctHist table might be out of sync.  I have seen this a couple of times over the year (not super common but it does happen)

    If it is just a matter of the the CA and GL no matching - it's more than likely a date issue.  CA looks at the date of the transactions where GL looks at the Period to Post.  You would need to check all of the dates on the transactions in GL and CA to make sure that the transaction date lines up to the period to post.

    Hope this helps.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans