8 posts tagged with "ETL"

New ETL: Financial Periods​

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.
• Per-module close flags: closedInGeneralLedger, closedInSupplierLedger, closedInCustomerLedger, closedInInventoryManagement, closedInCashManagement and closedInFixedAssets.

The collection supports deletion tracking and reconciliation (deletedDatabaseRecord).

Budgets collection reimport​

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.

Data Quality Improvements​

• Deletion tracking is now available for all collections except Budgets, GeneralLedgerBalances, and JournalTransactions. The API exposes an includeDeleted filter so integrations can choose whether soft-deleted records are included in query results.

New Fields​

SupplierDocumentLine / APInvoiceLine​

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.

New Fields​

CustomerDocumentLine​

No integrator-facing changes in this release.

New Fields​

SalesOrderLines​