Collected Amount
This metric shows how much money has been received from customers whose accounts entered a dunning workflow during a given period.
We’re just looking at customers who, from the chosen date onward, ever had a dunning workflow started (whether by customer, invoice, or customer group). Then we add up every payment they actually made on or after that same date. If nobody paid, the total is zero.
Workflows Open Balance
This represents the total outstanding balance as of the workflow start date across all active dunning workflows.
How it’s calculated:
Retrieve all active workflows (customer workflows, invoice workflows, and customer-group workflows) that ended on or after the selected date.
For each workflow record, compute the starting balance:
Invoice workflows use the invoice-specific starting balance.
Customer/customer-group workflows sum the whole balance at start
If a customer appears in both an individual workflow and a group workflow, only the larger of the two balances counts.
Convert each workflow’s starting balance into the company’s base currency using up-to-date exchange rates.
Sum all converted balances.
Both metrics are recalculated on demand and cached per user/company for correct dashboard display.