Data Mart ETL - 2026-04-15
Bug Fixes
- Customer payments with document type
DRM(Debit Note) are now correctly processed. Previously, these records caused a mapping error during the ETL transform step and were not synced to MongoDB.
Data Mart API - 2026-04-03
New Fields
CustomerDocumentLine
| Field | Type | Description |
|---|---|---|
| lineType | String | The line type, letting you distinguish between different categories of customer document lines. |
| manualAmount | Decimal! | The manually entered amount override on the customer document line. |
| manualAmountInCurrency | Decimal! | The manually entered amount override expressed in the document's currency. |
Data Mart ETL - 2026-04-03
New Fields
CustomerDocumentLine
| Field | Type | Description |
|---|---|---|
| LineType | string | The line type on the customer document line, making it possible to distinguish between different line categories. |
| ManualAmount | decimal | The manually entered amount override on the customer document line. |
| ManualAmountInCurrency | decimal | The manually entered amount override expressed in the document's currency. |
Data Mart API - 2026-04-01
New Fields
Experimental GL balance queries
The generalLedgerBalanceExperimentalForwardPeriodsByGroup and generalLedgerBalanceExperimentalForwardPeriodsExpanded queries now accept an optional periodsUpTo parameter.
| Parameter | Type | Description |
|---|---|---|
| periodsUpTo | String (format: yyyyMM) | Upper-bound financial period for forward expansion. When omitted, the current month is used (previous default behaviour). |
Data Mart ETL - 2026-04-01
No integrator-facing changes in this release.
Data Mart API - 2026-03-26
New Endpoints
- generalLedgerBalancesForwardByGroup - Forward-period expansion paginated by group. Each affected (branchId, accountId, subaccountId) group is expanded with virtual monthly periods up to the current month. Use
lastGroupKeyfor cursor-based pagination. Marked as EXPERIMENTAL. - generalLedgerBalancesForwardExpanded - Forward-period expansion with overflow.
pageSizecontrols approximate source documents processed; response may exceedpageSizedue to virtual period expansion. UselastGroupKeyfor cursor-based pagination. Marked as EXPERIMENTAL.
Data Mart ETL - 2026-03-26
New Fields
SalesOrderLines
| Field | Type | Description |
|---|---|---|
| Note | string | The user-defined note text connected to the sales order line, sourced from the ERP Note table. |
| ExtPrice | decimal | The extended price in currency for the sales order line, mapped from SOLine.CuryExtPrice. |
| LastModifiedDateTime | DateTime | The last modified timestamp of the sales order line. |