Questions tagged [exact-online]

Exact Online is an online accounting program. Use this tag for questions about the use of Exact Online, or the data retrieved from it using its various interfaces.

Exact Online is an online accounting program. Use this tag for questions about the use of Exact Online, or the data retrieved from it using its various interfaces.

Some useful resources to start using Exact Online:

35 questions
6
votes
3 answers

How to get the PictureURL from the Exact Online XML-feed to show the picture using Invantive Data Access Point?

When using Data Access Point to generate an XML feed, using the following query: select * from exactonlinerest..items the resulting XML has a…
6
votes
1 answer

Installation steps of Exact Online driver for Microsoft Power BI

I want to use Microsoft Power BI Desktop edition to run reports including data from Exact Online. The Exact Online driver is not available with the pre-configured sources Microsoft offers. How do I install an Exact Online driver?
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

Specify required freshness of data from Data Cache

I am using Invantive SQL for Exact Online to integrate BOARD with Exact Online. For caching, Invantive Data Cache is configured. By default the data remains fresh enough for the /*+ ods */ hint to be used for 7 days. I can switch the Data Cache…
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

Retrieve salary per component from Exact Online using Invantive SQL

How can I retrieve the salary per individual component and employee using the ado.net provider of Invantive SQL for use within Microsoft Power BI? I seem unable to find a XML or REST-based table that contains the amounts.
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
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…
2
votes
2 answers

When I try to log on to Exact Online, I get an Oops, something went wrong error

When I try to log on to Exact Online using Invantive Data Hub, I get an error message my username and password is wrong while I am very sure it is correct (it has been for weeks already). When I try to log on using Exact Online itself, I get an…
Jham
  • 121
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?
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…
2
votes
1 answer

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.InvantiveSystemException bij…
Anne
  • 33
1
2 3