Aging A/R - API

For requests or help with our API
Post Reply
PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Aging A/R - API

Post by PBECKER » Mon Apr 18, 2022 11:23 am

Jordan/API Team

First off thank you for rolling out the Open Dental API! We love it!

Request: We currently pull the "standard Open Dental" Aging A/R report that shows total patient balance by Aging period and also insurance balance by patient.

We have noticed that the patient balance is the sum that is owed, is there any API method that we can pull what a patient owes broken down by procedure code or procedure description

In the below this is broken out by each line item instead of sum of amount due for patient balance.

Example
John Doe
$25 D110
$75 D2150

Thanks for #Rockin @Jordan and @API Team

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Aging A/R - API

Post by SLeon » Tue Apr 19, 2022 8:35 am

There is not yet an API method that will return an account breakdown for a patient. Currently, you can get a patient's total balance with AccountModules GET PatientBalances, but this does not itemize the individual charges by procedure. We will work on adding a method for you to retrieve this detailed information.

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: Aging A/R - API

Post by PBECKER » Tue Apr 19, 2022 5:20 pm

Hello Sarah

Would the method also include the procedure code and/or the description of the completed procedure.

Do you think we should work with the OD DB SQL team or is this something that can be added to the OD API?

Thanks so much Sarah

example
Patient Name Amount PCODE
John Doe $5.00 d1110
John Doe $55.00 D2310

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Aging A/R - API

Post by SLeon » Thu Apr 21, 2022 9:55 am

If you are open to using a query, I believe Query #159 posted on our Query Page would give you the information you need. This could be used with our Queries PUT ShortQuery API method for each patient.

Post Reply