Open Dental Forum

nathansparks

This is my position, and loosely, the position of Open Dental at this time, and is not legal advice. As a third party, whether the patnum (by itself with no medical information) is PHI or not isn't really the point, the fact is that ALL third parties using the API should know they are acting as a Bu...

nathansparks

I was asked about this post and wanted to clarify, as the person was concerned about opening a port on their server. The opened port for the planned econnector version would be opened only to your local network (like for MySQL or MariaDb). Even this is not required to call the API on the econnector ...

nathansparks

No, it is not currently part of eServices. It is a third party program link available to customers with proprietary third party code that is not Open Source. We may add eServices that offer Care Credit functions in the future (I like the idea).

nathansparks

so, the open source model for "Open Dental" is no longer the case? Good question! This answer to the question is that Open Dental is still Open Source, nothing has changed. This 'program link' content, in this case, is protected by a licensing agreement with a third party. Third party/program link ...

nathansparks

I have researched with our engineers at Open Dental and you can already set an appointment status (like scheduled) and appointment confirmation status. However, right now you are limited on appointment confirmation status to unconfirmed (like all new appointments) and confirmed (default in Open Dent...

nathansparks

I would add that editing appointment confirmation status for patient arrival, confirmed (which is what started the thread) is allowed with the API but I think it needs to be improved, because it was designed to match the FHIR specification, and instead we need to expand it to allow for more custom s...

nathansparks

This is not an issue unless you are manually entering paper charting from previous times. If a customer ever calls in about this we might change it, we have not had a call about this before but you make a good point. It was designed this way on purpose, to show EO and EC on the date they were entere...

nathansparks

Updates are not taking longer than they did before in general, but only because as you suggest, your database is larger. The reason we have you call in is to prevent people from doing this who maybe should not.

nathansparks

We are not discouraging plugins at this point and do not have plan to end support. For many of the things third parties want to do, plugins make the most sense. For some cases, FHIR will make more sense. At this point, plugins are the most powerful way to change or add on to how Open Dental works in...

nathansparks

I will answer this question: Question: I love Open Dental and I feel every penny I pay for support is well worth it. However, when I look into my crystal ball at 5-10 years down the road, the "open" part of Open Dental seems to be deteriorating and this saddens me. It's extremely frustrating that th...

nathansparks

Happysapiensdental: In fact, if you connect to TSI outside of Open Dental (which is fine), you will have the same issue with the insurance payments unless you violate your agreement with TSI. You must report the insurance payments whether automatically or through TSI's portal or some other way. It i...

nathansparks

Dear Happysapiensdental, I take two issues here that we can address, one from your original post and one from your follow-up. 1. Insurance payments should not be considered as payments form the patient. Perhaps expected insurance payments should also be subtracted from patient balance sent to TSI? B...

nathansparks

These may help:
http://www.opendental.com/manual/securityoverview.html
http://www.opendental.com/manual/security.html
http://www.opendental.com/manual/encryption.html
http://www.opendental.com/manual/encryp ... ocker.html
http://www.opendental.com/manual/middletier.html

nathansparks

The MySQL password is not stored in the database. The OD admin password is not stored in the database. But, do not use one the same exact password for both, or in general for any two applications where security is important. There is a possibility that your clearinghouse password may be the same and...

nathansparks

NO, do NOT call them directly, Chris is incorrect, we are not supposed to have anyone call them, we will call them.

nathansparks

Easy to fix, not related to version of Open Dental, not new. Just go to setup, definitions, Appt Confirmed and move the one you want to use as the default to the top using the Up and Down buttons. Someone edited that order, that is the only explanation. You will need to pay even more attention to th...

nathansparks

I like these ideas, I will have our engineers write these up into feature requests that you can vote on. Putting just one vote on a feature request will mean you get notified when we add the feature. I will treat most of these with high priority.
Nathan Sparks (CEO Open Dental)

nathansparks

Mifa, I know it has been a while, but in case you still care, this will pull your values, for recall type table SELECT DefaultInterval, (DefaultInterval>> 24) AS Years, (DefaultInterval>>16<<16)-(DefaultInterval>>24<<24)>>16 AS Months, (DefaultInterval>>8<<8)-(DefaultInterval>>16<<16)>>8 AS Weeks, D...

nathansparks

We have just never had that requested. Good idea. Put in a Feature Request and send me an email with the feature request number to nate.sparks@opendental.com and I will have that feature added.

nathansparks

We should begin working on an archive protocol for tables, and add functionality within the program for each one as we add it. Unfortunately, while there are some groups that could be considered, many tables will have distinct archive functionality. Clinical items (think procedures , prescriptions e...

nathansparks

They will certainly work from the same database. My hope is to add limited tablet functionality first, as duplicating the entire program in a browser is more difficult and having some tablet functionality sooner makes more sense to me right now.

nathansparks

A browser based version (as opposed to the current middle tier web connection) cannot have plugins 'just work' because it won't even have hooks, and is coded from scratch in another language. There won't (can't be) be plugins. But the main Open Dental version is not going anywhere, and this is not a...

nathansparks

I would caution that this may not the best place for a hook. If you are not using the Open Dental built in texting, this form is not the right place to be putting your text messages. You should hook in to the patient level send text button perhaps, but this form is specific to Open Dental two way te...

nathansparks

I will investigate how this happened and back port a fix if possible.

nathansparks

Thanks for being a beta tester on this Rick. The issue you had with some texts not going through seems to have been related to the outbound number: we do not have control over previous 'abuse' of a number (most numbers have some history at this point) that may have caused issues with carriers, but w...

nathansparks

Latency and speed are both possible issues. Latency can be caused by speed issues (ie you have 1000 packets lined up to traverse your gateway and time elapses while they take turns) or can exist simply due to the nature of your connection. In Open Dental you can use the Tools>Misc Tools>Test Latency...

nathansparks

I (Open Dental Staff) had another customer call in about this and point me here. You may just need to make the hygienist the 'dentist' for any appointments where you want all of the procedures to go to the hygienist, so to default the behavior that way on the schedule (others should use the operator...

nathansparks

Dentrix can perform the decryption for you, and if that ever changes we will attempt to provide an Open Dental internal solution.

nathansparks

When a software company supports a client, there may be (and have been) database version specific behaviors. For instance, Open Dental generally requires a specific version of MySQL: you can use another version, but then we cannot address any issues you have related to behavior of that MySQL instanc...

nathansparks

sarrahlynn, I think you should call Open Dental and talk this over with me (Nathan). The amount that insurance is expected to pay you on the customer's behalf is still their debt, and so as part of the account balance it ages. The aging report does show and subtract the expected insurance for the pa...

nathansparks

I would post a request for content here.

nathansparks

create one referral per procedure, they can both be attached to the same referral slip, but each referred procedure has a distinct connection to the referral.

nathansparks

Normal families are account based, so they share an account balance (although there are also patient balances within) and generally get one statement. Say you have a married couple that wants separate accounts and statements. Just have two families and put them in a superfamily, that way you know th...

nathansparks

What browser and operating sytem are you using? There are invisible characters at the end of each line that are being stripped by whatever method you are grabbing the query, try copying this and see if you have the same result, it works fine for me: /*303 List of active patients with no appointments...

nathansparks

The first Lighthouse Open Dental demonstration had a rocky start due to Open Dental not expecting the quantity of attendees that showed, and that exceeded the number that our GoToMeeting software could accomodate. Within a few minutes we switched to 'GoToWebinar' which has a 200 attendee limit vs 20...

nathansparks

You can simply add an 'adjustment to insurance benefits' in the upper right of the edit insurance plan window http://opendental.com/manual/insplan.html. I have not seen a request for an automation for this, probably because it is not too common and perhaps because it might not be accurate unless you...

nathansparks

You have to subscribe to the tasklists that you want to pop up for you (right click on task or tasklist, subscribe). Are you subscribed?

nathansparks

Jordan, it has been well over a year and I thought you could elaborate or update? Would a feature request be the next step (like adding a diffferent brand) or contacting Topz to sort out any issues?

nathansparks

Jordan will answer your question authoritatively, but it would be very difficult to graph custom reports because they are custom, the interface would be complex, so probably no time soon. That feature will need to get more fleshed out first anyhow, allowing custom queries would be premature. But I t...

nathansparks

The third party (Lighthouse) is probably putting data directly into Open Dental, so there is no user logged in, Open Dental client is not even involved, so no way for Open Deental to put entry in audit trail. The only way to do it would be to have lighthouse change how it 'talks' to open dental, Lig...

nathansparks

All conditions must be met, so like an 'and'. For now just make multiple automations instead of 'OR'.

nathansparks

look in your shared folder, what we call the A-z folder, there is a sub folder called SheetImages. It is in there.

nathansparks

It is feature request #1206.

nathansparks

We will try and purchase a similar machine for our next desktop workstation, this might not be in time for you, so you probably should try an nVidia card (keep receipt in c ase it does not work). Call me once you have the card if it seems to not work and you are on support and I can try various mode...

nathansparks

*Other than my last post above, I would note that I have seen situations where some display modes did not allow directX to work properly. I have even had an adjustment of the refresh rate (from 60hz to 70hx I think) 'make' directx work. **I would try put the display in native mode (highest resolutio...

nathansparks

This: Operating System: Windows 7 Professional 32-bit (6.1, Build 7600) (7600.win7_gdr.101026-1503) Language: English (Regional Setting: English) System Manufacturer: Dell Inc. System Model: OptiPlex 380 BIOS: Phoenix ROM BIOS PLUS Version 1.10 A01 Processor: Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93G...

nathansparks

You can remain on 5.0.22, and we would have said indefinitely, but upwards of 25% (maybe higher, it is hard to measure) of users start getting MySQL Error 17 or other error codes from MySQL starting in version 7.7 (really 7.8 now since 7.7 was moved back into beta and never moved out again). The use...

nathansparks

Yes, just put in 0% for your insurance percentages in the edit benefits window insidet the claim edit window (go to claim edit window in accoutn module, then double ckick on the right hand side 'benefits', set all benefits to zero % for each patient as they come in. YOu could do it in the edit insur...

nathansparks

Jordan can we add this to web page http://www.opendental.com/manual/patien ... minal.html?

nathansparks

My 2cents: You should still use peer to peer, a domain is nice for larger networks where you want to be able to control the permissions of multiple user/groups centrally, or distribute software to many clients without having to physically go to the machine, but requires more IT knowledge and there i...

nathansparks

There will always be an option to turn off the 'do not show window on startup' while logged in to Open Dental, then restart. YOu can do this now, and you will be able to in the future. A very nice feature would be to be able to specify the database as a command line argument so you could have icons ...

nathansparks

If you are on stable version (7.6.x) you should use mysql 5.0.22, otherwise use 5.5.x ( I thinki it is 5.5.9) if you are using Open Dental 7.8.x.

nathansparks

I am not sure why an MSI is involved at all. Do you have the 'show buttons for MSI' checkbox checked in help>update>setup? Next time you update, try it with me. My hours are 9-5 pacific, but I can always stay late. Email me at nate.sparks@opendental.com so we can set up an appointment or call our ma...

nathansparks

Dr Stark, sorry no reply to your question, probably because there is no good news for you. We update the trial version about every six months, with no intention to increase the frequency. Unfortunately it looks like you have a valid need, but we just do not have the bandwidth to do it more often. Al...

nathansparks

Thanks for the pointer on that, I will let our staff know too.

nathansparks

Jordan will have to answer, I saw you also have an open issue with our staff on this, I would put my 50 cents that it is a feature request. The key question for me is whether the quickbooks deposit slip will be accepted by the bank if that subtotal for cash is absent in a deposit including cash.

nathansparks

Thanks for your post, I don't think shrinking the font will help anything, and the second line for the treating dentist should not matter because nothing should be sent back from the insuance company to the treating dentist: that treating dentist address is superfluous I think. The electronic claim ...

nathansparks

It appears that while the production numbers shown in the appointment module used to take into account only the production shown on the schedule, a programming mistake caused the new numbers to not take that into consideration. It will be fixed shortly.

nathansparks

Yes, as Jordan said it is easy to add your own no fee codes, and then use a procedure button http://www.opendental.com/manual/procedurebuttons.html to tp all of the grouped 'steps' together, then set them complete as they are completed.

nathansparks

You enter the credit card payment into your merchant portal like normal. Then go to patient account in Open Dental, click payment button, choose 'credit card' from payment type (or you could call us to show you how to add new payment type if you want to track this type of transaction seperately) and...

nathansparks

There appears to be two threads of conversation here, mostly (2) below, but just to clarify for the entry where the doctor is comparing production numbers from this year to last, usually a report (1) would be used rather than (2). 1) production and income reports: if there is a problem with producti...

nathansparks

VR for notes, what software are you using/planning on using for the voice recognition?

nathansparks

Fixed bug [Chart module tab behaved wrong when clicking]. Released in 7.4.8 and 7.3.9

nathansparks

Well, it is grouped by procedure date and by patient in the family (you must provide the guarantors PatNum, which you can show on title bar of Open Dental) so grouping by claim is not needed, usually claims are for one procedure date and always for one patient, try this and comment back if it is not...

nathansparks

I am trying to do a setup here with 1 Dell Server 3 Work stations 1 laptop (mobile) I am doing a pediatric dental practice. I have 5 questions below. I was a computer programmer before dentistry and so I wanted to find how hard it is to install this program? I have done MySQL programming etc in the...

nathansparks

As to the first question...If you are compiling it yourself see http://www.opendental.com/manual/programmers.html where it says "There is no included installation program with the source code (yet). You can run Open Dental on your development computer without an installation program. Play with the i...

nathansparks

It will default to the scrolled position where the first time there is a scheduled provider if you populate the schedule(setup, schedule). SInce that might be a waste of time, you are looking at the blank database and there is also a small demo database distributed with the trial version. From insid...

nathansparks

There are rumors that The Office of the National Coordinator of Health IT (ONC) will publish guidelines for dental certification in mid 2011, we shall see.

nathansparks

Great idea to have a place for users to share their sheets, Jordan will probably comment.

nathansparks

to the first issue, Yes, bug, submitting now, thx

nathansparks

1024 x 768 is the minimum, so 900 x 1600 probably will not work, right hand side will be cut off. But just install trial version to see.

nathansparks

Can anyone remember a thread with a link to some great icons for people to use on their procedure buttons? I cannot find it...

nathansparks

In the mean time, if you have a stack of preprinted cards, you print to the label maker and stick the label onto the card. The reason why this is fairly popular and folks are not clamoring too hard for your proposed feature is that a 4.5 inch square sheet is not likely to last in my wallet until my ...

nathansparks

Josh, I called schick and their hardware is only compatible with their products and with Dentrix Imaging, which is an integrated dentrix product and is perhaps what you are currently using some version of. They do have a twain driver that they said worked with their bitewing sensors, I am not super ...

nathansparks

You could check to see if it is the patient fields, check the size of the table patfield , compare it to a backup from a week ago or more. The size should be very similar. It should also have less than 10,000 rows I would guess for nearly any office. We should be able to do a fix in less than 15 min...

nathansparks

Yes, like Rick says, find out exactly what you are doing when it happens. It is possible that you can characterize it so that we can replicate it and fix it. There has been more than one mouse related bug that was hard to replicate and thus hard to fix, but you should be able to characterize it if y...

nathansparks

js I consider this to be a bug and will add it as soon as I can. dg/Assigned to me. Added to bug list. dg/Not a bug. I tested a fake family on my machine where each of the two family members had different email addresses and I was not able to duplicate the issue. I tested in versions 7.0.41 and our ...

nathansparks

I have the documentation in front of me to do it right now, I don't think you will need us to do any programming changes. I just had not had time to call you back yet. But you can call me and I can setup your bridge. You will simply add a generic (custom) bridge and it is the fullinstallationpath\or...

nathansparks

Jordan will answer this,
Debbie and I tried to figure this out when you (or someone else, I did not take the call) called this week, we thought it was in the send claims window of the manage module, but we saw no result. I do not know if the issue was escalated into our issue tracking system.
Nathan

nathansparks

I have long been in favor of a feature with office specified error/omission checking. Maybe a default setting, but then each office can turn on or off certain checks. It could prompt user if they forget a step (like if there is no planned apt but there are non-recall treatment planned procedures), i...

nathansparks

There is absolutely no connection between file user permissions, database user permissions and OD program user permissions. Three sets of users, three sets of permission, no relationships. Now to your issue. When a procedure is deleted, it is simply marked as deleted, it is not really deleted. While...

nathansparks

Dr Hollinger, this issue is still open here at Open Dental. Dr Sparks is out of town. As I recall, we have had a call on this before and Dr sparks classifies it as a known annoyance. We will leave the issue open here until Dr Sparks decides whether or not it should be considered a bug. IT would help...

nathansparks

Similar bridging behavior, images that are stored in OD are not stored in the database, but in a shared file folder. The folder will be exactly the same size as the sum of the sizes of the individual files.

nathansparks

Not that I am aware of, where do you want this functionality?

nathansparks

We will evaluate this.

nathansparks

I do not see the issue really. It does appear to be a weakness in the audit trail, but I do not quite see a viable embezzlement plan. The patient balance would be incorrect, wouldn't it? Editing a scheduled payment amount is just editing the amount of the loan. Does not provide an embezzelment oppor...

nathansparks

Sorry about the website being down, godaddy is really a poor choice for hosing our website it turns out. They tell me now that 48-72 hours is reasonable downtime, thought their website state 99.9% guaranteed uptime.

Website is up now, locally hosted at our HQ until we find something redundant.

nathansparks

There is an option in the show tab in the account module, check it to show family commlog entries. Call us if that does not make sense. Sorry for the delay in answering- Nathan

nathansparks

I can't wait to try, also use http://opendental.com/manual/plugins.html (the ending 'l' was left off on previous post) for the opendental plugin page.

nathansparks

ns tested R-L460-HSB with version 7.0.20.0 of OD with 32 bit Vista, Usually when it 'works' with office but not with OD we are simply needing to install (reinstall in this case) the drivers from the disk that came with the topaz pad. I did not have to take any action when I upgraded from 6.9 to 7.0....

nathansparks · Re: Topaz Signature Pad Stopped working testing now in version 7.0.20.0 nathan

testing now in version 7.0.20.0
nathan

nathansparks

Yeah, everything looks bad, as if the program is wearing shoes that are too small and toes are poking through the leather...right? Well, you might have a very large display where you have the resolution very high (or in native resolution, which by itself is great) and so you set your DPI set to a gr...

nathansparks

drtech- Fixed, I only found the paysplit as PaySplit, thanks for the find.

nathansparks

Yeah, while this is our current focus and we are hopeful, please do not promise your patients anything. We certainly we do not wish to consider users' patients as having any hopes pinned on our development, so again, keep this under your cap with your patients.

nathansparks

This query is designed to see patient account information more by visit date than by accounting date, much like old accounting module. This may be useful when answering a patient who asks 'why is my balance $52.32?' Note that by default it will run summed by date, but can be easily expanded by runni...

nathansparks

ns/updated, thank you for your keen eye, let me know if there is still an issue /*Annual production and income report For all providers*/ DROP TABLE IF EXISTS t1,t2; SET @FromDate='2010-01-01' , @ToDate='2010-12-31'; CREATE TABLE t1( Month int NOT NULL, $Production double NOT NULL, $Adjustments doub...

nathansparks

thanks, fixed, updated published query at website and the one published above

nathansparks

You would never want to restore 'everything' from your old machine to your new machine, you just want the data, the documents, images etc.. IF you have been organized, it is VERY simple, just copy the documents from your old machine ovver the network was brentwood ended with, they are already in one...

nathansparks

They also have great customer service, they go the extra mile, never any passing of the buck when they should not.

nathansparks

Sorry, fixed capitalization in post above there were 5 places where I used Patient instead of patient, also published on our web site under query examples

nathansparks

You could try this, it corresponds with some other 'day sheet' expectations. IT gives you a little bit of trend and alot of information in one place. As it is it will automatically adjust to 'today' Use it in the reports, User query... it may be the longest SQL query I have written so make sure you ...

nathansparks

Before adding the feature request, could the poster explicitly state that the global fee update has been considered, and let us know the circumstances where that would not suffice?

nathansparks

OK, Looks like I can just point people to that discussion and make it a feature request for now, acknowledging that there is controversy over calling it a feature request rather than a bug as there is no category for 'known annoyance'

nathansparks

Fantastic Jordan! Those ideas actually go along way toward relieving the burden of data backup from the dentist who just wants to 'dent' :) As to those who have >32GB of data (images of course) the ironkey may not be the solution, I just like the iron key because it self destructs and I think that i...

nathansparks

Dr Verharen's office manager Diana is one of several customers who take issue with the 'unsent' showing on billing statements for their patients. In her case, her patients actually have actually said they do not have to pay their bill because it says 'unsent'. The dr also says it does not look profe...

nathansparks

I always advise OD users have secure, pw protected media for backups if they use the included OD backup/restore. Isn't that HIPAA compliant? For instance the IronKey product, it is also waterproof and, for added fun, the chip self destructs if it is physically tampered with. Yet once you unlock it, ...

nathansparks

IT is good to get the feedback, I will look into adding some more... any particular tasks that you are interested in?

nathansparks

Also, if you have submitted a claim for that particular procedure, you cannot submit a primary claim again, of course, as it would be secondary, unless you delete the first claim (if it is invalid). Call us up if you cannot clear it up. Make sure not to DELETE the original insurance, as indicated in...

nathansparks

I am getting an error that prevents me from testing this potential bug... patient 247 in Training DB, try to open image in scanned FMX:' specified cast is invalid. Entering as bug.
Version 6.8.13. We will take a look at your issue soon Dr Fuchs- nathan

nathansparks

I would add a payperiod default rules setup form, along with a multiple period add tool.

nathansparks

Yeah, vote for it... I agree, should not be a difficult change and appears to be a design oversight.

nathansparks

Confirm that not only payment has been recieved, but that the claim is recieved, with a date and satus indicating such. Sometimes I see people enter payments and then click cancel on the claim, so then the claim procedures are recieved but the claim is still 'sent' status. Otherwise we would need to...

nathansparks

That is the solution that I would use, I forsee no difficulty. Cheers,
Nathan

nathansparks

try something like this, if you want to include writeoffs (as negative production) it gets a little more involved, but really as the assistant has no control over what insurance the patient has (PPO), including the PPO writeoff will just create tension over who 'gets' the non-PPO appoointments, so t...

nathansparks

Great idea, we put that together and post back here

nathansparks

It seems to be regional, I have worked with some offices who have mostly deductible before % and others who have mostly % then deductible. Where did we get the information that it is universal?

nathansparks

I would try this for age in word, supposing you bring in birth date as BirthDate, I have not tried it, if it does not work, postback (or email you, I emailed this to you also). I guarantee nothing, but I would say 85% chance it will work, if not I have a typo { = INT({ DATE \@ "yyyy" } + { DATE \@ "...

nathansparks

Sounds great, please enter it as a feature request!

Cheers,
Nathan

nathansparks

I don't think so right now, I would get a bigger monitor. (i know that sounds crazy, but either that or some new eyes).

nathansparks

In general, if we were to build a bridge, the other softwware would have to publish specifications on bridging. IN this case, we would have to launch the Fuji software and send it the path to save the file to. IF the software accepts such an argument, then it is possible, and would be a request.

nathansparks

If you enter payments by total, rather than by procedure, for primary insurance there are problems with reporting, as jordan indicated. The whole point of having the PPO type is to keep track of the difference between the UCR and the PPO fee (called discount in tp module, writeoff in account module ...

nathansparks

Donn't know if this issue is still a problem, but this problem is usually because a file has some weird permissions at the point where it stopped copying (the next file). The reason I suspect this is that deleting the existing backup makes it go away. You see, there is a read only or locked file in ...

nathansparks

Have you 1. Created different 'users' for each of your staff, and then 2. Associated 'employees' with each user 3. Had each employee login with the now associated user account If the user, logged in as himself cannot edit his own timecard, then the maybe 'users cannot edit their own timecards' box i...

nathansparks

Finance charges typically do not add much to an account balance. For instance, a 2.5% APR translates to roughly .2% monthly, so if Bob the BadPayer owes you $500, this woul be a finance charge of about $1. Soooo, the .5% changes the finance charge on a $500 debt by about 20 cents. ... your time is m...

nathansparks

A little more on this topic: There is no income based on category of dental services unless you split patient payments to procedures, which is difficult. The query shown is great (if I do say so myself) but only applies to production (expected revenue, whether collected or not). Income (revenue) is ...

nathansparks

Yeah, sorry, got distracted. It was missing an @ sign on a variable try this SET @StartDate='2008-01-24', @EndDate='2009-01-24',@GuarantorNumber=1223; SELECT p.PatNum, ps.DatePay, ps.SplitAmt FROM patient p INNER JOIN paysplit ps ON p.PatNum=ps.PatNum WHERE DatePay BETWEEN @StartDate AND @EndDate AN...

nathansparks

Yeah, though a statement from the last year is the only way to show the context of the payments, otherwise it is not a ledger. something like SET @StartDate='2008-01-24'; SET @EndDate='2009-01-24'; SET @PatientNumber=1223; SELECT p.Patnum, DatePay, SplitAmt FROM patient p INNER JOIN paysplit ps ON p...

nathansparks

Should work, put the full date in, it will just look at the month and day, make sure you have both the from and to date filled out. Each benefit can be calendar year or service year, so check that too. To make sure you have it set up right I would call customer support at 866 239 0469.

nathansparks

From one nate to another, I can solve the mystery, although perhaps the answer is not too helpful. When you add a patient as a referral, OD copies some of that patient information to the referral table. The patient's identifying 'PatNum' is stored in ther referral table, so there could be some synch...

nathansparks

Yeah, usually this is caused by an estimate attached to the procedure in question. It can happen if you create a procedure and then drop an insurance. You can get it off the list by double clicking the procedure and deleting the estimate.

nathansparks

Close to the votes? Well, there is no magic number (by that I mean there is no number of votes that guarantees the feature will be added immediately), but there are only 5 votes total for this feature. With each customer able to use 100 votes per office, that means that 1/20 of one customer wants th...

nathansparks

We have several users who we support in austrailia... it is $89 month US, you could prepay in 12 month increments and recieve a 10% discount and also avoid fluctuations (you would know each year what your cost would be). You can call or email, if you call we can return the call to avoid toll charges.

nathansparks

Yeah, that is a request, I think it is #230, there are only 20 vote on it now. So as each Open Dental customer has 100 votes, that means that 1/5 of one customer sees it as a primary need. Get your votes out there! Call if you need help using the feature request system. If you are not a customer, yo...

nathansparks

I think you would need a query, someone else may know something I don't on this, call customer service and I will write you a query, that seems like a useful query.

nathansparks

When you edit a letter merge you will see threee columns of available fields: the first is patient fields, the second is referral fields the third is entitled 'other' and includes fields called carriername, carrieraddress and carrier city state zip. Use those. For referral letters, you can do the sa...

nathansparks

Yes, just put in a large amount, 100,000 is often used. The one issue with the copay fee schedule is that it may be complicated to come up with the copay amounts. I wam willing to work with you on this til we get it working right for you, and define any hurdles.

nathansparks

check to make sure that you are not comparing production with total production (total production include adjustments and writeoffs)

nathansparks

Yes, and you can see these for all of your patients on the recall list. Read this web page: http://www.open-dent.com/manual/recalllist.html and this one for setting up the type to show or not show on that list: http://www.open-dent.com/manual/recallsetup.html You can call Open Dental for specific he...

nathansparks

Open time not based on operatory time or chair time, based on provider time. The provider time is set within each appoinment, and is based on default time for each procedure and provider. SEE http://www.open-dent.com/manual/aptedit.html This is because if you have a patient in a chair getting numb, ...

nathansparks

jorge, the bridge is my favorite..nice

nathansparks

OK, I just wrote it, easier than trying to make you glue two together Patients with appointment in date range who had no procedure completed in the given interval prior to the planned appointment Possible useful to show patients who need an extra reminder in order to show up, not hugely practical (a...

nathansparks

Sure. I would also encourage you to just have an office policy that you set appoinment status to appointment confirmed if you do not need to confirm it (for instance if an appointment is less than three weeks out, confirm it immediately). Then you can just use the confirmation list ( http://www.open...

nathansparks

Yes, one example is #35 available at http://www.open-dent.com/manual/queryexamples.html 35. List of families seen in the last three years. Useful for generating a list of patients for Christmas cards. After saving the resulting datafile, you would use the letter merge feature of Word to actually pri...

nathansparks

Yeah, I researched this so we could show Open Dental users on a map, it is expensive to purchase a control that does this programatically. If you find something that just needs an input list (like somone could have written an Excel addon that does this) we can help you query the database to get the ...

nathansparks

yeah, this is an annoyance, but it is not a bug,
it is a feature request. I checked and it has not been requested before or yet.
http://www.open-dent.com/manual/featurerequests.html

nathansparks

I agree with JorgeBon and would add that this (enter fee schedule, use PPO percentage type, select fee sched ininsurance window) is the only way to both charge your patient the correct amount and keep track of the difference between your fee and the PPO fee (PPO writeoff). IF you care not about this...

nathansparks

I don't have one just like that, you would have to request it unless someone else already has it (because of the two or more appointments requirement, this is no longer a garden variety query). It would depend upon the hygiene definition. Usually I would include proceures marked 'IsHygiene', but you...

nathansparks

Just a guess, but probably no procedure that triggers the recall has been completed. For instance, if a child prophy triggers the recall, and the child has never had a child prophy, then it will not be due. Alos, when you make any changes, you must allow OD to synchronize patients.

nathansparks

The best way to transfer the procedure codes if you do not need procedure descriptions would be to use the fee schedule export/import tool. http://www.open-dent.com/manual/feescheduletools.html If you do need them with descriptions in another OD database, you could just make a divergent copy of the ...

nathansparks

On a similar note, Is there a way to store email communication with patient in open-dental. The work-around of storing it as a document / scanned version / image..is very painful..isnt it ? Well, I would not bother storing the incoming communication in open dental, if you need it it is available in...

nathansparks

Regarding the first part of the question, I did not address the legal aspect that you brought up. If there were some litigation and the communication log was proffered as evidince, by itself it would hold little value, although if sworn upon by the party who created it, that sworn testimony would be...

nathansparks

To the first part of the question: It is a valid request to add some specified security to the communications log, but there may be no connection to any HIPAA requirement (none that I can ascertain) and such added security may not bestow the expected value whatever that is; however, I may be missing...

nathansparks

this is just a few clicks...Setup>Practice>Choose default insurance billing provider from dropdown. This would be the entity provider that you have set up to use only as a billing provider.

nathansparks

Yeah, the 3.5 dowload takes about 7-15 min, so I usually have people save it to server and then run as needed on machines upon which you wish to use the feature voting. there is no danger if that is what you were asking, and it takes another 10-15 minutes per machine to install, you don't have to in...

nathansparks

With norton 360, just make sure that you have opened port 3306 for two way communication on both the server and workstations. I find in general that it 'slows' computers down, but that is fairly subjective. Many dentists use norton and OD, I just think the interface for opening ports on the firewall...

nathansparks

I believe the planned appointment has a length just like any other apt, see the bar on the left in the edit appointment screen when you click on the planned apt from either the chart module or apt module. I will check on this in a few hours but i am pretty sure.

nate

nathansparks

well, the original date sent is not kept when a claim is resubmitted, I usually advise that you would note this in the claim note or comm log if you originally sent the claim on a date different that the service date AND you have to resend a claim.

nathansparks

I would check insurance used relative to annual limit (on lower right), or if it is low on TP then notice that there might be treatment of higher priority that has ins estimates adding up to an amount greater than annual limit. Other things to check would be ins categories and specifics of insurance...

nathansparks

Use this for the count of patients with each insurance, the unhandled exception eror you got was because there was an error in your SQL, probably you put a date in wrong format, try this exactly as written, save to favorites, THEN change the date each time you run Call me if you have any problems, o...

nathansparks

OK, the question is, are you wanting to count primary insurance only or any insurance? If you count any insurance then your percentages will be greater than 100% added together. Also it might be more effective if we limit it to a time period where you have seen the patients, typically 2 years or wha...

nathansparks

I will have some queries posted for you within an hour or so
nathan

nathansparks

Since your conversion failed, be aware that you probably also have a backup in that same directory(that od created), as when OD finds a database to be of an older version than the executable, the first thing it does is make a copy, so look in your c:\mysql\data (or whatever directory you have set) a...

nathansparks

'I' and 'i' are different characters in the turkish character set, and there is an i in 'userid', I know that does not help much, I would concur with changing from turkish to english and seeing if the problem goes away, then we can look for a solution. "function configure sets names in "latin5" so t...

nathansparks

I received one email from a user with XP set to turkish who had the same issue, about 3 months ago, no resolution, I will see if I can find anything out on the mysql website.

Nathan

nathansparks

Here you go /*Patient list of Sum of the Fees of all Treatment planned and all scheduled procedures*/ DROP TABLE IF EXISTS tmp1; /*Create a temp table containing summary info by procedure*/ CREATE TABLE tmp1 SELECT patient.PatNum, sum(ProcFee) AS '$Scheduled', 0 AS '$TP' FROM patient INNER JOIN proc...

nathansparks

Savvy, I do not think you will need a card swiper I guess, you did not indicate that you had one: have a Topaz T-L460-HSB Electronic Signature Device and a Cherry MY 7000 USB Keyboard. What else do I need? I currently use CardService Linksys LPAIO processing machine w/ attached model PIN 10 number k...

nathansparks

Savvy, Additional equipment: you might want a card reader that mounts on your monitor (less than $20, $10 last time I looked), won't need much else. Fees: Sean from X-charge will go over the fees with you, I find he is very upfront and easy to talk to. He may still be on vacation, don't know, just g...

nathansparks

If want a count column also of new patients use this custom query New Patients in Date Range with Date of last visit and Procedure Count SET @pos=0, @FromDate='2008-06-01' , @ToDate='2008-06-31'; SELECT @pos:=@pos+1 as 'Count', patient.PatNum, LName, FName, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS '...

nathansparks

Jimmy, there are other users looking for the spanish translation, let me know if you have one
Nathan

nathansparks

Yeah, you can switch the order and add secondary sorting by using
ORDER BY FieldName1 DESC, FieldName2 DESC, FieldName3 ASC

ASC is ascending, DESC is descending

Nathan

nathansparks

FYI, the only time I have seen this type of 'Intermittancy' with the images folder was when there was more than one 'server', the Internet service provider had a xxx.yyy.server@zzz that the netwrok sometimes decided to send traffic destined for the local server to. When it does NOT work, try and pin...

nathansparks

Savvy's issue that he called and talked to me (and amber) about on July 11 was a file permissions issue, I did not record the exact permission but it was either a read only folder or file or a share or security setting for a particular folder or file. Savvy had not changed anything, unfortunately, W...

Search found 172 matches