A recurring question from accountancy users involves selecting administrations from all available administrations.
If administrations (Invantive terminology: “partitions”, Exact Online terminology: “divisions”) are selected that do not exist, an error message such as the following occurs:
itgengpr012: Kan actieve partities niet wijzigen in 1@eol
This is followed by a list of possible alternatives.
What is the Exact Online division code?
The division code of an administration is a number, unique per Exact Online country, that is assigned sequentially when an administration is created. Older administrations, for example, have numbers around 50,000, while new administrations are currently around 3 million.
Resolving the itgengpr012 error
Check whether the number matches the division code of the administration.
The division code is different from the administration number, as shown in the image below:
Many companies and accountants will use the number ‘2591’ or ‘1’ from the red box on the left, but the red box on the right shows the division code after _Division_. You will also see this division code in the browser’s address bar when switching administrations in Exact.
How do I retrieve all division codes?
With the Invantive SQL query below on SystemDivisions, all administrations available to the app can be retrieved:
select sdn.code
, sdn.hid
, sdn.description
from systemdivisions sdn
order
by sdn.code
The leftmost column contains the division code.
The division codes are also visible in the free app “Valuta Tools” for Exact Online, shown in brackets after the name of the administration:
Specific properties can be retrieved in even more detail with the query:
select spn.CODE
, spn.NAME
, spn.ALLOW_WRITE
, spn.IS_ACTIVE
, spn.IS_ARCHIVED
, spn.IS_SELECTED
, spn.IS_SELECTED_BY_DEFAULT
, spn.IS_USED
from SYSTEMPARTITIONS@DataDictionary spn
where spn.provider_name = 'ExactOnlineAll'
order
by spn.CODE
Other causes
The error message can also occur due to incorrect permissions (“division scoping”). See Forbidden - User division is not within division scope (Itgeneor228 / itgenoda060) - 2 van forums
Our advice is to always work with your own client ID on Exact Online:
- Register your own client ID as described in Registering an Exact Online app for use with Invantive Control for Excel
- Install a recent version suitable for the current version of Exact Online, available at https://releasenotes.invantive.com
- Log in to Exact Online from Invantive Control for Excel by entering your own client ID, redirect URL and, if applicable, client secret.
The following video demonstrates this for Invantive Cloud, and as long as a separate application name is used for Invantive Control, this video can also be used as a guide:


