Search found 711 matches
- Thu Mar 16, 2017 8:26 am
- Forum: Main Forum
- Topic: Auto adjust code when I change # of surfaces
- Replies: 7
- Views: 10808
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...
- Mon Mar 13, 2017 9:01 am
- Forum: Developers
- Topic: Hook Request - Practice Genius
- Replies: 2
- Views: 7366
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...
- Mon Mar 13, 2017 8:01 am
- Forum: Main Forum
- Topic: 'max_allowed_packet' value exceeded
- Replies: 7
- Views: 15472
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...
- Thu Mar 09, 2017 9:29 am
- Forum: Main Forum
- Topic: Clinics and multiple locations
- Replies: 9
- Views: 10889
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...
- Thu Mar 09, 2017 8:18 am
- Forum: Main Forum
- Topic: Clinics and multiple locations
- Replies: 9
- Views: 10889
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...
- Thu Mar 09, 2017 7:57 am
- Forum: Main Forum
- Topic: Add space between days on week view
- Replies: 3
- Views: 6682
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.
- Wed Mar 08, 2017 12:06 pm
- Forum: Developers
- Topic: Hook request
- Replies: 3
- Views: 8437
Re: Hook request
This hook has been added to the head version and back ported to 16.4.25. Enjoy developing your plugin!
- Wed Mar 08, 2017 11:18 am
- Forum: Main Forum
- Topic: Add space between days on week view
- Replies: 3
- Views: 6682
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
http://www.opendental.com/manual/featurerequests.html
- Wed Mar 08, 2017 8:02 am
- Forum: Developers
- Topic: Hook request
- Replies: 3
- Views: 8437
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;
}
- Tue Mar 07, 2017 6:13 pm
- Forum: Developers
- Topic: Forms colors and icons
- Replies: 5
- Views: 13388
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...
- Tue Mar 07, 2017 3:10 pm
- Forum: Main Forum
- Topic: How to have a red "X" over missing teeth?
- Replies: 1
- Views: 3831
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.
http://www.opendental.com/manual/graphics.html.
- Tue Mar 07, 2017 3:05 pm
- Forum: Main Forum
- Topic: How to make chart view fullscreen?
- Replies: 4
- Views: 8321
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.
- Mon Mar 06, 2017 10:35 am
- Forum: Advanced Topics
- Topic: Avg Insurance Payment
- Replies: 4
- Views: 8991
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...
- Mon Mar 06, 2017 8:01 am
- Forum: Advanced Topics
- Topic: Avg Insurance Payment
- Replies: 4
- Views: 8991
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'; ...
- Thu Feb 23, 2017 6:55 pm
- Forum: Main Forum
- Topic: Color change for procedures in chart
- Replies: 8
- Views: 19418
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...
- Thu Feb 23, 2017 5:23 pm
- Forum: Main Forum
- Topic: Color change for procedures in chart
- Replies: 8
- Views: 19418
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...
- Mon Feb 20, 2017 10:02 am
- Forum: Main Forum
- Topic: Payment Type Totals by Date Range Query Help
- Replies: 5
- Views: 10257
Re: Payment Type Totals by Date Range Query Help
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.jclaydds wrote:would you suggest I call in and discuss it with support?
- Mon Feb 20, 2017 9:02 am
- Forum: Main Forum
- Topic: Payment Type Totals by Date Range Query Help
- Replies: 5
- Views: 10257
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...
- Mon Feb 20, 2017 8:50 am
- Forum: Developers
- Topic: Error compiling 16.2.53
- Replies: 6
- Views: 15414
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...
- Wed Feb 15, 2017 10:05 am
- Forum: Main Forum
- Topic: Adding a Field in OD
- Replies: 4
- Views: 7995
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'...
- Wed Feb 15, 2017 8:06 am
- Forum: Advanced Topics
- Topic: OD 16.4.22: InsBenBWCodes is an invalid pref name
- Replies: 6
- Views: 9512
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';
SELECT ValueString FROM preference WHERE PrefName LIKE 'DatabaseVersion';
- Mon Feb 13, 2017 9:18 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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.
- Tue Feb 07, 2017 2:07 pm
- Forum: Main Forum
- Topic: Patient portal question
- Replies: 2
- Views: 5490
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...
- Tue Feb 07, 2017 1:50 pm
- Forum: Main Forum
- Topic: Procedure Colors
- Replies: 2
- Views: 5983
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
http://opendental.com/manual/featurerequests.html
- Tue Feb 07, 2017 11:04 am
- Forum: Main Forum
- Topic: Fix query 403
- Replies: 5
- Views: 12564
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. ...
- Mon Feb 06, 2017 5:42 pm
- Forum: Main Forum
- Topic: switching one provider over to another "clinic"
- Replies: 2
- Views: 6069
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...
- Mon Feb 06, 2017 8:51 am
- Forum: Main Forum
- Topic: OD startup slow down?
- Replies: 7
- Views: 16461
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...
- Mon Feb 06, 2017 8:39 am
- Forum: Main Forum
- Topic: Open Dental on your cellphone
- Replies: 2
- Views: 6083
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.
- Thu Feb 02, 2017 11:11 am
- Forum: Main Forum
- Topic: is there a daily report for patients with appointments today
- Replies: 1
- Views: 4693
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...
- Thu Feb 02, 2017 8:14 am
- Forum: Main Forum
- Topic: Statments - sending under wrong name
- Replies: 4
- Views: 7408
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...
- Tue Jan 31, 2017 12:55 pm
- Forum: Main Forum
- Topic: implant insurance pricing not showing
- Replies: 6
- Views: 15757
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 ...
- Mon Jan 30, 2017 3:41 pm
- Forum: Main Forum
- Topic: how to reconcile payments and outstanding
- Replies: 4
- Views: 6487
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...
- Fri Jan 27, 2017 3:12 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
Re: Perio Chart Voice Plugin
I tried out the left, right, and backspace, and they worked fine for me. Have you trained the speech recognizer with your voice?Rickliftig wrote:If you get a chance, could you check the "backspace", "left", "right" commands? They weren't working for me yesterday.
- Tue Jan 24, 2017 5:40 pm
- Forum: Main Forum
- Topic: Printing Ortho Chart Notes
- Replies: 2
- Views: 6666
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.
- Tue Jan 24, 2017 1:26 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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...
- Mon Jan 23, 2017 7:21 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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?
- Sat Jan 21, 2017 5:56 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
Re: Perio Chart Voice Plugin
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.Rickliftig wrote:Chris - I keep getting errors with "skip current tooth':
- Sat Jan 21, 2017 4:23 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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...
- Tue Jan 17, 2017 9:06 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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/
https://github.com/chrismcgehee10/OpenD ... /releases/
- Tue Jan 17, 2017 9:42 am
- Forum: Main Forum
- Topic: find appointments assigned to a operatory
- Replies: 3
- Views: 6855
Re: find appointments assigned to a operatory
Glad to be of help!
- Tue Jan 17, 2017 8:04 am
- Forum: Main Forum
- Topic: find appointments assigned to a operatory
- Replies: 3
- Views: 6855
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...
- Sun Jan 15, 2017 3:05 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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...
- Tue Jan 10, 2017 1:06 pm
- Forum: Main Forum
- Topic: Payment on Production reports?
- Replies: 1
- Views: 4150
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:...
- Tue Jan 10, 2017 8:39 am
- Forum: Main Forum
- Topic: $$ in Daily Payments report doesn't match account
- Replies: 1
- Views: 3976
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...
- Tue Jan 10, 2017 8:30 am
- Forum: Main Forum
- Topic: Automatically associate a code
- Replies: 4
- Views: 8280
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...
- Mon Jan 09, 2017 8:43 am
- Forum: Main Forum
- Topic: Printing Ortho Chart Notes
- Replies: 2
- Views: 6666
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
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
- Wed Jan 04, 2017 7:04 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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.
- Mon Jan 02, 2017 12:12 pm
- Forum: Developers
- Topic: Plugin not loading (16.4 beta)
- Replies: 7
- Views: 14086
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....
- Wed Dec 28, 2016 10:58 am
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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.
- Sat Dec 24, 2016 2:20 pm
- Forum: Main Forum
- Topic: Perio Chart Voice Plugin
- Replies: 46
- Views: 130447
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...
- Wed Dec 21, 2016 11:26 am
- Forum: Main Forum
- Topic: dropbox feature
- Replies: 9
- Views: 14741
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.
- Mon Dec 19, 2016 10:38 am
- Forum: Main Forum
- Topic: dropbox feature
- Replies: 9
- Views: 14741
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...
- Mon Dec 19, 2016 9:40 am
- Forum: Developers
- Topic: Plugin Deployment process
- Replies: 12
- Views: 23953
Re: Plugin Deployment process
See http://opendental.com/manual/plugins.html and http://opendental.com/manual/patternplugins.html for tips and patterns.
- Wed Dec 07, 2016 8:06 am
- Forum: Main Forum
- Topic: Scan EOB when No insurance payment is made
- Replies: 12
- Views: 22854
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.
- Wed Nov 30, 2016 8:22 am
- Forum: Main Forum
- Topic: unsure how to fix this error message
- Replies: 7
- Views: 13560
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...
- Tue Nov 29, 2016 8:13 am
- Forum: Main Forum
- Topic: According
- Replies: 1
- Views: 3978
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...
- Wed Nov 23, 2016 1:48 pm
- Forum: Main Forum
- Topic: Query #1121 vs #1097
- Replies: 4
- Views: 8011
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.
- Wed Nov 23, 2016 12:29 pm
- Forum: Main Forum
- Topic: Query #1121 vs #1097
- Replies: 4
- Views: 8011
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.
- Wed Nov 23, 2016 10:43 am
- Forum: Main Forum
- Topic: improving referral accuracy
- Replies: 9
- Views: 19817
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...
- Tue Nov 22, 2016 11:06 am
- Forum: Main Forum
- Topic: Report: Incomplete Procedure Notes
- Replies: 2
- Views: 5581
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.
- Tue Nov 22, 2016 8:39 am
- Forum: Main Forum
- Topic: Copying/Pasting Provider Schedule
- Replies: 3
- Views: 7641
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 ...
- Tue Nov 22, 2016 8:28 am
- Forum: Main Forum
- Topic: Letter merge function 16.3.XX
- Replies: 7
- Views: 13290
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...
- Mon Nov 21, 2016 4:19 pm
- Forum: Main Forum
- Topic: Letter merge function 16.3.XX
- Replies: 7
- Views: 13290
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.
- Mon Nov 21, 2016 8:19 am
- Forum: Main Forum
- Topic: Letter merge function 16.3.XX
- Replies: 7
- Views: 13290
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?
- Thu Nov 10, 2016 3:44 pm
- Forum: Advanced Topics
- Topic: Signal OD to refresh
- Replies: 6
- Views: 14222
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...
- Thu Nov 10, 2016 11:27 am
- Forum: Advanced Topics
- Topic: Query question, balance?
- Replies: 1
- Views: 9561
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...
- Wed Nov 09, 2016 8:11 am
- Forum: Main Forum
- Topic: query help
- Replies: 5
- Views: 17554
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.
- Tue Nov 08, 2016 3:04 pm
- Forum: Main Forum
- Topic: Exporting Reports in PDF file
- Replies: 1
- Views: 4655
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/
http://www.cutepdf.com/
- Wed Oct 26, 2016 8:28 am
- Forum: Main Forum
- Topic: Editing Appointment Types
- Replies: 8
- Views: 14254
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.
- Tue Oct 25, 2016 8:29 am
- Forum: Main Forum
- Topic: Audit report
- Replies: 1
- Views: 4479
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...
- Mon Oct 24, 2016 11:14 am
- Forum: Main Forum
- Topic: Integrated patient communication system
- Replies: 5
- Views: 11207
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.
http://www.vertical.com/vertical/public.
- Wed Oct 19, 2016 2:28 pm
- Forum: Advanced Topics
- Topic: FHIR and Dropbox as an AtoZ folder
- Replies: 1
- Views: 4932
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...
- Wed Oct 19, 2016 2:26 pm
- Forum: Sharing
- Topic: FHIR API Documentation
- Replies: 0
- Views: 14591
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.
- Tue Oct 18, 2016 8:42 am
- Forum: Main Forum
- Topic: Thank you Open Dental - 5 Stars Review
- Replies: 2
- Views: 6124
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.
- Tue Oct 18, 2016 8:32 am
- Forum: Main Forum
- Topic: Procedure status to track rejected treatment?
- Replies: 1
- Views: 5095
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 ...
- Thu Oct 13, 2016 9:01 am
- Forum: Main Forum
- Topic: Appointment Confirmed Not Tracked
- Replies: 3
- Views: 7083
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.
- Wed Oct 12, 2016 2:34 pm
- Forum: Main Forum
- Topic: X12 Format from Insurance
- Replies: 3
- Views: 7955
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...
- Wed Oct 12, 2016 8:53 am
- Forum: Main Forum
- Topic: Appointment Confirmed Not Tracked
- Replies: 3
- Views: 7083
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.
- Thu Oct 06, 2016 2:17 pm
- Forum: Main Forum
- Topic: Bad Debt
- Replies: 6
- Views: 13010
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...
- Wed Sep 28, 2016 2:32 pm
- Forum: Developers
- Topic: Error compiling 16.2.53
- Replies: 6
- Views: 15414
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
https://www.nuget.org/packages/Microsoft.Net.Compilers/
http://stackoverflow.com/questions/2863 ... tudio-2012
- Mon Sep 26, 2016 3:21 pm
- Forum: Main Forum
- Topic: Query help add 'AbbrDesc' abbreviated description
- Replies: 1
- Views: 4321
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_...
- Mon Sep 19, 2016 11:07 am
- Forum: Advanced Topics
- Topic: Query request
- Replies: 1
- Views: 5014
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...
- Thu Sep 15, 2016 5:56 pm
- Forum: Main Forum
- Topic: Deposit correlation & Reports?
- Replies: 1
- Views: 3831
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 ...
- Wed Sep 07, 2016 9:39 am
- Forum: Main Forum
- Topic: Time card reports specifics
- Replies: 9
- Views: 14489
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,...
- Wed Aug 31, 2016 9:39 am
- Forum: Main Forum
- Topic: Hide or change (NoBillIns) on statement or account?
- Replies: 4
- Views: 8333
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
http://opendental.com/manual/featurerequests.html
- Mon Aug 15, 2016 8:09 am
- Forum: Main Forum
- Topic: setting provider time for hygiene
- Replies: 2
- Views: 6071
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: ...
- Thu Jul 14, 2016 6:03 pm
- Forum: Main Forum
- Topic: 16.2 -Bad debt -Adjustment Categorization Query
- Replies: 3
- Views: 7462
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...
- Mon Jun 13, 2016 11:25 am
- Forum: Advanced Topics
- Topic: Error loading Module Preferences after upgrade to 16.1.27
- Replies: 6
- Views: 12140
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...
- Tue May 31, 2016 8:39 am
- Forum: Advanced Topics
- Topic: No longer able to update databases with the trial version
- Replies: 4
- Views: 9735
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...
- Wed Apr 20, 2016 8:11 am
- Forum: Main Forum
- Topic: How to move procedure code to a different category
- Replies: 5
- Views: 8570
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.
- Wed Mar 09, 2016 8:37 am
- Forum: Main Forum
- Topic: How to track cancellation of the Hygiene appointments ?
- Replies: 5
- Views: 7595
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.
- Tue Mar 08, 2016 3:10 pm
- Forum: Main Forum
- Topic: How to track cancellation of the Hygiene appointments ?
- Replies: 5
- Views: 7595
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...
- Tue Feb 16, 2016 11:48 am
- Forum: Main Forum
- Topic: Undelete a deleted note?
- Replies: 2
- Views: 5180
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=...
- Fri Jan 29, 2016 9:01 am
- Forum: Main Forum
- Topic: Treatment plan priority not changing sort order anymore.
- Replies: 9
- Views: 13900
Re: Treatment plan priority not changing sort order anymore.
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.mikebarrdds wrote: Where is the user request page? I forget. Thanks!
- Thu Jan 28, 2016 6:00 pm
- Forum: Main Forum
- Topic: Treatment plan priority not changing sort order anymore.
- Replies: 9
- Views: 13900
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.
- Wed Jan 27, 2016 4:19 pm
- Forum: Main Forum
- Topic: Treatment plan priority not changing sort order anymore.
- Replies: 9
- Views: 13900
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 ...
- Tue Jan 26, 2016 9:41 am
- Forum: Main Forum
- Topic: Messaging
- Replies: 4
- Views: 7772
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!
- Wed Jan 13, 2016 4:20 pm
- Forum: Main Forum
- Topic: Time Cards or Payroll Reports Printing
- Replies: 3
- Views: 7063
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.
- Mon Jan 11, 2016 3:09 pm
- Forum: Main Forum
- Topic: Time Cards or Payroll Reports Printing
- Replies: 3
- Views: 7063
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 ...
- Fri Jan 08, 2016 12:52 pm
- Forum: Main Forum
- Topic: Planned Appointments in Version 15.4
- Replies: 3
- Views: 6476
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...
- Tue Dec 22, 2015 4:27 pm
- Forum: Main Forum
- Topic: Treatment Plan Module
- Replies: 2
- Views: 5560
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!
- Tue Dec 22, 2015 2:24 pm
- Forum: Main Forum
- Topic: Treatment Plan Module
- Replies: 2
- Views: 5560
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.
- Tue Dec 22, 2015 2:16 pm
- Forum: Main Forum
- Topic: 2 questions
- Replies: 4
- Views: 8363
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...
- Thu Dec 17, 2015 3:56 pm
- Forum: Main Forum
- Topic: Collections Reporting
- Replies: 1
- Views: 4708
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...
- Thu Dec 17, 2015 3:37 pm
- Forum: Main Forum
- Topic: 2 questions
- Replies: 4
- Views: 8363
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.
- Wed Dec 09, 2015 5:41 pm
- Forum: Main Forum
- Topic: Insurance Aging Report
- Replies: 14
- Views: 22454
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...
- Mon Dec 07, 2015 1:07 pm
- Forum: Main Forum
- Topic: Group notes in Version 15.4
- Replies: 9
- Views: 13721
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...
- Fri Dec 04, 2015 11:38 am
- Forum: Main Forum
- Topic: Insurance Aging Report
- Replies: 14
- Views: 22454
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...
- Mon Nov 30, 2015 10:46 am
- Forum: Main Forum
- Topic: Group notes in Version 15.4
- Replies: 9
- Views: 13721
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...
- Mon Nov 16, 2015 2:28 pm
- Forum: Main Forum
- Topic: scroll bug?
- Replies: 4
- Views: 8282
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 ...
- Wed Nov 04, 2015 2:25 pm
- Forum: Main Forum
- Topic: Irritating Behavior - Default Note
- Replies: 6
- Views: 10070
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...