Open Dental Forum

I need to run a report that shows the codes for our top dollar volume dental procedures. I also need a report that shows the amount insurance providers will pay for that procedure. Does anyone know if these reports actually exist? And if so, how do I run them? Thank you.

You can start with this: Reports/Released user Queries

Copy and paste below..

/*54*/ SET @FromDate='2007-01-01' , @ToDate='2007-01-15';
SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) As Patient, pc.ProcCode, pl.ProcDate, pl.ProcFee, ps.SplitAmt
FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
AND pl.ProcStatus != 6
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
LEFT JOIN paysplit ps ON pl.ProcNum=ps.ProcNum
WHERE pl.ProcDate >= @FromDate
AND pl.ProcDate <=@ToDate
ORDER BY patient.LName, patient.FName ASC;

Then try #264

drtmz