Search found 122 matches
- Thu Jan 30, 2020 8:20 am
- Forum: Advanced Topics
- Topic: Query - listing of Payment & Payment date with Production & Production dates
- Replies: 1
- Views: 10762
Re: Query - listing of Payment & Payment date with Production & Production dates
Off of the top of my head: your first query will miss any "As Total" payments because those are claimprocs but are not attached to procedures. Your second query will miss any paysplits that are not attached to a procedure (which i'm less up to date on if these paysplits are valid "income" anymore de...
- Fri Jan 24, 2020 9:36 am
- Forum: Main Forum
- Topic: Patient report
- Replies: 4
- Views: 9826
Re: Patient report
Note that the above query does not take into account the insurance the patient had at the time the procedure was completed, only what their current insurance coverage is now. The patient may have dropped their insurance plan between the procedure date and today. If you are trying to look back severa...
- Mon Oct 22, 2018 5:56 pm
- Forum: Developers
- Topic: Source Code for Web-Hosted Version
- Replies: 1
- Views: 3816
Re: Source Code for Web-Hosted Version
That page specifically mentions that were are not working on a web version at this time. Open Dental does not currently have a version that will run in a web browser. As of 9/6/2016, we are working hard on patient portal and other web technologies, but not directly on a web version. We are still act...
- Fri Oct 19, 2018 2:00 pm
- Forum: Main Forum
- Topic: Pay periods semi-monthly
- Replies: 4
- Views: 5183
Re: Pay periods semi-monthly
Approved feature requests just means they have been approved by someone here at HQ to be shown in the feature request list. Feature requests start out with the "New" approval status, then go to "Approved" if they have been approved by the OpenDental feature request staff. They then get moved to "InP...
- Mon Sep 24, 2018 11:33 am
- Forum: Main Forum
- Topic: Insurance Verification List issue
- Replies: 2
- Views: 4539
Re: Insurance Verification List issue
You can check out https://opendental.com/manual/insverifylist.html for more information on how these list filters work. My short testing does not have the issues you describe in this task, I would check your filters and make sure the patient appointment is within the range you have set. The first co...
- Mon Aug 20, 2018 12:11 pm
- Forum: Main Forum
- Topic: adjusted production
- Replies: 1
- Views: 3796
Re: adjusted production
OpenDental has a built in Provider Payroll P&I report ( https://www.opendental.com/manual/reportprovpayroll.html ) that can be run per provider. This report might work for you. It is hidden by default so you may need to un-hide it in your report setup ( https://www.opendental.com/manual/reportdispla...
- Mon Aug 20, 2018 8:46 am
- Forum: Main Forum
- Topic: tie recall to urgent med information?
- Replies: 2
- Views: 4755
Re: tie recall to urgent med information?
If you don't mind duplicating the information (likely you already have this listed in their medical info in the chart tab), you can add a new Patient Field ( https://www.opendental.com/manual/custompatientfields.html ). Then you can edit your "Patient Information" entry in Display Fields ( https://w...
- Wed Jun 27, 2018 11:29 am
- Forum: Advanced Topics
- Topic: Duplication in security log table
- Replies: 7
- Views: 15218
Re: Duplication in security log table
Thank you for the information. Unfortunately I can't seem to find where these duplicate entries are being created in the latest beta version, so I will have to leave this alone for now. It might have been fixed, or there might be some specific series of events that is falling through the cracks. If ...
- Mon Jun 11, 2018 11:09 am
- Forum: Advanced Topics
- Topic: Duplication in security log table
- Replies: 7
- Views: 15218
Re: Duplication in security log table
If you can pass along the securitylog.LogDateTime and securitylog.LogText for one of the duplicate pairs I can see if I can track it down. Most times the logtext generation has slightly different formatting/wording that can point engineers in the right direction to try and stop them from being creat...
- Mon Jun 11, 2018 9:53 am
- Forum: Advanced Topics
- Topic: Duplication in security log table
- Replies: 7
- Views: 15218
Re: Duplication in security log table
"but that shouldn't be needed since you can only have one appointment creation event." While this theoretically and logically should be true, its not specifically enforced. The audit trail coding is so individualized that the calls to create them are not handled in a centralized manner, and there i...
- Thu Jun 07, 2018 2:43 pm
- Forum: Advanced Topics
- Topic: Daily Production goals
- Replies: 11
- Views: 20585
Re: Daily Production goals
We're still working on updating our documentation for the new beta version, but i'll try to summarize the feature here (I did not implement this feature so i'll do my best). Production goals will be calculated by provider based on an hourly rate * scheduled hours for the provider, summed for all the...
- Mon Jun 04, 2018 12:03 pm
- Forum: Main Forum
- Topic: can't connect to mysql host after windows update
- Replies: 19
- Views: 40524
Re: can't connect to mysql host after windows update
We've had a few different issues and solutions here on this forum so i'm going to try and point you in the right direction of where to troubleshoot if you're having an issue. As always, if you are still having issues you can contact support and we'll do our best to help you. 1.) No workstations are ...
- Mon Mar 19, 2018 9:46 am
- Forum: Main Forum
- Topic: Insurance payment not finalized error message
- Replies: 8
- Views: 20141
Re: Insurance payment not finalized error message
On 15.3 it's hard to say, could have been a bug that we fixed a long time ago or we hadn't created/enhanced a DBM to fix it yet. You'd have to either update to a newer version, or go scan through the source code of 15.3 yourself and see what query is being run to show that message. You should double...
- Wed Feb 28, 2018 2:27 pm
- Forum: Main Forum
- Topic: Add Insurance Plan to Query #164
- Replies: 4
- Views: 6190
Re: Add Insurance Plan to Query #164
It looks like you missed copying one line "DROP TABLE IF EXISTS tmp2;" at the very bottom of this query when you grabbed it off the example page. I'd recommend adding it back if you are saving it to your favorites or somewhere, otherwise a table will stick around in your database forever after runni...
- Mon Feb 26, 2018 2:01 pm
- Forum: Advanced Topics
- Topic: 17.4.34 Procedure fee x7 in account & appt window
- Replies: 8
- Views: 14942
Re: 17.4.34 Procedure fee x7 in account & appt window
There is a DBM tool called "ProcedurelogBaseUnitsZero" that should set all of your procedures base units back to 0 if the procedure code base unit is set to 0. That should probably take care of it for you, and you can confirm it fixed them all by running: /*TP or Completed Procedures with BaseUnits ...
- Mon Feb 26, 2018 1:48 pm
- Forum: Advanced Topics
- Topic: Primary key duplicate
- Replies: 3
- Views: 8915
Re: Primary key duplicate
Looks like you figured it out, but if you're curious why this happens its because mysql was in the middle of inserting a row into the table when the power cut out, so the row got inserted but the auto-increment didn't get incremented. Its fairly common when power is interrupted during use, and DBM s...
- Fri Feb 23, 2018 9:45 am
- Forum: Main Forum
- Topic: Missing new CDT code D5612
- Replies: 6
- Views: 10886
Re: Missing new CDT code D5612
We've confirmed the D5612 category is a bug and i'll have an engineer comment here once it is fixed. But in the meantime feel free to find the code under "Rarely Used" and change the category manually.
- Fri Feb 23, 2018 8:27 am
- Forum: Main Forum
- Topic: Missing new CDT code D5612
- Replies: 6
- Views: 10886
Re: Missing new CDT code D5612
Some quick info: Were you on or above version 17.2.36 or 17.3.22 when you ran the import? D5612 imports under "Never Used" category, while D5611 imports under "Dentures" category (If they exist). Check to see that the category isn't hidden, then you can change the category on the code manually to a ...
- Fri Feb 23, 2018 7:48 am
- Forum: Main Forum
- Topic: Missing new CDT code D5612
- Replies: 6
- Views: 10886
Re: Missing new CDT code D5612
I wrote up a ticket here at OD HQ to look into this, thanks for bringing it to our attention. Another engineer or I will make sure to let you know what we find.
- Wed Feb 21, 2018 11:48 am
- Forum: Advanced Topics
- Topic: Query for Multiple Patient Field Defs
- Replies: 3
- Views: 6680
Re: Query for Multiple Patient Field Defs
Might be useful to also change ORDER BY to "ORDER BY p.LName, p.FName, pf.FieldName" all patients will show the fields in the same order. Also, I think the joins might need to be left joins instead of inner joins (if you want to show patients even if they dont have a patfield filled out), because I ...
- Wed Feb 14, 2018 11:40 am
- Forum: Advanced Topics
- Topic: 17.4.34 Procedure fee x7 in account & appt window
- Replies: 8
- Views: 14942
Re: 17.4.34 Procedure fee x7 in account & appt window
I agree with Jason that it sounds exactly what base units is meant to do, so possibly someone filled some in by accident at some point and fixed it so new procs do not have it anymore. You'll see the normal proc fee on procedures and everywhere else (including reports) it should count the base units...
- Mon Feb 12, 2018 2:33 pm
- Forum: Main Forum
- Topic: Synology backup
- Replies: 5
- Views: 8808
Re: Synology backup
Worth a try at least, but yeah it might be completely unrelated to the file's being new or in use. Could just be some other weird issue that synology has, I am not familiar with it.
- Mon Feb 12, 2018 7:40 am
- Forum: Main Forum
- Topic: Synology backup
- Replies: 5
- Views: 8808
Re: Synology backup
Now that I actually think about it, my We do not often make changes to the computer table comment is wrong. If any instances of OD are still open and running on your client machines we do update that table with a heartbeat (computer.LastHeartBeat) to let OD know that the computer is still connected ...
- Mon Feb 12, 2018 7:36 am
- Forum: Main Forum
- Topic: Synology backup
- Replies: 5
- Views: 8808
Re: Synology backup
My guess would be that synology backup has a problem with trying to copy files that are locked/in use, or possibly it thinks that those files have been changed during the backup process (though not sure why, it sounds like you're running this at a time where no one is using OD) so it tries to recopy...
- Wed Feb 07, 2018 8:05 am
- Forum: Main Forum
- Topic: Cloud Based vs Daisy Chain multiple offices single database
- Replies: 15
- Views: 26712
Re: Cloud Based vs Daisy Chain multiple offices single datab
I'm not sure how many of our larger customers with these type of setups regularly visit these forums, I know there are a couple. The OD engineers that reply on these forums can give as much information as we have about some solutions, but we're always on second/third hand information on the details ...
- Tue Feb 06, 2018 7:39 am
- Forum: Main Forum
- Topic: Warning of inactive pation
- Replies: 6
- Views: 11200
Re: Warning of inactive pation
I'm a little confused at your question. Are you looking for ways to notify when you select these patients or ways to find these types of patients before hand so you can add notifications (Their chart never got followed up on after not doing treatment so a popup was never added)? For notifying the fr...
- Mon Feb 05, 2018 3:32 pm
- Forum: Main Forum
- Topic: Insurance payment not finalized error message
- Replies: 8
- Views: 20141
Re: Insurance payment not finalized error message
If this isn't enough info you'll need to contact support. It is possible that there is a broken state on one of these entries and that is why they are not showing in another report, if this is the case no one here on the forum is going to be able to help you much because we don't know your current D...
- Mon Nov 20, 2017 4:43 pm
- Forum: Main Forum
- Topic: Patient Picture
- Replies: 7
- Views: 11204
Re: Patient Picture
Just to add a little more insight to Allen and Jason's comment, here at OpenDental HQ we do use our software for our day to day operations and the majority of us are using two 1920x1080 monitors. So we are aware of certain places in the program that it would be nice to utilize that extra horizontal ...
- Mon Nov 20, 2017 4:28 pm
- Forum: Main Forum
- Topic: cancel by accident
- Replies: 5
- Views: 7827
Re: cancel by accident
We are very unlikely to ever change the order, spacing, or position of the OK and Cancel buttons for any forms. We try to keep a consistent position and spacing of the OK and Cancel in our windows throughout the program and they are only ever moved when we are trying to make room for other buttons o...
- Mon Nov 20, 2017 4:14 pm
- Forum: Main Forum
- Topic: Online backups and automatic local backups
- Replies: 1
- Views: 3754
Re: Online backups and automatic local backups
There have been a few other users discussing this lately, you might check out viewtopic.php?f=2&t=6648
- Fri Aug 18, 2017 3:58 pm
- Forum: Main Forum
- Topic: website down
- Replies: 1
- Views: 4529
Re: website down
We are aware, thank you for reporting it. The website should be back up now. We were/are having some difficulties with our host so had to change some things on our end to get it back up in the meantime.
- Mon May 22, 2017 1:07 pm
- Forum: Main Forum
- Topic: Audit Trail Updates
- Replies: 13
- Views: 23751
Re: Audit Trail Updates
As Chris mentioned, your #1, #2 and #3 can be accomplished by a custom query. #4 would have to be an enhancement. #5, some of our logs do record this information and some do not. This is partially due to programming time required to make complex logs, and is sometimes due to when we first added the ...
- Thu Apr 06, 2017 11:26 am
- Forum: Main Forum
- Topic: 17.1 Tooth Chart Slider = Awesome!
- Replies: 4
- Views: 8696
Re: 17.1 Tooth Chart Slider = Awesome!
Just adding a note that 17.1 is now available and was publicly released as beta on 03/31/2017.
- Wed Mar 15, 2017 4:25 pm
- Forum: Main Forum
- Topic: Can't set "Note" appts complete with new feature/option
- Replies: 4
- Views: 6472
Re: Can't set "Note" appts complete with new feature/option
"Appointments, patient notes were unable to be set complete sometimes." has been fixed and the fix will be available once 16.4.27 is released. Thank you for bringing this to our attention. A workaround until 16.4.27 is released is to double click on the note appointment on the schedule to open the a...
- Thu Jul 07, 2016 3:55 pm
- Forum: Developers
- Topic: OD16.2.26 error: Field not found: 'OpenDentBusiness.Remoting
- Replies: 2
- Views: 6787
Re: OD16.2.26 error: Field not found: 'OpenDentBusiness.Remo
Did your clean and re-adding the reference fix for your other post fix this issue too or are you still getting it?
- Wed Jul 06, 2016 11:51 am
- Forum: Developers
- Topic: Error in PrefC.GetString(PrefName prefName) function
- Replies: 5
- Views: 12649
Re: Error in PrefC.GetString(PrefName prefName) function
Because PrefName is an enum (really just passed as an int position in the enumeration) it almost seems like the call is using a different version of the enum then the GetString() function. Might check to see that your OpenDentBuisness reference isn't pointing to an older version? Or try cleaning the...
- Fri Jul 01, 2016 1:29 pm
- Forum: Main Forum
- Topic: Query writing
- Replies: 3
- Views: 7074
Re: Query writing
For learning SQL basics (or MYSQL in particular), a book called the MySQL Cookbook isn't bad. Its not great for teaching you semantics but its good for syntax and a starting point for people who haven't ever used SQL.
- Mon Apr 18, 2016 12:44 pm
- Forum: Main Forum
- Topic: Delays normal when tx planning or writing notes?
- Replies: 4
- Views: 7516
Re: Delays normal when tx planning or writing notes?
Even though it looks like the UI is the thing that is taking a long time it is almost certainly related to how long it is taking to run queries against your database, which is highly related to your networking setup. In addition, there are some processes and queries that have been improved significa...
- Mon Apr 18, 2016 12:22 pm
- Forum: Main Forum
- Topic: Possible bug in treatment plan module (15.4.40.0)
- Replies: 2
- Views: 4709
Re: Possible bug in treatment plan module (15.4.40.0)
Several of these things were fixed in 16.1. In short, the bottom of the TP module text box should have really never been user editable because it was never saved. In a past version someone half-way added quick paste notes for treatment plans but not really, since they only added it to that box that....
- Mon Mar 21, 2016 5:41 pm
- Forum: Main Forum
- Topic: Payment appears in report but not in GUI
- Replies: 4
- Views: 7750
Re: Payment appears in report but not in GUI
The payment table patnum should tell you which account the payment is posted on. The paysplit patnum will tell you which account the payment counts for on the ledger. If you suspect any sort of funky business I would recommend running DBM and then checking if the payment still exists in your report....
- Mon Mar 21, 2016 5:32 pm
- Forum: Main Forum
- Topic: Mapped Drives Lost when Updating Open Dental
- Replies: 5
- Views: 9807
Re: Mapped Drives Lost when Updating Open Dental
Note that most of the things you have mentioned Ardavan are only required to be done by the first person updating. Which given a specific update process can be a trusted IT or other experienced staff member to log in as Admin on the server. Everyone else just needs access to the local directory for ...
- Fri Mar 18, 2016 4:42 pm
- Forum: Main Forum
- Topic: Appointments Disappeared - not recorded in Audit Log
- Replies: 13
- Views: 14348
Re: Appointments Disappeared - not recorded in Audit Log
The code with the bug was first introduced in 15.4 with the appointment reminders feature. Though I could easily see an office not having run into the bug through normal use for an extended period of time.
- Fri Mar 18, 2016 3:13 pm
- Forum: Main Forum
- Topic: Appointments Disappeared - not recorded in Audit Log
- Replies: 13
- Views: 14348
Re: Appointments Disappeared - not recorded in Audit Log
"Appointments were being deleted when multiple users were concurrently modifying appointments for the same patient sometimes." fixed in version 15.4.40 and 16.1.11. As Allen mentioned, we can't recover what was already lost sadly. But in this case this was happening because user1 had the appt edit w...
- Wed Mar 09, 2016 10:31 am
- Forum: Main Forum
- Topic: How to track cancellation of the Hygiene appointments ?
- Replies: 5
- Views: 7633
Re: How to track cancellation of the Hygiene appointments ?
The explanation Chris gave is the easiest implementation to keep track of the information you're describing (Potentially even creating a separate operatory to keep track of these notes). To answer your question of "could we" add something to the program, the answer is yes but it would be a feature r...
- Mon Feb 29, 2016 4:03 pm
- Forum: Advanced Topics
- Topic: Output of Line Breaks into CSV
- Replies: 6
- Views: 10901
Re: Output of Line Breaks into CSV
So to do it like we do for middle tier, and assuming you want to keep it as replacing all line breaks with spaces, it'd look like: REPLACE(REPLACE(commlog.Note, CONCAT(CHAR(13),CHAR(10)),CHAR(10)),CHAR(10),' ') Which will work for both places that store new lines as "\r\n" and those that only use "\...
- Mon Feb 29, 2016 3:55 pm
- Forum: Advanced Topics
- Topic: Output of Line Breaks into CSV
- Replies: 6
- Views: 10901
Re: Output of Line Breaks into CSV
I don't have a lot of advice about how to fix this problem, but I have some context. Some places in the program store "\r\n" as returns, and others only store "\n". This is because in .net, richtextboxes store new lines differently than textboxes (more specifically an ODtextbox is an enhanced richt...
- Mon Feb 29, 2016 2:08 pm
- Forum: Advanced Topics
- Topic: Output of Line Breaks into CSV
- Replies: 6
- Views: 10901
Re: Output of Line Breaks into CSV
I don't have a lot of advice about how to fix this problem, but I have some context. Some places in the program store "\r\n" as returns, and others only store "\n". This is because in .net, richtextboxes store new lines differently than textboxes (more specifically an ODtextbox is an enhanced richte...
- Tue Feb 02, 2016 5:05 pm
- Forum: Main Forum
- Topic: Required fields
- Replies: 1
- Views: 3826
Re: Required fields
While I didn't work on this specifically, I can add a little more background to this. Making fields 100% required is tricky. For example, lets say someone is entering data for a patient and they walk off. What if they didn't get the required information? The only thing the user can do at that point ...
- Thu Jan 28, 2016 11:01 am
- Forum: Developers
- Topic: Problem with latest SigPlusNET.dll
- Replies: 3
- Views: 11623
Re: Problem with latest SigPlusNET.dll
There are multitudes of issue with switching how the signatures are generated, so my guess is that the newer dll might be doing it slightly differently. If the signature control cannot "read" the old signature as valid, it is shown as blank. There are two components to having a correct signature, th...
- Thu Jan 14, 2016 4:58 pm
- Forum: Main Forum
- Topic: Backup files have large size.
- Replies: 31
- Views: 43838
Re: Backup files have large size.
What are the size differences uncompressed?
- Tue Jan 12, 2016 12:18 pm
- Forum: Main Forum
- Topic: Hygiene/Recall Analysis Report
- Replies: 5
- Views: 8746
Re: Hygiene/Recall Analysis Report
Which specific report are you referring to? The report button inside the Recall List? Or something different?
- Mon Dec 21, 2015 12:08 pm
- Forum: Main Forum
- Topic: How about this report?
- Replies: 9
- Views: 13954
Re: How about this report?
Travis Yes, this does look like something that I can use. Can you show me where I need to enter info (Date, provider etc....) to make it work for me? To adjust the date range, change the @FromDate='YYYY-MM-DD' and @ToDate='YYYY-MM-DD' at the top of the query on the fourth line. For example: SET @Fr...
- Fri Dec 18, 2015 2:41 pm
- Forum: Main Forum
- Topic: How about this report?
- Replies: 9
- Views: 13954
Re: How about this report?
Added ProcDesc column for you. /*1022 Procedure code totals by ProcCode and provider for completed procedures with completion date in date range.*/ /*Showing production, writeoffs, adjustments, and net production*/ /*Query code written/modified: 12/18/2015*/ SET @FromDate='2014-01-10', @ToDate='2014...
- Fri Dec 11, 2015 2:29 pm
- Forum: Main Forum
- Topic: Insurance Aging Report
- Replies: 14
- Views: 22588
Re: Insurance Aging Report
If you continue having trouble getting what you are wanting from this query I recommend checking out http://opendentalsoft.com:1942/ODQueryRequest/QueryRequestForm.aspx . There an OD query engineer can assist you in getting the information you need. To answer your immediate question, you would have ...
- Thu Dec 10, 2015 1:26 pm
- Forum: Advanced Topics
- Topic: Kiosk tablets and wired network
- Replies: 4
- Views: 9477
Re: Kiosk tablets and wired network
To answer you first question, it would be pretty difficult to get this to work and require very specific programming in a plug-in. This is because OD is set up in such a way to require a database connection at all times to pull down and push up information. As for your second question, this is certa...
- Tue Dec 01, 2015 3:10 pm
- Forum: Main Forum
- Topic: Remove automatic backups
- Replies: 7
- Views: 10776
Re: Remove automatic backups
To answer #2: Honestly it's not a hard process to do manually. Any sort of deletion of backups is a touchy subject, especially doing it automatically. Its something that only someone who knows what they are doing should be doing, and ensuring that they understand what happens if they delete all of t...
- Tue Dec 01, 2015 2:59 pm
- Forum: Main Forum
- Topic: Summary of payment types?
- Replies: 1
- Views: 4142
Re: Summary of payment types?
A query like query examples #783 could be re-written to group by just type instead of date and type. http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
- Mon Nov 30, 2015 4:45 pm
- Forum: Advanced Topics
- Topic: Translation for tooth surface in group notes
- Replies: 6
- Views: 10533
Re: Translation for tooth surface in group notes
Setup->Display Fields->ProcedureGroupNote. Double click the row with Surf as the field name, and give it whatever translated name you want it to show as the New Description. The process is a little different for that window because they are display fields which are user editable/configurable.
- Fri Nov 27, 2015 1:13 pm
- Forum: Main Forum
- Topic: Seeing who is in each surgery
- Replies: 2
- Views: 5334
Re: Seeing who is in each surgery
Joe is correct that messaging buttons are probably what you're looking for. You would turn the button on when someone is taken in to the operatory, and then turn the button off after it has been cleaned. The appointment module can (and should) be used for scheduling who should be in which operatory,...
- Fri Nov 27, 2015 12:21 pm
- Forum: Developers
- Topic: Text Messaging
- Replies: 2
- Views: 5783
Re: Text Messaging
I'm not really understanding your question, can you elaborate further?
- Fri Nov 20, 2015 12:38 pm
- Forum: Developers
- Topic: OD DataBase
- Replies: 3
- Views: 7340
Re: OD DataBase
David and Tom are correct. You cannot use Access for Opendental. Access is NOT a database management system because its not relational, nor is it supported by OD. However, you can export data from mysql to something like excel if you wanted, but it would just be a snapshot of what was in OD at the t...
- Thu Nov 12, 2015 2:28 pm
- Forum: Advanced Topics
- Topic: mysql.ini help needed for slave replication on windows box
- Replies: 12
- Views: 29367
Re: mysql.ini help needed for slave replication on windows b
Have you checked out http://www.opendental.com/manual/replication.html? It has instructions for both one way replication and daisy chain, which have a few more options mentioned in their .ini settings than you currently have.
- Thu Oct 29, 2015 4:01 pm
- Forum: Main Forum
- Topic: Changing Server Dates to change OD entry?
- Replies: 4
- Views: 7581
Re: Changing Server Dates to change OD entry?
Additionally for reference:
Security in OD: http://www.opendental.com/manual/security.html
Networking Security (IT related setup): http://www.opendental.com/manual/comput ... setup.html
Mysql Security (IT related setup): http://www.opendental.com/manual/securitymysql.html
Security in OD: http://www.opendental.com/manual/security.html
Networking Security (IT related setup): http://www.opendental.com/manual/comput ... setup.html
Mysql Security (IT related setup): http://www.opendental.com/manual/securitymysql.html
- Mon Oct 12, 2015 3:43 pm
- Forum: Main Forum
- Topic: Little Help from Query Gurus, please.
- Replies: 3
- Views: 6663
Re: Little Help from Query Gurus, please.
While David's comments are correct, you are going to run into issue getting the patient paid amount if you simply left join paysplits to this query. This is because of potential duplication of rows and the way SUM() works in mysql. Currently the query works fine, but if you joined in paysplit and tr...
- Mon Oct 12, 2015 3:27 pm
- Forum: Main Forum
- Topic: Question when 2 insurances
- Replies: 5
- Views: 9342
Re: Question when 2 insurances
There are a few things you can do. First of all, you can do as JimZ mentions and just mark the secondary claim as received with $0.00 payment. Instead, you can instead delete the secondary claim, double click on the procedure, double click on the secondary insurance estimate and delete it. Additiona...
- Tue Oct 06, 2015 5:07 pm
- Forum: Main Forum
- Topic: Splitting appointment time between team members
- Replies: 2
- Views: 5270
Re: Splitting appointment time between team members
This is usually accomplished with the conjunction of provider time/assistant time set on the left side of the procedure in the procedure edit window ( http://www.opendental.com/manual/procedurecodeedit.html ), the left side of the appointment in the edit appointment window ( http://www.opendental.co...
- Tue Oct 06, 2015 2:24 pm
- Forum: Main Forum
- Topic: Planned Appointments
- Replies: 8
- Views: 13899
Re: Planned Appointments
We have been trying to reproduce some of these issues here at HQ but have not been able to see the issue with the up and down arrows, or the slowness you are experiencing. If you could call in to OD and let them take a copy of your DB it would make it much easier for us to understand and fix these i...
- Fri Oct 02, 2015 11:45 am
- Forum: Main Forum
- Topic: Fix query 403
- Replies: 5
- Views: 12600
Re: Fix query 403
I have fixed query 403 on our website examples page, please take a look at it and let me know if there are any other issues. It is now much more specific about which benefit it uses as the annual max for the plan. As Jason mentioned max will work in almost all cases (because why would you have a lim...
- Mon Sep 21, 2015 12:04 pm
- Forum: Main Forum
- Topic: Time card entry error-SOLVED
- Replies: 10
- Views: 10815
Re: Time card entry error-SOLVED
DBM does not do anything because time card rules with an EmployeeNum of zero are valid to OpenDental. They are timecardrules that apply to all employees, instead of just a specific employee. They are manually created by selecting "All Employees" in the time card setup window when adding a new time c...
- Fri Sep 04, 2015 4:17 pm
- Forum: Main Forum
- Topic: Middle Tier on Linux
- Replies: 3
- Views: 7142
Re: Middle Tier on Linux
The middle tier service can only be run on a windows OS, but your machine running middle tier does not need to be the same one housing your database. Your database and file server can stay on a linux server with middle tier. Your machine running the middle tier will just need to have a direct connec...
- Tue Sep 01, 2015 7:30 am
- Forum: Main Forum
- Topic: Unhandled Exception
- Replies: 2
- Views: 4723
Re: Unhandled Exception
It looks like this is a duplicate thread. See Arna's responses at viewtopic.php?f=1&t=5919
- Tue Sep 01, 2015 7:20 am
- Forum: Main Forum
- Topic: Unhandled Exception
- Replies: 2
- Views: 4723
Re: Unhandled Exception
There are two things this could be. Benefit is one our database tables in mysql, and if that table is missing it is a major issue that will affect your insurance estimates. Additionally, it could be the name of an image on that patient's account named "benefit". I would need to see the full exceptio...
- Tue Sep 01, 2015 7:09 am
- Forum: Main Forum
- Topic: Windows 10
- Replies: 15
- Views: 20666
Re: Windows 10
I have not heard of this issue yet here at OpenDental. If you go to File->Graphics in OD, does it say you are using DirectX, Simple Tooth Chart or OpenGL?. If you call in to OpenDental our staff can help you troubleshoot.
- Tue Sep 01, 2015 6:59 am
- Forum: Developers
- Topic: Print button is not showing.
- Replies: 3
- Views: 7456
Re: Print button is not showing.
Are you running this in visual studios in Debug mode? Build the solution in release mode and it should not take you to print preview.
- Thu Aug 06, 2015 11:01 am
- Forum: Main Forum
- Topic: claim validation before sending
- Replies: 2
- Views: 4935
Re: claim validation before sending
In addition to what dgraffeo has mentioned, there was an enhancement to the Claim Send window in version 15.2.12 that added a preference you can enable in Setup->Manage->Manage Preferences called "Claims Send window validate on load (can cause slowness)". Turning this on will make claims be validate...
- Thu Jul 30, 2015 1:37 pm
- Forum: Main Forum
- Topic: Deleting Preauthorized procedures
- Replies: 2
- Views: 4900
Re: Deleting Preauthorized procedures
This is feature request #3753. I recommend you promote this request by adding comments, votes, and pledges towards it.
- Fri Jul 24, 2015 4:03 pm
- Forum: Main Forum
- Topic: Be Afraid, Be Very Afraid... Ransomware
- Replies: 25
- Views: 40760
Re: Be Afraid, Be Very Afraid... Ransomware
Another thing that I do not see a lot of mention of here, but is mentioned in that article is that having frequent offline or off-site backups that have been verified is also very key for mitigating the impact of these viruses. That way your worst case scenario is losing the data between your last b...
- Thu Jul 23, 2015 3:39 pm
- Forum: Main Forum
- Topic: Software Bug - Appointment Window
- Replies: 6
- Views: 9459
Re: Software Bug - Appointment Window
Thank you for bringing this to our attention. As Jason mentioned, "The cancel button in the Edit Appointment window is a way to cancel out of appointment specific settings (scroll panel section in the top left) and the appointment note.". That is the intended behavior, however the appointment descri...
- Fri Jul 17, 2015 4:43 pm
- Forum: Main Forum
- Topic: Edit procedure description
- Replies: 4
- Views: 7240
Re: Edit procedure description
If the procedure code you used is an ADA code, the description will be not editable. The only way to set the Description back the default for that code would be to run one of the Procedure Code Tools. However it sounds like you may be talking about a Proc Code and not a Description. The Proc Code fi...
- Thu Jul 09, 2015 3:16 pm
- Forum: Main Forum
- Topic: Bad Daily Production and Income Report
- Replies: 2
- Views: 5078
Re: Bad Daily Production and Income Report
In addition to adearmondsattler's questions, was the duplicated payment a patient payment or an insurance payment?
- Wed Jun 17, 2015 10:21 am
- Forum: Main Forum
- Topic: After Adding Database to existing, Reports WAY off
- Replies: 4
- Views: 8440
Re: After Adding Database to existing, Reports WAY off
As boboffice suggested, please contact conversions directly about this issue. The sooner the better. They will be the ones that are most capable to answer any of your questions or concerns.
- Fri Jun 12, 2015 4:13 pm
- Forum: Main Forum
- Topic: Invalid Signature on Chart
- Replies: 10
- Views: 11126
Re: Invalid Signature on Chart
Adearmondsattler is partially correct. We released a fix so that procedures signed in older versions (pre 13.1) will no longer show "invalid signature" just because there are returns in the note. However, the chart module will still show signed for any signed note. The chart module does not differen...
- Mon Apr 20, 2015 3:32 pm
- Forum: Main Forum
- Topic: total collection per provider based on receive date
- Replies: 10
- Views: 14701
Re: total collection per provider based on receive date
Allen's comment was referring to the current version. This was changed in a bug fix "Database maintenance insurance payment fix tool now uses the date received on claims when creating checks." in versions 14.3.24, and 14.2.45. Any installation with that version or newer will use in the received date...
- Mon Apr 20, 2015 3:15 pm
- Forum: Developers
- Topic: Importing name of selected patient
- Replies: 7
- Views: 12399
Re: Importing name of selected patient
As Jason mentioned, you will either need to have a patient object set outside of the form, or you can use the patnum in Jason's other examples and call patients.GetPat(INSERT PATNUM HERE);. The patient object that function returns will contain the patient's name. I hope this helps, however any addit...
- Mon Apr 06, 2015 2:11 pm
- Forum: Main Forum
- Topic: Capitation Plans & Gross Production
- Replies: 3
- Views: 4236
Re: Capitation Plans & Gross Production
The general formula for gross production of a procedure assuming ONLY one capcomplete insurance estimate per procedure is as follows: (Procedure Fee * (Procedure unity quantity + Procedure code base units)) - capcomplete writeoff amount Therefore, if you have a $100.00 procedure fee, 1 unit quantity...
- Wed Apr 01, 2015 3:21 pm
- Forum: Main Forum
- Topic: Capitation Plans & Gross Production
- Replies: 3
- Views: 4236
Re: Capitation Plans & Gross Production
In general, capitation writeoffs are subtracted from the fees on procedures to get gross production. This usually solves the problem. http://www.opendental.com/manual/plancapitation.html We do not recommend having more than one capitation plan for a single patient. If you do so, you must manually ch...
- Wed Apr 01, 2015 11:05 am
- Forum: Main Forum
- Topic: Discounts do funky math
- Replies: 5
- Views: 6911
Re: Discounts do funky math
This feature was initially developed for offices with cash only patients. We have updated the documentation in our manual to reflect this http://opendental.com/manual/treatmentplandiscounts.html . The discount feature is intended for use with cash only patients and is not currently programmed to int...
- Fri Mar 06, 2015 4:16 pm
- Forum: Main Forum
- Topic: Creating a Claim with Bilateral Space Maintainers
- Replies: 4
- Views: 7713
Re: Creating a Claim with Bilateral Space Maintainers
The tooth range treatment area only works for permanent teeth. See Feature Request #3333 "Add the ability to select primary teeth for procedure codes set up to use the "tooth range" treatment area."
- Fri Feb 27, 2015 4:48 pm
- Forum: Main Forum
- Topic: Procedures Not Billed to Insurance
- Replies: 1
- Views: 3028
Re: Procedures Not Billed to Insurance
It is, you might check out our query examples page at http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx to see if there is anything similar that could work for you, or one you could use as a starting point. Then you can use our database documentation for your version of OD on this page http:...
- Mon Jan 19, 2015 4:56 pm
- Forum: Main Forum
- Topic: How to add patient.ChartNumber to Daily Payments Report
- Replies: 4
- Views: 5439
Re: How to add patient.ChartNumber to Daily Payments Report
As dieutan mentioned chart numbers are still in use. They are used for various reasons but are user editable. If you are looking on guidance on how to go about editing the code of that report to show chartnumber, I would urge you to create a post in the developer forums instead. Our payments report ...
- Fri Dec 12, 2014 5:48 pm
- Forum: Main Forum
- Topic: Payment plans not working
- Replies: 2
- Views: 3540
Re: Payment plans not working
This bug was fixed in version 14.3.24. It can be seen on the bugs page (http://opendentalsoft.com:1942/ODBugTra ... sions.aspx) as "Enhanced payment plans report execution time on large databases." That version should be released soon.
- Fri Dec 12, 2014 5:36 pm
- Forum: Main Forum
- Topic: Insurance Plan History
- Replies: 1
- Views: 2695
Re: Insurance Plan History
That patient is always going to be linked to that plan historically. This is because all of his old claims need an insurance plan to point to when you review those past claims. In database terms, an insurance plan being currently linked to a patient is shown by the existence of an entry in the patpl...
- Fri Nov 28, 2014 1:51 pm
- Forum: Main Forum
- Topic: Dance of joy
- Replies: 1
- Views: 3091
Re: Dance of joy
I passed the message along to the conversions department. I am sure they will be happy to see it.
- Mon Nov 17, 2014 4:27 pm
- Forum: Developers
- Topic: Timestamp on Payment or PaySplit
- Replies: 7
- Views: 9554
Re: Timestamp on Payment or PaySplit
I would also recommend using payment.DateEntry instead of payment.PayDate since payment.PayDate is user editable and you could technically enter a payment for a past/future date. Payment.DateEntry should always match the audit trail PaymentCreate permissions's date.
- Fri Nov 14, 2014 4:27 pm
- Forum: Developers
- Topic: Timestamp on Payment or PaySplit
- Replies: 7
- Views: 9554
Re: Timestamp on Payment or PaySplit
Here's a basic concept that might be along the lines of what you're looking for. If you're running it in the User Query in Open Dental it will show the names and payment type names, but if you're running it as a MySQL query outside the program it will need a few more tweaks. It's not quite there, b...
- Thu Oct 30, 2014 5:08 pm
- Forum: Main Forum
- Topic: recall/unscheduled lists, and patients with same name
- Replies: 7
- Views: 6969
Re: recall/unscheduled lists, and patients with same name
In the meantime, you could request/write a custom query to show everything the unscheduled list does, but also shows PatNum or other fields. See this page for more info: http://www.opendental.com/manual/queryoverview.html . However, custom reports aren't quite as easy to use and nice looking as our ...
- Thu Oct 30, 2014 5:03 pm
- Forum: Main Forum
- Topic: Tablet help
- Replies: 9
- Views: 18994
Re: Tablet help
Or $2,500 for a computer.... but I can't program at home without a computer. Its for work I swear...
- Thu Oct 23, 2014 5:01 pm
- Forum: Main Forum
- Topic: Broken appt query broken?
- Replies: 4
- Views: 5424
Re: Broken appt query broken?
KevinRossen is correct, most offices take their broken appointments off the schedule. His query will look for broken appointment adjustments instead of appointments with the broken status. Another way would be to look in the audit trail for appointmentedit entries with the word broken in the log tex...
- Mon Sep 29, 2014 5:10 pm
- Forum: Main Forum
- Topic: How to run report on HMO & PPO seperately
- Replies: 1
- Views: 2910
Re: How to run report on HMO & PPO seperately
Take a look at our query examples page http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx to see if there are any queries that you can run to do what you are looking for. You can use the filters at the top to narrow your search down. Open Dental also can write a custom query for you, details ...
- Thu Sep 25, 2014 5:34 pm
- Forum: Main Forum
- Topic: demographic reports?
- Replies: 1
- Views: 3331
Re: demographic reports?
Be sure to check our query examples page at http://opendentalsoft.com:1942/ODQueryL ... yList.aspx to see if any of these can get you the information you are wanting, or at least give you a starting point.
- Thu Sep 25, 2014 5:12 pm
- Forum: Developers
- Topic: Questions regarding claimpayment and payment tables.
- Replies: 2
- Views: 4279
Re: Questions regarding claimpayment and payment tables.
I'm writing some reports and I'm having trouble figuring this out, perhaps someone with a better idea of how the database works can give me some advice? I have done the queries below, but not being a financial guy I don't know if what I'm getting back makes any sense. 1. If I sum PayAmt(payment tab...
- Thu Aug 14, 2014 1:03 pm
- Forum: Main Forum
- Topic: Staff ROSTER/Scheduling
- Replies: 3
- Views: 3965
Re: Staff ROSTER/Scheduling
You can specify a date range in the top left of that window, and then print the schedule. So if you wanted to print out a schedule two weeks in advance, you'd just set the date range however you wanted to show (as many days in advance as you want) and click print.
- Tue Aug 12, 2014 5:02 pm
- Forum: Main Forum
- Topic: Problem regarding signatures and amounts
- Replies: 12
- Views: 12045
Re: Problem regarding signatures and amounts
I apologize for my previous post, I thought you were talking about saved treatment plans, not treatment planned procedures (both can be signed). With this information, I now understand what the issue is and I can confirm that it is working as intended. Your signature is invalid because the procedure...
- Mon Aug 11, 2014 2:00 pm
- Forum: Main Forum
- Topic: Problem with a Case statement
- Replies: 3
- Views: 4449
Re: Problem with a Case statement
I am not quite sure of the exact thing you are trying to do, but this looks like it should work for what you are trying to do, or can be slightly modified to get the day numbers you are looking for. SET @FromDate=(CURDATE() - INTERVAL 14 DAY) - INTERVAL (DAYOFWEEK(CURDATE())-1) DAY; SET @ToDate=(CUR...
- Mon Aug 11, 2014 1:41 pm
- Forum: Main Forum
- Topic: Problem regarding signatures and amounts
- Replies: 12
- Views: 12045
Re: Problem regarding signatures and amounts
I don't see this functionality changing very much in the future. Once a patient has signed the treatment plan, it cannot change or it defeats the purpose of the signature. A saved treatment plan is a snapshot of what was treatment planned for that patient on that date, and will not change when the p...
- Fri Jul 25, 2014 3:26 pm
- Forum: Main Forum
- Topic: Printing Daily Payments Sheet
- Replies: 7
- Views: 7329
Re: Printing Daily Payments Sheet
I think you're looking for something like query #792 posted on our query examples page here: http://opendentalsoft.com:1942/ODQueryL ... yList.aspx. You can then click export and export it to use outside of OD.
- Fri Jul 25, 2014 8:25 am
- Forum: Main Forum
- Topic: Bug Report/buggy behavior - pay periods ended
- Replies: 9
- Views: 16155
Re: Bug Report/buggy behavior - pay periods ended
The issue is that pay periods cannot always go from Sunday to Sunday. The next pay period cannot overlap the previous pay period, so it could not start again on Sunday. You would have to have pay periods that either went from Sunday to Saturday, or Monday to Sunday. Which would make the pay period 1...
- Fri Jul 25, 2014 7:17 am
- Forum: Main Forum
- Topic: Assigning Clinics to Operatories and Appointment Views
- Replies: 1
- Views: 3155
Re: Assigning Clinics to Operatories and Appointment Views
My recommendation would be to set up one appointment view for each clinic, and separate ops for each clinic. You can then edit that appointment view to only show the operatories for that clinic. As you mentioned, you can then use schedules or blockouts for the days that staff will not be at that cli...
- Mon Jul 14, 2014 3:06 pm
- Forum: Advanced Topics
- Topic: Locating incorrect Ins Estimate Remaining
- Replies: 3
- Views: 6351
Re: Locating incorrect Ins Estimate Remaining
Do you have OD set to automatically run aging, or do you manually run aging? The InsEst column in the account module will only fill on pending claims, so you're looking for a claim that has been created or sent. To the database you're looking for a claimproc with status 0.
- Fri May 23, 2014 3:44 pm
- Forum: Main Forum
- Topic: Exporting reports in a csv file
- Replies: 2
- Views: 8082
Re: Exporting reports in a csv file
As Wjstarck mentioned, you will have to run a query to export. If you're just looking for the same information the daily payments report gives you, query example #792 is almost exactly the same.
- Fri May 23, 2014 3:40 pm
- Forum: Advanced Topics
- Topic: A/R Grouped by Month Query (like dashboard)
- Replies: 1
- Views: 3975
Re: A/R Grouped by Month Query (like dashboard)
The AR report on the dashboard isn't so much "Grouping" by month, as it is running an AR report AsOf that month's date, and then plotting the values. You could do the same thing. You can either run an AR report (query examples #666, #718 or any other) with an AsOf date set at the top to be the first...
- Mon May 19, 2014 3:25 pm
- Forum: Advanced Topics
- Topic: XP and HIPAA and Virtual Machines?
- Replies: 11
- Views: 19985
Re: XP and HIPAA and Virtual Machines?
I'm not sure the exact situation you're in, but have you tried using a newer version of windows but running the application, or its installer in compatibility mode for XP or older? It only occasionally works for me, but its worth a shot.
- Thu May 08, 2014 3:46 pm
- Forum: Main Forum
- Topic: Difficulty with fee schedules...
- Replies: 3
- Views: 4610
Re: Difficulty with fee schedules...
Look at the bottom of http://www.opendental.com/manual/feeschedules.html to see the order that OD looks at to see which fee schedule to use. My guess is that they have an insurance fee schedule set and it uses that before it gets to the fee schedule rarely used. If it is getting the right fee schedu...
- Thu May 01, 2014 4:41 pm
- Forum: Main Forum
- Topic: How many days did i work?
- Replies: 6
- Views: 15022
Re: How many days did i work?
This will tell you the number of days that you had a completed procedure between the two dates that you set at the top. /*Number of days worked in date range (days where procedures were completed)*/ SET @FromDate='2014-04-29', @ToDate='2014-04-29'; SELECT COUNT(DISTINCT pl.ProcDate) AS 'Number of da...
- Thu Apr 03, 2014 5:01 pm
- Forum: Main Forum
- Topic: Owandy QuickVision - Problems with x-ray bridge
- Replies: 1
- Views: 3346
Re: Owandy QuickVision - Problems with x-ray bridge
Is Owandy open before clicking the bridge button? The bottom of http://www.opendental.com/manual/bridgeOwandy.html states "Owandy must be open when you click the bridge button, or the patient will not load in Owandy"
- Mon Mar 17, 2014 1:05 pm
- Forum: Main Forum
- Topic: Can I some how see which user/emp input a payment daily?
- Replies: 1
- Views: 3070
Re: Can I some how see which user/emp input a payment daily?
The audit trail can be queried to get this information. The rows you would be looking for are in the securitylog table, and would have a PermType of 15 (PaymentCreate). The usernum, and the date that audit trail are created are also located in that same table. You cannot currently track an individua...
- Fri Feb 28, 2014 5:00 pm
- Forum: Main Forum
- Topic: Daily report minus scheduled
- Replies: 3
- Views: 4093
Re: Daily report minus scheduled
I would also encourage you to check our query examples page to see if there is an already written query to suit your needs. http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
- Wed Feb 05, 2014 5:00 pm
- Forum: Advanced Topics
- Topic: Question on Building an advanced metrics query
- Replies: 11
- Views: 13591
Re: Question on Building an advanced metrics query
This query is a little weird, but it lets you set the ProvNum into a stored variable if you know the provider abbreviation. You could then use it just as if you had set it manually at the top. Just saves you some time from either doing a quick select statement to find out the provider's ProvNum befo...
- Fri Nov 01, 2013 4:34 pm
- Forum: Main Forum
- Topic: Aging Report for hygienists
- Replies: 2
- Views: 3419
Re: Aging Report for hygienists
The monthly aging report uses the primary provider for the patient. The provider selection for this report is just meant to filter down results, not attribute production or potential income to any particular provider.
- Mon Oct 07, 2013 2:40 pm
- Forum: Advanced Topics
- Topic: Please help with this query
- Replies: 9
- Views: 15318
Re: Please help with this query
Something like this will give you the the count by month of service for each carrier. Its more work to get them to show up vertically, but you can do it with some joins and a bit of work. SELECT MONTH(DateService),COUNT(*) AS 'Count',ca.CarrierNum FROM claim cl INNER JOIN insplan i ON i.PlanNum=cl.P...
- Fri Jul 12, 2013 3:53 pm
- Forum: Advanced Topics
- Topic: Recall List Methods
- Replies: 2
- Views: 5390
Re: Recall List Methods
That phrase is referring to the methods of contacting patients to let them know they have a recall coming up. Some possible methods would be contacting them via email, sending them a post-card, or calling them. They apply to the recall list in that they are all ways of notifying patients that they a...
- Fri Jul 12, 2013 3:38 pm
- Forum: Main Forum
- Topic: Dentist wrong on new appt
- Replies: 3
- Views: 4444
Re: Dentist wrong on new appt
When you mark an Operatory as "Is Hygiene" it considers the hygienist to be the main provider for that op. If you would like the dentist to be the main provider, go into Setup=>Operatories and uncheck that option. Hope that helps.