Search found 711 matches

by cmcgehee
Thu Mar 16, 2017 8:26 am
Forum: Main Forum
Topic: Auto adjust code when I change # of surfaces
Replies: 7
Views: 10708

Re: Auto adjust code when I change # of surfaces

1) I was able to reproduce this. I will look into this some more, and it will probably end up being fixed as a bug. 2) Our users generally get more frustrated when the program change things automatically behind the scenes than when we ask them if they would like the program to change something for t...
by cmcgehee
Mon Mar 13, 2017 9:01 am
Forum: Developers
Topic: Hook Request - Practice Genius
Replies: 2
Views: 7143

Re: Hook Request - Practice Genius

We will get these added to the program shortly. My only comment is that using line numbers for where you want the hook is not always sufficient. Some of our files change quite frequently so line numbers are always in flux. Including a little snippet of where you want the with a few lines of surround...
by cmcgehee
Mon Mar 13, 2017 8:01 am
Forum: Main Forum
Topic: 'max_allowed_packet' value exceeded
Replies: 7
Views: 15347

Re: 'max_allowed_packet' value exceeded

Based on this error message, you are exceeding the max_allowed_packet value when copying the contents of the Open Dental installation directory into the database. This happens during the update process. There are probably some large images or other files in the C:\Program Files\Open Dental folder on...
by cmcgehee
Thu Mar 09, 2017 9:29 am
Forum: Main Forum
Topic: Clinics and multiple locations
Replies: 9
Views: 10810

Re: Clinics and multiple locations

The treatment plan module is painfully slow though. simple stuff like assigning a priority to a procedure can take upwards of 10 seconds when it should be instantaneous. We would be happy to help troubleshoot this issue. You could enable the slow query log for a few days and then send it to us. Thi...
by cmcgehee
Thu Mar 09, 2017 8:18 am
Forum: Main Forum
Topic: Clinics and multiple locations
Replies: 9
Views: 10810

Re: Clinics and multiple locations

To echo Irfan, we generally don't recommend merging multiple databases into one. You may end up with duplicate patients, employees, providers, operatories, and fee schedules. Reports may be inaccurate due to work not being assigned to the proper clinic. The program will often be slower because queri...
by cmcgehee
Thu Mar 09, 2017 7:57 am
Forum: Main Forum
Topic: Add space between days on week view
Replies: 3
Views: 6639

Re: Add space between days on week view

We do implement many feature requests. Here is a sample list of feature requests we have completed in the last few months: 916, 1117, 3879, 4951, 1429, 5105, 1516, 2174, 4841, 4842, 4851, 1774, 2246, 4705, 4658, 4896, 1867, 3408, 2573.
by cmcgehee
Wed Mar 08, 2017 12:06 pm
Forum: Developers
Topic: Hook request
Replies: 3
Views: 8257

Re: Hook request

This hook has been added to the head version and back ported to 16.4.25. Enjoy developing your plugin!
by cmcgehee
Wed Mar 08, 2017 11:18 am
Forum: Main Forum
Topic: Add space between days on week view
Replies: 3
Views: 6639

Re: Add space between days on week view

There is a feature request to add bold lines between days: Request 4754. Adding some of your votes to this feature can help move it along.
http://www.opendental.com/manual/featurerequests.html
by cmcgehee
Wed Mar 08, 2017 8:02 am
Forum: Developers
Topic: Hook request
Replies: 3
Views: 8257

Re: Hook request

We sure can, Tim. Is this how you want the hook written? If you need any extra parameters, we can pass them in.

Code: Select all

if(Plugins.HookMethod(this,"FormOpenDental.menuItemLaboratories_Click")) {
	return;
}
by cmcgehee
Tue Mar 07, 2017 6:13 pm
Forum: Developers
Topic: Forms colors and icons
Replies: 5
Views: 13187

Re: Forms colors and icons

Hello Amir, Allen's gone for the night, but I can answer that question. The icons for each of the modules are stored in FormOpenDental.cs in a property named imageList32 which is a System.Windows.Forms.ImageList. You can find this list in the Design tab of FormOpenDental. This is where you can add y...
by cmcgehee
Tue Mar 07, 2017 3:10 pm
Forum: Main Forum
Topic: How to have a red "X" over missing teeth?
Replies: 1
Views: 3802

Re: How to have a red "X" over missing teeth?

This happens when you have Simple Tooth chart as your graphics mode. If you switch to DirectX or OpenGL, the whole tooth will disappear when you mark it as missing.
http://www.opendental.com/manual/graphics.html.
by cmcgehee
Tue Mar 07, 2017 3:05 pm
Forum: Main Forum
Topic: How to make chart view fullscreen?
Replies: 4
Views: 8266

Re: How to make chart view fullscreen?

There are a couple existing feature requests to have the ability to resize items in the chart module. These are 3385 and 4210. You can add some of your feature request votes to these ones.
by cmcgehee
Mon Mar 06, 2017 10:35 am
Forum: Advanced Topics
Topic: Avg Insurance Payment
Replies: 4
Views: 8671

Re: Avg Insurance Payment

