Invantive Control is a risk management software that integrates with Microsoft Excel. It is aimed at financial market and allows users to create risk matrices, models and plans.
http://www.invantive.com/products/invantive-control-for-excel
Questions tagged [invantive-control]
40 questions
3
votes
1 answer
Invantive Control Excel formula shows path to another user and doesn't evaluate to correct balance value
When I create myself a spreadsheet with Invantive Control, I can use formulas like I_EOL_BAL_YEAR_OPEN to get the balance year opening of some Exact Online company. When I reopen the spreadsheet, the balance is nicely calculated.
However, when a…
Jesper
- 33
3
votes
1 answer
MSI installed add-in for all terminal server users, how do I configure it just for one user?
A MSI I have installed for an Excel add-in (Invantive Control), installed the add-in for all users. I am running on terminal server, so now all users have this add-in, while it is only used by one single user. I had like just this single to user to…
3
votes
1 answer
Custom database connections lost on upgrade in settings.xml
After upgrading between two versions of Invantive Control, my custom connections for Freshdesk together with Exact Online have disappeared from settings.xml.
Is there any way to recover the settings? They were quite complex.
3
votes
1 answer
Timeout error itgenerr024 when trying to import data from Exact Online into Microsoft Excel with Invantive Control
When I execute the query I get the following error after ten minutes:
Error processing file 'c:\temp\in\GLTransactions\070-GLTransactions-2016-9-4-102.xml':Invantive.Data.OAuthException: itgenerr024: Your session has expired.
Please log on again.…
BVB
- 31
3
votes
2 answers
The Invantive Control for Excel add-in has disappeared from the ribbon in Microsoft Excel
Usually when I start up Microsoft Excel, the Invantive Control add-in loads automatically.
But it has now disappeared from the ribbon. How can I make the Invantive Control add-in active again?
Goombah
- 370
2
votes
1 answer
Unable to cast COM object of type System.__ComObject to IRibbonUI. IID 00c03a7-0000-0000-c000-000000000046 TYPE_E_LIBNOTREGISTERED 0x8002801d
After applying Microsoft .NET patches or upgrade and then subsequent downgrade of Microsoft Office, I am getting an error:
Unable to cast COM object of type System.__ComObject to IRibbonUI. IID 00c03a7-0000-0000-c000-000000000046 Library not…
Guido Leenders
- 780
2
votes
1 answer
Can not update spreadsheet with Exact Online formulas of Invantive Control
When I open a spreadsheet with formulas on Exact Online, I get the following error:
(In English: a number of links can not be updated. You can proceed without updating the values or by editing the incorrect links)
When I edit the links, I see a…
eroza
- 21
2
votes
1 answer
Unwanted Excel Sheet protection
I am running into a recurring issue while working with Invantive Control. I am building a report with multiple Invantive formulas. As I need to access more administrations than my default, I select the administration I need and deselect the default…
Jordie
- 43
2
votes
1 answer
How to select balance in Excel across multiple Exact Online divisions as with budgets across multiple accounts?
I'm using Invantive Control for Excel to create a Exact Online report using formulas.
I use the following formula to get the Period Balance:
=IF(I_EOL_BAL_PDE($F$1;$F$2;I$2;$E11;;)
I would like to get results for a certain set (or all) of my…
Jordie
- 43
2
votes
1 answer
Performance cross-company reporting on Exact Online balances
To solve consolidation problems with another package, we download all General Ledger transaction lines into an Excel sheet using Invantive Control. In Exact Online we have on each company a classification 2 which contains the code of the client,…
2
votes
1 answer
Comparing two current accounts in Excel show difference but identical values in Exact Online
I am posting transaction in two companies in Exact Online for inter-company reconciliation. In Excel I am using the following formula to check that the balance across companies is identical:
=I_EOL_BAL_YEAR_CLOSE($A$16;huidig;$A17)
This retrieves…
2
votes
1 answer
How to set up a check on authorized usage of both Invantive Control and Exact Online subscription?
Which possibilities are there for setting up a check on the license code or subscription code of both Invantive Control and Exact Online to make sure the user is authorized to use a report?
user696982
- 21
2
votes
1 answer
"itgenuty009" error when synchronising my cash flow model
When synchronizing my cash flow model, I get the following error:
De feiten kunnen niet in Excel cellen geplaatst worden door fouten in de formules. Bijvoorbeeld de expressie '=SUMIF(BALTable[ID], "=" & [ID], BALTable[Close])' veroorzaakt een fout…
2
votes
1 answer
Is it possible to call the synchronisation function using a VBA command for my Exact Online report?
I'm using Invantive Control for Excel to create an Exact Online report.
I'm changing some of the values of this report with VBA in Microsoft Excel, upon which the query is based.
So I'd like to be able to trigger the download function of the…
Goombah
- 370
2
votes
1 answer
Calculate GL classification from Exact Online real-time in my Excel report with Invantive Control for Excel
I like to get three columns in my Excel report for Exact Online with Invantive Control. I like to calculate the GL classification code and the GL classification description using as input to the Excel formula the following parameters using…
