Questions tagged [invantive-sql]

Invantive SQL is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc.​ Use this tag for questions about the use of Invantive SQL and make sure to add the appropriate tag for the system you are querying, like exact-online. For product use questions use Super User.

Invantive SQL is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc.

Invantive PSQL is a procedural extension on top of SQL included with Invantive SQL. Please use the tag Invantive SQL for PSQL questions.

Questions should include relevant SQL statements to reproduce the problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the databases and/or cloud-applications you are querying, like or .

For product use questions use Super User.


If you want to ask a question about an error you get when firing a SQL statement, copy this template into your question:

Problem statement:

[explain what you want to achieve]

Steps to reproduce:

1. The first step

2. The second step

        The SQL code you used (don't use images but code formatting)

Expected result: [show or explain the expected result, preferably in text]

Actual result: [show or explain the actual result, preferably in text. If you received an error, include the full error in the block below]

> [The error message]
81 questions
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

Query to get list of shipped serial numbers in Exact Online

We ship item per serial number using Exact Online as ERP system. I seem unable to find the column names to retrieve a list of shipments of serial numbers and associated invoices.
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Upload XML payload into multiple Exact Online companies

Using a query as below, you get output in the XML format required for Exact Online. These XML messages can be put in many files on disk using: local export documents in filecontents to "c:\temp\in" filename column filename And then loaded into…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Performance of many Exact Online excel formulas for sales transactions

We have an Excel spread sheet which has horizontally all financial periods considered (13, one year plus one month) and vertically a list of article codes. The intersecting cells contain the sold quantity in that period of an article, using General…
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
0
votes
1 answer

Quantity in stock in stock locations in Exact Online

Using the following query, I found that for items that have a stock location, there are multiple rows returned from the REST API StockLocations of Exact Online: select spn.item_code_attr || '-' || spn.warehouse_code_attr || '-' || stn.code key , …
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
1 2 3 4 5
6