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

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

2. Load transactions: Directo, BSS, and Erply staging tables into 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_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 simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 8 purchases
  • 10 purchase rows
 2026-07-04 04:15:04 20s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-07-04 04:00:03 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-07-04 03:30:02 0s
completed scheduled odoo Odoo scheduled import
  • 1520 journal entries
  • 17121 lines
 2026-07-04 03:00:04 5s
completed scheduled quickbooks QuickBooks scheduled import
  • 10 transactions
  • 33 lines
 2026-07-04 02:00:03 2m 7s
completed scheduled directo full Directo full import (3 companies)
  • 88210 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-07-03 04:30:01 2m 2s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 8 purchases
  • 10 purchase rows
 2026-07-03 04:15:02 21s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-07-03 04:00:01 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-07-03 03:30:03 0s
completed scheduled odoo Odoo scheduled import
  • 1519 journal entries
  • 17118 lines
 2026-07-03 03:00:03 1s
completed scheduled quickbooks QuickBooks scheduled import
  • 10 transactions
  • 33 lines
 2026-07-03 02:00:02 2m 4s
completed scheduled directo full Directo full import (3 companies)
  • 88017 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-07-02 04:30:01 2m 2s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 8 purchases
  • 10 purchase rows
 2026-07-02 04:15:02 20s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-07-02 04:00:04 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-07-02 03:30:03 0s
completed scheduled odoo Odoo scheduled import
  • 1519 journal entries
  • 17118 lines
 2026-07-02 03:00:03 1s
completed scheduled quickbooks QuickBooks scheduled import
  • 10 transactions
  • 33 lines
 2026-07-02 02:00:02 2m 4s
completed scheduled directo full Directo full import (3 companies)
  • 87805 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-07-01 04:30:01 2m 1s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 8 purchases
  • 10 purchase rows
 2026-07-01 04:15:04 21s
completed scheduled bss BSS scheduled import
  • 0 entries
  • 0 detalizations
 2026-07-01 04:00:03 0s
completed scheduled erply Erply scheduled import
  • 0 accounts
  • 0 entries
 2026-07-01 03:30:02 0s
completed scheduled odoo Odoo scheduled import
  • 1519 journal entries
  • 17118 lines
 2026-07-01 03:00:04 5s
completed scheduled quickbooks QuickBooks scheduled import
  • 10 transactions
  • 33 lines
 2026-07-01 02:00:04 1m 57s
completed scheduled directo full Directo full import (3 companies)
  • 87765 transactions
  • 0 payments
  • 0 receipts
  • 0 invoices
 2026-06-30 04:30:02 2m 2s
completed scheduled simplbooks SimplBooks scheduled import
  • 1 invoices
  • 4 invoice rows
  • 8 purchases
  • 10 purchase rows
 2026-06-30 04:15:03 21s

Source Table Statistics

Directo

directo_transaction_row 88,210
directo_payment 0
directo_payment_row 0
directo_receipt 0
directo_receipt_row 0
directo_invoice 0
directo_invoice_row 0
Total 88,210

Odoo

odoo_account 2,637
odoo_journal_entry 1,520
odoo_journal_entry_line 17,121
Total 21,278

QuickBooks

qb_account 800
qb_transaction 10
qb_transaction_line 33
qb_customer 12
qb_vendor 252
qb_class 0
Total 1,107

SimplBooks

sb_financial_account 195
sb_income_account 3
sb_client 6
sb_invoice 1
sb_invoice_row 4
sb_purchase 8
sb_purchase_row 10
sb_payment 9
sb_incoming 1
Total 237

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 68
azure_epra_formulas 0
azure_indi_account_mapping_sp 7,076
azure_kontserni_kontoplaan 540
azure_objects 0
azure_project_repository 0
azure_sp_accounts_taxonomy 136
azure_sp_list_eliminations 0
Total 7,820