Consolidated TB not correct.

(0) Share

Report

Posted on by joebongiorno

454

I consolidated one of my companies...like I have been doing for the past 10 years. But this time, when I went to view the TB, the balance is not correct.

If I go to chart of accounts....and view one account. I click on transactions and download to excel. I add them up manually the amount is correct. But when I run the TB or if in chart of accounts I run Balance, setup...the amount is not correct. It is taking the balance of the prior month. It is not including the transactions of the current month in the balance. (although the transactions are there since I can see them when I download them in excel)

Yesterday when I tried the balance was correct. But I had to make a correction in one of my subsidiary companies...so I removed the transactions of the month and then reran the consolidations ( I have done this many, many times over the past 10 years and never had an issue.). But now I am. Not sure why and don't know how to correct this.

From first image below...it is showing a balance of $6,740.97. From the second image below, when I download the transactions and sum up manually, it showing a balance of 9,522.67. This is the correct number. But not sure why the TB is now showing this number. The difference is exactly 2,781.70. This is the total transaction for this last month.

It seems that it removed the transactions for that month twice? I do not recall but I may have a had a couple of AX open and hit remove transaction on one AX and then hit it again on another AX (but I am not sure)

Any suggestions?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidated TB not correct.

Hello joebongiorno,

This error message requires a developer to get the problem resolved.

You cannot do it yourself from the AX client.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

RE: Consolidated TB not correct.

Hi Joe,

This error is thrown by database while trying to recalculate the balances that may eventually solve the incorrect balance problem. Please work with technical team and see what may be causing this and then try to recalculate the balances again. This is something that works out of the box but we see you are having issues so tech team can come to your rescue.

Thanks,

Satish Panwar

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
joebongiorno 454 on at

Like (0)

Report

RE: Consolidated TB not correct.

When I ran the recalculate period balances I received this error message

Was this reply helpful? Yes No
joebongiorno 454 on at

Like (0)

Report

RE: Consolidated TB not correct.

Hi

What do you mean by technical help? I am not receiving any error message. Do we need to remove records from tables? Which table?

Thanks

Joe

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidated TB not correct.

Hi joebongiorno,

It seems that you have already done what you could possibly do from the AX client. I think that you will need some technical help here to get this fixed.

Best regards,

Ludwig

Was this reply helpful? Yes No
joebongiorno 454 on at

Like (0)

Report

RE: Consolidated TB not correct.

I did run the consolidation again and still the error. I actually removed the transactions. And still getting the error.

It seems that it doubled up the removal. When I look at the detailed transactions....they are all correct. But when I look at the summary of the TB..it is removing an amount again. Simple example:

Feb total is $1,000. March total is $1,000, April total is $1,000 and May total is $1,000. When I run the balance at May the amount is $4,000.

But then I removed the transactions for May from consolidation. If I run the total for April I get $3,000. If I run the total for May I should get $3,000 (since I removed the May transactions). But instead I am getting for May $2,000. It is taking the April balance of $3,000 and deducting 1000. If I just run the balance for May I get (1,000).

Very weird.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Consolidated TB not correct.

Hi joebongiorno,

Have you tried running the consolidation once again as you did it before? If this does not fix the issue let's have a technical expert look into this to ensure that the transactions have not remove multiple times as you mentioned.

Best regards,

Ludwig

Was this reply helpful? Yes No
joebongiorno 454 on at

Like (0)

Report

RE: Consolidated TB not correct.

I tried running recalculate period balances. But no luck. Still getting the same error.

Anyone have any ideas?

Was this reply helpful? Yes No