You’re offline. This is a read only version of the page.
Account total on Trial Balance does not equal Account Total on Detail G/L Ledger.
Error states "**indicates the calculated period ending balance does not match the YTD balance on AcctHist"
I have narrowed the difference down to a RE (Revenue Recognition) transaction.
How do I fix?
thank you!
*This post is locked for comments
Thanks Rick! Your answer put me in the right direction and solved the problem.
When the Detail G/L Ledger issues such a warning it means that the value in the accthist table for this account and the reporting period does not equal the sum of the debits and credits for that account and period. The first step is to determine whether the transactions showing under the reporting account/subaccount appear to be complete and accurate. If the do, then calculate the net change for that account and period, turn on initialize mode, open the account history screen and select the account/subaccount combination, fiscal year and ledger ID and edit the PTD Balance amount for the period in question to what you calculated. However, if you determine that there is a missing or duplicate transaction showing on the detail GL report then do not perform the above steps as the accthist table is actually correct and you will need to add in the missing transaction to the GLTran table. By the way, your situation is extremely rare but likely resulted from some sort of error while posting a GL batch.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (