Received in 2025, posted in 2026

An invoice's received time is the EventTimestamp of its "Received" event, its posted time that of "Posted", and its paid time that of "Paid" or "Manual payment". What is the Amount of invoices received on or before 31 December 2025 with a PostingDate in 2026, in USD?

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

FactInvoiceEvent
FactInvoice

InvoiceID
Activity
EventTimestamp
UserID
PostingDate
Amount
Topics: Time Series & Trends 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