Announcements
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.
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
Share
Report
All responses (
Answers (
