Open Dental Forum

That code should be located in ControlApptPanel.cs.

Since there is not a standardized place to put this kind of marketing information in Open Dental, what you are probably going to be best served by is a custom query. You can get in contact with our query team to discuss this by filling out the form here: https://opendentalsoft.com:1943/ODQueryReques...

From my experience with other offices that have tried to this, the "best" way to do it is ultimately what works best for your office. But what I have seen as the simplest option that tends to work very well is what you suggested: using a custom query separate out the production for the provider betw...

Please contact support when you are able. We should be able to get that issue resolved for you!

(503)363-5432

Thanks!

Hello, From a quick scan I can see you are missing a "UNION ALL" in this section: SELECT adj.AdjDate AS 'Date', 0 AS 'Fee', adj.AdjAmt AS 'Adj', 0 AS 'InsW' FROM adjustment adj WHERE adj.AdjDate BETWEEN @StartDate AND @EndDate ) prod GROUP BY DATE_FORMAT(prod.Date,'%M %Y') ORDER BY YEAR(prod.Date),M...

I think this mod should work for you. What your query was doing was getting every patient that had a commlog that was not the one you wanted. Rather than only excluding those that had that commlog. That's what this line was doing : INNER JOIN commlog cl ON p.PatNum = cl.PatNum AND cl.CommType<>439 W...

Hello, There are multiple ways that you could handle this with Open Dental. I will list them below with a few quick pros and cons. I would recommend contacting support to go through these options in more detail if you are interested! * Open Dental Cloud - we do offer a cloud solution, which could be...

I will add to this as well, that if you are using our eClipboard app, for Patient Photos, you can have the patients take their own Patient Picture when they come in for their appointment using a mobile device. They can also fill out their forms using the app as well. This automatically imports the p...

Having the fields below the item that grew move back up to their original location is not currently functionality that we have in the sheet window. This would be something that you could submit a feature request for. If you are interested, here is a link that discusses the feature request process: h...

You can add new quick buttons through Setup > Chart > Procedure Buttons. In the Quick Button Category, if you double click on an blank area the right hand window where you want a new button to be, you can enter information for the new button. You cannot currently add quick buttons outside of the Qui...

From what it looks like, there might be a setting for your google account that is blocking the use of tokens for authentication. You can contact our support at 503-363-5432 and we might be able to help troubleshoot this with you, if this is still an issue.

Hope this helps!

Hello,

That is understandably confusing. I would recommend contacting support at 503-363-5432 or support@opendental.com so that we can look into this issue with you. There is either going to be something we can help you set up differently to mitigate this, or find another solution.

Regards

MySQL has built in limits for connections and connection errors, when the number of concurrent connections matches the limit, or the number of connection errors matches the limit, then MySQL will refuse further connections. Using `flush hosts` will clear our those connections and connection errors. ...

Hello, this is something that we would probably need to look into with you over the phone. I would suggest that you contact support to discuss it. 503-363-5432.

Thanks!

Hi Dr.RichM, You can get the estimated adjusted production for scheduled procedures in the standard report. All you need to do is go into the Report Setup window (Reports -> Standard -> Setup) under the Misc Settings tab. On there you can check "Monthly P&I scheduled production subtracts PPO write-o...