Open Dental Forum

Can anyone direct me to a report or query that will total the payments received by payment type?
I would like to generate a total of all the payments by cash, credit card and personal check for the year 2008.

Thanks.
DRTMZ

Try running this in the user query window:

set @startdate = '2008-01-01', @enddate = '2008-12-31';
select PayType, sum(payamt) $Total from payment where paydate between @startdate and @enddate group by paytype

Just edit dates at top for whatever range you want; format is YYYY-MM-DD.

Perfect. Exactly what I was looking for.

DRTMZ
Tom Zaccaria