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
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

Integrate ADO.NET provider on On-premise Data Gateway with PowerApps

I am trying to integrate a large number of data sources available through a custom ADO.NET provider on a Windows server into PowerApps. To make the data available, I am using v14 of the On-premise Data Gateway (non-personal mode). The gateway…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Change chosen SQL Server database in distributed database with Invantive Data Hub

We run a daily job to load Exact Online into a SQL Server database for reporting purposes with Sumatra. We now want to redirect the SQL insert statement to another database on the same SQL Server. Connections are: …
Frans Oude Weernink
  • 1
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

Data Replicator connection string for use with Data Hub

I am trying to set up Invantive Data Hub with Replicator. The default discovery creates entries for Exact Online and others, but there is no entry in settings.xml which shows me how to configure data cache. This one exists for example:
Jurriaan Buitenweg
  • 422
  • 2
  • 12
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
0
votes
1 answer

Mass upload pictures for performance testing

To test performance with many and large binary objects, I need 1.000 or more document attachments to be available within Exact Online. Loading them through the user interface is quite cumbersome: many clicks per document and there is no easy drag &…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
1 answer

Exact Online query with joins runs more than 15 minutes

I am using the following query: set use-result-cache false set use-http-cache false create or replace table settings@inmemorystorage as select '29676ec4-61b5-45eb-a5a3-6feffe03d1d3' sor_id , '[[Exploded]]' exploded_signal_text , …
H Jansen
  • 319
  • 1
  • 8
0
votes
1 answer

Document attribute stays empty for Invoice class

When trying to fetch the SalesInvoices class from the Exact Online REST API all the relevant document entries stay empty. I'm using the Exact Online Python SDK for fetching these SalesInvoices. The code used: return self.api.invoices.filter( …
Martijn Nosyncerror
  • 172
  • 1
  • 3
  • 16
0
votes
1 answer

Alternative approach to parameters in Invantive Control to control query outcome

I would like to use parameters in Invantive control. For example, I would like to retrieve only the hours, of Exact Online Project management which, are in the given data parameters.
Bram Reemers
  • 99
  • 4
0
votes
1 answer

Missing content of field CreatorFullName and ModifierFullName in GeneralJournalEntryLines

The business object GeneralJournalEntryLines contains the GL transaction lines of Exact Online. For performance tuning reasons, we are changing our scripts that copy data from Exact Online to our on-premise database to only include changes where…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
0
votes
2 answers

Exact Online API Returns XML Error

What I do I'm really confused about the following. I'm logged in via Exact Online oAuth2 (works) I'm redirected to the set redirect url (works) Now, I'm doing a POST request for creating an CRM Account…
schellingerht
  • 5,726
  • 2
  • 28
  • 56
0
votes
1 answer

Upload XML into Exact Online exceeding maximum size or response time

I have several XML files generated by a industry solution with new data to be uploaded into Exact Online using the XML API, either directly or using the UploadXmlTopics table in Invantive SQL with the Exact Online driver. However, the Exact Online…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43
1 2 3
…
10 11