Invantive Control is an Excel add-on which allows two-way synchronization between Excel and traditional databases as well as cloud-based applications, using native SQL or Invantive SQL. Include SQL statements and/or block definitions to reproduce the problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the platform you are querying, like exact-online or freshdesk. For product use questions use Super User.
Questions tagged [invantive-control]
32 questions
1
vote
0 answers
Get employee ID from NMBRS API
I have to query employee salaries information for statistical analysis. But using invantive-control and invantive query tool all EmployeeId fields are empty. And I need this field to add additional information. My question is how can I get…
Andrius V.
- 134
- 1
- 8
1
vote
1 answer
Restrict list of employees in NMBRS to just a few companies
I am creating a report on sick leave on nmbrs.nl using Invantive SQL.
By default this query retrieves data across all companies:
select *
from employees emp
join employeeabsence(emp.id)
This takes an enormous amount of time since for each…
Andrius V.
- 134
- 1
- 8
1
vote
1 answer
Improve performance of WareHouse query on Exact Online
We have 20 warehouses and 3.000 articles. Therefore there are 60.000 rows in the ItemWarehouses table of Exact Online. However, retrieval takes 1200 ms per 60 rows, so total query on this data volume for a warehouse analysis takes 3-4 hours.
I've…
Joanna
- 23
- 2
1
vote
1 answer
How can this query be optimized for speed?
This query creates an export for UPS from the deliveries history:
select 'key'
, ACC.Name
, CON.FullName
, CON.Phone
, ADR.AddressLine1
, ADR.AddressLine2
, ADR.AddressLine3
, ACC.Postcode
, ADR.City
, …
Leo H
- 35
- 5
1
vote
1 answer
Insert Invoice into Exact Online
I want to insert an Invoice into Exact Online. When I insert the invoice manual, it works fine, but with the Invantive Control tool I get an error:
insert into UploadXMLTopics
( topic
, payload
, division_code
, orig_system_reference
,…
Frank Leemkuil
- 83
- 3
1
vote
1 answer
How to Include a reference to a table in Invantive Excel add-in
I'm making a financial report in Excel using the data from Exact Online using the Invantive Control Excel Add-in. In Exact Online I have a classification for the General Ledgers. In my Excel file, I would like to match these classifications on my…
Bram Masselink
- 35
- 3
1
vote
1 answer
Combining multiple condition in single case statement
Does Invantive SQL support multiple condition in a single case statement? I the statement below, I did not get any results. Tried the same statement with only 1 condition (no cascade), this retrieved the expected result.
select prj.code
, …
H Jansen
- 319
- 1
- 8
1
vote
2 answers
On synchronize Exact Online GL transactions with Invantive Control for Excel error: "You are trying to move cells within a table on the worksheet"
When trying to synchronize my model with Invantive Control for Excel, the following error occurs:
This is the complete error message:
Type: System.Runtime.InteropServices.COMException
at System.RuntimeType.ForwardCallToInvokeMember(String…
R. van Deursen
- 33
- 4
1
vote
1 answer
Change language from French to English for Exact Online add-in Invantive Control for Excel
In Invantive Control for Excel on Exact Online, I get all text and messages in French as for example:
Une erreur s'est produite lors de la validation du modele de donnees de base avec version 15 des specifications referentielles.
Also, the…
Guido Leenders
- 4,232
- 1
- 23
- 43
0
votes
1 answer
Is it possible to create a sales order in Exact Online using REST API of Invantive Control
I want to create a Sales Order in Exact Online in the table SalesOrders.
This works using the REST API controlled by Invantive Control.
However, Exact Online reports that the sales order lines are missing.
How can I create the salesorder, since in…
H Jansen
- 319
- 1
- 8
0
votes
1 answer
Project Report with internal rate from Exact Online in Invantive SQL
I would like to make a report in Invantive using the internal rate from Exact Online Projectmanagement. I am not able to find the right table for this report. I can't find the information which has the dates with corresponding internal rate per…
Bram Reemers
- 99
- 4
0
votes
1 answer
itgensdf054 on synchronize in Invantive Control
When synchronizing a model in Excel with one block, I receive an itgensdf054 error which indicates that it could not clear the target range where the data of the query below is synchronized into.
The full error message is:
Could not clear contents…
H Jansen
- 319
- 1
- 8
0
votes
1 answer
How to insert a blank column in a SQL query?
This is the SQL code I currently use via the Invantive Control for Excel, linked with our Exact Online DB.
As you can see in the code, in front of the line of the second select case I would like to enter 4 blank columns. The way it's coded right now…
David Geers
- 3
- 1
- 3
0
votes
1 answer
String to double or decimal
How to convert a string to a double or decimal? In Exact Online (REST API) I try to calculate with a decimal value in a string field. e.g items.netprice + items.notes. The field items.notes contains the decimal value.
Tried using cast and convert…
H Jansen
- 319
- 1
- 8