totaling accounts in the management reporter

(0) Share

Report

Posted on by Community Member

Hi Gurus

While i was defining the row definitions for the management reporter(financial statement), i met a tricky problem. i have some main accounts defined as below:

the main accounts inside the red rectangle are "Total" type, but when i tried to link the row definition with the financial dimensions, only three of them as listed in the "Totaling accounts" in the management reporter as below:

But if i select the "Individual or range", and browse the individual main account, i do can find some of the "Total" main accounts.

i check the Total settings for these main accounts in the "Chart of accounts", all of them have sub-account defined, from my point of view, the main accounts "1401.02" and "1401.03" should belong to the "Totaling accounts". Does anyone know how the management report distinguish the main accounts?

Many Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Matloob 781 on at

Like (0)

Report

Hi jianrui

Have you checked nothing is defined in Active from and active to date in 1401.2 and 1401.3? please also check sub-accounts you have defined in above accounts has got some transactions ?

Regards

Mohammad Matloob

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

[quote user="Mohammad Matloob"]

Hi jianrui

Have you checked nothing is defined in Active from and active to date in 1401.2 and 1401.3? please also check sub-accounts you have defined in above accounts has got some transactions ?

Regards

Mohammad Matloob

[/quote]

Hi Mohammad,

i have already checked the settings, none of them has transactions posted, and i didn't configure the "Active from" or "Active to" for any of these accounts.

Thanks.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report

This is a AX bug, the solution to fix this issue as below:

In the DimensionAttributeValue table there is a column called IsTotal which should be 1 (TRUE) for the totaling accounts. That is more than likely a 0 for the accounts that are not showing in MR correctly.

In the DimensionAttributeValue table the EntityInstance is the RecID from the MainAccount table. So you can find your account in the MainAccount table, get the RecID of that account and then search for that value in the EntityInstance column of the DimensionAttributeValue table and look at the IsTotal.

Thanks.

Was this reply helpful? Yes No
Matloob 781 on at

Like (0)

Report

Thanks for sharing the bug and its solution Jianrui.

Was this reply helpful? Yes No
Musalaiah 25 on at

Like (0)

Report

Hi Mohammad,

I created a Total account in AX. Then in MR in row definition selected the account as a Totaling account and account intervals were populated in the Formula field. Which is correct.

Then I configured additional total account intervals in AX. but they did not populate in MR. When I select the account as totaling it does not populate new accounts in the Formula field. I refreshed the cached financial data and restarted the MR services.

Please do the needful.

Thanks and regards

murali.kambampati@gmail.com

Was this reply helpful? Yes No