Search found 122 matches

by tgriswold
Thu Jan 30, 2020 8:20 am
Forum: Advanced Topics
Topic: Query - listing of Payment & Payment date with Production & Production dates
Replies: 1
Views: 10515

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...
by tgriswold
Fri Jan 24, 2020 9:36 am
Forum: Main Forum
Topic: Patient report
Replies: 4
Views: 9691

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...
by tgriswold
Mon Oct 22, 2018 5:56 pm
Forum: Developers
Topic: Source Code for Web-Hosted Version
Replies: 1
Views: 3700

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...
by tgriswold
Fri Oct 19, 2018 2:00 pm
Forum: Main Forum
Topic: Pay periods semi-monthly
Replies: 4
Views: 4979

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...
by tgriswold
Mon Sep 24, 2018 11:33 am
Forum: Main Forum
Topic: Insurance Verification List issue
Replies: 2
Views: 4397

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...
by tgriswold
Mon Aug 20, 2018 12:11 pm
Forum: Main Forum
Topic: adjusted production
Replies: 1
Views: 3688

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...
by tgriswold
Mon Aug 20, 2018 8:46 am
Forum: Main Forum
Topic: tie recall to urgent med information?
Replies: 2
Views: 4662

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...
by tgriswold
Wed Jun 27, 2018 11:29 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

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 ...
by tgriswold
Mon Jun 11, 2018 11:09 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

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...
by tgriswold
Mon Jun 11, 2018 9:53 am
Forum: Advanced Topics
Topic: Duplication in security log table
Replies: 7
Views: 14717

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...
by tgriswold
Thu Jun 07, 2018 2:43 pm
Forum: Advanced Topics
Topic: Daily Production goals
Replies: 11
Views: 19367

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...
by tgriswold
Mon Jun 04, 2018 12:03 pm
Forum: Main Forum
Topic: can't connect to mysql host after windows update
Replies: 19
Views: 39366

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 ...
by tgriswold
Mon Mar 19, 2018 9:46 am
Forum: Main Forum
Topic: Insurance payment not finalized error message
Replies: 8
Views: 19774

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...
by tgriswold
Wed Feb 28, 2018 2:27 pm
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 5965

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...
by tgriswold
Mon Feb 26, 2018 2:01 pm
Forum: Advanced Topics
Topic: 17.4.34 Procedure fee x7 in account & appt window
Replies: 8
Views: 14028

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 ...
by tgriswold
Mon Feb 26, 2018 1:48 pm
Forum: Advanced Topics
Topic: Primary key duplicate
Replies: 3
Views: 8513

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...
by tgriswold
Fri Feb 23, 2018 9:45 am
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10647

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.
by tgriswold
Fri Feb 23, 2018 8:27 am
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10647

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 ...
by tgriswold
Fri Feb 23, 2018 7:48 am
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10647

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.
by tgriswold
Wed Feb 21, 2018 11:48 am
Forum: Advanced Topics
Topic: Query for Multiple Patient Field Defs
Replies: 3
Views: 6358

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 ...
by tgriswold
Wed Feb 14, 2018 11:40 am
Forum: Advanced Topics
Topic: 17.4.34 Procedure fee x7 in account & appt window
Replies: 8
Views: 14028

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...
by tgriswold
Mon Feb 12, 2018 2:33 pm
Forum: Main Forum
Topic: Synology backup
Replies: 5
Views: 8684

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.
by tgriswold
Mon Feb 12, 2018 7:40 am
Forum: Main Forum
Topic: Synology backup
Replies: 5
Views: 8684

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 ...
by tgriswold
Mon Feb 12, 2018 7:36 am
Forum: Main Forum
Topic: Synology backup
Replies: 5
Views: 8684

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...
by tgriswold
Wed Feb 07, 2018 8:05 am
Forum: Main Forum
Topic: Cloud Based vs Daisy Chain multiple offices single database
Replies: 15
Views: 26112

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 ...
by tgriswold
Tue Feb 06, 2018 7:39 am
Forum: Main Forum
Topic: Warning of inactive pation
Replies: 6
Views: 10853

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...
by tgriswold
Mon Feb 05, 2018 3:32 pm
Forum: Main Forum
Topic: Insurance payment not finalized error message
Replies: 8
Views: 19774

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...
by tgriswold
Mon Nov 20, 2017 4:43 pm
Forum: Main Forum
Topic: Patient Picture
Replies: 7
Views: 10910

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 ...
by tgriswold
Mon Nov 20, 2017 4:28 pm
Forum: Main Forum
Topic: cancel by accident
Replies: 5
Views: 7583

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...
by tgriswold
Mon Nov 20, 2017 4:14 pm
Forum: Main Forum
Topic: Online backups and automatic local backups
Replies: 1
Views: 3656

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
by tgriswold
Fri Aug 18, 2017 3:58 pm
Forum: Main Forum
Topic: website down
Replies: 1
Views: 4363

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.
by tgriswold
Mon May 22, 2017 1:07 pm
Forum: Main Forum
Topic: Audit Trail Updates
Replies: 13
Views: 23446

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 ...
by tgriswold
Thu Apr 06, 2017 11:26 am
Forum: Main Forum
Topic: 17.1 Tooth Chart Slider = Awesome!
Replies: 4
Views: 8578

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.
by tgriswold
Wed Mar 15, 2017 4:25 pm
Forum: Main Forum
Topic: Can't set "Note" appts complete with new feature/option
Replies: 4
Views: 6265

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...
by tgriswold
Thu Jul 07, 2016 3:55 pm
Forum: Developers
Topic: OD16.2.26 error: Field not found: 'OpenDentBusiness.Remoting
Replies: 2
Views: 6593

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?
by tgriswold
Wed Jul 06, 2016 11:51 am
Forum: Developers
Topic: Error in PrefC.GetString(PrefName prefName) function
Replies: 5
Views: 12382

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...
by tgriswold
Fri Jul 01, 2016 1:29 pm
Forum: Main Forum
Topic: Query writing
Replies: 3
Views: 6970

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.
by tgriswold
Mon Apr 18, 2016 12:44 pm
Forum: Main Forum
Topic: Delays normal when tx planning or writing notes?
Replies: 4
Views: 7413

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...
by tgriswold
Mon Apr 18, 2016 12:22 pm
Forum: Main Forum
Topic: Possible bug in treatment plan module (15.4.40.0)
Replies: 2
Views: 4550

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....
by tgriswold
Mon Mar 21, 2016 5:41 pm
Forum: Main Forum
Topic: Payment appears in report but not in GUI
Replies: 4
Views: 7612

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....
by tgriswold
Mon Mar 21, 2016 5:32 pm
Forum: Main Forum
Topic: Mapped Drives Lost when Updating Open Dental
Replies: 5
Views: 9561

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 ...
by tgriswold
Fri Mar 18, 2016 4:42 pm
Forum: Main Forum
Topic: Appointments Disappeared - not recorded in Audit Log
Replies: 13
Views: 14027

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.
by tgriswold
Fri Mar 18, 2016 3:13 pm
Forum: Main Forum
Topic: Appointments Disappeared - not recorded in Audit Log
Replies: 13
Views: 14027

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...
by tgriswold
Wed Mar 09, 2016 10:31 am
Forum: Main Forum
Topic: How to track cancellation of the Hygiene appointments ?
Replies: 5
Views: 7513

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...
by tgriswold
Mon Feb 29, 2016 4:03 pm
Forum: Advanced Topics
Topic: Output of Line Breaks into CSV
Replies: 6
Views: 10635

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 "\...
by tgriswold
Mon Feb 29, 2016 3:55 pm
Forum: Advanced Topics
Topic: Output of Line Breaks into CSV
Replies: 6
Views: 10635

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...
by tgriswold
Mon Feb 29, 2016 2:08 pm
Forum: Advanced Topics
Topic: Output of Line Breaks into CSV
Replies: 6
Views: 10635

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...
by tgriswold
Tue Feb 02, 2016 5:05 pm
Forum: Main Forum
Topic: Required fields
Replies: 1
Views: 3779

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 ...
by tgriswold
Thu Jan 28, 2016 11:01 am
Forum: Developers
Topic: Problem with latest SigPlusNET.dll
Replies: 3
Views: 11477

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...
by tgriswold
Thu Jan 14, 2016 4:58 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42961

