======Total Amount In Collections======

Back to [[QueryDirectory Query Directory]]

//
Once we change a Patient's Billing Options to "date turned over to collections", this patient now appears as the color red in the Active Patients List.
Is there a way to determine the amount of balance that all those patients in red have--in total?
//

%%(sql)
SELECT
SUM(postedbal - ageunapplied) AS "AmtInCollections"
FROM
ptpayors a
JOIN payors b ON a.payornum = b.payornum
WHERE
b.collectdate IS NOT NULL
%%


----
CategoryQueries