Page 1 of 1

How to link Payment to PayPlan in database

Posted: Thu Dec 03, 2020 2:59 pm
by dcrider
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.

Re: How to link Payment to PayPlan in database

Posted: Thu Dec 03, 2020 3:54 pm
by allends
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

Re: How to link Payment to PayPlan in database

Posted: Fri Dec 04, 2020 7:28 am
by dcrider
Thank you!