Re: Backup files have large size.

What are the size differences uncompressed?
by tgriswold
Tue Jan 12, 2016 12:18 pm
Forum: Main Forum
Topic: Hygiene/Recall Analysis Report
Replies: 5
Views: 8628

Re: Hygiene/Recall Analysis Report

Which specific report are you referring to? The report button inside the Recall List? Or something different?
by tgriswold
Mon Dec 21, 2015 12:08 pm
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 13732

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...
by tgriswold
Fri Dec 18, 2015 2:41 pm
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 13732

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...
by tgriswold
Fri Dec 11, 2015 2:29 pm
Forum: Main Forum
Topic: Insurance Aging Report
Replies: 14
Views: 22257

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 ...
by tgriswold
Thu Dec 10, 2015 1:26 pm
Forum: Advanced Topics
Topic: Kiosk tablets and wired network
Replies: 4
Views: 9048

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...
by tgriswold
Tue Dec 01, 2015 3:10 pm
Forum: Main Forum
Topic: Remove automatic backups
Replies: 7
Views: 10534

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...
by tgriswold
Tue Dec 01, 2015 2:59 pm
Forum: Main Forum
Topic: Summary of payment types?
Replies: 1
Views: 4077

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
by tgriswold
Mon Nov 30, 2015 4:45 pm
Forum: Advanced Topics
Topic: Translation for tooth surface in group notes
Replies: 6
Views: 10220

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.
by tgriswold
Fri Nov 27, 2015 1:13 pm
Forum: Main Forum
Topic: Seeing who is in each surgery
Replies: 2
Views: 5244

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,...
by tgriswold
Fri Nov 27, 2015 12:21 pm
Forum: Developers
Topic: Text Messaging
Replies: 2
Views: 5657

