Subtotal not appear on financial statement (traditional) on groups

(0) Share

Report

Posted on by Abdullah Sarhan

Dear all

hope this finds you well

i am trying to create balance sheet using financial statement (traditional) i create groups for two levels, when i print out the report it dose not show subtotal for the second level.

is this normal in ax our is there any solution, and what is the solution.

following the layout

ScreenHunter_5F00_10-Jul.-18-21.41.jpg

Regards,,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Abdullah,

Can you post a screenprint that shows how you setup your row definitions?

Have you used a calculation type row and included all elements or have you made use of a group row type?

Ludwig

Was this reply helpful? Yes No
Abdullah Sarhan 90 on at

Like (0)

Report
Copy link

Link copied!

Dear Ludwig

thank you for your reply

following Screen shot of the setup for the definitions, i did not use the calculation type for , i used group , calculation gives duplicate amounts.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you check whether your subelements / sub-nodes have a value assigned similar to what you can identify from the next Screen-print?

Please also check that your sub-elements do not have the "hidden" checkbox activated.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Abdullah Sarhan 90 on at

Like (0)

Report
Copy link

Link copied!

hi Ludwig

i have test the steps that you send it and it works properly , i have another question regarding financial statement, can we dynamic make cross tab for months , as following

Thank you very much

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, This can be realized by Setting up lines that represent your months and by entering a date interval code in the setup tab of your different lines.

Best regards,

Ludwig

Was this reply helpful? Yes No