12 posts tagged with "ETL"

In this release:

• Supplier documents, payments and payment lines: synchronization of the new supplier document, payment and payment-line fields, with historical backfills.
• APHistoricalData: new ETL, disabled in Production while testing is in progress.

In this release:

• Customers: field values, customer fields, notes, related-data lookups and reimport.
• Locations: nullable GLN and historical data refresh.
• Contacts: date-of-birth synchronization and historical backfill.
• Branches: branch-name synchronization and historical backfill.
• SalesOrders: field removal and reimport.
• Employees: full-refresh synchronization, soft deletion and attributes identifier import.
• Customer and supplier IDs on lines: line synchronization imports the customer or supplier ID and backfills existing lines.
• GeneralLedgerBalances: removed balances are now marked as deleted, with a one-time cleanup of existing data.
• CustomerPayments and CustomerPaymentLines: cash-document inclusion remains disabled.
• ARHistoricalData: remains disabled in Production.

Production ETL availability​

• ARHistoricalData is disabled in Production while testing is in progress. The AR_HISTORICAL_DATA enum value and API reference are present, but the ETL is not enabled in Production.
• InventoryItems is enabled in Production. The INVENTORY_ITEMS ETL is enabled for inventory item synchronization.

Location sync reports missing Payment By values as null​

Locations 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.

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​

Field	Type	Description
DeferralScheduleNbr	string	The deferral schedule's business number, populated separately from the existing DeferralSchedule (description) and DeferredCode (code) values.

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​

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.