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.
35
questions
3
votes
1
answer
30
views
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 ...
- 33
0
votes
1
answer
32
views
Include Excel formula in block generated from SQL
Running Invantive Control for Excel, I want to fill a block with data from Exact Online. However, one of the columns should be the multiplication of the rate listed in a settings Excel worksheet with ...
- 778
0
votes
2
answers
72
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?
- 370
0
votes
1
answer
25
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....
- 778
0
votes
0
answers
33
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
29
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?
- 370
0
votes
1
answer
46
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 ...
- 778
2
votes
1
answer
42
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 ...
- 21
0
votes
0
answers
82
views
Create a clone of an Exact Online company
I am trying to create a clone of an Exact Online company to test new functionality (this is also helpful to GDPR regulations). I seem able to create a backup and download it, but there is no button to ...
- 778
1
vote
1
answer
44
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 ...
- 13
0
votes
1
answer
202
views
Access list of available tables on Exact Online for instance sales orders
I would like to access the list of available tables on Exact Online in the Query Tool. I've found some samples on superuser.com and stackoverflow.com with specific queries such as on transactionlines, ...
- 778
2
votes
2
answers
272
views
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 ...
- 121
0
votes
1
answer
25
views
Missing internal rate on Exact Online employment
When you have an employment in Exact Online, you can have an internal rate. The APIs also list it as the column InternalRate in ExactOnlineREST..EmploymentSalaries.
But in the tab Employment of an ...
- 778
0
votes
1
answer
29
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 ...
- 43
1
vote
1
answer
36
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....
