Search found 14 matches

by serenityfamilydental
Tue Jul 07, 2020 11:29 am
Forum: Main Forum
Topic: import ada 2019 claim forms
Replies: 4
Views: 5709

Re: import ada 2019 claim forms

We are not paying the monthly fee. So I wonder if it is possible for us to get XML file so that we can upload. Thanks, Sean
by serenityfamilydental
Mon Jul 06, 2020 1:41 pm
Forum: Main Forum
Topic: import ada 2019 claim forms
Replies: 4
Views: 5709

import ada 2019 claim forms

Is there any instructions how to import 2019 ada claim forms? Where to get XML file and image file? Thanks
by serenityfamilydental
Mon Jun 15, 2020 9:00 am
Forum: Main Forum
Topic: gmail problem
Replies: 1
Views: 3145

gmail problem

Hi, we just re-open today. found out that we cannot send email via open dental. We setup Gmail in open dental. This morning, we got error message Error message from the email client was: The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response wa...
by serenityfamilydental
Mon Dec 10, 2018 6:48 am
Forum: Developers
Topic: Question about Appointment table
Replies: 2
Views: 4629

Re: Question about Appointment table

Thanks a lot for your reply. Please point me to the syntax of Appointments.Delete(). If I cannot deleted simply, I should be able to mark it Broken just by UPDATE appointmentSET AptStatus = 5 WHERE AptNum=XXX, right? If I want to mark appointment as confirmed or texted, can I simply do UPDATE appoin...
by serenityfamilydental
Thu Dec 06, 2018 11:15 am
Forum: Developers
Topic: Question about Appointment table
Replies: 2
Views: 4629

Question about Appointment table

Hi, if an appointment is changed, e.g. scheduled time changed, AptNum should still be the same, right?
If I need to cancel an appointment, then simply delete the row with AptNum=XXX, right?

I would like expert to confirm. Thanks, Sean
by serenityfamilydental
Tue Nov 13, 2018 2:27 pm
Forum: Developers
Topic: mySQL query problem
Replies: 2
Views: 4274

Re: mySQL query problem

Thanks a lot for your reply. It turns out that I point to the wrong database. I am all set.
by serenityfamilydental
Tue Nov 13, 2018 1:14 pm
Forum: Developers
Topic: mySQL query problem
Replies: 2
Views: 4274

mySQL query problem

Hi, I run a customized query in mySQL workbench to get all appointment for certain day, however I can NOT get all appointments. If I run the same query inside Opendental Custom query, I can get all appointments. I list my query below. Another question, if I run this query in mySQL workbench, appoint...
by serenityfamilydental
Tue Oct 09, 2018 1:05 pm
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 8182

Re: Create template database

The problem is that I don't want to re-configure the blank database. I would like to keep all formatting information of the existing database, but without patient data. Seems like there is no such thing. Thanks anyway.
by serenityfamilydental
Tue Oct 02, 2018 4:13 pm
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 8182

Create template database

Hi, I wonder if there is a way to create a template database to share with other offices. This template database should have all the format/configuration, but without patient data, personal data. This is different than blank database that open dental put it in during installation. Thanks,
by serenityfamilydental
Sat Jan 13, 2018 7:45 pm
Forum: Main Forum
Topic: Old Trial Version
Replies: 1
Views: 4625

Old Trial Version

Hi, My open dental is version 16.4.51. I need to install a server at home. So I download the trial version from opendental.com. But that is version 17.2.43. Apparently it will not work for us.

Where can I download an old version software?

Thanks,
by serenityfamilydental
Sat Apr 18, 2015 2:19 pm
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14627

Re: total collection per provider based on receive date

I think this is a bug. I am pretty sure the software picks up claim send date instead of received date. If it uses received date, then I would not have problem
by serenityfamilydental
Wed Apr 15, 2015 3:30 pm
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14627

Re: total collection per provider based on receive date

Thanks. I know where my problem is now. I use Ins pay fix tool to automatically generate checks. It picks up production date as check date. Is there a setting I can change so that it pickup today as check day?
by serenityfamilydental
Tue Apr 14, 2015 2:04 pm
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14627

Re: total collection per provider based on receive date

Thanks. But e.g. I posted one insurance payment today 4/14/15 $100 for production day 3/25/15 by Dr. A. When I run production/income report for this month. It shows no insurance payment on 4/14/15. If I run payment report on 3/25/15, it shows insurance payment of $100. So how do I change the system,...
by serenityfamilydental
Mon Apr 13, 2015 6:37 pm
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14627

total collection per provider based on receive date

We get an associate. I would like to pay her based on her collection. So how do I get weekly/monthly collection number, cash, credit card, and insurance, based on receive date, not production date? I think this is a very common question. I want to know every week/month how much each provider gets pa...