Open Dental Forum

Thanks Jason! It gets set to the patient's primary provider which is set via the Edit Patient Information window. https://www.opendental.com/manual/patientedit.html It would be a feature request to override the patient provider with the provider linked to the user currently logged in (if the user is...

Hello, I did a quick search, but didn't see anything related. I just noticed today that perio exams are indicating "DOC" for the provider instead of the hygienist. (In the "Exams" list in the upper let corner of the perio chart window.) Shouldn't it default to the logged in user (the hygienist)? Am ...

That will work in most cases, but it will only fetch deceased guarantors from patients who are currently an active patient. If the patient is archived or are also deceased, it won't fetch the guarantor. I think the simplest way to fetch deceased guarantors is to find all patient rows whose PatNum=G...

Hello, I couldn't find anything on this, but am looking for a script/SQL to create a list of deceased patients set as account Guarantors. Would be even better if it would place the next oldest family member as Guarantor. :) Looking to identify deceased Guarantors to prevent statements being addresse...

You should update to the most recent v16.3 because it sounds like "When processing a payment, extra paysplits might be created" which was fixed in v16.3.47 http://opendentalsoft.com:1942/ODBugTracker/PreviousVersions.aspx#16.3 I recommend running DBM after updating which might clean it up or descri...

It could be a bug in the version you are at and if you are at an older version, a newer DBM might be able to help you. I instantly think of paysplits to other patients / hidden patient with same name / etc. If you can't track it down feel free to give us a call. Our techs are pretty good at finding...

Hello, I'm not sure how, but I have a patient's credit card payment showing twice (two entries) in Deposits. I added one to the correct day's deposit slip, but the other entry is still haning out there. Patient's Account only shows one entry. I've run the Database Maintenance tool, but it didn't see...

Hi Everyone. Just wanted to see if there is a comprehensive guide on running open dental on linux servers with windows 10 PC's. I've seen a couple threads and some general info but wondering if theres anything that is comprehensive step by step end to end guide. Thanks! Best setup possible - stabil...

Thanks - that got it. Query #958 get most offenders but not all. To also get partial payments that are not finalized, run #971: /*971 List of partial payments that need finalized.*/ /*The results of this query are the partial payments that need finalized for the message box when clicking the Reports...

Hello, I'm encountering an error message when trying to run reports ("Reports" -> "Standard") which states: At least one insurance payment is not finalized. Reports will be inaccurate until all payments are finalized. See query example in the online manual #958, "Claims with payments entered by no c...

There is no need to keep the old setup files. We automatically back them up because many offices call in with update problems and often times want to go back to the last working version because they chose to update during working hours or at lunch time which is not recommended. Feel free to delete ...

All: I apologize if this has been asked before (try searching on "setup" and see how many results you get!), but is there any reason to save old Setup_*.exe files? I've been using Open Dental since 2010, so you can imaging how many updates/upgrades have been done, resulting in many such files (over ...

cmcgehee wrote:It is indeed a new upgrade. We added the ability to run the report for a date range in 16.2. In 16.3 we added the ability to choose provider and clinics and to include procedures with no notes for a day and procedures with unsigned notes.

Excellent! Thanks - I'll upgrade tonight.

Brad

Hi everyone, A quick question - when I run the standard report "Incomplete Procedure Note" I do not get any configuration options (e.g., specify/select clinic, provider, or date range as indicated in the online user manual). Is this a relatively new upgrade to the report? I'm currently running Open ...

jordansparks wrote:No, there is no way to do that yet.

Any progress on this? Just had a patient with retained primary maxillary canines wedged in between #6/7 and #10/11. Would be nice to be able to chart them. My hygienist is pulling her hair out trying to figure out what to do...

The "Assignment of Benefits (pay provider)" option is only stored at the subscriber level. See "Subscriber Information" http://www.opendental.com/manual/insplan.html There are several feature requests asking to have the assignment of benefits option stored at the plan level and at the claim level. ...

I apologize if this is covered elsewhere (I searched both the forums and the User Manual but didn't see anything), but is there a way to set this at the carrier level? I've had a couple of carriers recently change their policies such that out of network providers no longer receive payment directly -...

Hi everyone, I searched, but didn't find anything on this. I'm in the process of switching to Dentrix Plantinum sensors for digital x-ray and am wondering if anyone is running Dentrix with MySQL Server instead of the default Microsoft SQL Server (on Microsoft Windows) on the backend. I'd like to sta...

Never mind - figured it out. Those patients had been set to "Inactive" hence they weren't showing in the list.

Sorry for the confusion.

Brad

I'm in the same process and have utilized the SQL indicated, but on spot checking, it appears to be missing some patients' appointments. (A couple of patients seen in 2014 were not in the produced list.) Any ideas/suggestions? Thanks! /*35 List of families seen in the last three years - Useful for g...

A question about clinics and restrictrions. I've set up a test environment (Open Dental 14.1.18.0 running in Oracle Virtualbox) and have created multiple users assigned and restricted to two separate clinics. When I login as one of the restricted users, I can view the entire schedule (for both clini...

The middle tier service can only be run on a windows OS, but your machine running middle tier does not need to be the same one housing your database. Your database and file server can stay on a linux server with middle tier. Your machine running the middle tier will just need to have a direct conne...

All: I'm looking at adding a second location and wondering about connectivity. It appears (from my limited research) that the Middle Tier solution requires a Windows OS to run - is that correct? I'm currently using a Linux database and file server and would like to stay away from Windows if possible...

Lot of good answers in this forum. As for me, we use Vostro, Optiplex, PowerEdge Servers. These are available on ebay for a reasonable price. Main things about setting up the computers (just enumerating what everyone is telling) run server in VM, so if it fails, we can quickly recover RAID setup fo...

% is a wildcard. There are different ways you can handle wildcards. I think leaving it blank is one option. Also, explicitly using an ip address is another option. But keep in mind that there is a difference between an ip address and a computername. See skip-name-resolve in the mysql manual. As you...

You need to add a user called root@% Hi Jordan. I did this and continue to get the connection error message originally posted. Thanks for pointing that out by the way - I had read that page in the online manual but had not read into it enough to realize that user needed to be created. Interestingly...

You need to add a user called root@% Hi Jordan. I did this and continue to get the connection error message originally posted. Thanks for pointing that out by the way - I had read that page in the online manual but had not read into it enough to realize that user needed to be created. Interestingly...

You need to add a user called root@% Hi Jordan. I did this and continue to get the connection error message originally posted. Thanks for pointing that out by the way - I had read that page in the online manual but had not read into it enough to realize that user needed to be created. easiest thing...

Forgive me if this is covered somewhere - I couldn't find anything with the "search" feature, here or the online manual. I am interested in migrating an existing OpenDental installation from a Windows Server 2008 server to Linux (Ubuntu) and am having trouble with the MySQL portion. I've copied the ...