Open Dental Forum

Posted: **Thu Oct 26, 2023 1:12 pm**

x-post from developer forum.

Hi, how do you calculate max remaining? The issue I'm finding is incorporating the 'Adjustments to Insurance Benefits' record (found on the Edit Insurance Plan screen within the Family Module) which I can't seem to find in the DB or APIs returns.

Posted: **Fri Oct 27, 2023 8:05 am**

Good morning,

From our manual:

Individual Annual Max - (Ins Used + Pending) = Remaining

You can incorporate the adjustments to insurance benefits entered in this form via the ClaimProc table. They will have a claimproc.Status of "Adjustment".

Posted: **Fri Oct 27, 2023 12:56 pm**

You're the best! Dunno how i missed it but thank you!

Open Dental Forum

Calculating Max Remaining using SQL and/or APIs... ???

Calculating Max Remaining using SQL and/or APIs... ???

Re: Calculating Max Remaining using SQL and/or APIs... ???

Re: Calculating Max Remaining using SQL and/or APIs... ???