Microsoft Dynamics AX (Archived)

Total of the transactions in the year is not 0.00. Total is -0.03 (End Year Closing Process)

(0) Share

Report

Posted on by Community Member

Dear All AX Experts,

I'm using Microsoft Dynamics AX 2012 R2,

Please help me to solve this issue doing end year closing process,

When I'm run end year closing process, AX give an error message like i attached below:

"Total of the transactions in the year is not 0.00. Total is -0.03. This is a serious error. Run \"Check\" on ledger transactions"

1325.image002.jpg

What i have tried :

1. I have run check and fix error using consistency check but there is no error,

2. I also have check using SQL database (table GeneralJournalAccountEntry, GeneralJournalEntry, and FocusDimensionBalances) but there is no difference from those tables.

Really appreciate for any ideas and suggestions,

Thanks Before,

Chris

*This post is locked for comments

I have the same question (0)

All responses (28)

Answers (2)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Chris,

Have you tried increasing your cent rounding to e.g. 0.05 to overcome this issue?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

Is it in General Ledger> Setup> Currencies Setup?

If I change it to e.g. 0.05 will it effect all posted vouchers in GeneralJournalAccountEntry table?

Thanks,

Chris

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Chris,

This change will not affect already posted transactions but only future transactions that are posted.

If you change the setup for a short while in a test environment you should be able to verify whether the rounding setup is responsible for the outcome you see.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

Sorry after i update using database (Query to table GeneralJournalAccountEntry, GeneralJournalEntry, and FocusDimensionBalances) the error become "Total of the transactions in the year is not 0.00. Total is -4.86. This is a serious error. Run \"Check\" on ledger transactions" if i round it to 0.5 i think it still error because the unbalance amount is -4.86 but there is no unbalance amount in that 3 tables, are there another tables i've to check? or are there any suggestion to adjust this unbalance amount due to end year closing process?

are there any suggestions?

Thanks,

Chris

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Chris,

Please check the following solution on LCS

https://fix.lcs.dynamics.com/Issue/Solution?bugId=3656289&qc=05c092291c51d53360f7e189ce59dab9f88ae88d8d516fc1d8863b283812806f

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

Sorry, I'm using AX 2012 R2, is there LCS for year end closing for AX 2012 R2?

Thanks,

Chris

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Chris,

Have you tried doing the following - as described in the solution - which is in my opinion Independent of the R2 or R3 Version.

- Uncheck the delete close-of-year transactions during transfer check box.

- Check if an account has opening account in the main account setup and possibly remove it

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

Like (0)

Report

Hello Chris,

Have you been able to get this resolved?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Dear Ludwig,

I have tried what you have suggested but the errors still exist,

I updated via sql query using table GeneralJournalAccountEntry and then i rerun year end closing and it solved my issue,

Thanks,

Chris

Was this reply helpful? Yes No
Mateen Rasool 45 on at

Like (0)

Report

Hi Chris,

I am facing same issue in year end closing can you tell me what you fix using SQL query in general journal account entry table ???

Was this reply helpful? Yes No