---
title: "Itgenxml091 op BARCODE veld"
language: en
source_language: nl
translation_state: pending
canonical: https://documentation.invantive.eu/en/forum/6802/itgenxml091-op-barcode-veld
original: https://documentation.invantive.eu/nl/forum/6802/itgenxml091-op-barcode-veld
updated: 2026-11-17T12:59:02Z
license: https://documentation.invantive.eu/en/
---

# Itgenxml091 in the BARCODE field

Tijdens de synchronisatie van Items naar Exact Online krijgen wij onderstaande fout:

> itgenxml091
> The ‘BARCODE’ column has a value ‘10788942212008112505’, which cannot be converted to the Int64 data type.
> The value ‘10788942212008112505’ is not a valid large integer.
> The value was either too large or too small for an Int64.
> Please use a comma ‘,’ as the separator for thousands.

Request ID: `0HNN7G8UUIJP0:00000001`

As a result, synchronisation fails.

Kan nagekeken worden waarom het BARCODE-veld als Int64 wordt behandeld in plaats van als tekst (string)?

## Accepted answer

A fix has been deployed to resolve this issue. Een vijftal kolommen zijn vervallen door de overgang van XML naar REST-tabellen.

For further information, see:

<div class="onebox">

[Invantive Cloud Release FrequencyCloud](https://forums.invantive.com/t/releasefrequentie-invantive-cloud/4713)

forums.invantive.com

</div>

## Reply 2

[![956b2b1d2d1bcc4efe1a7108bd7a177224ec2851](/img/85a0e7292fcd74708595f456a40ded69e24b307a9a4ae4c683b9d6fd055b34be/819x411.png)](https://forums.invantive.com/uploads/db9863/original/2X/5/5e72e1334219e726b7309b3dad8ca018ee09102b.png)

> itgenxml091
>
> The column `BARCODE` in `Items` has a value ‘10788942212008112505’ which cannot be converted to the ‘int64’ data type.
>
> The value ‘10788942212008112505’ is not a valid large integer.
> The value was either too large or too small for an Int64.
>
> Please use a comma ‘,’ as the separator for thousands.

## Reply 3

Oorzaak is een te grote mogelijke waarde voor het gebruikte data type voor dit veld in de Invantive software. A change will be made to resolve this issue.

Rapport: `gmr-eol-items`

Call stack:

```
System.OverflowException
ValidationException
ValidationException
   at System.Number.ThrowOverflowException[TInteger]()
   at System.String.System.IConvertible.ToInt64(IFormatProvider provider)
   at Invantive.Data.DataUtility.ConvertToLong(GlobalState owner, ExecutionOptions executionOptions, Object val)
```

SQL Statement:

```
select /*+ result_set_name('Items') */
       ...
,      itm.barcode
       ...
from   ( select to_number(itm.division_code) division
         ,      to_guid(replace(itm.id_attr, '{', '', '}', '')) id
         ,      itm.*
         from   exactonlinexml..items@eol itm
       ) itm
...
```

Exact Online dicteert in de metadata dat het een integer-getal is:

```
<xsd:element name="Barcode" type="xsd:integer" minOccurs="0"/>
```

De grootst mogelijke invoerwaarde in Exact Online user interface zelf zijn 20 negens:

```
99999999999999999999
```

The number 10788942212008112505 has 20 digits and exceeds the maximum value of 19 digits for an Int64 (9223372036854775807).

Binnen de REST API’s hanteert Exact Online een tekst in plaats van een Int64 zoals bij XML. A text value is also preferable because of the potential leading zeros.

## Reply 8

This question was automatically closed after 1 week of inactivity. The last answer provided has been marked as the solution.

Please ask a new question in a separate thread if the problem reoccurs. Please include a link to this thread in the new question by pasting its URL into the text.

---

Source: [https://forums.invantive.eu/t/itgenxml091-op-barcode-veld/6802](https://forums.invantive.eu/t/itgenxml091-op-barcode-veld/6802)
