Revision [174]
Last edited on 2008-11-10 17:13:01 by SethKriegerAdditions:
======Total Amount In Collections======
Deletions:
Revision [173]
Edited on 2008-11-10 17:12:34 by SethKriegerAdditions:
======[[Total Amount In Collections======
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?
SELECT
SUM(postedbal - ageunapplied) AS "AmtInCollections"
FROM
ptpayors a
JOIN payors b ON a.payornum = b.payornum
WHERE
b.collectdate IS NOT NULL
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?
SELECT
SUM(postedbal - ageunapplied) AS "AmtInCollections"
FROM
ptpayors a
JOIN payors b ON a.payornum = b.payornum
WHERE
b.collectdate IS NOT NULL
Deletions:
comments here appear in italics
paste your tested query here