Re: Text Messaging

I'm not really understanding your question, can you elaborate further?
by tgriswold
Fri Nov 20, 2015 12:38 pm
Forum: Developers
Topic: OD DataBase
Replies: 3
Views: 7145

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...
by tgriswold
Thu Nov 12, 2015 2:28 pm
Forum: Advanced Topics
Topic: mysql.ini help needed for slave replication on windows box
Replies: 12
Views: 28783

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.
by tgriswold
Thu Oct 29, 2015 4:01 pm
Forum: Main Forum
Topic: Changing Server Dates to change OD entry?
Replies: 4
Views: 7396

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
by tgriswold
Mon Oct 12, 2015 3:43 pm
Forum: Main Forum
Topic: Little Help from Query Gurus, please.
Replies: 3
Views: 6495

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...
by tgriswold
Mon Oct 12, 2015 3:27 pm
Forum: Main Forum
Topic: Question when 2 insurances
Replies: 5
Views: 9223

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...
by tgriswold
Tue Oct 06, 2015 5:07 pm
Forum: Main Forum
Topic: Splitting appointment time between team members
Replies: 2
Views: 5186

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...
by tgriswold
Tue Oct 06, 2015 2:24 pm
Forum: Main Forum
Topic: Planned Appointments
Replies: 8
Views: 13624

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...
by tgriswold
Fri Oct 02, 2015 11:45 am
Forum: Main Forum
Topic: Fix query 403
Replies: 5
Views: 12499

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...
by tgriswold
Mon Sep 21, 2015 12:04 pm
Forum: Main Forum
Topic: Time card entry error-SOLVED
Replies: 10
Views: 10613

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...
by tgriswold
Fri Sep 04, 2015 4:17 pm
Forum: Main Forum
Topic: Middle Tier on Linux
Replies: 3
Views: 7049

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...
by tgriswold
Tue Sep 01, 2015 7:30 am
Forum: Main Forum
Topic: Unhandled Exception
Replies: 2
Views: 4655

Re: Unhandled Exception

It looks like this is a duplicate thread. See Arna's responses at viewtopic.php?f=1&t=5919
by tgriswold
Tue Sep 01, 2015 7:20 am
Forum: Main Forum
Topic: Unhandled Exception
Replies: 2
Views: 4655

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...
by tgriswold
Tue Sep 01, 2015 7:09 am
Forum: Main Forum
Topic: Windows 10
Replies: 15
Views: 20106

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.
by tgriswold
Tue Sep 01, 2015 6:59 am
Forum: Developers
Topic: Print button is not showing.
Replies: 3
Views: 7324

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.
by tgriswold
Thu Aug 06, 2015 11:01 am
Forum: Main Forum
Topic: claim validation before sending
Replies: 2
Views: 4835

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...
by tgriswold
Thu Jul 30, 2015 1:37 pm
Forum: Main Forum
Topic: Deleting Preauthorized procedures
Replies: 2
Views: 4819