Here is the query showing one row per procedure code: SET @FromDate='2016-01-01' , @ToDate='2017-01-13'; SELECT definition.ItemName, procedurecode.ProcCode, procedurecode.Descript, COUNT(DISTINCT procedurelog.ProcNum) AS TotProcs, AVG( claim.InsPayAmt) AS `$AvgInsPayAmt`, SUM(claim.InsPayAmt) AS `$T...
by cmcgehee
Mon Mar 06, 2017 8:01 am
Forum: Advanced Topics
Topic: Avg Insurance Payment
Replies: 4
Views: 8671

Re: Avg Insurance Payment

I made one change: COUNT(*) to COUNT(DISTINCT procedurelog.ProcNum). That way you will get the count of the procedures completed. My next question is if you want to see one row for each procedure code or if you want one row for the entire practice. SET @FromDate='2016-01-01' , @ToDate='2017-01-13'; ...
by cmcgehee
Thu Feb 23, 2017 6:55 pm
Forum: Main Forum
Topic: Color change for procedures in chart
Replies: 8
Views: 19280

Re: Color change for procedures in chart

Ah, I see what you're asking now. The PFM Seat by default has a Paint Type of None. If you want it to show up on the graphical tooth chart, you can change the Paint Type to another type by going to Lists -> Procedure Codes -> PFM Seat and selecting your desired Paint Type. http://opendental.com/manu...
by cmcgehee
Thu Feb 23, 2017 5:23 pm
Forum: Main Forum
Topic: Color change for procedures in chart
Replies: 8
Views: 19280

Re: Color change for procedures in chart

To change the color of treatments on the tooth chart, go to Setup -> Definitions -> Chart Graphic Colors. You can then choose your favorite colors for TP'ed procedures, existing other procedures, completed procedures, etc. Also, I cannot see the image that is in your comment. Maybe you need to set t...
by cmcgehee
Mon Feb 20, 2017 10:02 am
Forum: Main Forum
Topic: Payment Type Totals by Date Range Query Help
Replies: 5
Views: 10151

Re: Payment Type Totals by Date Range Query Help

jclaydds wrote:would you suggest I call in and discuss it with support?
I would recommend that. It will be easier to troubleshoot when we can compare internal reports and run other queries to nail down the discrepancies.
by cmcgehee
Mon Feb 20, 2017 9:02 am
Forum: Main Forum
Topic: Payment Type Totals by Date Range Query Help
Replies: 5
Views: 10151

Re: Payment Type Totals by Date Range Query Help

In what way are you adding adjustments to collections? Open Dental doesn't have an official way to make adjustments to collections. The Adjustment objects only affect production. Adjustments to collections could be made by using a negative patient payment, for example. This query was set up for a sp...
by cmcgehee
Mon Feb 20, 2017 8:50 am
Forum: Developers
Topic: Error compiling 16.2.53
Replies: 6
Views: 15196

Re: Error compiling 16.2.53

We don't store a compiled version of the program in our public repository. You can download the trial version which is fully compiled and contains the database: http://opendental.com/TrialDownload-15-4-35.exe . It, however, is not the latest and greatest. It contains version 15.4 while our latest st...
by cmcgehee
Wed Feb 15, 2017 10:05 am
Forum: Main Forum
Topic: Adding a Field in OD
Replies: 4
Views: 7948

Re: Adding a Field in OD

It would be fairly easy to add a count to the Referrals list, but we would still go through the Feature Request process to add it. Alternatively, you could use a query to get the count of the patients from each referral. Here is 501 from our website. /*501 Count of patients from each 'referred from'...
by cmcgehee
Wed Feb 15, 2017 8:06 am
Forum: Advanced Topics
Topic: OD 16.4.22: InsBenBWCodes is an invalid pref name
Replies: 6
Views: 9208

Re: OD 16.4.22: InsBenBWCodes is an invalid pref name

Did you miss running the convert script on your database? That preference was added to the database when upgrading to 16.4.19. I'm curious as to what this query returns on the database you are using:
SELECT ValueString FROM preference WHERE PrefName LIKE 'DatabaseVersion';
by cmcgehee
Mon Feb 13, 2017 9:18 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

I am definitely open to contributions from other developers. I'm working on another project right now, so I might not have time for a while to enhance this plug-in. I will, however, continue to fix bugs if any come up.
by cmcgehee
Tue Feb 07, 2017 2:07 pm
Forum: Main Forum
Topic: Patient portal question
Replies: 2
Views: 5433

Re: Patient portal question

You could create an email template that includes the website and tells the patient they have a payment due and they can pay in the patient portal. http://opendental.com/manual/emailtemplates.html In version 17.1 we have added a feature to send statements directly to the portal which will also send a...
by cmcgehee
Tue Feb 07, 2017 1:50 pm
Forum: Main Forum
Topic: Procedure Colors
Replies: 2
Views: 5953

Re: Procedure Colors

That is currently not possible. It looks like somebody has had the same idea as you and requested it in Feature Request 1366. You can add your votes to it to help move it along.
http://opendental.com/manual/featurerequests.html
by cmcgehee
Tue Feb 07, 2017 11:04 am
Forum: Main Forum
Topic: Fix query 403
Replies: 5
Views: 12500

Re: Fix query 403

The term 'discount' can mean two different things in Open Dental. There is a discount field that can be entered on a treatment plan procedure. When the procedure is set complete, an adjustment is created for the same amount as the discount. A discount can also mean 'writeoff', as in a PPO discount. ...
by cmcgehee
Mon Feb 06, 2017 5:42 pm
Forum: Main Forum
Topic: switching one provider over to another "clinic"
Replies: 2
Views: 6042

Re: switching one provider over to another "clinic"

I would recommend against artificially assigning patients to different clinics. For some of our paid services, like Integrated Texting, we bill based on the number of locations, and we determine the number of locations based on the number of active clinics in the database. If you are a single locati...
by cmcgehee
Mon Feb 06, 2017 8:51 am
Forum: Main Forum
Topic: OD startup slow down?
Replies: 7
Views: 16355

Re: OD startup slow down?

If this slowness is happening before the Choose Database prompt appears, it could be because Open Dental is trying to connect to the database saved in the config file and is unable to. The connection attempt times out at 30 seconds. In the Choose Database window, try unchecking "Do not show this win...
by cmcgehee
Mon Feb 06, 2017 8:39 am
Forum: Main Forum
Topic: Open Dental on your cellphone
Replies: 2
Views: 6030

Re: Open Dental on your cellphone

Currently there is not a way to view chart notes on the Mobile Web version of Open Dental. Pretty much your only option for that is to log in a computer that has Open Dental from your phone using something like TeamViewer. This is far from ideal, but it might be helpful in a pinch.
by cmcgehee
Thu Feb 02, 2017 11:11 am
Forum: Main Forum
Topic: is there a daily report for patients with appointments today
Replies: 1
Views: 4665

Re: is there a daily report for patients with appointments t

Query 1005 sounds like it could be close. It will give a yes or no simply on whether the patient has a an appointment scheduled with recall procedures on it. /*1005 Patients with an appointment today, showing if that appointment has any recall triggers. Also shows years since last pano, months since...
by cmcgehee
Thu Feb 02, 2017 8:14 am
Forum: Main Forum
Topic: Statments - sending under wrong name
Replies: 4
Views: 7299

Re: Statments - sending under wrong name

Currently you can do this by going to the patient's account, clicking the drop down next to the Statements button, selecting More Options, checking the Single Patient Only box, and then creating the statement. There is not a way to use batch billing to send statements to patients who are not guarant...
by cmcgehee
Tue Jan 31, 2017 12:55 pm
Forum: Main Forum
Topic: implant insurance pricing not showing
Replies: 6
Views: 15682

Re: implant insurance pricing not showing

It could be because there is no insurance category setup for implants. Open Dental considers implants to be under the General insurance category. You can add your own Implants category. http://www.opendental.com/manual/inscatssetup.html Then on each insurance plan that cover implants, you would add ...
by cmcgehee
Mon Jan 30, 2017 3:41 pm
Forum: Main Forum
Topic: how to reconcile payments and outstanding
Replies: 4
Views: 6367

Re: how to reconcile payments and outstanding

I made a quick modification to query 771. This query will show procedures that have a fee greater than 0 where the sum of the insurance payments and patient payments is 0. Note that you need to be splitting patient payments to procedures for any query like this to work. /*Modified 771 Daily procedur...
by cmcgehee
Fri Jan 27, 2017 3:12 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

Rickliftig wrote:If you get a chance, could you check the "backspace", "left", "right" commands? They weren't working for me yesterday.
I tried out the left, right, and backspace, and they worked fine for me. Have you trained the speech recognizer with your voice?
by cmcgehee
Tue Jan 24, 2017 5:40 pm
Forum: Main Forum
Topic: Printing Ortho Chart Notes
Replies: 2
Views: 6623

Re: Printing Ortho Chart Notes

This feature is now done. Once 17.1 is out for release, you will be able to upgrade to it and print out the Ortho Chart.
by cmcgehee
Tue Jan 24, 2017 1:26 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

If the installer doesn't work, here's what you can do. 1. Download the VoiceCommand.dll and place it in the Open Dental program files directory on any computer you want to use the plugin. https://github.com/chrismcgehee10/OpenDentalVoice/blob/master/VoiceCommand/bin/Release/VoiceCommand.dll 2. Creat...
by cmcgehee
Mon Jan 23, 2017 7:21 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

You're welcome, Rick. I did end up going out later Saturday night. Question: How important would it be to be able to mark a tooth as not skipped?
by cmcgehee
Sat Jan 21, 2017 5:56 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

Rickliftig wrote:Chris - I keep getting errors with "skip current tooth':
This should be fixed as of version 1.1.1. It turns out I was trying to call a method in Open Dental that was different in 16.3 than it was in 16.4.
by cmcgehee
Sat Jan 21, 2017 4:23 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

Did pretty much as your instructions but no mic button on the left. What do you think? In the Open Dental installation directory is there a file named VoiceCommand.dll? In the Program Links, is there a program link that is enabled that has a plugin dll name of VoiceCommand.dll? Are you on Open Dent...
by cmcgehee
Tue Jan 17, 2017 9:06 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

I have made a new release that includes the ability to mark teeth as skipped.
https://github.com/chrismcgehee10/OpenD ... /releases/
by cmcgehee
Tue Jan 17, 2017 9:42 am
Forum: Main Forum
Topic: find appointments assigned to a operatory
Replies: 3
Views: 6829

Re: find appointments assigned to a operatory

Glad to be of help!
by cmcgehee
Tue Jan 17, 2017 8:04 am
Forum: Main Forum
Topic: find appointments assigned to a operatory
Replies: 3
Views: 6829

Re: find appointments assigned to a operatory

Query 848 will work for that. Just set the operatory name and VISIBLE up top. /*848 Scheduled appointments in specific operatory.*/ /*Query code written/modified: 01/17/2017*/ SET @OperatoryName='%%';/*To search for all Operatories, set OperatoryName='%%'*/ SET @OperatoryVisibility='HIDDEN';/*Accept...
by cmcgehee
Sun Jan 15, 2017 3:05 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

Rick, Thank you very much for the feedback. It is good to know that the L on the perio chart means lingual not labial. I will definitely get that changed. I'm still working on learning how to talk like a dentist. :D I will also work on adding a skip teeth functionality. Most likely I will change the...
by cmcgehee
Tue Jan 10, 2017 1:06 pm
Forum: Main Forum
Topic: Payment on Production reports?
Replies: 1
Views: 4133

Re: Payment on Production reports?

It sounds like query 771 might fit your needs. /*771 Daily procedures report with amount paid to date for each procedure by treating provider. As of 7.2 only works if you split patient payments to procedures. Also shows total amount patient paid in date range. For all providers, leave variable like:...
by cmcgehee
Tue Jan 10, 2017 8:39 am
Forum: Main Forum
Topic: $$ in Daily Payments report doesn't match account
Replies: 1
Views: 3953

Re: $$ in Daily Payments report doesn't match account

It sounds like you have insurance payments grouped by check. This report will show the amount for the entire insurance check, and just choose one of the patients to display in the patient name column. There is the option to group by patient instead of check. See http://opendental.com/manual/reportda...
by cmcgehee
Tue Jan 10, 2017 8:30 am
Forum: Main Forum
Topic: Automatically associate a code
Replies: 4
Views: 8193

Re: Automatically associate a code

Open Dental does not have that sort of functionality. Something you could do is set up automation so that a popup comes up reminding you to add D6057 when D6062 is scheduled on an appointment. http://opendental.com/manual/automation.html There are existing feature requests to add an automation trigg...
by cmcgehee
Mon Jan 09, 2017 8:43 am
Forum: Main Forum
Topic: Printing Ortho Chart Notes
Replies: 2
Views: 6623

Re: Printing Ortho Chart Notes

We are currently working on that feature and are almost done (Feature Request 3200). It will most likely be available in 17.1. In the meantime, you can use query 1115 or 1116.
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
by cmcgehee
Wed Jan 04, 2017 7:04 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

The plug in relies on Windows Speech Recognition. Try going through the setup of that app on the workstations that are having problems. You can do that by typing "windows speech recognition" in Windows search.
by cmcgehee
Mon Jan 02, 2017 12:12 pm
Forum: Developers
Topic: Plugin not loading (16.4 beta)
Replies: 7
Views: 13838

Re: Plugin not loading (16.4 beta)

In regards to the Perio Chart Voice plugin, there should be a folder in the Open Dental installation directory (or in the Debug or Release folder if you're running compiled) that is named "VoiceCommandPlugin". If you could email me the contents of error log file, I can take a look. chris@opendental....
by cmcgehee
Wed Dec 28, 2016 10:58 am
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Re: Perio Chart Voice Plugin

You are very welcome. It was fun to program. If you have any issues with the plugin, you can email me at chris.a.mcgehee@gmail.com.
by cmcgehee
Sat Dec 24, 2016 2:20 pm
Forum: Main Forum
Topic: Perio Chart Voice Plugin
Replies: 46
Views: 124910

Perio Chart Voice Plugin

I have created a plugin that controls the Perio Chart within Open Dental by voice. It is completely free (and open source). Here are some things that you can accomplish with this plugin: Create new perio chart Enter measurements for probing, muco gingival junction, mobility, furcation, gingival marg...
by cmcgehee
Wed Dec 21, 2016 11:26 am
Forum: Main Forum
Topic: dropbox feature
Replies: 9
Views: 14528

Re: dropbox feature

In my casual usage of Dropbox within Open Dental, it took about 1.5 seconds from the time that I double clicked an image in the Images module and the time it took for the image to open. Your response time may be faster or slower.
by cmcgehee
Mon Dec 19, 2016 10:38 am
Forum: Main Forum
Topic: dropbox feature
Replies: 9
Views: 14528

Re: dropbox feature

How would we move our existing local AtoZ folder to dropbox? Is it as simple as installing a client then moving the contents of our local AtoZ folder into the folder that the dropbox client creates? Yep, you just need to move the root AtoZ folder and maintain the current directory hierarchy and the...
by cmcgehee
Wed Dec 07, 2016 8:06 am
Forum: Main Forum
Topic: Scan EOB when No insurance payment is made
Replies: 12
Views: 22164

Re: Scan EOB when No insurance payment is made

Request 2605 is to allow attaching an EOB where a claim payment exists but the sum of the payments is zero. Request 2883 is to attach an EOB to a claim when there is not insurance payment at all.
by cmcgehee
Wed Nov 30, 2016 8:22 am
Forum: Main Forum
Topic: unsure how to fix this error message
Replies: 7
Views: 13440

Re: unsure how to fix this error message

That is the correct place to be running a query. If the FLUSH HOSTS command did not work try increasing the maximum number of connection errors using this command: SET GLOBAL max_connect_errors=1000; Note that this will only be in effect until you restart your MySQL service. To make this setting per...
by cmcgehee
Tue Nov 29, 2016 8:13 am
Forum: Main Forum
Topic: According
Replies: 1
Views: 3958

Re: According

My understanding is that you set up the Credit Card payment type as an Automatic Payment Entry in the accounting setup. Since your credit card payments are automatically debiting an asset account, then a deposit does not need to be made to get your accounts right. To make credit card payments not ap...
by cmcgehee
Wed Nov 23, 2016 1:48 pm
Forum: Main Forum
Topic: Query #1121 vs #1097
Replies: 4
Views: 7966

Re: Query #1121 vs #1097

That sounds like your numbers match. Technically it is still possible for them not to match after you remove patients with $0 production. If a patient's only completed procedures have procedure fees of $0, they would appear on #1121 but then get filtered out of #1097.
by cmcgehee
Wed Nov 23, 2016 12:29 pm
Forum: Main Forum
Topic: Query #1121 vs #1097
Replies: 4
Views: 7966

Re: Query #1121 vs #1097

Both queries are equally accurate; they are just measuring different things. #1121 will count a patient only if they had a completed procedure in the date range. #1097 will display a patient if their zip code is in the list supplied regardless of if they have any completed procedures.
by cmcgehee
Wed Nov 23, 2016 10:43 am
Forum: Main Forum
Topic: improving referral accuracy
Replies: 9
Views: 19610

Re: improving referral accuracy

Here are some of our manual pages that cover referrals. http://www.opendental.com/manual/referrals.html http://www.opendental.com/manual/referralsetup.html http://www.opendental.com/manual/referralslips.html http://www.opendental.com/manual/reportreferralanalysis.html It sounds like you want a way t...
by cmcgehee
Tue Nov 22, 2016 11:06 am
Forum: Main Forum
Topic: Report: Incomplete Procedure Notes
Replies: 2
Views: 5554

Re: Report: Incomplete Procedure Notes

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.
by cmcgehee
Tue Nov 22, 2016 8:39 am
Forum: Main Forum
Topic: Copying/Pasting Provider Schedule
Replies: 3
Views: 7568

Re: Copying/Pasting Provider Schedule

Recently we've been having a lot of calls where people copy pasted the schedule and nothing happened. Usually it was because there were no providers selected. In early versions of 16.3 (and maybe 16.2 also), the Schedules window loaded with no providers or employees selected, so clicking copy paste ...
by cmcgehee
Tue Nov 22, 2016 8:28 am
Forum: Main Forum
Topic: Letter merge function 16.3.XX
Replies: 7
Views: 13156

Re: Letter merge function 16.3.XX

So if you have multiple clinics and you do a mail merge how does the correct address get plugged in for each clinic? It would be useful to have clinic info for a letter merge. Currently you have to create a different template for each clinic. And why not make every possible field available? The rea...
by cmcgehee
Mon Nov 21, 2016 4:19 pm
Forum: Main Forum
Topic: Letter merge function 16.3.XX
Replies: 7
Views: 13156

Re: Letter merge function 16.3.XX

The practice information is something that rarely ever changes, so it could be put into the letter merge template. There is no field 'Patient Name' but there are fields for the patient's LName, FName, MiddleI, and Preferred which can be used to construct the patient's name.
by cmcgehee
Mon Nov 21, 2016 8:19 am
Forum: Main Forum
Topic: Letter merge function 16.3.XX
Replies: 7
Views: 13156

Re: Letter merge function 16.3.XX

It is still being supported. I added a new field to letter merge just the other day. Could you email me the data file, the template, and the letter to chris@opendental.com?
by cmcgehee
Thu Nov 10, 2016 3:44 pm
Forum: Advanced Topics
Topic: Signal OD to refresh
Replies: 6
Views: 13822

Re: Signal OD to refresh

You are pursuing the proper line of attack. That is the correct way to send a refresh signal. I copied your same query and used it to insert a row into the signalod table, and it caused the Open Dental instance that I had open to refresh. Do you have a high value or a blank value for your process si...
by cmcgehee
Thu Nov 10, 2016 11:27 am
Forum: Advanced Topics
Topic: Query question, balance?
Replies: 1
Views: 9371

Re: Query question, balance?

The patient's balance is stored in the BalTotal column on the patient's guarantor. You would just need to join on the patient table again to get the guarantor and display the BalTotal column. SET @pos=0, @FromDate='1990-01-01' , @ToDate='2013-01-01'; SELECT pa.ChartNumber, pa.LName, pa.FName, MAX(Pr...
by cmcgehee
Wed Nov 09, 2016 8:11 am
Forum: Main Forum
Topic: query help
Replies: 5
Views: 17472

Re: query help

You can use the built-in Daily Procedures report and group it by procedure code. This will tell you the number of procedures completed for the chosen time frame. If you need a twist on this report, let me know what it is, and I'll see if I can find it on the Query Examples page.
by cmcgehee
Tue Nov 08, 2016 3:04 pm
Forum: Main Forum
Topic: Exporting Reports in PDF file
Replies: 1
Views: 4617

Re: Exporting Reports in PDF file

You can do this by printing and selecting "Print to PDF". Some printer drivers do not have this option, so we recommend installing CutePDF Writer which you can then select as your printer.
http://www.cutepdf.com/
by cmcgehee
Wed Oct 26, 2016 8:28 am
Forum: Main Forum
Topic: Editing Appointment Types
Replies: 8
Views: 14174

Re: Editing Appointment Types

On the contrary to this feature being obsolete, it is actually in beta. In version 16.3 we enhanced appointment types to include procedures and provider time patterns. You may update to 16.3 at this time if you desire this feature, but it will be buggier than the stable version 16.2.
by cmcgehee
Tue Oct 25, 2016 8:29 am
Forum: Main Forum
Topic: Audit report
Replies: 1
Views: 4454

Re: Audit report

This sounds like it could be what you need. Query 1039 from our examples page: /*1039 Current balance for families with a credit amount, billing type, last visit date, and next visit date*/ /*Last visit and Next visit are based off any member of the family*/ /*Query code written/modified: 03/11/2015...
by cmcgehee
Mon Oct 24, 2016 11:14 am
Forum: Main Forum
Topic: Integrated patient communication system
Replies: 5
Views: 11129

Re: Integrated patient communication system

I know that Vertical Communications is working on an Open Dental integration that provides similar functionality, but it might not be available for a little while.
http://www.vertical.com/vertical/public.
by cmcgehee
Wed Oct 19, 2016 2:28 pm
Forum: Advanced Topics
Topic: FHIR and Dropbox as an AtoZ folder
Replies: 1
Views: 4720

Re: FHIR and Dropbox as an AtoZ folder

I can answer those questions. We are starting small with FHIR and planning to build onto it as long as there is sufficient interest. The resources which we have implemented are Appointment, Location, Organization, Patient, Practitioner, Schedule, Slot, and Subscription. These resources are read-only...
by cmcgehee
Wed Oct 19, 2016 2:26 pm
Forum: Sharing
Topic: FHIR API Documentation
Replies: 0
Views: 13463

FHIR API Documentation

One of the new features in version 16.3 of Open Dental is a RESTful API that follows the FHIR standard. FHIR is the standard that HL7 came up with to use when transferring healthcare data with a RESTful API. Here is the documentation for those interested.
by cmcgehee
Tue Oct 18, 2016 8:42 am
Forum: Main Forum
Topic: Thank you Open Dental - 5 Stars Review
Replies: 2
Views: 6083

Re: Thank you Open Dental - 5 Stars Review

Thank you very much. We always appreciate hearing that our customers are happy using the software that we have created and the support that we provide.
by cmcgehee
Tue Oct 18, 2016 8:32 am
Forum: Main Forum
Topic: Procedure status to track rejected treatment?
Replies: 1
Views: 5048

Re: Procedure status to track rejected treatment?

There is not a way to create custom procedure statuses. An improvement to saving the a treatment plan and then deleting the procedure is to move the procedure to an inactive treatment plan. If the patient does decide to accept the treatment, you can simply move the procedure to the active treatment ...
by cmcgehee
Thu Oct 13, 2016 9:01 am
Forum: Main Forum
Topic: Appointment Confirmed Not Tracked
Replies: 3
Views: 7000

Re: Appointment Confirmed Not Tracked

You're welcome. Version 16.3 is when we added the tracking of the Confirmation status to the audit trail.
by cmcgehee
Wed Oct 12, 2016 2:34 pm
Forum: Main Forum
Topic: X12 Format from Insurance
Replies: 3
Views: 7905

Re: X12 Format from Insurance

Open Dental can import insurance plan information using the 834 version of the X12 format. http://opendental.com/manual/importinsplans834.html This is a fairly new feature (16.1) so not many people have used it yet. Perhaps other users of this forum can comment on how they obtained 834 files from th...
by cmcgehee
Wed Oct 12, 2016 8:53 am
Forum: Main Forum
Topic: Appointment Confirmed Not Tracked
Replies: 3
Views: 7000

Re: Appointment Confirmed Not Tracked

What version of Open Dental are you on? On 16.3.15, I changed the Confirmed status on an appointment from the appointment module, and it showed up in the audit trail.
by cmcgehee
Thu Oct 06, 2016 2:17 pm
Forum: Main Forum
Topic: Bad Debt
Replies: 6
Views: 12901

Re: Bad Debt

We could write a custom query that excludes patients who have not had any new charges in the last 6 months. I looked through our query examples page and didn't see anything that did what you are looking for. You can fill out a custom query request on our website: http://opendentalsoft.com:1942/ODQue...
by cmcgehee
Wed Sep 28, 2016 2:32 pm
Forum: Developers
Topic: Error compiling 16.2.53
Replies: 6
Views: 15196

Re: Error compiling 16.2.53

You also have the option to download a NuGet package so that you can use the most up-to-date C# compiler.
https://www.nuget.org/packages/Microsoft.Net.Compilers/
http://stackoverflow.com/questions/2863 ... tudio-2012
by cmcgehee
Mon Sep 26, 2016 3:21 pm
Forum: Main Forum
Topic: Query help add 'AbbrDesc' abbreviated description
Replies: 1
Views: 4290

Re: Query help add 'AbbrDesc' abbreviated description

This ought to do the trick. /*# 1022 Query code written/modified: 09/26/2016*/ SET @FromDate='2016-09-01', @ToDate='2016-09-30'; SELECT A.Provider,A.ProcCode,A.AbbrDesc, COUNT(A.ProcCode) AS 'Quantity', SUM(A.ProcFee) AS $ProcFee_, SUM(A.WriteOffs) AS $WriteOffs_, SUM(A.Adjustments) AS $Adjustments_...
by cmcgehee
Mon Sep 19, 2016 11:07 am
Forum: Advanced Topics
Topic: Query request
Replies: 1
Views: 4849

Re: Query request

This one will work if you only want to consider primary insurance carriers. Let me know if there are any minor modifications I can perform for you. /* Modified 247 List of patients with appointments for a date range (in future or past) with primary insurance carrier listed Also lists sum of fees for...
by cmcgehee
Thu Sep 15, 2016 5:56 pm
Forum: Main Forum
Topic: Deposit correlation & Reports?
Replies: 1
Views: 3812

Re: Deposit correlation & Reports?

It sounds to me like you want a report like our internal Daily Payments report but that shows one row per check. I modified a query from our existing queries page http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx . /*Modified 687 Daily Payments Report, broken down like built in report*/ SET ...
by cmcgehee
Wed Sep 07, 2016 9:39 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14158

Re: Time card reports specifics

Just the other day I wrote a query that will display the hours worked each week for every employee. Enjoy! /*Weekly hours worked for all Employees. First day of the week is Sunday.*/ /*Query code written/modified: 08/02/2016*/ SET @FromDate='2016-01-01' , @ToDate='2016-07-31'; SELECT CONCAT(e.LName,...
by cmcgehee
Wed Aug 31, 2016 9:39 am
Forum: Main Forum
Topic: Hide or change (NoBillIns) on statement or account?
Replies: 4
Views: 8270

Re: Hide or change (NoBillIns) on statement or account?

Currently there is not a way to remove "(NoBillIns)" from statements. You are welcome to submit a feature request to create a preference to include it.
http://opendental.com/manual/featurerequests.html
by cmcgehee
Mon Aug 15, 2016 8:09 am
Forum: Main Forum
Topic: setting provider time for hygiene
Replies: 2
Views: 6053

Re: setting provider time for hygiene

If you are trying to set the schedule for when hygienists are scheduled to work, you can do this from: http://opendental.com/manual/scheduleadd.html . If you are looking to set the time allotted to a hygiene procedure for a specific provider, you can find how to this toward the bottom of this page: ...
by cmcgehee
Thu Jul 14, 2016 6:03 pm
Forum: Main Forum
Topic: 16.2 -Bad debt -Adjustment Categorization Query
Replies: 3
Views: 7441

Re: 16.2 -Bad debt -Adjustment Categorization Query

To determine which adjustment types are considered Bad Debt, you would look in the preference table. There will be a row that has a PrefName of BadDebtAdjustmentTypes . The ValueString for that row will be a comma-delimited list of numbers. Each of those values will be a pointer to the DefNum on the...
by cmcgehee
Mon Jun 13, 2016 11:25 am
Forum: Advanced Topics
Topic: Error loading Module Preferences after upgrade to 16.1.27
Replies: 6
Views: 11884

Re: Error loading Module Preferences after upgrade to 16.1.2

This error can occur if a preference is missing from your database. This may have happened if the convert script did not execute properly. To find out what the error is exactly, we will need a copy of your database. When you have some time, please call Open Dental support so that we can troubleshoot...
by cmcgehee
Tue May 31, 2016 8:39 am
Forum: Advanced Topics
Topic: No longer able to update databases with the trial version
Replies: 4
Views: 9494

Re: No longer able to update databases with the trial versio

The tempdash tables are created when running Dashboard Reports. Open Dental will usually delete them as soon it is done with the dashboard queries, but if Open Dental closed down in the middle of running the report, then the tempdash table wouldn't get deleted. Having extra tempdash tables lying aro...
by cmcgehee
Wed Apr 20, 2016 8:11 am
Forum: Main Forum
Topic: How to move procedure code to a different category
Replies: 5
Views: 8496

Re: How to move procedure code to a different category

Descriptions for ADA codes are not editable. They need to stay the same for when they are sent off to the insurance companies. You can change the Layman's Term to 'Retainer' and then most places in the program would display your new name.
by cmcgehee
Wed Mar 09, 2016 8:37 am
Forum: Main Forum
Topic: How to track cancellation of the Hygiene appointments ?
Replies: 5
Views: 7514

Re: How to track cancellation of the Hygiene appointments ?

Yes, you could create a 'Patient Note' on the schedule, and in that note you could enter all notes for the day. You could either put the note early or late in the day when you won't have appointments, or you could create a 'Note' operatory in which to put the note.
by cmcgehee
Tue Mar 08, 2016 3:10 pm
Forum: Main Forum
Topic: How to track cancellation of the Hygiene appointments ?
Replies: 5
Views: 7514

Re: How to track cancellation of the Hygiene appointments ?

You could find those appointments in the audit trail. If you limit the date to yesterday and today and select the AppointmentMove permission, you can see the patients who had an appointment that got moved. After that you can select the AppointmentEdit permission to find the appointments that were de...
by cmcgehee
Tue Feb 16, 2016 11:48 am
Forum: Main Forum
Topic: Undelete a deleted note?
Replies: 2
Views: 5124

Re: Undelete a deleted note?

An alternate workaround is to use a query to get the note from the database. Then you would be able to copy the deleted note and paste it into the procedure notes. A query like this should work: /*All proc notes for a patient on a given day.*/ /*Query code written/modified: 02/16/2016*/ SET @PatNum=...
by cmcgehee
Fri Jan 29, 2016 9:01 am
Forum: Main Forum
Topic: Treatment plan priority not changing sort order anymore.
Replies: 9
Views: 13817

Re: Treatment plan priority not changing sort order anymore.

mikebarrdds wrote: Where is the user request page? I forget. Thanks!
You can access the feature requests from within Open Dental by going to Help | Request Features. On that screen you can search by the request number of by the description.
by cmcgehee
Thu Jan 28, 2016 6:00 pm
Forum: Main Forum
Topic: Treatment plan priority not changing sort order anymore.
Replies: 9
Views: 13817

Re: Treatment plan priority not changing sort order anymore.

Arna, the functionality to resort saved treatment plans was not added in 15.4 from what I can tell. Mike, there currently is a feature request (2969) that has votes on it to reorder procedures within saved treatment plans. If you add some votes to it, it becomes more likely that we will implement it.
by cmcgehee
Wed Jan 27, 2016 4:19 pm
Forum: Main Forum
Topic: Treatment plan priority not changing sort order anymore.
Replies: 9
Views: 13817

Re: Treatment plan priority not changing sort order anymore.

Mike, when you add a priority to procedures in the default treatment plan, it will resort the procedures to match the priority. However, if you assign priorities to procedures in a saved treatment plan, the procedures will not be resorted. This is the case even in the beta. On your previous version ...
by cmcgehee
Tue Jan 26, 2016 9:41 am
Forum: Main Forum
Topic: Messaging
Replies: 4
Views: 7703

Re: Messaging

If you are looking for feedback from other OD users, you might want to post this on our Main Forum. The people who usually browse this forum are the programming, IT type. We programmers would be happy to answer any technical questions you have about messaging!
by cmcgehee
Wed Jan 13, 2016 4:20 pm
Forum: Main Forum
Topic: Time Cards or Payroll Reports Printing
Replies: 3
Views: 7021

Re: Time Cards or Payroll Reports Printing

For the Print Grid report under Payroll Reports, we changed the heading text to display the dates for the pay period and the paycheck date. This fix will be released in 15.3.41 and 15.4.19.
by cmcgehee
Mon Jan 11, 2016 3:09 pm
Forum: Main Forum
Topic: Time Cards or Payroll Reports Printing
Replies: 3
Views: 7021

Re: Time Cards or Payroll Reports Printing

1) There is not a way to print Time Cards on one sheet of paper. Depending on what you're using this for, you may be able to find something on our Query Examples page that can show all Time Cards on one page: http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx 2) I will look into changing the ...
by cmcgehee
Fri Jan 08, 2016 12:52 pm
Forum: Main Forum
Topic: Planned Appointments in Version 15.4
Replies: 3
Views: 6446

Re: Planned Appointments in Version 15.4

We implemented some improvements to planned appointments that will available in the 15.4.19. In the window "Appointments for Patient", planned appointments that are attached to completed appointments will no longer show up in the list by default. There is a checkbox now to show completed appointment...
by cmcgehee
Tue Dec 22, 2015 4:27 pm
Forum: Main Forum
Topic: Treatment Plan Module
Replies: 2
Views: 5519

Re: Treatment Plan Module

We implemented a fix so that if a procedure code does not have a Layman's Term, it will use the code's description. This fix will be released in 15.4.11. Thank you for bringing this to our attention!
by cmcgehee
Tue Dec 22, 2015 2:24 pm
Forum: Main Forum
Topic: Treatment Plan Module
Replies: 2
Views: 5519

Re: Treatment Plan Module

The Description column in the new Treatment Plan window, uses the Layman's Term for the procedure code. If a procedure code does not have a description entered for the Layman's Term, then this window will leave the description blank.
by cmcgehee
Tue Dec 22, 2015 2:16 pm
Forum: Main Forum
Topic: 2 questions
Replies: 4
Views: 8319

Re: 2 questions

Dr. Bonilla, we have fixed the Treatment Plans to print the patient's name on the line after the practice phone number. Also, for Active and Inactive Treatment Plans, the heading will display today's date instead of 01/01/0001. This fix will be released in 15.4.11. Thank you for letting us know abou...
by cmcgehee
Thu Dec 17, 2015 3:56 pm
Forum: Main Forum
Topic: Collections Reporting
Replies: 1
Views: 4677

Re: Collections Reporting

It is difficult to get a meaningful collections percentage figure because the period that the collections occurs is different than the period that the production occurs. A number that is more helpful is the Collections Ratio. On our website in the last section of this page, http://www.opendental.com...
by cmcgehee
Thu Dec 17, 2015 3:37 pm
Forum: Main Forum
Topic: 2 questions
Replies: 4
Views: 8319

Re: 2 questions

Right, the patient name needs to be printed on a new line after the practice phone number. We'll look into getting this issue fixed.
by cmcgehee
Wed Dec 09, 2015 5:41 pm
Forum: Main Forum
Topic: Insurance Aging Report
Replies: 14
Views: 22257

Re: Insurance Aging Report

SET @CarriersToExclude=""*/ The reason why this gave you an error is because you are missing the semicolon at the end of the line and because you have an extra "*/". I realize now that the query that I originally gave you will exclude all carriers if you have SET @CarriersToExclude="";. So I rewrot...
by cmcgehee
Mon Dec 07, 2015 1:07 pm
Forum: Main Forum
Topic: Group notes in Version 15.4
Replies: 9
Views: 13664

Re: Group notes in Version 15.4

Could you explain to me how you are setting the background color by provider for procedure notes on the progress notes grid? In Definitions | Prog Notes Colors, there are options to set the background color for appointment objects but not procedure notes. I see the utility in marking procedures as s...
by cmcgehee
Fri Dec 04, 2015 11:38 am
Forum: Main Forum
Topic: Insurance Aging Report
Replies: 14
Views: 22257

Re: Insurance Aging Report

This report shows outstanding claims from PPO insurances where you can excluded specific carriers. Let us know if this works for you. /*Modified 1071 List of outstanding PPO claims excluding specific carriers*/ /*Query code written/modified: 12/04/2015*/ SET @CarriersToExclude="Alliance Medical|Moda...
by cmcgehee
Mon Nov 30, 2015 10:46 am
Forum: Main Forum
Topic: Group notes in Version 15.4
Replies: 9
Views: 13664

Re: Group notes in Version 15.4

It's always good to hear that our users like our newest version. Concerning the color of the group notes, you can set that by going to Setup | Definitions | Prog Notes Colors | Status Existing Current Prov and changing the color there. The reason why procedures that have signed group notes do not sh...
by cmcgehee
Mon Nov 16, 2015 2:28 pm
Forum: Main Forum
Topic: scroll bug?
Replies: 4
Views: 8208

Re: scroll bug?

I see that when my cursor is the Last Name field, the scroll does not work. If I move my cursor over to the grid with the patients' names, then the scroll works. The reason that this works like this is because a control only scrolls if it is has focus on it; this applies to software in general, not ...
by cmcgehee
Wed Nov 04, 2015 2:25 pm
Forum: Main Forum
Topic: Irritating Behavior - Default Note
Replies: 6
Views: 10005

Re: Irritating Behavior - Default Note

The current behavior when the Procedure Info window opens is to to put the cursor at the end of the notes text box if the Date Entry of procedure is today. The cursor is put at the end of the notes if the Date Entry is not today. If you open a procedure that was created or set complete today, does t...