The integrated Help of Invantive Control does not include the included Excel functions for Exact Online. However, you can determine the possibilities in several ways.
The easiest way after learning the function is to just type ahead and let Excel complete it for Invantive Control. For instance, enter I_EOL_DIV_NAME
and then press CTRL+SHIFT+A to have Excel autocomplete the arguments:
The second way is to type ahead such as I_EOL_DIV_NAME
and then press the function wizard and you get a list of parameters:
The most easy way is to first log on to Exact Online:
And then go to the Modeler ribbon and choose Building Blocks:
The formulas are scalar formulas, the reports are array formulas which use SQL.
Depending on which platform you are connected to, you will see different building blocks. So on Salesforce or Freshdesk there will be no Exact Online, unless you have a connection to both Salesforce and Exact Online.
All formulas on Exact Online start of with the division code which is the Belgium 'dossier' or Dutch 'administratie'. When not specified, it defaults to the last chosen division in the web frontend of Exact Online.
When you are connected to multiple Exact Online countries / data centers, you can add the alias to enable cross-country reporting, such as: =I_EOL_DIV_NAME("NUMBER@fr")
for data from the French data center.
PS. The formula you are looking for is probably I_EOL_BAL_YEAR_CLOSE
:
Answering your own question is nice; however the question still should be on-topic and good quality. At first your question is off-topic asking for documentation. Second, it's unclear as that add-in isn't well known, please provide some background to it. – Máté Juhász – 2017-01-08T11:47:25.423
@MátéJuhász I've tried to rephrase the question to better express the problem the user was having. A friend told me there should be a tag or product name so this one has been added. If you have a tip for me how to do this better? I think it could be on topic. – Guido Leenders – 2017-01-08T12:19:13.530
@MátéJuhász This is a feature from within the application, so not an off-site resource recommendation. I tried to clarify that. Can you vote to reopen? – Guido Leenders – 2017-01-11T11:50:36.693