Re: Deleting Preauthorized procedures

This is feature request #3753. I recommend you promote this request by adding comments, votes, and pledges towards it.
by tgriswold
Fri Jul 24, 2015 4:03 pm
Forum: Main Forum
Topic: Be Afraid, Be Very Afraid... Ransomware
Replies: 25
Views: 36700

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...
by tgriswold
Thu Jul 23, 2015 3:39 pm
Forum: Main Forum
Topic: Software Bug - Appointment Window
Replies: 6
Views: 9365

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...
by tgriswold
Fri Jul 17, 2015 4:43 pm
Forum: Main Forum
Topic: Edit procedure description
Replies: 4
Views: 7129

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...
by tgriswold
Thu Jul 09, 2015 3:16 pm
Forum: Main Forum
Topic: Bad Daily Production and Income Report
Replies: 2
Views: 4985

Re: Bad Daily Production and Income Report

In addition to adearmondsattler's questions, was the duplicated payment a patient payment or an insurance payment?
by tgriswold
Wed Jun 17, 2015 10:21 am
Forum: Main Forum
Topic: After Adding Database to existing, Reports WAY off
Replies: 4
Views: 8308

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.
by tgriswold
Fri Jun 12, 2015 4:13 pm
Forum: Main Forum
Topic: Invalid Signature on Chart
Replies: 10
Views: 10897

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...
by tgriswold
Mon Apr 20, 2015 3:32 pm
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14524

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...
by tgriswold
Mon Apr 20, 2015 3:15 pm
Forum: Developers
Topic: Importing name of selected patient
Replies: 7
Views: 12264

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...
by tgriswold
Mon Apr 06, 2015 2:11 pm
Forum: Main Forum
Topic: Capitation Plans & Gross Production
Replies: 3
Views: 4149

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...
by tgriswold
Wed Apr 01, 2015 3:21 pm
Forum: Main Forum
Topic: Capitation Plans & Gross Production
Replies: 3
Views: 4149

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...
by tgriswold
Wed Apr 01, 2015 11:05 am
Forum: Main Forum
Topic: Discounts do funky math
Replies: 5
Views: 6776

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...
by tgriswold
Fri Mar 06, 2015 4:16 pm
Forum: Main Forum
Topic: Creating a Claim with Bilateral Space Maintainers
Replies: 4
Views: 7593

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."
by tgriswold
Fri Feb 27, 2015 4:48 pm
Forum: Main Forum
Topic: Procedures Not Billed to Insurance
Replies: 1
Views: 2975

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:...
by tgriswold
Mon Jan 19, 2015 4:56 pm
Forum: Main Forum
Topic: How to add patient.ChartNumber to Daily Payments Report
Replies: 4
Views: 5324

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 ...
by tgriswold
Fri Dec 12, 2014 5:48 pm
Forum: Main Forum
Topic: Payment plans not working
Replies: 2
Views: 3466

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.
by tgriswold
Fri Dec 12, 2014 5:36 pm
Forum: Main Forum
Topic: Insurance Plan History
Replies: 1
Views: 2636

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...
by tgriswold
Fri Nov 28, 2014 1:51 pm
Forum: Main Forum
Topic: Dance of joy
Replies: 1
Views: 3020

Re: Dance of joy

I passed the message along to the conversions department. I am sure they will be happy to see it.
by tgriswold
Mon Nov 17, 2014 4:27 pm
Forum: Developers
Topic: Timestamp on Payment or PaySplit
Replies: 7
Views: 9320

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.
by tgriswold
Fri Nov 14, 2014 4:27 pm
Forum: Developers
Topic: Timestamp on Payment or PaySplit
Replies: 7
Views: 9320

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...
by tgriswold
Thu Oct 30, 2014 5:08 pm
Forum: Main Forum
Topic: recall/unscheduled lists, and patients with same name
Replies: 7
Views: 6857

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 ...
by tgriswold
Thu Oct 30, 2014 5:03 pm
Forum: Main Forum
Topic: Tablet help
Replies: 9
Views: 18828

Re: Tablet help

