I'm encountering an error message when trying to run reports ("Reports" -> "Standard") which states:
So running query #958:At least one insurance payment is not finalized. Reports will be inaccurate until all payments are finalized.
See query example in the online manual #958, "Claims with payments entered by no check, not finalized
Produces no output (column headings are present, but no data). Any ideas on how to fix this? Running Open Dental 16.3.45.0./*958 Claims with payments entered but no check, not finalized*/
/*Query code written/modified: 03/11/2015*/
SELECT claim.PatNum AS 'Pat#',
CONCAT(CONCAT(patient.LName,', '),patient.FName) AS 'PatientName',
claim.DateService,
carrier.CarrierName,
SUM(claimproc.InsPayAmt) AS '$InsPayAmt'
FROM claim
INNER JOIN claimproc ON claimproc.ClaimNum = claim.ClaimNum
INNER JOIN patient ON patient.PatNum = claim.PatNum
INNER JOIN insplan ON insplan.PlanNum = claim.PlanNum
INNER JOIN carrier ON insplan.CarrierNum = carrier.CarrierNum
WHERE (claimproc.Status = '1' OR claimproc.Status = '4' OR claimproc.Status=5)
AND (claimproc.InsPayAmt != 0 AND claimproc.ClaimPaymentNum = '0')
GROUP BY claim.PatNum,claim.ClaimNum,claimproc.ClaimPaymentNum,claim.PatNum
ORDER BY patient.LName, patient.FName, claim.DateService
Thanks.
Brad