Invantive Query Tool is a Windows query program for traditional databases as well as cloud-based applications using REST and XML. Include SQL statements 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. For product use questions use Super User.
Questions tagged [invantive-query-tool]
14 questions
3
votes
1 answer
How do I download only my purchase invoice documents from Exact Online with Invantive Query Tool?
To comply to regulations, I'm trying to download the purchase invoice documents (as PDF files) from some of my divisions to save them on-disk for archiving purposes.
I use Invantive Query Tool to do this. I like to know which table to use and how to…
Berky
- 31
- 1
3
votes
1 answer
itgenobr001: Client not found. on Data Access Point with Exact Online Belgium
We have just gone live with https://ecotaksen.be. The queries and updates on Exact were running fine, but after installing the production license an error itgenobr001: Client not found. occurs.
My data container specification is:
H Jansen
- 319
- 1
- 8
3
votes
1 answer
Error itgensql005: unknown identifier 'ID'
I'm using the Invantive Query Tool to update address data for suppliers in Exact Online on a large scale. I've written some VBA code that generates SQL code to put into the Invantive Query Tool. I've used this before and it worked fine, I've updated…
Boris D
- 43
- 3
3
votes
2 answers
Exact Online import GLTransactions with automatic reconciliation
I am using our query tool to generate XML files for the topic GLTransactions of the XML API of Exact Online. The input for these files are XML Audit Files coming from Twinfield (XAF 3.1 format).
Since Exact Online has a mixed ledger and lots of…
Guido Leenders
- 4,232
- 1
- 23
- 43
2
votes
1 answer
Empty columns when querying
When using the Invantive Query Tool to request the table GLTransactionlines on Exact Online, my query times out.
When selecting a single column the query returns no data. Specifically, I would like to know from what table I can request my…
Ronald Westerhof
- 23
- 3
2
votes
1 answer
Getting error when retrieve contacts from Exact Online
I want to retrieve all contact persons from one company in Exact Online and get the following error:
select * from AccountContacts
Error:
itgenusg026: The requested number of 3.308 columns is not supported. Restrict the number of requested columns…
Frank Leemkuil
- 83
- 3
2
votes
0 answers
Intermittent error "Not authorized to access Exact Online" when accessing XML topic Settings of Exact Online
During querying on Exact Online, I sometimes get an intermittent error in the Invantive Query Tool:
Not authorized to access Exact Online.
Please check that you have access to the administration and have licensed a module for the data object…
Guido Leenders
- 4,232
- 1
- 23
- 43
1
vote
1 answer
Retrieving inactive employees
I have the following query using the Invantive Query Tool connecting to NMBRS.
select e.number
, es.EmployeeId
, e.displayname
, es.ParttimePercentage
, es.startdate
from Nmbrs.Employees.EmployeeSchedules es
left
outer…
RS Finance
- 224
- 1
- 9
1
vote
1 answer
How to get debtors from numbers for top 3 partitions
I want to get debtors from numbers from TOP 3 partitions. I am using this query to select partitions:
use select top 1 code, data_container_alias from systempartitions@datadictionary where data_container_alias = 'nmbrs'
And this query to get…
Andrius V.
- 134
- 1
- 8
1
vote
1 answer
Time-out error using an Exact Online query in the Invantive query tool?
I'm using this query:
select *
from MailMessagesReceived mmd
inner
join MailMessageAttachments mmt
on mmd.ID = mmt.ID
Where mmd.created > '2017-01-01'
And mmd.SenderMailbox = 'finappanl@lyanthe.com'
And …
Boris D
- 43
- 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
0
votes
1 answer
Invantive Query Tool error querying NMBRS.nl
I want to run a query in Nmbrs.nl getting the journal information of a run.
So I selected a company by using:
using 111111
Then the following query to get the run info:
select *
from CompanyRunsYear(2017)
This gives me a list of the runs in…
RS Finance
- 224
- 1
- 9
0
votes
1 answer
Retrieve list of General Ledger transaction lines without error itgenugs026
When I run the following query on Exact Online, I receive an error itgenugs026: The requested number of 1,396 columns is not supported.
select *
from GLTransactionLines t
How can I get the list of general ledger transactions through the XML…
Guido Leenders
- 4,232
- 1
- 23
- 43
0
votes
1 answer
Use outcome of SQL query as value for variable
I have a query that extracts performance measurements of a number of APIs and those I want to save over time to different files in one folder. Say every hour one run and one output file.
The Invantive scripting statement
local export results as…
Guido Leenders
- 4,232
- 1
- 23
- 43