# Questions tagged [invantive-control]

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

**0**

votes

**1**answer

44 views

### Opening balance from Exact Online not coming through for I_EOL_BAL_PDER with Invantive Control

When I use the formula I_EOL_BAL_PDER, the opening balance is not include in the amount.
How can I include the opening balance as well in the Excel formula?

**2**

votes

**1**answer

128 views

### 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 ...

**3**

votes

**1**answer

206 views

### 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 ...

**0**

votes

**1**answer

19 views

### Error itgengpr020 / itgenuty427 on log on to Invantive Control for Excel with Exact Online

When I log on to Exact Online from within Invantive Control for Excel, I get the following error:
There are 1.005 available partitions. This exceeds the maximum allowed
number of 1.000 partitions....

**0**

votes

**0**answers

28 views

### Invantive Control - Use SUMIFS

I'm building a block where a want a formula to be put in one cell.
What i got is the following:
"=SUMIFS('Interne tarieven'!B:B,'Interne tarieven'!A:A,$C{E,.,.,^+10,.},'Interne tarieven'!C:C,"<="&...

**0**

votes

**1**answer

13 views

### Get outstanding amount of purchase and sales order with a certain invoice number from Exact Online with a formula

I like to get the outstanding amount of the sales orders and purchase orders with Invantive Control for Exact Online.
Is there also a way to filter these invoices?

**0**

votes

**1**answer

42 views

### itgenuty530: The document property 'INVANTIVE_REPOSITORY' can not be accessed since Excel is busy calculating

When opening a spreadsheet with Exact Online formulas and Invantive Control blocks I receive the following error:
itgenuty530: The document property 'INVANTIVE_REPOSITORY' can not be accessed since ...

**2**

votes

**1**answer

23 views

### 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 ...

**0**

votes

**1**answer

11 views

### Resolve itgenuty436 error during synchronization in Excel with database

When running synchronization on Invantive Control for one spreadsheet which downloads data from multiple databases, I get this error with error code itgenuty436:
Kon het Excel bereik ''Exact ...

**0**

votes

**1**answer

21 views

### Avoid message “The Invantive Excel functions can only be installed when you have exactly one active Excel process.”

During startup of Excel I sometimes receive the following message:
The Invantive Excel functions can only be installed when you have
exactly one active Excel process.
Please end all 2 Excel ...

**1**

vote

**1**answer

24 views

### itgendch023: Backing database of Data Cache could not be opened

I've configured Invantive Data Cache on my connection to Exact Online Belgium. It connects fine. But when I run the following query (for example) as a first query:
select * from me
I get a:
Backing ...

**3**

votes

**1**answer

51 views

### 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 ...

**0**

votes

**1**answer

18 views

### Can not retrieve classifications from GL Account using I_EOL_GL_ACTCLN_CODE

I am using the following Excel formula to retrieve the Exact Online classification code from a GL Account:
=I_EOL_GL_ACTCLN_CODE(A3;B3;)
where A3 is the division code (the number), B3 is the General ...

**1**

vote

**1**answer

27 views

### Weird column names in pivot table when downloading Exact Online data with Invantive Control

I've configured a block in Invantive Control which downloads data using the query:
select sii.QuotationNumber
, sie.QuotationNumber
, sii.quotationDate
, sii.DueDate
, sii....

**3**

votes

**1**answer

18 views

### 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 ...

**0**

votes

**1**answer

71 views

### Invantive Control MSI fails with error status 1602

When installing Invantive Control for Excel using the MSI installer, it ends with the message:
Invantive Control for Excel Setup Wizard was interrupted
In the event log it says in chronological ...

**3**

votes

**1**answer

19 views

### 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 ...

**0**

votes

**1**answer

26 views

### For sales person (cost center) provision list of sales invoices paid

In Exact Online you can not easily determine what invoices have recently been paid and get a total on that to base our provision for the sales persons on. How can I get such a list?

**0**

votes

**1**answer

15 views

### Per article and assortment code in Exact Online the revenues per month

I want to determine per article and assortment code in Exact Online the total quantity of items shipped and the division currency amount. Exact Online only offers an overview per account. How can I ...

