Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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?