Error message itgengpr012 when selecting Exact Online administrations

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:

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:

Krijgen ineens probleem bij het downloaden van een administratie en krijgen ook de itgenpr012 melding:

itgengpr018
The Adminitration ‘1536219’ is not available.
Possible valid alternatives: 1334433: 2 - … (1334432).

Wel iets andere omschrijving maar lijkt erop.

Als ik de SQL query in de Invantive Query Tool 20.1.378 uitvoer krijg ik deze melding:

Gekke is dat dit gewoon weken achter elkaar goed draait en sinds twee dagen ineens deze melding.

De invoering van division scoping op Exact Online heeft nogal wat voeten in de aarde. Dagelijks ontvangen we meerdere problemen in het gebruik hierdoor; Exact is nog bezig met de verfijning van division scoping. Echter, regelmatig ligt het probleem primair niet in usability bugs in de division scoping, maar in het gebruik.

Kunnen de reproductiestappen (vanaf begin tot/met de Invantive SQL query die de foutmelding geeft) hier toegevoegd worden?