- August 11, 2010 at 9:32 am #31123
I am looking for a report that lists all our patients who have a none zero balance on their patient account.
The “Patient List” would work in the right way but there seems to be no way to include the outstanding balance on it.
We have several thousand patients, where nearly all of them have a zero balance. So need to be able to limit down to include only those with none zero balances.
Tony TaylorAugust 11, 2010 at 9:35 am #32500
Yes please – i would like that too please 🙂
ACtually – i have this report! Will upload it for you?August 11, 2010 at 9:38 am #32501
Sorry – just looked at the SQL – it is coded for my clinic and custom fields.
Hedley and William were great in providing a report for me that did it.
Ask them about it 🙂
CheersAugust 12, 2010 at 10:31 am #32502
Hi – please find attached two reports :-
– Account Balances (All)
– Account Balances (Open)
Please see this faq document if you need help importing these reports into your database :-
Hope this helps!
Attachments:You must be logged in to view attached files.
You must be logged in to reply to this topic.