Open Dental

The "Procedure.ComputEstimates/ClaimProc.ComputeBaseEst" in that column description for AllowedOverride is not a calculation. It is referring to a pair of functions in our code. For each procedure in the treatment plan, the Procedure.ComputeEstimates function calls the ClaimProc.ComputeBaseEst func...

joes wrote: ↑

Wed Jan 05, 2022 10:34 am

How do you plan to use the calculation? Is this part of a query or a plugin?

Query

Query

I am trying to get the "Allowed" In the Treatment Plan page. After consulting with the OpenDental Documentation, in the "claimproc", I see this https://i.imgur.com/BhzgQc9.png So it seems that the "Allowed" column is calculated by looking at some column that has "ComputeEstimates" divided by "Comput...

Hello Unioning them didnt work because the queries seem to be very different. I found Query #793 from the QueryList and it seems to work except the Writeoff amount is different from what is generated in the report. For reference, this is Query 793: https://pastebin.com/J5YhjjcL The production, adjus...

I would like to combine all these queries together (from Report) into One SELECT procedurelog.ProcDate Date, CONCAT(CONCAT(CONCAT(CONCAT(patient.LName, ', '),patient.FName),' '),patient.MiddleI) namelf, procedurecode.Descript Description, provider.Abbr, procedurelog.ClinicNum Clinic, procedurelog.Pr...