Warehouse Manager

Data integration and synchronization dashboard

Imports

Azure / SharePoint Import Not configured

Import SharePoint lists via Microsoft Graph API

Daily at 02:30

BSS Import Not configured

Import transaction entries from BSS real estate accounting

Daily at 04:00

Directo Import Active

Import invoices, payments, and receipts from Directo

Weekdays at 04:30

Erply Import No companies

Import accounts and entries from Erply Books

Daily at 03:30

Odoo Import Active

Import chart of accounts and journal entries from Odoo

Daily at 03:00

QuickBooks Import Active

Import accounts, transactions, customers, and vendors

Daily at 02:00

SimplBooks Import Active

Import accounts, invoices, purchases, payments, and incomings

Daily at 04:15

Manual GL Import Active

Upload general-ledger CSV batches from any external accounting system

On demand

Exports

Bloomberg Export Not configured

Export daily balance data to Bloomberg SFTP

Weekdays at 14:05

Background Jobs (No UI)

JPM (JP Morgan) Not configured

Import holdings and transactions via SFTP

Weekdays at 14:00

Goldman Sachs Not configured

Import holdings and activity via SFTP

Weekdays at 14:10

Database Operations

Full Migration

Typically takes ~10 minutes to complete

Automatically daily at 06:00

Last run: 2026-09-02 06:00:03 (automatic) completed · 3m 54s

1. Migrate master data: companies, projects, and accounts from Azure

2. Load transactions: Directo, Odoo, QuickBooks, Erply, BSS, SimplBooks, and Manual GL staging into the normalized ODS layer

3. Transform: build core transaction model with project/object allocations and counterparty mappings

4. Consolidate: build ownership hierarchies

Data Impact Details

Drops & Recreates (structure lost)

  • Dimension tables (dim_date, dim_currency, dim_project, dim_object, dim_coa_taxonomy)
  • Staging tables (stg_directo_*, stg_bss_*, stg_erply_*, stg_qb_*)
  • ODS tables (ods_transaction_*)
  • Consolidation table (fct_ownership)
  • Mapping tables (dim_company_object_mapping, dim_account_object_mapping)

Deletes All Data (structure preserved)

  • core_transaction and core_transaction_line
  • Allocation tables (core_transaction_line_project, core_transaction_line_object)
  • Counterparty mappings (core_transaction_line_counterparty)
  • Reference dimensions (dim_currency, dim_date)
Output: What Gets Built

Core Data Model

  • core_transaction + core_transaction_line — Unified general ledger from Directo, BSS, Erply
  • core_transaction_line_project/object — Multi-dimensional allocations
  • core_transaction_line_counterparty — Line-level counterparty tracking

Dimensions

  • dim_company — Legal entities with ownership relationships
  • dim_project — Investments (ISIN, brokers, lifecycle)
  • dim_object — 3-level categorization hierarchy
  • core_account + dim_coa_taxonomy — Chart of accounts

Consolidation

  • fct_ownership — Parent-subsidiary relationships with ownership % and effective dates

Reporting Views

  • vw_pearaamat — General ledger with full dimensions
  • vw_financial_statements_monthly: monthly balance sheet and P&L by consolidation group (Intragroup/External)
  • vw_jane_tr_consolidated — Consolidated with Intragroup/External
  • vw_account_hierarchy — Standardized account hierarchy

After running, you can:

Query unified financial data across all source systems, generate consolidated/unconsolidated IFRS reports, analyze by investment position, and identify intragroup transactions for elimination.

Task History

Status Source Type Message Started Duration
completed scheduled full migration Full migration completed
  • 38347 core_transaction rows
  • all balanced.
 2026-09-02 06:00:03 3m 54s
completed scheduled directo invoice snapshot Directo outstanding-invoice snapshot 60 open invoices captured for today 2026-09-02 05:00:01 0s
completed scheduled directo full Directo full import (4 companies)
  • 190960 transactions
  • 2846 payments
  • 549 receipts
  • 937 invoices
 2026-09-02 04:30:02 4m 9s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 12 purchases
  • 14 purchase rows
 2026-09-02 04:15:03 25s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-09-02 04:00:02 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-09-02 03:30:04 0s
