Retail: the accrual that was never reversed

Every month-end electricity accrual of Mizan Retail (SourceCode AJ, account 62000) is reversed on the 1st by an RV journal whose ReversesJournalID points to it. Ignoring September 2026, one accrual was never reversed. Its amount, in USD?

Expected: One amount in USD, 2 decimals · KPI card
Tables: FactJournalLines · columns

FactJournalLines

JournalID
EntityCode
AccountCode
Debit
Credit
JournalStatus
PeriodKey
SourceCode
ReversesJournalID
PostingDate
Topics: Time Series & Trends Risk & Controls General Ledger & Close

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in