ExactOnlineXML XML Costunits/Costcenters table empty

The tables for ExactOnlineXML XML Costunits and Costcenters are empty when loaded from Invantive Cloud from Exact Online.

Please make sure that the Exact Online user of the database data container has actually the necessary privileges. When privileges are missing, a table is returned as empty.

To acquire more information on the rather complex privilege structure of Exact Online please refer to:

Also, please consider the use of the REST-version such as

The rule of thumb to select the probably best choice of table when there are multiple candidate tables is (see also the opening page of the Exact Online documentation of Invantive):

  • Table name ends with Incremental
  • Table name ends with Bulk
  • Table name starts with ExactOnlineREST
  • Table name starts with ExactOnlineXML

With three notable exceptions which we strongly recommend XML for:

  • BalanceLinesPerPeriod: periodic balances,
  • BalanceLinesPerPeriodCostAnalysis: periodic balances (analytical),
  • APOutstandingItems: outstanding purchase invoices,
  • AROutstandingItems: outstanding receivable invoices.

Heel erg bedankt, hier ben ik al erg mee geholpen.

Is er ook een manier om te achterhalen welke rechten nodig zijn voor welke tabellen?

Nee, dit is bij Exact lijkt het organisch gegroeid. Vaak is wel te zien aan de namen van de rechten. Als het niet lukt, dan is advies contact op te nemen met Exact Online Support.