Open Dental Forum

We are trying to build a Patient Ledger view to show Appointment, Production, Collection, WriteOff & Adjustment data together.
In ProcedureLog table there are lot of records with AptNum=0 and so we are not able to relate Appointment with Adjustments.
For eg. if a patient had an appointment followed by procedure in Apr 21, and in Jun 21 there was Adjustment, how do we tie them together.

What is the best way to build relationship from Adjustment to Appointment?
We are trying to calculate net-production per appointment after all adjustments and writeoff.

I think the only way to associate an adjustment to an appointment is to have the adjustment attached to a procedure that is attached to an appointment. When you found many records in the ProcedureLog table with AptNum=0, were you filtering by ProcStatus? I ask because those records may have a status of Deleted or some other status that is not relevant to your net-production per appointment.