Finance | Project Operations, Human Resources, ...

Trial Balance mismatch as on end of the month, but matching one day before

(0) Share

Report

Posted on by Chetan Dedhia

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.

I have the same question (0)

All responses (7)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chetan Dedhia 73 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Also, can you let us know your exact AX2012 R3 version (build) no?

Was this reply helpful? Yes No
Chetan Dedhia 73 on at

Like (0)

Report

Ok.

Was this reply helpful? Yes No
Chetan Dedhia 73 on at

Like (0)

Report

Kernel Version 6.3.6000.4282

Was this reply helpful? Yes No
Chetan Dedhia 73 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Trial Balance mismatch as on end of the month, but matching one day before

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Trial Balance mismatch as on end of the month, but matching one day before

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates