Chart of accounts - Totals and Group Totals

Finance and Operations/AX User Forum
1

Calling all Finance consultants -

I am configuring my COA and I have set totals for certain sections of the COA for example - Revenue etc or Assets. Problem is the totals are spilling ove rin to Trial balance effectively doubling up the values giving me a dodgy Trial Balance.

I am unsure of how Group totals work but guessing it would be the same with them too.

Question - How do I make the COA functon so that you can see the totals on the COA overview but they dont double up on TB?

Thanks for your time

Ken

2

Not a finance consultant, but I presume you have lets say a number of accounts set to type “Balance” and at the end you have one with “Total”. Against the total line you should have an active setup button, and the totals line lists the accounts above. You do not post to total accounts, so they will not double up in the TB as they are simply a total of the defined accounts.

Not sure what you mean by the spilling over, but in the overview this would be due to the totals setting I believe. Row definitions on financial statements are a different matter I believe.