Hello API Team
Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html
Patient ID
patient Full Name
Date of Service: This is the date a procedure was completed
Provider Name: The provider Name that completed the below above procedure.
Procedure Completed: code or name of the type of procedures that was completed.
Amount due: (Broken down by insurance balance, and patient balance) - This must be current meaning it is an open balance that has not been paid.
Aging Period. Example this is the aging period of the above balance 0-30, 31-60, ..
GET ApiProcedureLogs
Re: GET ApiProcedureLogs
Hello API Team Attn Jordan or Sarah.
Really need your help unless you recommend we go with a custom sql query.
Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html
Patient ID
patient Full Name
Date of Service: This is the date a procedure was completed
Provider Name: The provider Name that completed the below above procedure.
Procedure Completed: code or name of the type of procedures that was completed.
Amount due: (Broken down by insurance balance, and patient balance) - This must be current meaning it is an open balance that has not been paid.
Aging Period. Example this is the aging period of the above balance 0-30, 31-60, ..
Really need your help unless you recommend we go with a custom sql query.
Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html
Patient ID
patient Full Name
Date of Service: This is the date a procedure was completed
Provider Name: The provider Name that completed the below above procedure.
Procedure Completed: code or name of the type of procedures that was completed.
Amount due: (Broken down by insurance balance, and patient balance) - This must be current meaning it is an open balance that has not been paid.
Aging Period. Example this is the aging period of the above balance 0-30, 31-60, ..
Re: GET ApiProcedureLogs
Good morning,
Because these fields come from different tables and require many calculations, a query may be your best bet. I would recommend using Query #740 from https://opendentalsoft.com:1943/ODQuery ... yList.aspx as a starting place.
Because these fields come from different tables and require many calculations, a query may be your best bet. I would recommend using Query #740 from https://opendentalsoft.com:1943/ODQuery ... yList.aspx as a starting place.