Retrieving cost centres and cost units balance sheet account across multiple years in Exact

Questions (nl)
,
1

We use cost centres and cost units on balance sheet accounts for property investments and projects. However, it does not carry forward the balance per cost centre/cost unit on balance sheet accounts into a new year. How can I use Invantive Control to retrieve balance sheet balances for balance sheet accounts with cost centres/cost units across multiple years?

2

What exact Excel formula do you use to retrieve the balance of a balance sheet account, consisting of the opening balance and a period range?

3

Ik heb deze formule gebruikt:

=I_EOL_CCE_BAL_PDE_CLOSE
4

Is het mogelijk om de volledige formule op te nemen inclusief gebruikte parameterwaardes?

5

=I_EOL_CCE_BAL_PDE_CLOSE(VERT.ZOEKEN(O$6;Administraties!$A:$C;3;ONWAAR);O$5;‘CONSO YTD’!$B$1;1;‘CONSO YTD’!$B$2;‘CONSO YTD’!$A11)