Search found 6 matches

by baoluan1
Thu May 19, 2022 9:37 am
Forum: Developers
Topic: Scheduled KPI in Monthly Production and Income report
Replies: 0
Views: 243

Scheduled KPI in Monthly Production and Income report

On the Monthly Production and Income OD report if you run it mid month you have scheduled $ for future days. I have been trying to replicate this one KPI through the API but cant seem to match it. I know that the procedurelog table has the procfee and one could just total that BUT the claimproc tabl...
by baoluan1
Fri Feb 04, 2022 2:14 pm
Forum: Developers
Topic: Standard Report Syntax Question
Replies: 4
Views: 1182

Re: Standard Report Syntax Question

Thank you. I really appreciate the insight.
by baoluan1
Fri Feb 04, 2022 11:24 am
Forum: Developers
Topic: Standard Report Syntax Question
Replies: 4
Views: 1182

Re: Standard Report Syntax Question

That worked. Thank you. If you happen to know why getting patient payments strictly from the payments table isnt adding up right either I'll take one last asssit. If not no worries. I'll figure these tables out eventually.

Thanks again.
by baoluan1
Fri Feb 04, 2022 8:11 am
Forum: Developers
Topic: Standard Report Syntax Question
Replies: 4
Views: 1182

Standard Report Syntax Question

To Whom it May Concern, I am constructing custom sql reports for our offices and have found my equations dont match those found in the standard monthly (day by day) Production and Income report. Particularly the 'Ins Income' numbers. I was wondering if I might be able to see the whole sql syntax use...
by baoluan1
Fri Jan 21, 2022 10:18 am
Forum: Developers
Topic: ShoryQuery Syntax Question
Replies: 4
Views: 1173

Re: ShoryQuery Syntax Question

Good morning I tried utilizing the test keys with no luck there either. So it’s not a clinic software version issue. Dev_KEY = "NFF6i0KrXrxDkZHt" Customer_KEY = "VzkmZEaUWOjnQX2z" header = {"Authorization" : "ODFHIR %s/%s" % (Dev_KEY,Customer_KEY)} ShortQuerysite = "https://api.opendental.com/api/v1...
by baoluan1
Thu Jan 20, 2022 8:17 am
Forum: Developers
Topic: ShoryQuery Syntax Question
Replies: 4
Views: 1173

ShoryQuery Syntax Question

I am currently trying to utilize the ShortQuery feature of the API and having issues. My Get requests for other resources work fine so I know authentication isnt the issue. I have had the clinics update to 21.3.39 to ensure its not an outdated version that doesnt allow for ShortQuery usage. My pytho...