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
11
votes
3 answers

How to use x-www-form-urlencoded in rails

Am trying to access the token from ExactOnlineAPI but the documentation recommends to only use x-www-form-urlencoded. Does Ruby on Rails has this kind of encoding, if so how can i use it. What is the different between x-www-form-urlencoded and…
Little Phild
  • 785
  • 1
  • 6
  • 17
4
votes
1 answer

Same Exact Online query in Invantive Control for Excel gives different result when executed with customer

I have the following query to make a revenue report based on area groups from Exact Online: select itemgroupcode , itemgroupdescription , code , description , country , postcodegebied , name , financialyear…
Bram Reemers
  • 99
  • 4
3
votes
1 answer

Handcrafted OData queries on Exact Online with Invantive

We are currently running a number of hand-crafted and optimized OData queries on Exact Online using Python. This runs on several thousand of divisions. However, I want to migrate them to Invantive SQL for ease of maintenance. But some of the…
user9461953
3
votes
1 answer

Determine applicable division of Exactonlinerest..MailMessagesReceived

The mailmessagesreceived and mailmessagessent of Exact Online contain all work for all divisions of a customer. To retrieve them in our SQL Server database we use the following query: use select min(code) from systemdivisions group by…
JeroenVervoort
  • 33
  • 3
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

Register an AWS GIT code push event in Exact Online ERP

When a developer checks in code through a GIT push to AWS codecommit, I want to register an event in our ERP package Exact Online. This allows a project manager to review from within the ERP package the commits. AWS Codecommit only supports triggers…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
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

Exact API response language

While implementing some functionality in my app I noticed the Exact API responds names in English. However in the Exact software you can define names of several entities in multiple languages. Based on the language settings of my user it would be…
Odyssey1111
  • 134
  • 8
3
votes
1 answer

Invantive Data Hub query on Exact Online returns too many rows

when I use Invantive Data Hub to dowload data from multiple Exact Online companies , I get duplicate rows when I expect one row per company. I use the following query: select gla.code , gla.description , gla.division , …
Mart
  • 31
  • 4
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
1 answer

How optimize the performance of SerialNumbers by SalesInvoicesExploded?

I have the following query: select sie.invoicedate sie_invoicedate , sie.Silitem sle_item , sie.Silitemcode sle_itemcode , sie.Silitemdescription sle_itemdescription , sie.Silnetprice …
Frank Leemkuil
  • 83
  • 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
3
votes
2 answers

Error itgensql005 when fetching serial number from Exact Online GoodsDeliveryLines for upload to Freshdesk ticket

I want to exchange information between ExactOnline and Freshdesk based on deliveries (Exact Online Accounts -> Freshdesk Contacts, Exact Online deliveries -> Freshdesk tickets). The serial number of delivered goods is not available in either the…
H Jansen
  • 319
  • 1
  • 8
3
votes
1 answer

ExactOnline API en OData

I am struggling with the API of Exact Online. Using this example code to retrieve information of the server: $response = $exactApi->sendRequest("crm/Accounts?$filter=substringof('test', Name) eq true', 'get'); Above returns a Bad Request. Anyone…
karel
  • 53
  • 6
3
votes
3 answers

Token request on Exact Online not returning access token

I have been trying to use OAuth 2.0 to connect to Exact Online. We tend to focus on Java-applications and sadly Exact doesn't have documentation/examples/support for Java. I was able to do the authentication request but for the token request I'm…
G. De Baets
  • 51
  • 6
1
2 3
…
10 11