How to link Payment to PayPlan in database

This forum is for programmers who have questions about the source code.
Post Reply
User avatar
dcrider
Posts: 67
Joined: Sun Sep 29, 2019 11:03 am
Contact:

How to link Payment to PayPlan in database

Post by dcrider » Thu Dec 03, 2020 2:59 pm

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.

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: How to link Payment to PayPlan in database

Post by allends » Thu Dec 03, 2020 3:54 pm

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
Allen
Open Dental Software
http://www.opendental.com

User avatar
dcrider
Posts: 67
Joined: Sun Sep 29, 2019 11:03 am
Contact:

Re: How to link Payment to PayPlan in database

Post by dcrider » Fri Dec 04, 2020 7:28 am

Thank you!

Post Reply