**3**

votes

**1**answer

20 views

### 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? ...

**0**

votes

**1**answer

38 views

### Uninstall Excel Add-in Invantive Control - Exact Online Edition

I've installed the Invantive Control Excel add-in for Exact Online using Microsoft ClickOnce by running setup.exe.
How can I uninstall it?

**3**

votes

**1**answer

83 views

### 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:
=...

**0**

votes

**1**answer

31 views

### Retrieve Exact Online data for which no Excel formula exists

I want to retrieve the outcome of the following query in an Excel cell:
select pro.code
from ExactOnlineRest.Project.projects PRO
join ExactOnlineRest.Manufacturing.shoporders SHO
on SHO....

**0**

votes

**1**answer

18 views

### Message “Do you want to re-activate Invantive Control functions.xlam” on every start of Excel

On every start of Excel I receive a pop-up asking me whether to re-activate Invantive Control functions.xlam. This is a xlam from the add-on Invantive Control.
Even when I answer "Yes", the same ...

**2**

votes

**1**answer

12 views

### 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?

**1**

vote

**0**answers

239 views

### How to query the Trial Balance and the General Ledger from Twinfield using SQL

I'm trying to retrieve and query the Trial Balance and the General Ledger from Twinfield with Invantive Control for Excel using Invantive SQL or an Invantive Excel formula.
How would I be able to do ...

**1**

vote

**1**answer

40 views

### Get Exact Online classification value assigned for an account in Excel cell

We have the sales representative stored as classification 1 on an Account in Exact Online. The account name can be retrieved using a formula such as I_EOL_ACT_NAME.
But in I_EOL_ACT_... I can not ...

**3**

votes

**1**answer

21 views

### “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], "=...

**0**

votes

**1**answer

128 views

### How do I access the Help on Exact Online functions for Excel functions when using Invantive Control?

I am creating a number of reports using Invantive Control for Excel and I would like to have an overview of the available Excel functions for Exact Online (those starting with I_EOL_...)
Especially I ...

**2**

votes

**1**answer

53 views

### 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 ...

**0**

votes

**1**answer

50 views

### Why do I get #N/A (#N/B) as the outcome of an Exact Online formula in Excel with Invantive Control?

In my Excel sheets there are cell formulas that don't show any values, but instead give "#N/A" ("#N/B").
For example, the formula:
=I_EOL_GL_ACT_DESCRIPTION("868056"; "4000")
does not return "...

**3**

votes

**1**answer

72 views

### 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 ...

**1**

vote

**1**answer

80 views

### After upgrading to Windows 10 the Invantive Control for Exact Online add-in is gone in Microsoft Excel

My PC was upgraded from Windows 7 to Windows 10. This was done using formatting the hard disk and then re-installing all software.
I used to have a Developers ribbon in which I could disable/enable ...

**2**

votes

**0**answers

53 views

### Invantive Control Template Search GL Transactions in Exact Online [closed]

I want to use the template 'Search GL Transactions' in Invantive Control for Excel to get all general ledger transactions from multiple Exact Online administrations (companies) in one list.
We use ...

**2**

votes

**1**answer

60 views

### After updating Invantive Control fo Excel, I get the error: 'itgenefn003' after synchronizing my model to import data from Exact Online

After an update of Invantive Control for Excel I get the following error when I synchronize my model to import data from Exact Online:
ITGENEFN003
Type: Invantive.Configuration....

**1**

vote

**1**answer

43 views

### When executing a query to import data from Exact Online with Invantive Control for Excel I get the error “itgenxml004”

When I try to execute a query within Invantive Control for Excel, I get the following error:
itgenxml004
U heeft geen toegang tot Administratie '873160'. Toegang zou de restrictie erop van ...

**3**

votes

**1**answer

80 views

### 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: ...

**3**

votes

**1**answer

51 views

### The Invantive Control for Excel add-in makes Microsoft Excel start up slower

When starting Microsoft Excel, it takes a bit longer to load due to the Invantive Control add-in. Is there any way I could disable the add-in when I won't be needing it?

**4**

votes

**2**answers

98 views

### 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?