Stack Overflow
Stack Overflow

Questions tagged [exact-online]

Exact Online is an online accounting program. It has a CSV, XML and REST API to communicate with.

Exact Online is an online accounting program. It has over 1.000 CSV, XML and REST API's to communicate with. Many APIs offer DML features.

Some useful resources to start programming against the XML and REST API of Exact Online:

156 questions
2
votes
1 answer

ExactOnline: The remote server returned an error: (400) Bad Request

I'm trying to connect to ExactOnline server using HttpWebRequest from C#. When I try to get the Response, I get an exception: "The remote server returned an error: (400) Bad Request". The Web Request looks like: Method: GET Address:…
mca
  • 466
  • 3
  • 11
2
votes
1 answer

Get list of blocked Exact Online divisions

We have a few thousand companies in Exact Online from which a certain percentage runs their own accounting and has their own license. However, there is a daily changing group of companies that are behind with their payments to Exact and therefore…
user9461953
2
votes
1 answer

Error 'Invalid authorization request' on preauthenticating Exact Online

Using cloud.invantive.com I am preauthenticating a connection to Exact Online using the OAuth2 Code Grant Flow. I have entered the client ID, the associated client secret and checked deviating redirect URI. On clicking the Preauthenticate button, I…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
2
votes
1 answer

'Use select' notation to specify multiple partitions of Exact Online data container

I'd like to select an active partition in the Data Hub. Normally I would use the following statement: INVANTIVE> use 1552839 2> Exclamation itgendhb077: Error in Invantive Data Hub. Database '1552839' does not exist. Make sure that the name is…
RS Finance
  • 224
  • 1
  • 9
2
votes
1 answer

Determine list of selected partitions on Exact Online

When I set the list of active partitions in Data Hub using: select code from systemdivisions where city='Rotterdam' to all customers in Rotterdam, the next queries will retrieve data across all customers. In Invantive Control I can see in the…
RS Finance
  • 224
  • 1
  • 9
2
votes
1 answer

Upload contents of CSV as new maximum stock position in Exact Online

I want to upload the contents of a CSV file as new values in Exact Online data set using for instance the following SQL statement: update exactonlinerest..ItemWarehouses set maximumstock=0 where id='06071a98-7c74-4c26-9dbe-1d422f533246' and …
PaulPSmith
  • 41
  • 2
2
votes
1 answer

Unkown Index error by using Invantive Control: "The index position 275 is not in use. The last index used is 7"

The error is on the column 'whs.description'. It won't give any error at the join 'ExactOnlineREST.Inventory.Warehouses Whs on Whs.ID=SHO.Warehouse' select Pro.code , ShopOrderNumber , SHO.status , SHO.Description , …
Bram Reemers
  • 99
  • 4
2
votes
1 answer

How to include an Excel formula with a reference to a table in Invantive Control 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
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
2 answers

Different companies listed in Exact Online REST API system divisions and XML API Administrations

When I download the list of companies using the end point Administrations either through the user front end or directly using a HTTP GET, I receive an XML with contents such as: …
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
2
votes
1 answer

SQL select statement similar to vertical search approximate match in Excel

Having a table with columns 'price' and 'quantity'. e.g: rec price qty 1. 10,00 1 2. 7,50 5 3. 5,00 25 4. 3,00 100 I need to select the price for a quantity of 65. This is the price of record 3. Qty 65 is between qty 25…
H Jansen
  • 319
  • 1
  • 8
2
votes
1 answer

Create Exact Online companies en mass

To simulate an accountancy environment, I need to create at least 100 of Exact Online companies (divisions, administraties, dossiers). This can be achieved using a manual action, repeated 100 times. And repeated across 7 countries. In totaal 700…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
2
votes
1 answer

Error: itgeneor003 Object metadata could not be retrieved for 'customers1' when creating table

When trying to execute the query below with the Exact Online Adapter in the Excel 2016 for Windows on Windows 10. We get the error Object metadata could not be retrieved for 'customers'. with error code itgeneor003. create or replace table…
Frank Leemkuil
  • 83
  • 3
2
votes
1 answer

Can not join Exact Online's Bill of Material Items and Items itself

When I run the following query to retrieve item details on items in the Bill of Materials (BOM) of Exact Online, I get no item details: select * from BillOfMaterialItemDetails bom join ExactOnlineREST..items itm on itm.ID =…
H Jansen
  • 319
  • 1
  • 8
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
1
2
3
…
10 11