DD-CON-004-Q054 Very Hard Time series

Largest month-end intercompany suspense, 2025

At which month end of 2025 was the intercompany suspense largest in absolute terms, and what was it? Answer as YYYY-MM · amount in USD (debit positive).

Expected: YYYY-MM · amount · Column chart by month end
Tables: FactGLLines, DimAccount_SAP, DimAccount_Oracle, DimAccount_Legacy +3 · columns

FactGLLines
DimAccount_SAP
DimAccount_Oracle
DimAccount_Legacy
DimFXRate
DimICPartner
DimEntity

EntityCode
LocalAccountCode
Amount
DrCrIndicator
PostingStatus
SourceTypeCode
PostingDateKey
PartnerCode
RateType
Rate
PeriodKey
CurrencyCode
Topics: Time Series & Trends Consolidation & Currency