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

How to add payment conditions to AR outstanding items in a report on Exact Online?

I am using Invantive Control to create an Excel report with some outstanding invoices information from Exact Online. I have created a model with the block designer and I have the outstanding invoices information I need. Now I also want to know the…
Jeroen
  • 21
  • 1
2
votes
1 answer

When syncing my model within Invantive Control for Excel I get the error "Could not find parameter with name 'P_SCHEME_CODE'

When I try to synchronise my model retrieving GL Account Classification information from Exact Online, I get the following error: itgensdf031: Could not find parameter with name 'P_SCHEME_CODE': What should I change in order for this to…
Geert Visscher
  • 23
  • 2
2
votes
2 answers

Connect Power BI with Exact Online more efficiently than through HTML

I am using Microsoft Power BI with Exact Online using Data Access Point on https://data-access-point.com using queries such as select * from exactonlinexml..aroutstandingitems. However, the URL must contain the user name and password to allow Data…
KPI Solutions
  • 47
  • 3
2
votes
1 answer

Error invalid_value on Freshdesk when inserting contact persons from Exact Online

In a Freshdesk testing environment, the following SQL statement copies all contact persons involved with a sales order from Exact Online to Freshdesk: insert into contacts@freshdesk ( name , address , phone , email ) select delivery_account_name , …
H Jansen
  • 319
  • 1
  • 8
2
votes
1 answer

SQL error in Invantive Control for Excel

This is for Invantive Control for Excel. What could be causing an error at the second CREATE TABLE? CREATE TABLE niveau1@inmemorystorage AS SELECT ID , Code , AddressLine1 , Name , Parent FROM Accounts WHERE …
Leo H
  • 35
  • 5
2
votes
1 answer

Exporting documents from Exact Online for one division gives a spreadsheet instead of separate files

Using the following SQL I get a list of documents and small thumbnails in Exact Online: select document_account_name || document_references_yourref || year(document_date) || '-' || month(document_date) || '-' || day(document_date) …
Joery
  • 23
  • 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
2
votes
1 answer

Exact Online API: deleting and updating items like BankEntryLines

We are building an exensive api-link with the Exact online odata API. Problem we are having is that many objects cant be updated or deleted. For instance BankEntryLines, GeneralJournalEntryLines. We have now worked around this by creating new…
Jelle
  • 31
  • 2
2
votes
1 answer

Can't make item through Exact Online REST API

I have been struggling to get the Exact Online Api to work. It should be possible to make items through the API, but the API isn't allowing me to make 1. As result of an earlier problem, I got recommended to switch to the unofficial picquer library:…
Duncan
  • 351
  • 2
  • 10
2
votes
3 answers

400 Bad Request when getting access token for ExactOnline using RestSharp

I need to go through the OAuth2 flow for ExactOnline but I get stuck on step 3 of the docs (https://developers.exactonline.com/#OAuth_Tutorial.html%3FTocPath%3DAuthentication%7C_____2) I created the following c# code using the Postman chrome app for…
Corstiaan
  • 1,114
  • 15
  • 34
2
votes
1 answer

parsing xml: wrong character set encoding

My site communicates with a remote API to synchronize databases. The data I receive is in XML and 999 out of 1000 times this is proper XML which I can directly parse using simplexml_load_string. Yet 1 out of 1000 times I get incorrectly encoded XML…
Hacktisch
  • 1,392
  • 15
  • 33
2
votes
1 answer

How to filter Exact Online accounts on their classification code?

I am trying to make a list of how much accounts have a certain classification1 code (which currently ranges from 1 to 7). when accessing the API (which makes use of OData) I get the following error: No property 'Code' exists in type…
Daan Goumans
  • 65
  • 1
  • 10
1
vote
2 answers

ExactOnline all sales prices for given price-list

I'm building a margin-monitor for exact-online, for this I need to fetch all of the products, sales price and sales prices for a specific price-list. So far I've managed to get the products and default sales prices via the REST-API. However,…
S.D.
  • 2,486
  • 1
  • 16
  • 23
1
vote
1 answer

Stating Debit or Credit for Financial/Entries?

I am inserting new entries through the Rest API of Exact Online. However, I can not seem to find a way to state which amount is debit or credit. I thought that depending on what GLAccount you use for the entry, that amount would automatically change…
14mble
  • 119
  • 1
  • 11
1
vote
2 answers

Change the Status of a Sales Order in ExactOnline

We currently need to set the status of orders to CANCEL in ExactOnline through the API when they are cancelled in our shop. I got through the ExactOnline API documentation and in the PUT request of salesOrders, I did not find any Status field that I…
Umar Zahid
  • 323
  • 1
  • 13
1 2
3
…
10 11