You’re offline. This is a read only version of the page.
Announcements
73
Dear All,
I have this issue of trial balance not matching for period 01-Apr-21 to 31-Aug-21 in AX2012 R3. However when the trial balance is generated for period 01-Apr-21 to 30-Aug-21, its matching. I have rebuild balances for dimension set and also did recalculate ledger periods, but still the balances are not matching,
I found this query on one of the forums and when executed, the balance are not matching as well in the table as well
SELECT sum(CreditAccountingCurrencyAmount),sum(CreditReportingCurrencyAmount),sum(DebitAccountingCurrencyAmount),sum(DebitReportingCurrencyAmount) FROM DimensionFocusBalance group by DimensionFocusBalance.FocusDimensionHierarchy, DimensionFocusBalance.Ledger
Please advise.
Regards,
Chetan.
Hi Ludwig,
Trial balance GL account total is not matching with the Voucher transactions for the GL account. Still figuring out the complete details (voucher wise).
What can be possible solution to fix it?
Thanks,
Chetan
Kernel Version 6.3.6000.4282
Ok.
Also, can you let us know your exact AX2012 R3 version (build) no?
Hello Chetan,
Have there any filter been applied when exporting the data?
Can you compare your exported and summarized data with the ones that you can identify in the voucher transactions inquiry form? That is, please try to filter your data - for the different date ranges - in the GL voucher transactions form, export them to excel and see if this gives you the same result.
Best regards,
Ludwig
Hi Ludwig,
I exported the Trial Balance in excel and Summed up the DR and CR balances
- Period 01-Apr-21 to 30-Aug-21 > DR balance is equal to CR balance
- Period 01-Apr-21 to 31-Aug-21 > DR balance is not equal to CR balance
- Period 30-Aug-21 to 31-Aug-21 > DR balance is not equal to CR balance
- Period 31-Aug-21 to 31-Aug-21 > DR balance is not equal to CR balance
Regards,
Chetan.
Hi Chetan,
What did you use to reconcile the trial balance data against?
Did you use your select statement, the financial reporter or something else?
Best regards,
Ludwig
#1
André Arnaud de Cal...
294,208
Super User 2025 Season 1
#2
Martin Dráb
232,970
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
