I'm having difficulty finding a link between a Payment and a PaymentPlan. Is there a more accurate way than looking it up by PatNum and assuming the PayAmt will be the same as the amount on the corresponding PayPlanCharge?
Cash patients, for example, may not make a payment when the scheduled date arrives if that date is a holiday or weekend, so I also can't assume the date will be the same.
How to link Payment to PayPlan in database
Re: How to link Payment to PayPlan in database
In the grand scheme of things Payments don't really have a lot of financial weight in the program.
What you are looking for are PaySplits
https://www.opendental.com/OpenDentalDo ... l#paysplit
What you are looking for are PaySplits
https://www.opendental.com/OpenDentalDo ... l#paysplit