Release 2.0.0.54
Executive Summary
Owned Fleet Allowance Surrender: Introduced an end-to-end surrender workflow with a dedicated accounting ledger (Voyage CO2 Surrender Assets) to lock and hold allowances on company balance sheets prior to official surrender.
Invoice Controlling & Exposure Reconciliation: Added an Invoice Controlling submodule to audit invoiced versus physical carbon exposure per voyage and instantly flag unbalanced AP/AR positions.
FuelEU Maritime Calculator & Bio Modeling: Launched an interactive voyage compliance calculator featuring custom biofuel blending, regulatory target trajectories (2025–2051), and synthetic compliance pricing for bio voyages.
Insight Hub Visual ETL (Data Preparation): Introduced a visual data preparation layer supporting dataset joins, appends, pivot/unpivot transformations, and 4-level date hierarchies with drill-down capabilities.
Automated Price Reconciliation & Curve Implication: Deployed an automated recon engine with holiday schedule awareness to validate curve completeness, alongside an in-house hierarchical Baltic forward price implication engine.
Unified VoyageCargo Algorithm & Client APIs: Rolled out the unified VoyageCargo algorithm to dynamically convert cargos to voyages upon nomination, supported by centralized client Swagger API documentation.
EU ETS & Financial Invoicing (Invoices, Controlling, Owned Fleet Surrender, & Bank Accounts)
A substantial expansion covering owned fleet allowance surrender workflows, a dedicated invoice controlling module, custom PDF invoice templating, and banking APIs.
Owned Fleet (OV) Allowance Surrender Workflow: Implemented an end-to-end surrender process for owned vessels surrendering allowances directly to authorities. Added a dedicated OV Allowance Surrender tab with Ready for Surrendering and Surrendered stages. Introduced the Voyage CO2 Surrender Assets accounting transaction account (routing: Prepaid Assets → Surrender Assets → Transferred Assets), locking allowances to prevent double-allocation while retaining them on company balance sheets prior to official surrender. Added multi-invoice group surrendering and integrated surrender statuses into Net Position, Physicals, Financials, and the All Invoices API.
Invoice Controlling & Invoice Balance Submodule: Added a comprehensive Controlling and Invoice Balance module under Invoices to audit and reconcile invoicing liabilities against physical exposure across both AP (Owners) and AR (Charterers).
Distributes invoice volumes across physical trades based on status hierarchy: Completed → Surrendered → Ready for Surrendering → Outstanding → Pending.
Tracks Not Invoiced Volume per voyage and introduced an Unbalanced Positions filter to immediately isolate under- or over-invoiced voyages.
Added position filtering (All, AP, AR), summary KPI cards (Carbon AP/AR Exposure, Issued Invoices, Net Balance), total aggregation rows (SUM for volumes, weighted averages for prices), and inline quick-actions (Generate Invoice, Edit Physical Trade, Comments).
Custom PDF Invoice Generation: Introduced an Invoicing submodule under ETS Settings allowing clients to design, configure, and export professional PDF invoices for AP/AR Cash and Allowance Transfers, featuring customizable business unit headers, logos, and dynamic voyage/port tags.
Invoicing UI & Workflow Modernization: Renamed Payables & Receivables (APAR) to Invoices, Invoices to Issued, and Pending Invoices to Pending. Enabled negative amount entry for Payable Transfer invoices, synchronized the Close Spot Price Date with Transfer Date, and added safeguards/warnings when reallocating carbon breakpoint volumes.
Bank Accounts Public API: Added a dedicated public API endpoint (/api/public/bankaccounts) to retrieve company bank account configurations (IBAN, account numbers, currencies, status) for automated external reconciliation.
ERP & Back-Integration Enhancements: Updated integration rules to treat external VMS/IMOS status Posted as Released to ensure allowance Transfer XMLs trigger reliably. Added an ActionBy username audit column across integration logs (including Dataloy logs).
Trade Distribution & Voyage Linkage: Added a Trade Distribution Summary pop-up on Financial Deals and introduced a dedicated Linked Voyage column ({VesselName} - V{VoyageNo}) visible in both the UI and Excel exports.
FuelEU Maritime (FEUM) & Fuel EU Calculator
The launch of the Fuel EU Calculator suite, synthetic bio-voyage pricing models, and compliance trade journal controls.
Fuel EU Calculator Submodule: Rolled out an interactive voyage compliance calculator:
Itinerary & Leg Generator: Auto-generates consecutive voyage legs based on port calls, arrival/departure dates, port percentages (0% or 100%), and operational functions (Loading, Bunkering, Transit, Discharge).
Fuel Consumption & Emissions Modeling: Calculates leg-by-leg consumption, Sea %, Energy (MJ), WtW GHG intensity, TtW CO₂, ETS phase-in allowances, Compliance Balance, penalty exposure (€2,400/t VLSFO equivalent), and pooling cost/revenue.
Target WtW Curves: Integrated regulatory reduction trajectories from 2025 through 2051 alongside annual ETS phase-in rules (70% in 2025, 100% from 2026).
Voyage Summary: Aggregates Total/Reportable Energy (GJ), total emissions, net penalty or pooling revenue, and converts total compliance costs into EUR and USD.
Default Marine Fuel Grades: Standardized fixed baseline grades (HFO, LFO, MGO, LNG) with regulatory LCV, WtT, TtW, and WtW values.
Bio Blender: Tool to formulate custom biofuel blends (e.g., B20, B30 FAME) by blending base fossil fuels with bio-feedstocks to dynamically calculate blended LCV, WtT, TtW, and WtW intensity.
Company State Management: Added Save and Clean/Reset features to store custom calculator inputs per organization.
Synthetic Compliance Pricing for Bio Voyages: Implemented compliance cost analysis for biofuel voyages by calculating synthetic baseline consumption (what CB and ETS emissions would have been if burning conventional fuel vs. actual bio consumption), factoring in biofuel price premiums and quantities to derive the true net compliance cost per employment.
Compliance Trade Journals & Vendor Management: Added support for mapping specific counterparty vendor numbers (VendorNo) directly from compliance trades into external ERP pool journal entries (overriding standard contract owners). Added a quick-entry pop-up during trade creation and exposed IsCounterpartyEmployment in the FEUM Employments API.
Pool Settlements & Contract Locking: Unlocked settled pools after surplus banking to allow post-settlement adjustments to vessel composition and surplus sharing. Added column-locking icons to TCHF contracts and employments to prevent automated raw imports from overriding verified operational numbers.
UK ETS Module
Balance & Net Position Isolation: Resolved an issue where unallocated EUA financial trades and unlinked swaps under EU ETS were being counted in the UK ETS Net Position, ensuring strict balance isolation between UKA and EUA inventories.
Contract Dropdown Restrictions: Restricted UKA contract selection strictly to the UK ETS Manager, removing it from general freight and financial trade creation dropdowns.
Surrender Workflow Compatibility: Extended the new Owned Fleet Allowance Surrender workflow to fully support UKA compliance obligations.
Custom Report Builder (Insight Hub) & Data Preparation
A major evolution introducing a visual ETL Data Preparation layer, advanced hierarchies, and rich visual components.
Data Preparation (Visual ETL Layer): Added a new Data Preparation submodule within Modeling:
Applied Steps Audit Trail: Chronological list of all applied transformations with the ability to edit, reorder, or delete steps.
Data Transformations: Added Pivot (converting unique row values into columns with aggregations) and Unpivot (converting columns into attribute-value pairs).
Dataset Joins & Appends: Added Merge (Inner, Left, Right, and Full joins between datasets with custom key selection) and Append (concatenating datasets with auto-alignment of matching columns and union of mismatched fields).
Column & Value Operations: Selectable grid columns, double-click inline column renaming, data type conversion menu, value search/replace pop-up, ascending/descending sorting, column deletion, and row filtering (removing empty/null values, distinct value filtering, and conditional logic).
Visuals & Charting Enhancements:
New Visual Types: Added Clustered Bar charts and an interactive Shapes library (Rectangles, Rounded Rectangles, Ellipses, Lines, Arrows, Triangles) with custom text overlay, color fills, and transparency controls.
Date Hierarchies & Multi-Level Drill: Automatic Date Hierarchy generation (Year → Quarter → Month → Day) with full drill-down, drill-up, go to next level, and expand to next level navigation across charts.
Date Formatting Submenu: Added granular date display formatting options (dd.mm.yyyy, yyyy-mm-dd, mmmm yyyy, etc.) directly on visual fields.
Matrix Controls: Added expand/collapse controls (+ / -) for nested column headers, sticky row/column totals without scrolling, and persistence of expansion state in view mode.
Table Totals & Advanced Aggregations: Column-level total row customization (Sum, Average, Count, Min, Max, None) with an option to hide aggregation labels. Added new aggregations including Distinct Count, Standard Deviation, Variance, and Median.
Canvas & Design Utilities: Added Format Painter to copy and paste styling across visuals, Copy/Paste visuals across dashboard pages, custom canvas background colors/transparency, and red alignment snap-lines during visual resizing.
Pre-defined Data Sources: Added a one-click connection modal to pull standard FindDeals trade data into reports.
Presentation View Polish: Clean view mode removing filter indicators and column type tags, adding clear (View) / (Edit) mode tab indicators.
World Map & Scenario Management
Scenario-Isolated Regions & Pegs: Upgraded the World Map to support isolated region layouts, coloring schemes, and peg allocations per scenario, ensuring vessels and simulated routes belong strictly to their designated scenario model.
Scenario Manager Metrics: Fixed vessel peg allocation counts within the Scenario Manager and scoped the "Has Peg" filter strictly to the active scenario.
P&L & Deal Integration: Added a World Map Scenario selector dropdown in Physical Deals and P&L Settings/APIs to simulate positions and mark-to-market calculations against hypothetical routing scenarios.
UX Refinements: Enabled the ESC key to quickly close the peg editing dialog and removed obsolete route columns.
Price Matrix (PM) & Automated Price Reconciliations
Automated Price Reconciliation Engine: Rolled out an end-to-end automated price recon and validation system:
Recon Jobs Manager: Create, configure, and schedule recon jobs with customizable publication lags (e.g., T-0 for end-of-day Baltic, T-1 for morning broker curves) and automated email summary alerts.
Contract Recon Rule Mapping: Database table and interface mapping expected price requirements per contract (Spot vs. Forward expectations, expected forward period counts, and units across TCE, PMT, WorldScale, and Percentage).
Multi-Stage Validation Pipeline: Automated checks for missing curves, stale data, curve shrinkages, null/zero prices, forward period shortfalls, and duplicates.
Holiday Calendar Awareness: Differentiates between missing publication dates and official market holidays (e.g. Baltic Europe bank holidays), suppressing false missing-price alerts.
UI Results Viewer: Added an in-app "View Results" panel to inspect detailed reconciliation logs directly in the platform.
Baltic Price Implication Engine: Built an in-house hierarchical implication engine (Year → Quarter → Month) utilizing both Linear and Average methodologies to derive consistent monthly forward curves when underlying periods lack granular quotes or exhibit internal discrepancies.
Contract & Source Configurations: Added an IsBunker toggle on PM contracts to distinguish bunker swaps from freight FFAs, added a SkipFFASuffix parameter for Baltic forward tickers (handling new cape indices), and introduced an advanced last-business-day-of-month filter for targeted contract recalculations. Renamed "Pricer" module references to "Price Matrix" across permissions.
Trading Algorithms & Data Center
Unified "VoyageCargo" Algorithm: Built a new algorithm unifying both voyages and cargos into a single execution pipeline:
Dynamically transitions contracts from long/short cargo (Cargo Usd/Day or Cargo Usd/Ton) to Voyage or Voyage Charter upon vessel nomination while retaining unique cargo identifiers.
Supports unified grouping across Counterparty, Charter Party Date, and Vessel Code.
Accommodates per-day, per-ton, index-linked, and optional cargo structures.
Algorithm Adjustments: Ensured negative volume representation for all TC-Out structures (TC-Out, Tolerance-Out, Index-Out, Optional-Out), corrected index percentage scaling from decimal representations, and enabled manual override of original creation timestamps (OriginallyCreatedAt) in carbon exposure models.
Data Center & Job Connectors: Added dynamic token generation and storage within scheduled Jobs for external APIs requiring session-based bearer authentication (e.g. Zema), and updated import jobs to gracefully handle empty data arrays without caching stale raw reports. Decoupled Data Center code references from Risk modules for performance.
Platform, Observability & Performance Polish
Unified Client Swagger Documentation: Launched a centralized public API documentation portal consolidating client-accessible endpoints across Price Matrix, Risk, and Data Center while excluding administrative routes.
API Response Compression: Implemented response compression on the Public Risks API (/api/public/trades) to optimize network transfer times for large payloads (>50 MB).
Frontend Stability Telemetry (Faro/Loki): Resolved multiple client-side exceptions and assertions across Physical Deals, Map View, Snapshots, Users, Financial Deals, and Custom Reports.
Infrastructure Maintenance: Upgraded underlying Ubuntu OS releases across DEV, TEST, UAE, and LIVE virtual machine clusters, and renewed platform SSL/TLS security certificates.
Usability Improvements: Multi-page sorting across financial deals, batch confirmation streamlining for multi-deal deletions, visual unread indicators on voyage comments, and soft-delete capabilities for dictionary entries.