Data Mart ETL - 2026-11-09
In this release:
- Sales order line quantity in base unit (breaking change):
quantityInBaseUnitnow returns the base-unit quantity that Visma.net ERP stores on the sales order line.
Sales order line quantity in base unit (breaking change)
Breaking change. On salesOrderLines and salesOrderLinesV2, quantityInBaseUnit was recalculated from the item's current unit conversion, and that calculation was not always right:
- For units that convert by dividing (for example a box of 12 sold per piece), the conversion was reversed, so the value was wrong.
- Lines with quantity 0, lines already in the base unit where the item has no unit conversion, lines using a class or global unit conversion, and non-stock items returned null.
quantityInBaseUnit now returns the base-unit quantity that Visma.net ERP stores on the sales order line when the line is saved. This is the value ERP uses itself, rounded to the company's quantity decimals. It is null only when ERP found no unit conversion for the line.
quantity is unchanged: it returns the quantity in the line's unit of measure (uom). The item's base unit is in baseUnitName. The descriptions of both fields in the schema now say which unit they use.
Field names and types are unchanged. Lines that were already correct (most lines in the base unit and lines with a multiply conversion) keep their value.
What you need to do:
- If your integration treats a null
quantityInBaseUnitas "no base quantity" or falls back toquantity, check that logic: most of those lines now have a value, and zero-quantity lines return 0. - If your integration recalculates or corrects
quantityInBaseUniton your side, you can use the value as returned. - If you do not use this field, no action is needed.
Existing sales order lines are corrected as part of the release. The correction does not change updatedInDataMartDateTime, so an incremental fetch based on that field does not pick up the corrected lines. If you have stored this quantity and need it corrected, fetch your sales order lines again after the release.