Changes to the Data Mart ETL pipeline
View All TagsLocations with no Payment By value in the ERP now sync with paymentBy and paymentByType set to null. Previously a missing value was silently reported as the default Due Date, which could not be distinguished from a real setting. Locations with an unrecognised Payment By code continue to sync with paymentByType: null while keeping the raw code in paymentBy.
The FinancialPeriods collection is now synced from the ERP. Each document describes a period in the company's financial calendar:
finPeriodId, startDate, endDate, description, active and year.closedInGeneralLedger, closedInSupplierLedger, closedInCustomerLedger, closedInInventoryManagement, closedInCashManagement and closedInFixedAssets.The collection supports deletion tracking and reconciliation (deletedDatabaseRecord).
The Budgets collection has been updated to use the full GLBudgetLine composite key (companyId, branchId, ledgerId, financialYear, groupId, parentGroupId). Sibling budget lines that share a groupId but differ in parentGroupId were previously collapsed under a single document, causing related rows to be lost.
includeDeleted filter so integrations can choose whether soft-deleted records are included in query results.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.| 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. |
No integrator-facing changes in this release.
| 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. |