completed scheduled odoo Odoo scheduled import
  • 1553 journal entries
  • 17513 lines
 2026-09-02 03:00:03 5s
failed scheduled quickbooks Job failed App\Jobs\GetNewDataFromQuickBooksJob has timed out. 2026-09-02 02:00:03 10m 5s
completed scheduled full migration Full migration completed
  • 38297 core_transaction rows
  • all balanced.
 2026-09-01 06:00:03 3m 55s
completed scheduled directo invoice snapshot Directo outstanding-invoice snapshot 55 open invoices captured for today 2026-09-01 05:00:01 0s
completed scheduled directo full Directo full import (4 companies)
  • 190807 transactions
  • 2844 payments
  • 549 receipts
  • 932 invoices
 2026-09-01 04:30:02 4m 9s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 12 purchases
  • 14 purchase rows
 2026-09-01 04:15:03 25s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-09-01 04:00:02 1s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-09-01 03:30:04 0s
completed scheduled odoo Odoo scheduled import
  • 1553 journal entries
  • 17513 lines
 2026-09-01 03:00:03 6s
completed scheduled quickbooks QuickBooks scheduled import
  • 29 transactions
  • 133 lines
 2026-09-01 02:00:02 2m 7s
completed scheduled full migration Full migration completed
  • 38255 core_transaction rows
  • all balanced.
 2026-08-31 06:00:01 3m 58s
completed scheduled directo invoice snapshot Directo outstanding-invoice snapshot 55 open invoices captured for today 2026-08-31 05:00:02 0s
completed scheduled directo full Directo full import (4 companies)
  • 190672 transactions
  • 2840 payments
  • 548 receipts
  • 931 invoices
 2026-08-31 04:30:01 4m 13s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 12 purchases
  • 14 purchase rows
 2026-08-31 04:15:04 25s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-08-31 04:00:03 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-08-31 03:30:02 0s
completed scheduled odoo Odoo scheduled import
  • 1552 journal entries
  • 17510 lines
 2026-08-31 03:00:01 5s
completed scheduled quickbooks QuickBooks scheduled import
  • 12 transactions
  • 75 lines
 2026-08-31 02:00:03 1m 59s
completed scheduled full migration Full migration completed
  • 38248 core_transaction rows
  • all balanced.
 2026-08-30 06:00:02 3m 55s

Source Table Statistics

Directo

directo_transaction_row 190,960
directo_payment 2,846
directo_payment_row 12,992
directo_receipt 549
directo_receipt_row 941
directo_invoice 937
directo_invoice_row 2,791
Total 212,016

Odoo

odoo_account 2,641
odoo_journal_entry 1,553
odoo_journal_entry_line 17,513
Total 21,707

QuickBooks

qb_account 801
qb_transaction 29
qb_transaction_line 133
qb_customer 12
qb_vendor 252
qb_class 0
Total 1,227

SimplBooks

sb_financial_account 195
sb_income_account 3
sb_client 6
sb_invoice 1
sb_invoice_row 4
sb_purchase 12
sb_purchase_row 14
sb_payment 13
sb_incoming 1
Total 249

Erply

erply_account 0
erply_account_entry 0
Total 0

BSS

bss_transaction_entry 0
bss_transaction_entry_detalization 0
Total 0

JPM

jpm_client 0
jpm_holding 0
jpm_instrument 0
jpm_transaction 0
jpm_fx_position 0
Total 0

Goldman Sachs

gs_account 0
gs_activity 0
gs_holding 0
Total 0

Manual GL

manual_gl_import_batch 0
stg_manual_gl_line 0
manual_gl_import_batch_validation_error 0
Total 0

Azure

azure_bs_konto_objekt 0
azure_entity_relationships 82
azure_epra_formulas 0
azure_indi_account_mapping_sp 7,076
azure_kontserni_kontoplaan 540
azure_objects 0
azure_project_mapping 0
azure_project_repository 0
azure_sp_accounts_taxonomy 136
azure_sp_list_eliminations 0
Total 7,834