Or $2,500 for a computer.... but I can't program at home without a computer. Its for work I swear...
by tgriswold
Thu Oct 23, 2014 5:01 pm
Forum: Main Forum
Topic: Broken appt query broken?
Replies: 4
Views: 5309

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...
by tgriswold
Mon Sep 29, 2014 5:10 pm
Forum: Main Forum
Topic: How to run report on HMO & PPO seperately
Replies: 1
Views: 2849

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 ...
by tgriswold
Thu Sep 25, 2014 5:34 pm
Forum: Main Forum
Topic: demographic reports?
Replies: 1
Views: 3207

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.
by tgriswold
Thu Sep 25, 2014 5:12 pm
Forum: Developers
Topic: Questions regarding claimpayment and payment tables.
Replies: 2
Views: 4211

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...
by tgriswold
Thu Aug 14, 2014 1:03 pm
Forum: Main Forum
Topic: Staff ROSTER/Scheduling
Replies: 3
Views: 3888

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.
by tgriswold
Tue Aug 12, 2014 5:02 pm
Forum: Main Forum
Topic: Problem regarding signatures and amounts
Replies: 12
Views: 11861

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...
by tgriswold
Mon Aug 11, 2014 2:00 pm
Forum: Main Forum
Topic: Problem with a Case statement
Replies: 3
Views: 4354

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...
by tgriswold
Mon Aug 11, 2014 1:41 pm
Forum: Main Forum
Topic: Problem regarding signatures and amounts
Replies: 12
Views: 11861

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...
by tgriswold
Fri Jul 25, 2014 3:26 pm
Forum: Main Forum
Topic: Printing Daily Payments Sheet
Replies: 7
Views: 7194

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.
by tgriswold
Fri Jul 25, 2014 8:25 am
Forum: Main Forum
Topic: Bug Report/buggy behavior - pay periods ended
Replies: 9
Views: 15915

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...
by tgriswold
Fri Jul 25, 2014 7:17 am
Forum: Main Forum
Topic: Assigning Clinics to Operatories and Appointment Views
Replies: 1
Views: 3108

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...
by tgriswold
Mon Jul 14, 2014 3:06 pm
Forum: Advanced Topics
Topic: Locating incorrect Ins Estimate Remaining
Replies: 3
Views: 6234

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.
by tgriswold
Fri May 23, 2014 3:44 pm
Forum: Main Forum
Topic: Exporting reports in a csv file
Replies: 2
Views: 8007

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.
by tgriswold
Fri May 23, 2014 3:40 pm
Forum: Advanced Topics
Topic: A/R Grouped by Month Query (like dashboard)
Replies: 1
Views: 3908

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...
by tgriswold
Mon May 19, 2014 3:25 pm
Forum: Advanced Topics
Topic: XP and HIPAA and Virtual Machines?
Replies: 11
Views: 18405

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.
by tgriswold
Thu May 08, 2014 3:46 pm
Forum: Main Forum
Topic: Difficulty with fee schedules...
Replies: 3
Views: 4501

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...
by tgriswold
Thu May 01, 2014 4:41 pm
Forum: Main Forum
Topic: How many days did i work?
Replies: 6
Views: 14865

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...
by tgriswold
Thu Apr 03, 2014 5:01 pm
Forum: Main Forum
Topic: Owandy QuickVision - Problems with x-ray bridge
Replies: 1
Views: 3292

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"
by tgriswold
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: 3005

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...
by tgriswold
Fri Feb 28, 2014 5:00 pm
Forum: Main Forum
Topic: Daily report minus scheduled
Replies: 3
Views: 4028

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
by tgriswold
Wed Feb 05, 2014 5:00 pm
Forum: Advanced Topics
Topic: Question on Building an advanced metrics query
Replies: 11
Views: 13392

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...
by tgriswold
Fri Nov 01, 2013 4:34 pm
Forum: Main Forum
Topic: Aging Report for hygienists
Replies: 2
Views: 3336

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.
by tgriswold
Mon Oct 07, 2013 2:40 pm
Forum: Advanced Topics
Topic: Please help with this query
Replies: 9
Views: 15103

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...
by tgriswold
Fri Jul 12, 2013 3:53 pm
Forum: Advanced Topics
Topic: Recall List Methods
Replies: 2
Views: 5306

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...
by tgriswold
Fri Jul 12, 2013 3:38 pm
Forum: Main Forum
Topic: Dentist wrong on new appt
Replies: 3
Views: 4335

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.