Search found 235 matches

by allends
Wed Mar 27, 2024 9:56 am
Forum: Main Forum
Topic: Webforms font size too small... can it be enlarged?
Replies: 1
Views: 37

Re: Webforms font size too small... can it be enlarged?

Mikey, Webforms can be edited via the sheets system, but to get access to some of the features you are looking for (Adding a logo, enlarging fonts, etc...) you will need to disable the mobile version of sheets that you plan on uploading to our webforms server. This will ensure the patient is routed ...
by allends
Fri Mar 01, 2024 9:29 am
Forum: Main Forum
Topic: Where are the OpenDentalCloud local backups stored?
Replies: 3
Views: 294

Re: Where are the OpenDentalCloud local backups stored?

On Site refers to our hosting location. Not the local office.
by allends
Thu Feb 29, 2024 10:26 am
Forum: API
Topic: Posting payments to payment plans
Replies: 5
Views: 271

Re: Posting payments to payment plans

Very soon. The engineering team and the testing department are running through final checks for both the 23.3 stable version and the 24.1 beta version.
by allends
Thu Feb 29, 2024 10:19 am
Forum: API
Topic: Posting payments to payment plans
Replies: 5
Views: 271

Re: Posting payments to payment plans

In 23.3, you are no longer required to make a prepayment to payment plans via the API, so this won't happen if you choose to not make prepayments for that version and higher moving forward. If you choose to not make prepayments, the unearned type will not be set and this will no longer occur. The de...
by allends
Thu Feb 29, 2024 9:03 am
Forum: API
Topic: Posting payments to payment plans
Replies: 5
Views: 271

Re: Posting payments to payment plans

Are you entering the payment via the API? If so, it is likely that the culprit is the preference found here: PayPlanPref.png The definition set in that preference is most likely set as Do Not Show On Account. The office will need to set up a definition without that flag set and change that preferenc...
by allends
Thu Feb 29, 2024 8:35 am
Forum: Main Forum
Topic: Table instemplate
Replies: 1
Views: 237

Re: Table instemplate

Query favorites are just SQL queries that have been saved for later.
https://www.opendental.com/manual233/qu ... rites.html

The InsTemplate table does not exist in the Open Dental schema, so the most likely source of that User Query Favorite is a 3rd party.
by allends
Thu Feb 08, 2024 9:02 am
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 601

Re: Request For Table Indexes?

I still don't have a full grasp of the scope of this request. There is an unknown number of tables that you are requesting to poll like this and it is unlikely that any of them have an index on a datetime column which Open Dental rarely, if ever, queries on. It would be easier to assist you if I kne...
by allends
Tue Feb 06, 2024 2:39 pm
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 601

Re: Request For Table Indexes?

I share your concerns about churn on the database, but the scope of this request increased by an indeterminate amount, since I am unsure how how many indexes we would need to add to an unknown amount of tables. I am assuming, based on your concern, that your frequency for this polling interval is ve...
by allends
Tue Feb 06, 2024 12:45 pm
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 601

Re: Request For Table Indexes?

Typically we do not entertain index requests, mostly due to the side effects you mentioned. When we do tend to add indexes, it is because a system in Open Dental is demonstrably slow due to a lack of said index. A 5+ second query time to poll a table for changes shouldn't be too terrible for most us...
by allends
Mon Jan 22, 2024 4:09 pm
Forum: API
Topic: Open Dental 23.2 Benefit API does not have CodeGroup
Replies: 4
Views: 787

Re: Open Dental 23.2 Benefit API does not have CodeGroup

It is very rare for Open Dental to change an existing feature in such a way that the API would not continue to function. This instance is a rare exception and has not occurred for the last three years of development for Open Dental and the Open Dental API. But why release something as "stable" versi...
by allends
Tue Dec 12, 2023 11:11 am
Forum: API
Topic: Data Mismatch between Provider Table Primary Key Value ProvNum and ProcedureLog Table for ProvNum
Replies: 2
Views: 1770

Re: Data Mismatch between Provider Table Primary Key Value ProvNum and ProcedureLog Table for ProvNum

In general, deleted procedures will actually be saved with a provider. It is possible that deleted procedures will be saved to the database with a ProvNum of 0 though. When that happens you can just assume that the procedure was canceled/deleted before it was fully added and the procedure itself can...
by allends
Mon Oct 30, 2023 9:59 am
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3992

Re: Deprecation of PayPlans POST

I am unsure of what this process has to do with the deprecation of Patient Payment Plans. I am not following how the process of making a payment plan has anything to do with taking payment for a statement. Developers using the XML file from a statement to attempt to discern which procedures a patien...
by allends
Fri Oct 27, 2023 1:54 pm
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3992

Re: Deprecation of PayPlans POST

Saskia, It is not clear to me what exactly you are trying to do in your program in regards to payment plans, but I will attempt to address some concerns that I believe you might have. As for the other scenario - I don't understand. How will PayPlanCharges GET help us (no plan has been created yet) S...
by allends
Tue Jul 25, 2023 1:24 pm
Forum: Advanced Topics
Topic: Procedure notes bug -> OD 23.1.32
Replies: 5
Views: 2449

Re: Procedure notes bug -> OD 23.1.32

There appears to be bug when I edit a procedure note in the chart. When I double-click to edit the note, the default note is appended to the end of my edited note when I click 'OK' Thanks. Version 23.1.33 has a fix for this and will be released today. FYI, there also appears to be a bug when printi...
by allends
Thu Jul 20, 2023 10:01 am
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3865

Re: Is it safe to always trust the aging data in the patient table?

I am assuming that you are wanting to use this data to create claims or perform actions through the API. If your users are doing non-account related actions in Open Dental (Adding procedures, completing procedures, updating procedures, etc...) and then performing financial actions in your software, ...
by allends
Wed Jul 19, 2023 2:17 pm
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3865

Re: Is it safe to always trust the aging data in the patient table?

How did you perform step #2 and step #4?
by allends
Thu Jul 13, 2023 10:15 am
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3865

Re: Is it safe to always trust the aging data in the patient table?

Aging has the possibility of being inaccurate in some rarer circumstances, but the overwhelming majority of the time it will be correct.
Relying on that data is probably safe for the most part, but there are always going to be exceptions to the rule.
by allends
Fri May 12, 2023 1:32 pm
Forum: API
Topic: Patient merge
Replies: 2
Views: 2522

Re: Patient merge

Open Dental does not plan on giving the ability for API developers to directly utilize Open Dental features in their programs. The purpose of the Open Dental API (and most APIs for that matter) is to provide access to data so it can be read or manipulated. It is not intended to allow open access to ...
by allends
Mon Apr 24, 2023 8:40 am
Forum: Developers
Topic: "Sign in to Microsoft" button error in Edit Email Address screen
Replies: 5
Views: 3941

Re: "Sign in to Microsoft" button error in Edit Email Address screen

You are correct. Open Dental does not support replacing our Microsoft token with a 3rd party Microsoft token.
by allends
Wed Apr 19, 2023 8:59 am
Forum: Main Forum
Topic: Spell Check and screen scrolling
Replies: 2
Views: 3855

Re: Spell Check and screen scrolling

This occurs if you have your text cursor has not been set in the textbox (You have not left-clicked into the textbox). The default behavior is that it will reload the text while maintaining visibility on your selected location, but since you do not have a selected location yet, it will be moved the ...
by allends
Thu Apr 13, 2023 9:54 am
Forum: Developers
Topic: "Sign in to Microsoft" button error in Edit Email Address screen
Replies: 5
Views: 3941

Re: "Sign in to Microsoft" button error in Edit Email Address screen

It is not possible to call some of our dlls using another application.
We use a proprietary method of connecting to Microsoft, as required by Microsoft.
You would need to go through the same process, and build that into your application, in order to email through your app.
by allends
Wed Mar 22, 2023 3:04 pm
Forum: Main Forum
Topic: Account Balance Bug
Replies: 6
Views: 4739

Re: Account Balance Bug

It would be difficult to troubleshoot this issue in this medium.
Our support staff would be able to help investigate this issue to find the underlying cause. I recommend give us a support call.
https://www.opendental.com/contact.html
by allends
Thu Mar 09, 2023 10:49 am
Forum: API
Topic: Use OpenDental credentials to log into website?
Replies: 3
Views: 1504

Re: Use OpenDental credentials to log into website?

As SLeon stated, we recommend our 3rd party developers create their own login systems so they can manage the credentials (reset password, forgotten passwords, sign in attempts, etc.). We do not have any plans of allowing developers to verify unknown credentials against the Open Dental database to ch...
by allends
Thu Mar 02, 2023 9:58 am
Forum: Advanced Topics
Topic: Stack trace:
Replies: 2
Views: 3347

Re: Stack trace:

Is this error still occurring?
by allends
Thu Mar 02, 2023 8:31 am
Forum: API
Topic: Missing Problem Section Info in Medical History
Replies: 1
Views: 1094

Re: Missing Problem Section Info in Medical History

Problems are called Diseases in the schema.
Diseases are attached to patients.
DiseaseDefs are the templates for creating Diseases.

https://www.opendental.com/site/apidiseases.html
by allends
Mon Feb 20, 2023 8:22 am
Forum: API
Topic: Email and text functions via API
Replies: 5
Views: 1593

Re: Email and text functions via API

Open Dental currently has no plan to create a feature to allow 3rd party services to send texts using our eServices texting service. If we opened up our texting infrastructure to 3rd party use, it is highly unlikely that we would allow them to text using the numbers that we have registered with cam...
by allends
Fri Jan 20, 2023 8:34 am
Forum: Advanced Topics
Topic: Help with Query
Replies: 2
Views: 3795

Re: Help with Query

Your query is pretty close to selecting all the information you need. I have edited the query to add in a select for the fee.Amount as well as a couple of Where-clause additions to narrow down your fee to the clinic and provider default (0 clinic/prov). If you need provider and clinic overrides, jus...
by allends
Wed Sep 21, 2022 4:25 pm
Forum: Developers
Topic: ReportingForRDL folder missing
Replies: 10
Views: 5273

Re: ReportingForRDL folder missing

After discussing this feature further, we are going to be to add the code back to the program.
Since the feature is still marked as deprecated, it is not guaranteed to remain in the program forever.
I recommend attempting to move your reports to a different reporting method over time.
by allends
Mon Sep 19, 2022 10:16 am
Forum: Developers
Topic: ReportingForRDL folder missing
Replies: 10
Views: 5273

Re: ReportingForRDL folder missing

Custom Reports have been deprecated for many years. https://www.opendental.com/manual174/reports.html https://www.opendental.com/manual214/reports.html Due to their deprecated status and the issues we have had with upkeeping the system, it was decided that the system should be removed from the code....
by allends
Tue Sep 06, 2022 9:30 am
Forum: Developers
Topic: Web Forms retrieval locale issue
Replies: 7
Views: 5572

Re: Web Forms retrieval locale issue

As of January 14th, 2020, Microsoft dropped support for Windows 7.
Any versions of OpenDental released after that date are not supported for, or intended to work on, Windows 7.
https://www.opendental.com/site/compute ... ments.html
by allends
Tue Aug 23, 2022 9:06 am
Forum: API
Topic: API Performance Suggestions
Replies: 13
Views: 3964

Re: API Performance Suggestions

You should be able to update to the beta now.
Please try again and let me know if you are still experiencing the issue.
by allends
Thu Jul 14, 2022 2:08 pm
Forum: Advanced Topics
Topic: Creating tables and triggers in the Open Dental database
Replies: 4
Views: 4697

Re: Creating tables and triggers in the Open Dental database

Where does Open Dental stand on 3rd parties adding tables and triggers in the Open Dental database? I have read in the documentation somewhere that it is no problem. Is that still the case? https://opendental.com/manual/plugins.html As you quoted from that page: If the plug-in makes use of extra da...
by allends
Thu Mar 31, 2022 8:57 am
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

Re: Custom Query for Discount Plan

This query is closer to what you are looking for ssebree. It is found on this page: https://opendentalsoft.com:1943/ODQueryList/QueryList.aspx /*1575 Patients with discount plans. For versions 20.5+*/ /*---------------------DO NOT MODIFY BELOW THIS LINE----------------------*/ /*Query code written/m...
by allends
Tue Mar 29, 2022 3:18 pm
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

Re: Custom Query for Discount Plan

Ssebree, There are a large number of online resources for learning SQL. Open Dental does not endorse any particular one, but Google is a great resource for finding them. Here are a couple helpful links to put what you learn about SQL into practice with Open Dental's schema: https://www.opendental.co...
by allends
Thu Mar 24, 2022 11:20 am
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

Re: Custom Query for Discount Plan

ssebree, I removed the duplicate posts in the other forums to keep answers focused in a single thread. Open Dental has a team dedicated to this, but we are not currently taking query requests. This may change in the future as staffing improves. Check this link later and it may be open for new reques...
by allends
Wed Mar 16, 2022 10:08 am
Forum: Main Forum
Topic: Sheet - image field max height is 4000
Replies: 5
Views: 3216

Re: Sheet - image field max height is 4000

The maximum value for static image height and width was last changed on 12/9/2014. The maximum value was changed from 2000 to 4000 as part of a change to allow statements to use sheets. There does not appear to be a time from 2008 to today that Open Dental has ever allowed a singular static image to...
by allends
Fri Feb 04, 2022 10:40 am
Forum: Developers
Topic: Standard Report Syntax Question
Replies: 4
Views: 5434

Re: Standard Report Syntax Question

You will want to look at paysplits instead of payments.
Total payment amounts should match total paysplit amounts, but there are times when that may not be the case (3rd parties, data corruption, old conversion data, etc.)
by allends
Fri Feb 04, 2022 8:23 am
Forum: Developers
Topic: Standard Report Syntax Question
Replies: 4
Views: 5434

Re: Standard Report Syntax Question

I recommend using the Claimproc table instead of the Claim table. SET @FromDate='2022-1-1' , @ToDate='2022-1-31'; SELECT SUM(InsPayAmt) FROM claimproc WHERE ClinicNum =1 AND DateReceived BETWEEN @FromDate AND @ToDate AND InsPayAmt != 0; That should get you the same insurance info used in the Product...
by allends
Fri Dec 31, 2021 9:13 am
Forum: Main Forum
Topic: Query for Active patients with first visit before date
Replies: 3
Views: 2600

Re: Query for Active patients with first visit before date

I recommend calling Open Dental for help then. They will be able to walk through the query with you for the context of your database. You could also try this query (If it is still empty, you may want to adjust your min date): SELECT patient.LName,patient.FName,MIN(procedurelog.ProcDate) DateFirstVis...
by allends
Thu Dec 30, 2021 9:39 am
Forum: Main Forum
Topic: Query for Active patients with first visit before date
Replies: 3
Views: 2600

Re: Query for Active patients with first visit before date

Is this more accurate? I added another column for most recent date and removed the procedures with MinVal dates. SELECT patient.LName,patient.FName,patient.DateFirstVisit,MAX(procedurelog.ProcDate) DateMostRecent FROM patient INNER JOIN procedurelog ON patient.patnum=procedurelog.PatNum WHERE patien...
by allends
Fri Nov 19, 2021 8:05 am
Forum: Main Forum
Topic: Adjustments linked to treatment planned procedures.
Replies: 4
Views: 3800

Re: Adjustments linked to treatment planned procedures.

https://www.opendental.com/manual/treat ... ounts.html

I believe this is the feature you are looking for. Discounts will create adjustments when the procedure is completed and will allow you to show the correct value on the treatment plan.
by allends
Wed Nov 10, 2021 11:10 am
Forum: Main Forum
Topic: color procedure changes
Replies: 7
Views: 5217

Re: color procedure changes

Then you would most likely want feature request #153. Feel free to add votes to this request if it would meet your needs.

https://www.opendental.com/manual/featurerequests.html
by allends
Wed Nov 10, 2021 9:01 am
Forum: Main Forum
Topic: color procedure changes
Replies: 7
Views: 5217

Re: color procedure changes

https://www.opendental.com/manual/proce ... eedit.html

The Color Override in that window is most likely what you want.
by allends
Fri Oct 08, 2021 12:40 pm
Forum: API
Topic: Pattern
Replies: 2
Views: 4302

Re: Pattern

https://www.opendental.com/OpenDentalDocumentation21-3.xml#appointment You are correct that the pattern is to determine what work is done when, to an extent. The description for that column is as follows: Time pattern, X for Dr time, / for assist time. Stored in 5 minute increments. Converted as ne...
by allends
Wed Sep 08, 2021 4:18 pm
Forum: Developers
Topic: API - Documents question
Replies: 5
Views: 5536

Re: API - Documents question

https://www.opendental.com/OpenDentalDo ... definition
Yes, the definition category is an enumeration that we will not repurpose or reorder so it can be considered reliable.
by allends
Mon Aug 02, 2021 4:35 pm
Forum: Main Forum
Topic: Appointment View Edit > Available Rows
Replies: 4
Views: 5147

Re: Appointment View Edit > Available Rows

It isn't as automated as the referrals system, but in the meantime you could create a patient field to store the referral info for a patient.
The patient field could be added to the appointments via the Appointment Views.
https://www.opendental.com/manual/custo ... ields.html
by allends
Tue Jul 20, 2021 8:42 am
Forum: Main Forum
Topic: decrease font size
Replies: 1
Views: 4213

Re: decrease font size

This page should help address your font size issue.
https://www.opendental.com/manual/zoom.html
by allends
Tue Jul 13, 2021 9:15 am
Forum: Main Forum
Topic: 3shape Bridge
Replies: 4
Views: 7517

Re: 3shape Bridge

Which version are you on?
by allends
Thu Jul 08, 2021 10:18 am
Forum: Main Forum
Topic: Should I change to Open Dental?
Replies: 4
Views: 6689

Re: Should I change to Open Dental?

I recommend joining this Facebook group:
https://www.facebook.com/groups/opendentalusersgroup

There are a lot of active users there that will be able to give you feedback on Open Dental.
by allends
Wed Jun 30, 2021 8:54 am
Forum: Main Forum
Topic: Unallocated Income Report
Replies: 1
Views: 3600

Re: Unallocated Income Report

These unearned income reports would be a good starting point to help find the information you need.
https://www.opendental.com/manual/repor ... ncome.html
by allends
Tue Jun 29, 2021 10:28 am
Forum: Developers
Topic: Cannot access API forum
Replies: 3
Views: 6736

Re: Cannot access API forum

You should be able to access the forum now.
by allends
Thu Apr 15, 2021 10:06 am
Forum: Main Forum
Topic: Appointment restrictions
Replies: 3
Views: 6135

Re: Appointment restrictions

Another option that you could try is to use an operatory for that procedure code.
Schedule the appointment in the operatory for the procedure code (indicating the tools are in use) and then add a blockout to the corresponding operatory the patient will be seated in.
by allends
Mon Mar 15, 2021 1:04 pm
Forum: Main Forum
Topic: Separate patients from insurance plans they are no longer attached to
Replies: 12
Views: 12566

Re: Separate patients from insurance plans they are no longer attached to

Are you attempting to enter into the total votes section?
There should be a section above that labeled "My Votes". That section should allow you enter points as well as show you the number of points remaining your office has available.
by allends
Thu Mar 04, 2021 2:36 pm
Forum: Main Forum
Topic: Lost Registration Key
Replies: 2
Views: 4514

Re: Lost Registration Key

Laurel,
If you give our support team a call at 503-363-5432, we would be happy to assist you with getting your original registration key.
by allends
Thu Jan 14, 2021 9:40 am
Forum: Developers
Topic: Insurance hook
Replies: 1
Views: 5945

Re: Insurance hook

Moved to the Developer Forum
by allends
Wed Dec 30, 2020 3:10 pm
Forum: Main Forum
Topic: Calculating Associate's Production
Replies: 2
Views: 3598

Re: Calculating Associate's Production

We do not recommend that you change the codes to "non-hygiene" codes. That will most likely cause you more hassle in the future. The best course of action would be to call our support team at 503-363-5432 and get in touch with our query department. It is likely that we already have a collections que...
by allends
Thu Dec 03, 2020 3:54 pm
Forum: Developers
Topic: How to link Payment to PayPlan in database
Replies: 2
Views: 5972

Re: How to link Payment to PayPlan in database

In the grand scheme of things Payments don't really have a lot of financial weight in the program.
What you are looking for are PaySplits
https://www.opendental.com/OpenDentalDo ... l#paysplit
by allends
Fri Nov 20, 2020 9:49 am
Forum: Advanced Topics
Topic: compile 20.3 under VS2019
Replies: 23
Views: 26205

Re: compile 20.3 under VS2019

jfd2, If you want to self-compile and not have this problem happen a lot of the time or have to go through the hassle of constantly monitoring what queries and features are getting added to the convert script, then I recommend updating to commits that have specific versions noted in the commit log m...
by allends
Mon Nov 09, 2020 10:55 am
Forum: Main Forum
Topic: New Care Credit Integration Setup Problem
Replies: 13
Views: 12913

Re: New Care Credit Integration Setup Problem

Dr Fuchs, The Bridges.dll is available to all customers who have a current support contract since we package it with our updates. The Bridges.dll has code that tells CareCredit that Open Dental is making the call to them, it poses a significant security risk for us to allow non-authorized versions o...
by allends
Thu Sep 03, 2020 3:05 pm
Forum: Main Forum
Topic: Checking Frequencies or Issues Before Financial Arrangement
Replies: 8
Views: 13267

Re: Checking Frequencies or Issues Before Financial Arrangement

Here is a link to our manual describing how to setup and use the frequency limitation system.
https://www.opendental.com/manual203/in ... tions.html
by allends
Thu Sep 03, 2020 11:18 am
Forum: Developers
Topic: How to click a OpenDental.UI.ODToolBar.ODToolBarButton?
Replies: 4
Views: 6521

Re: How to click a OpenDental.UI.ODToolBar.ODToolBarButton?

What is initiating this code that you want ran?
I may be misunderstanding, but you should be able to place your question into the hook in the payment click.
Then you could open your custom form if they chose, or just let the normal payment window open.
by allends
Wed Sep 02, 2020 11:31 am
Forum: Developers
Topic: How to click a OpenDental.UI.ODToolBar.ODToolBarButton?
Replies: 4
Views: 6521

Re: How to click a OpenDental.UI.ODToolBar.ODToolBarButton?

The easiest method is going to be to add a hook to this method "toolBarButPay_Click" in ControlAccount.
That way you can pose a question to perform your logic when the customer clicks the Payment button.
by allends
Thu Aug 06, 2020 10:14 am
Forum: Main Forum
Topic: v20.3 broke Title Bar size
Replies: 4
Views: 5649

Re: v20.3 broke Title Bar size

Due to the most recent changes, we would be able to add the ability to change the Title Bar font size as a feature request.
There is currently no way to go back to using default windows behavior for drawing the title bar as of 20.3.X
by allends
Mon Aug 03, 2020 3:05 pm
Forum: Main Forum
Topic: Mass Email and Queries
Replies: 1
Views: 2937

Re: Mass Email and Queries

That sounds like a great feature request. It is uncommon for us to share future plans for features in OpenDental because we do not want to create unreasonable expectations or timelines. I do agree that the feature would benefit the overall usage of the mass email system though and I will look into t...
by allends
Thu Jul 02, 2020 10:01 am
Forum: Main Forum
Topic: Care Credit integration
Replies: 2
Views: 3484

Re: Care Credit integration

It is our policy to avoid discussing projects that are still in development.
We are not sure what version it will be completed and released in, but it will require an update to use when it is ready.
by allends
Mon Jun 08, 2020 1:57 pm
Forum: Main Forum
Topic: Add more selections to the Gender field.
Replies: 1
Views: 3052

Re: Add more selections to the Gender field.

This functionality is currently in available OpenDental by turning on the "Public Health" feature here: https://www.opendental.com/manual/showfeatures.html This will make an new tab available in the patient edit window that allows sexual orientation and gender identity to be stored. https://www.open...
by allends
Fri Mar 13, 2020 7:45 am
Forum: Main Forum
Topic: Possible bug in "Preview Claim" window
Replies: 2
Views: 6074

Re: Possible bug in "Preview Claim" window

What is your resolution set to?
by allends
Thu Dec 12, 2019 1:21 pm
Forum: Main Forum
Topic: Table of Contents
Replies: 4
Views: 7082

Re: Table of Contents

I mean is it every single window that opens the table of contents when pressing the '?' button?
The reason I ask is because that should only occur if the window you have open has not been correctly hooked up on our end, so knowing the specific windows will allow us to check.
by allends
Thu Dec 12, 2019 12:06 pm
Forum: Main Forum
Topic: Table of Contents
Replies: 4
Views: 7082

Re: Table of Contents

Are there specific forms that are not working or is it every form?
by allends
Fri Nov 01, 2019 1:12 pm
Forum: Developers
Topic: Preferences in Open Dental Business. (feature request?)
Replies: 2
Views: 14685

Re: Preferences in Open Dental Business. (feature request?)

Justin, OpenDental does not use enum values to reference the preference enum, we use the enum names. https://www.opendental.com/OpenDentalDocumentation19-3.xml#preference The PrefName column in that table is what the program uses as its "Primary" key. The code that you posted toothChart.SetToothNumb...
by allends
Mon Feb 04, 2019 4:03 pm
Forum: Main Forum
Topic: Discount Plan set up
Replies: 7
Views: 12092

Re: Discount Plan set up

The start date was not added as part of that request. I will look into creating another request for adding the start date and have the 5741 request changed to reflect what was actually completed. The plan showing in the appointment module is done and is available to edit in two places. The appointme...
by allends
Thu Dec 27, 2018 9:28 am
Forum: Developers
Topic: Changing payment sort order
Replies: 2
Views: 4366

Re: Changing payment sort order

To be clear, you are asking about changing code in FormRpPaySheet.cs to order differently correct? If so, the table which fills the Daily Payments report is filled in RpPaySheet. Which method you use is dependant on if you have selected providers or not. In our current HEAD version, this is what the...
by allends
Mon Dec 17, 2018 2:51 pm
Forum: Main Forum
Topic: TSI Collection Agency BAD experience reporting
Replies: 14
Views: 15456

Re: TSI Collection Agency BAD experience reporting

Happysapiensdental, I have looked into both issues and have solutions for each. Unearned income switching to earned We will be enhancing the payment window to not send to TSI if the income transfer box is checked and all of the splits are for the same family. Since you can only complete an income tr...
by allends
Wed Dec 12, 2018 11:50 am
Forum: Main Forum
Topic: TSI Collection Agency BAD experience reporting
Replies: 14
Views: 15456

Re: TSI Collection Agency BAD experience reporting

I will be taking a look at this more in-depth, but for now I would like to address a few of your concerns. I wonder why would open dental allow such a company to tie up with its software. TSI is an integration that is optional to our customers. We integrate and bridge to many different softwares, ma...
by allends
Mon Dec 10, 2018 9:40 am
Forum: Main Forum
Topic: Welcome Back
Replies: 9
Views: 12850

Re: Welcome Back

Getting to teach those young'uns about general relativity and whatnot!
by allends
Tue Dec 04, 2018 3:08 pm
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 5097

Re: Unearned income column

Currently there is no preference to set the box to unchecked by default.
Adding a new preference for this would be a feature request.

https://www.opendental.com/manual/featurerequests.html
by allends
Mon Dec 03, 2018 8:40 am
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 5097

Re: Unearned income column

https://www.opendental.com/manual183/reportprodinc.html

There is a checkbox below the providers list labeled "Include Unearned". Uncheck that box and the column will not show.
by allends
Wed Nov 28, 2018 10:19 am
Forum: Main Forum
Topic: Patient portal login issues.
Replies: 5
Views: 6164

Re: Patient portal login issues.

18.3.26 should be the fixed version.
I would call in to support. We should be able to help troubleshoot this issue.
by allends
Tue Nov 27, 2018 4:20 pm
Forum: Main Forum
Topic: Patient portal login issues.
Replies: 5
Views: 6164

Re: Patient portal login issues.

If you update to the latest build of your current version then this should be fixed.
by allends
Tue Nov 13, 2018 1:40 pm
Forum: Developers
Topic: mySQL query problem
Replies: 2
Views: 4182

Re: mySQL query problem

I run a customized query in mySQL workbench to get all appointment for certain day, however I can NOT get all appointments. Most likely MySQL Workbench has some kind of row limit on its return set. https://blog.sqlauthority.com/2014/01/12/mysql-change-the-limit-of-row-retrieved-in-mysql-workbench-2...
by allends
Wed Oct 17, 2018 12:11 pm
Forum: Advanced Topics
Topic: CEMT Security Log
Replies: 4
Views: 6777

Re: CEMT Security Log

I would add votes to feature request 6767. It details requests for security and permissions in the CEMT tool.
Additionally, I would add a comment detailing your desire for an Audit Trail in the CEMT tool.
https://www.opendental.com/manual/featurerequests.html
by allends
Wed Oct 17, 2018 9:45 am
Forum: Advanced Topics
Topic: CEMT Security Log
Replies: 4
Views: 6777

Re: CEMT Security Log

What I gather from your post is you would like the CEMT to have an audit trail correct?
by allends
Tue Jul 24, 2018 12:31 pm
Forum: Main Forum
Topic: 2017 Census
Replies: 6
Views: 8308

Re: 2017 Census

Apologies, I will attempt to sort this out today. Looking at our records it says we have a few attempts at correspondence with you. On 6/18, you should have received an email message regarding your request and a number associated with the request.(#8042). On 6/19, we attempted to call your office, b...
by allends
Mon Jul 09, 2018 3:45 pm
Forum: Developers
Topic: Find the User Who's Currently Logged In
Replies: 11
Views: 16999

Re: Find the User Who's Currently Logged In

They want utility writers to access the database through their interface instead of banging on the database yourself. That is exactly what the OpenDentBusiness.dll is for and we encourage you to use it for interfacing with the DB. Security.CurUser is not a database field though. That field needs th...
by allends
Wed Jun 27, 2018 7:43 am
Forum: Developers
Topic: Delete - sheet
Replies: 1
Views: 3672

Re: Delete - sheet

This bug has been fixed in 18.1.18.

http://opendentalsoft.com:1942/ODBugTra ... sions.aspx
18.1.18(beta)(foreign) Released 5/31/2018
18.1.18(beta) Released 5/31/2018

Deleting a patient exam sheet could cause an error
by allends
Tue Jun 19, 2018 12:05 pm
Forum: Developers
Topic: How Unsupported is MySQL 5.7?
Replies: 1
Views: 4003

Re: How Unsupported is MySQL 5.7?

I can understand why 5.7 isn't bundled in the main install, it can take a long time to debug every possibility... This is the main reason. At OpenDental, we choose to support versions of MySQL that we have tested against our current codebase. This allows us to fix potential problems before they rea...
by allends
Fri Jun 08, 2018 9:08 am
Forum: Developers
Topic: Plugin Distribution/Upgrade
Replies: 3
Views: 6106

Re: Plugin Distribution/Upgrade

1) It is up to the customer to install your plugin on each of their computers. They must first add the program link to OpenDental, fill in the plugin dll name, and then enable it so your dll can be loaded. The stock programs are usually bridges, not plugins. 2) There are multiple ways to update plug...
by allends
Fri Jun 08, 2018 8:40 am
Forum: Developers
Topic: Identifier for Open Dental Installation
Replies: 3
Views: 5458

Re: Identifier for Open Dental Installation

Nearly every preference in FormPractice should help to identify a database somewhat uniquely. If you are fine with human entered info then that would be the best choice.
by allends
Wed May 02, 2018 12:12 pm
Forum: Main Forum
Topic: Treatment Plan - Odd Behavior
Replies: 6
Views: 9705

Re: Treatment Plan - Odd Behavior

Hold Ctrl and click on rows to un-highlight them.
by allends
Wed May 02, 2018 7:49 am
Forum: Main Forum
Topic: Treatment Plan - Odd Behavior
Replies: 6
Views: 9705

Re: Treatment Plan - Odd Behavior

What version are you on?
Also you can't enter procedures from the Treatment Plan module. What exactly is your way of making this happen?
I would call support if you have seen that problem occur because it could be a bug.
by allends
Tue Apr 24, 2018 12:05 pm
Forum: Advanced Topics
Topic: Beta v 17.4.59 Error - Reports -pref
Replies: 10
Views: 17914

Re: Beta v 17.4.59 Error - Reports -pref

Thats strange. The code that inserts that is located in the same method and was committed before we released version 17.4.53. If you self-compile and update it is possible that you missed some of a convert script. When did you update past version 17.4.53? If it reached the end of the method/you had ...
by allends
Tue Apr 24, 2018 10:53 am
Forum: Advanced Topics
Topic: Beta v 17.4.59 Error - Reports -pref
Replies: 10
Views: 17914

Re: Beta v 17.4.59 Error - Reports -pref

Looks like you missed a convert script somehow.
What is the datatype for the GroupNum column on the Insplan table?
by allends
Mon Apr 16, 2018 8:56 am
Forum: Main Forum
Topic: Assignment of Benefits Confusion
Replies: 9
Views: 16730

Re: Assignment of Benefits Confusion

Weight is calculated by considering the request system as a whole.
You added votes to a job, but more votes/critical votes were added to another job, giving it more weight.
by allends
Mon Apr 16, 2018 8:44 am
Forum: Main Forum
Topic: Payment behavior changed
Replies: 3
Views: 4449

Re: Payment behavior changed

If you are on the latest stable version, I would call support. We have done a fair number of enhancements to that logic recently and our techs are very knowledgeable about the way the new system works. If all else fails, an engineer can look at your database and discern the issue so it can be fixed ...
by allends
Thu Apr 05, 2018 2:45 pm
Forum: Main Forum
Topic: Payment behavior changed
Replies: 3
Views: 4449

Re: Payment behavior changed

I assume that means you are scheduling your procedures so the primary provider is the hygienist. I recommend setting your operatories up so you are the Provider on the operatories and the hygienists in your office are marked as the Hygienist. http://www.opendental.com/manual/operatories.html This me...
by allends
Tue Feb 06, 2018 3:50 pm
Forum: Main Forum
Topic: payment report for primary provider
Replies: 7
Views: 10798

Re: payment report for primary provider

Payments are not directly connected to providers. http://www.opendental.com/OpenDentalDocumentation17-4.xml#payment That shows our current schema as of 17.4. Paysplits are OpenDental's way of connecting a singular payment to multiple providers/patients. If that query is not returning any rows after ...
by allends
Tue Feb 06, 2018 2:53 pm
Forum: Main Forum
Topic: payment report for primary provider
Replies: 7
Views: 10798

Re: payment report for primary provider

The query that David gave should give that information, but it is lacking in provider info. Here is a slightly updated version of that query. SELECT patient.PatNum, patient.LName, paysplit.DatePay, patient.PriProv PrimaryProv, paysplit.ProvNum PaymentProv FROM paysplit INNER JOIN patient ON paysplit...
by allends
Tue Feb 06, 2018 11:49 am
Forum: Main Forum
Topic: Warning of inactive pation
Replies: 6
Views: 10849

Re: Warning of inactive pation

You may want to vote on these feature requests. Choose the ones that best suit what you need http://www.opendental.com/manual/featurerequests.html Request #1700 - Inactive and archive status patients show different color in select patient window Request #5162 - Prevent setting appointments complete ...
by allends
Mon Nov 20, 2017 12:17 pm
Forum: Main Forum
Topic: eConfirm, eRemind
Replies: 5
Views: 13278

Re: eConfirm, eRemind

https://www.facebook.com/groups/OpenDentalUsers/
This is not curated or maintained by OpenDental Software, but it is a very good place to go and get peer assistance on issues involving OpenDental or your practice.
by allends
Mon Nov 20, 2017 8:20 am
Forum: Main Forum
Topic: Patient Picture
Replies: 7
Views: 10908

Re: Patient Picture

It is not being utilized because we support a variety of different monitor resolutions. Our minimum size supported resolution as of 17.1 is 1280 x 768, but prior to that, the chart module was designed for 1024 x 768 resolution. http://opendental.com/manual/version17_1.html Re-designing the chart (or...
by allends
Thu Sep 07, 2017 10:00 am
Forum: Advanced Topics
Topic: 17.3
Replies: 2
Views: 5923

Re: 17.3

We haven't fully released it yet. There are still a few things being finished up for the final release.
by allends
Wed Sep 06, 2017 1:09 pm
Forum: Main Forum
Topic: Procedure code Default Notes
Replies: 2
Views: 6608

Re: Procedure code Default Notes

Dr. Hersh, I think I have a solution for you that you will be quite pleased with. 1. In 17.2 there is a feature for adding default TP notes. This note is completely separate to the completed procedure note (which is the current functionality in 17.1). 2. As Chris said, this is the way that feature i...
by allends
Wed Jun 14, 2017 12:56 pm
Forum: Developers
Topic: Trouble Compiling 16.4
Replies: 13
Views: 32197

Re: Trouble Compiling 16.4

You need to move the Hunspellx64.dll and Hunspellx86.dll from the Required dlls folder into the bin folder of the debug environment for the version you are running.
by allends
Fri Jun 09, 2017 5:07 pm
Forum: Main Forum
Topic: Discount plan questions for OD team
Replies: 16
Views: 28406

Re: Discount plan questions for OD team

It doesn't really matter who requested it because features are treated the same regardless of who requests them. "...but the real problem is the complication of actually adding this to our insurance logic. Every change to that logic presents possible bugs with a feature that should be pristine. It m...
by allends
Thu Jun 08, 2017 8:05 am
Forum: Main Forum
Topic: Discount plan questions for OD team
Replies: 16
Views: 28406

Re: Discount plan questions for OD team

What you described covers the scenario in which you would want to discount every procedure regardless of insurance, but it has been requested that the feature allow only discounting procedures that the insurance will not cover. That specific feature has problems, but the real problem is the complica...
by allends
Tue Jun 06, 2017 12:14 pm
Forum: Main Forum
Topic: Discount plan questions for OD team
Replies: 16
Views: 28406

Re: Discount plan questions for OD team

Coordinating benefits with discount plan coverage is very difficult. Essentially a Discount Plan would need to be treated like an insurance plan in the program. This means that our logic that calculates insurance estimates would need to be enhanced to consider this new "type" of insurance plan. Ther...
by allends
Fri May 26, 2017 7:42 am
Forum: Main Forum
Topic: Glitch
Replies: 3
Views: 8184

Re: Glitch

Have you called support?
by allends
Tue May 23, 2017 8:57 am
Forum: Main Forum
Topic: override context menu and add new menuItem
Replies: 15
Views: 27629

Re: override context menu and add new menuItem

So I assume you copied the code from ContrApptSheet2_MouseDown into the plugin and are just adding in a small bit of code to add a menu item correct?
I don't see how that would fail if you made you code similarly to the way the existing code looks.
by allends
Mon May 01, 2017 8:15 am
Forum: Developers
Topic: Additional properties for a custom plugin
Replies: 3
Views: 8638

Re: Additional properties for a custom plugin

If I was going to go about this I would just give them a setup window from somewhere in the program that they could set their own custom preferences.
I would store those in either my own MySQL table or an XML file depending on if they were workstation or database specific.
by allends
Wed Mar 29, 2017 8:10 am
Forum: Main Forum
Topic: 17.1 Tooth Chart Slider = Awesome!
Replies: 4
Views: 8578

Re: 17.1 Tooth Chart Slider = Awesome!

The tooth chart slider is in 17.1 and will be available with the next major release
teethdood most likely built his own version of OD from source code to test that feature.
by allends
Mon Mar 06, 2017 11:08 am
Forum: Developers
Topic: Forms colors and icons
Replies: 5
Views: 13173

Re: Forms colors and icons

I need a bit more information to give you a definitive answer. In the meantime this should cover most of the basics. If you are building your own version of opendental then it is as simple as using the Visual Studio interface to change the form properties that you wish to change. https://msdn.micros...
by allends
Tue Feb 28, 2017 8:08 am
Forum: Developers
Topic: Plugin Deployment process
Replies: 12
Views: 23601

Re: Plugin Deployment process

No. Currently 16.3.X is our stable version. That changes with each major release cycle (Major releases being 16.4.1 or 17.1.1).
16.4.X will be moved to be our stable version when we release 17.1.1 as our beta version.
by allends
Tue Feb 28, 2017 7:35 am
Forum: Developers
Topic: Plugin Deployment process
Replies: 12
Views: 23601

Re: Plugin Deployment process

Our beta is moved to stable when the next beta is released. We generally strive to have a fairly rapid release schedule, but no time has yet been set for our next release date.
That said we try to not go longer than three months between versions.
by allends
Thu Feb 16, 2017 1:44 pm
Forum: Main Forum
Topic: Payment plan question
Replies: 1
Views: 4113

Re: Payment plan question

We have released a new version of payment plans that actually includes the balances on the account.
http://opendental.com/manual/paymentplan.html

This should clear up your confusion with the old payment plan system.
by allends
Wed Feb 15, 2017 9:50 am
Forum: Advanced Topics
Topic: OD 16.4.22: InsBenBWCodes is an invalid pref name
Replies: 6
Views: 9186

Re: OD 16.4.22: InsBenBWCodes is an invalid pref name

Are you building and running through visual studio in debug mode?
If so, you most likely have a WebServiceServerName set.

Code: Select all

SELECT * FROM preference WHERE PrefName LIKE '%WebServiceServerName%';
If that query returns a value then you need to attempt to update the db from that computer first.
by allends
Thu Feb 09, 2017 3:41 pm
Forum: Developers
Topic: cellFontSize private to public on ODGrid?
Replies: 13
Views: 25914

Re: cellFontSize private to public on ODGrid?

private Font _titleFont=new Font(FontFamily.GenericSansSerif,8.5f,FontStyle.Bold); <------------- private Font _headerFont=new Font(FontFamily.GenericSansSerif,8.5f,FontStyle.Bold); <-------------- private Font _cellFont=new Font(FontFamily.GenericSansSerif,8.5f); These have been uncommented and ma...
by allends
Wed Jan 25, 2017 4:31 pm
Forum: Developers
Topic: Plugin Deployment process
Replies: 12
Views: 23601

Re: Plugin Deployment process

These hooks have been committed to 16.4.19

Code: Select all

Plugins.HookAddCode(this,"FormApptEdit.Load_end3",AptCur,pat);
This hook was committed for Hook 1. If this is not what you need then let me know.
by allends
Mon Jan 23, 2017 2:36 pm
Forum: Developers
Topic: Plugin Deployment process
Replies: 12
Views: 23601

Re: Plugin Deployment process

This is a lengthy list and I will try to be as thorough as possible when addressing each of these hooks. First, I will not that line numbers are generally a bad way to reference locations you want code inserted since our code is constantly changing. It is good that you added the line description you...
by allends
Tue Jan 17, 2017 10:39 am
Forum: Developers
Topic: New Hook Request for Cameras!
Replies: 4
Views: 12378

Re: New Hook Request for Cameras!

I added this hook

Code: Select all


			if(Plugins.HookMethod(this,"ContrImages.ToolBarImport_Click_Start",PatCur)) {
				FillDocList(true);
				return;
			}
to the import button click and made the FillDocList public.

Both of those will be available in 16.4.15 when it is released.
by allends
Mon Jan 09, 2017 8:07 am
Forum: Main Forum
Topic: Scan EOB when No insurance payment is made
Replies: 12
Views: 22161

Re: Scan EOB when No insurance payment is made

Feature Requests 2883 and 2605 are both complete and will be available with the release of 17.1
by allends
Thu Jan 05, 2017 5:26 pm
Forum: Developers
Topic: New Hook Request for Cameras!
Replies: 4
Views: 12378

Re: New Hook Request for Cameras!

Do you need these hooks if I make the FillDocList public?
Also does the Scan Click hook need to return right there or can it be a hook add method?
by allends
Mon Dec 19, 2016 8:23 am
Forum: Developers
Topic: Plugin Deployment process
Replies: 12
Views: 23601

Re: Plugin Deployment process

Plug-in hooks are requested here, in the developers forum. Once I have looked them over to make sure they conform to our patterns, I place them into our latest beta version and they will be available for the next release. As for plug-ins themselves, we do not add them to the program or our release p...
by allends
Thu Dec 08, 2016 10:07 am
Forum: Main Forum
Topic: Procedures selecting themselves?
Replies: 4
Views: 8424

Re: Procedures selecting themselves?

Calling support may be the best bet.
We could see if we can fix the problem and if not, then we can get a copy of your db to help us pinpoint the bug in the program.
by allends
Tue Aug 16, 2016 12:57 pm
Forum: Developers
Topic: New Hook Request
Replies: 3
Views: 9225

Re: New Hook Request

This hook has been added to 16.2.43 and will be available with the next release.
by allends
Thu Jul 28, 2016 8:49 am
Forum: Main Forum
Topic: Date field adjustment
Replies: 5
Views: 12646

Re: Date field adjustment

What version of Opendental are you using?
by allends
Wed Jul 27, 2016 12:16 pm
Forum: Advanced Topics
Topic: Ding!
Replies: 2
Views: 6161

Re: Ding!

It is not part of our current coding patterns to use "Enter" as an accept key.
The *ding sound you are hearing is windows notifying you that you cannot create a new line in a single line textbox.
by allends
Mon Jul 25, 2016 10:35 am
Forum: Main Forum
Topic: Print progress notes
Replies: 1
Views: 5018

Re: Print progress notes

Right click the Progress Notes grid. It should be an option there,
by allends
Tue Jul 12, 2016 2:46 pm
Forum: Developers
Topic: Hook request
Replies: 6
Views: 13661

Re: Hook request

The remaining hooks have been added to 16.2.30.
by allends
Tue Jun 28, 2016 3:04 pm
Forum: Developers
Topic: Hook request
Replies: 6
Views: 13661

Re: Hook request

Both of these hooks have been added and released in 16.2.25.
by allends
Fri Jun 17, 2016 7:16 am
Forum: Main Forum
Topic: Printing reports in landscape mode
Replies: 2
Views: 5736

Re: Printing reports in landscape mode

Currently there is no way to switch between portrait and landscape mode when viewing reports in the program.

What reports are you specifically having trouble with?
by allends
Tue May 03, 2016 4:28 pm
Forum: Developers
Topic: HookAddCode Request
Replies: 2
Views: 6242

Re: HookAddCode Request

I have added this hook to version 16.1.21 and it will be available with the next release.
by allends
Mon May 02, 2016 8:58 am
Forum: Advanced Topics
Topic: CEMT command line and plugins
Replies: 1
Views: 4833

Re: CEMT command line and plugins

1) Do you foresee (or are there already) command line options for the CEMT? It would be great if I could fire up the CEMT feeding it a phone number at the command line, and after logging in the search results are presented. There are currently no Command Line arguments for the CEMT. Suggestions suc...
by allends
Thu Apr 21, 2016 12:27 pm
Forum: Main Forum
Topic: Is changing display box size possible?
Replies: 1
Views: 4051

Re: Is changing display box size possible?

In Family Module - the Recall box - we'd love it to have at least 4 lines so we don't have to scroll to see Prophy/FMX/4BW/Pano due dates. This would require squeezing the Patient Information and Insurance Plan grids. It wouldn't be too difficult to add, but it could adversely affect some customers...
by allends
Mon Mar 21, 2016 4:39 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

Without seeing the actual problem in the database, I can only think that the paysplit was attached to a patient from a different family. It sounds like you were able to query the exact payment. If the paysplit patnum is different than the patnum that you are really expecting, then that is most likel...
by allends
Mon Mar 21, 2016 7:07 am
Forum: Main Forum
Topic: CEMT 15.4.40 Web Services bug
Replies: 3
Views: 7759

Re: CEMT 15.4.40 Web Services bug

Actually there is. I will share a bit of a secret. ... In version 16.2, we have added the ability for the CEMT to be hosted through the middle tier service now. It will allow an office to organize a CEMT without having a direct connection to the server constantly. As for the problem in 15.4.40, I wi...
by allends
Fri Mar 18, 2016 4:44 pm
Forum: Main Forum
Topic: Appointments Disappeared - not recorded in Audit Log
Replies: 13
Views: 14027

Re: Appointments Disappeared - not recorded in Audit Log

I was able to track the issue back to 15.4. Most likely, why this hasn't been a huge issue is because two workstations would need to be on the same patient, editing/adding an appointment, at the same time. Or, as Travis stated, they would need to leave an Edit Appointment window open for a long enou...
by allends
Fri Mar 18, 2016 7:45 am
Forum: Main Forum
Topic: Appointments Disappeared - not recorded in Audit Log
Replies: 13
Views: 14027

Re: Appointments Disappeared - not recorded in Audit Log

The problem really only occurred when two different workstations were adding or editing and appointment at the same time, for the same patient. I hope it isn't happening too often. Since the appointment is deleted, there is no real way for us to bring it back. We wouldn't know what it looked like be...
by allends
Thu Mar 17, 2016 3:07 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 problem has been found and will be fixed with the next release.
by allends
Thu Feb 25, 2016 7:02 am
Forum: Developers
Topic: Hook Request
Replies: 1
Views: 5101

Re: Hook Request

These hooks have been added to the program and will be available with the release of 16.1.3.
by allends
Tue Feb 16, 2016 10:37 am
Forum: Developers
Topic: HookAddCode Request
Replies: 6
Views: 14348

Re: HookAddCode Request

This has been added to 15.4.31. I changed a few names to better follow our patterns. try { if(Plugins.HookMethod(this," FormSmsTextMessaging.butReply_Click_sendSmsSingle ",patNum,mobileNumber,textReply.Text,YN.Yes)) { goto HookSkipSmsCal l; } SmsToMobiles.SendSmsSingle(patNum,mobileNumber,textReply....
by allends
Wed Jan 27, 2016 8:10 am
Forum: Main Forum
Topic: ? of reports bug in V 15.3.44.0
Replies: 1
Views: 4004

Re: ? of reports bug in V 15.3.44.0

This is fixed as of 15.3.45 and will be released shortly.
by allends
Thu Dec 10, 2015 6:51 am
Forum: Advanced Topics
Topic: CEMT: table opendental.jobrole doesn't exist
Replies: 3
Views: 6586

Re: CEMT: table opendental.jobrole doesn't exist

A fix has been committed for this and will be released in 15.4.8
by allends
Wed Dec 09, 2015 12:02 pm
Forum: Main Forum
Topic: Insurance Aging Report
Replies: 14
Views: 22254

Re: Insurance Aging Report

Does this SQL Query start at this /*Modified 1071 List of outstanding PPO claims excluding specific carriers*/ /*Query code written/modified: 12/04/2015*/ SET @CarriersToExclude="Alliance Medical|Moda Insurance";/*Enter carriers separated by a pipe ('|' without the quotes). To see all leave blank a...
by allends
Wed Dec 09, 2015 7:19 am
Forum: Main Forum
Topic: Insurance Aging Report
Replies: 14
Views: 22254

Re: Insurance Aging Report

That is an SQL query. It runs in the User Query section of OpenDental and outputs information from the database. If you go to Reports>User Query, you will see a box at the top you can paste this in. After that, hit the "Submit Query" button and you will see you information displayed in the bottom ha...
by allends
Tue Dec 08, 2015 2:53 pm
Forum: Advanced Topics
Topic: Patients list refresh while typing
Replies: 3
Views: 6826

Re: Patients list refresh while typing

I see how that could be confusing. Adding the "showing 40 out 52 results" comment would be a feature request. If it garners some attention it will get done.
by allends
Tue Dec 08, 2015 12:03 pm
Forum: Advanced Topics
Topic: Patients list refresh while typing
Replies: 3
Views: 6826

Re: Patients list refresh while typing

This is an intentional feature. If you had 50000 patients in your database and the grid didn't limit itself, the grid would initially load with 50000 rows. From there, every letter you typed would go and get a subset of that 50000 from the database and display them on the screen. This would be unbea...
by allends
Thu Nov 19, 2015 7:56 am
Forum: Main Forum
Topic: Unable to Edit Quick Buttons
Replies: 2
Views: 5460

Re: Unable to Edit Quick Buttons

Tthe ability to edit Procedure Buttons was added in 14.3.1. If you update to the latest stable version, the instructions on the website should be correct.
by allends
Wed Nov 18, 2015 9:33 am
Forum: Developers
Topic: Hooks for custom plugins
Replies: 8
Views: 13831

Re: Hooks for custom plugins

Yes, the commit shows on our bug tracker as:
Plugin Hooks, added hooks to a couple patient windows.
by allends
Tue Nov 10, 2015 9:57 am
Forum: Main Forum
Topic: Email to patient after a referral
Replies: 8
Views: 13583

Re: Email to patient after a referral

A preference for turning this feature off will be available in 15.4.
It will be located in EHR settings and will default to on if you have EHR turned on at the time of updating.
by allends
Thu Oct 29, 2015 9:27 am
Forum: Developers
Topic: Hooks for custom plugins
Replies: 8
Views: 13831

Re: Hooks for custom plugins

My apologies, I must have missed this when you responded. I can get all of these into the next version of 15.3, but I have made a few changes shown in bold. OpenDental.FormPatientAddAll: if(Plugins.HookMethod(this, "FormPatientAddAll.butOK_Click_ start ")) { return; } OpenDental.FormPatientEdit: Add...
by allends
Tue Oct 13, 2015 11:02 am
Forum: Developers
Topic: Hook request: FormPatientEdit.cs
Replies: 2
Views: 6262

Re: Hook request: FormPatientEdit.cs

These have been added to the program and will be available with version 15.3.22. I have changed the second hook slightly to better match our patterns: bool isValid=true; object[] parameters=new object[] { isValid,PatCur }; Plugins.HookAddCode(this,"FormPatientEdit.butOK_Click_beginning",parameters);...
by allends
Tue Oct 13, 2015 11:01 am
Forum: Developers
Topic: Hook Request for Payment plan
Replies: 1
Views: 4651

Re: Hook Request for Payment plan

These have been added to the program and will be available with the release of 15.3.22.
by allends
Mon Oct 05, 2015 9:10 am
Forum: Main Forum
Topic: google map function
Replies: 5
Views: 11762

Re: google map function

It is simply a tool to show you how close your patients are to your practice, based on their address given.
by allends
Wed Sep 30, 2015 12:04 pm
Forum: Sharing
Topic: Consent forms
Replies: 5
Views: 27783

Re: Consent forms

Go to Setup>Sheets and click the Import button.
Then import the XML file.
by allends
Mon Sep 21, 2015 8:57 am
Forum: Main Forum
Topic: Time card entry error-SOLVED
Replies: 10
Views: 10612

Re: Time card entry error-SOLVED

THE PROGRAM HAS A BUG AS IT SHOULD ENSURE WHEN THE EMPLOYEE IS DELETED THE TIME-CARD RULE FOR THE EMPLOYEE SHOULD BE DELETED AS WELL. This has been fixed as of version 14.3.30. If you are wondering why TimeCardRule rows with an employeenum of 0 were not deleted, then it is because those rows are no...
by allends
Mon Aug 24, 2015 4:30 pm
Forum: Developers
Topic: Plugin hook for LabCase plugin
Replies: 7
Views: 12957

Re: Plugin hook for LabCase plugin

This has been added to 15.3.12 and will be available with the next release.
by allends
Fri Aug 14, 2015 3:51 pm
Forum: Developers
Topic: Plugin hook for LabCase plugin
Replies: 7
Views: 12957

Re: Plugin hook for LabCase plugin

Since it is against our policy to backport plug-in hooks past the beta I cannot.
Thankfully, our release cycle is only around 6-8 weeks, so our current beta will be stable soon enough.
by allends
Fri Aug 14, 2015 9:21 am
Forum: Developers
Topic: Plugin hook for LabCase plugin
Replies: 7
Views: 12957

Re: Plugin hook for LabCase plugin

This has been added to 15.3.10 and will be released with the next beta update.
by allends
Thu Aug 13, 2015 2:00 pm
Forum: Developers
Topic: Hooks for custom plugins
Replies: 8
Views: 13831

Re: Hooks for custom plugins

First, it is typical to include a snippet of code where you want the hook. That way I know exactly where you want it. Without that it could get placed in an incorrect location and that could interfere with your plug-in. Second, based on your naming convention of these hooks you want them either at t...
by allends
Mon Aug 03, 2015 11:07 am
Forum: Main Forum
Topic: text reminders
Replies: 15
Views: 21110

Re: text reminders

http://opendental.com/manual/version15_3.html

In version 15.3 we have released a texting feature that is integrated into OpenDental itself.
It might be something you are interested in if you don't want to go looking for a third-party solution.
by allends
Wed Jul 29, 2015 12:18 pm
Forum: Developers
Topic: Hook Request - FormPayment
Replies: 7
Views: 15117

Re: Hook Request - FormPayment

I have added your plug-in hook to 15.3.6, but I have changed it slightly so all of our customers are not running extra queries. object[] parameters={ dataRoww["PatNum"].ToString(),apptRows[elementI].PatFieldDefNum,text }; Plugins.HookAddCode(null,"ApptSingleDrawing.DrawElement_afterFillText",paramet...
by allends
Tue Jul 21, 2015 9:55 am
Forum: Developers
Topic: Hook Request - FormPayment
Replies: 7
Views: 15117

Re: Hook Request - FormPayment

Since it is against our policy to backport plug-in hooks past the beta I cannot.
Thankfully, our release cycle is only around 6-8 weeks, so our current beta will be stable soon enough.
by allends
Mon Jul 20, 2015 2:52 pm
Forum: Developers
Topic: Hook Request - FormPayment
Replies: 7
Views: 15117

Re: Hook Request - FormPayment

With the new release of 15.3 as the beta this new hook will be going back to 15.3 and not 15.2. I should be able to add them to the next release of 15.3.
by allends
Fri Jul 17, 2015 9:10 am
Forum: Developers
Topic: change variable value via hook code?
Replies: 2
Views: 5506

Re: change variable value via hook code?

http://opendental.com/manual/patternplugins.html Parameters ... For parameters that are value types and for strings, if a user wishes the changed value to persist after the hook is run, then we will need to follow this pattern: object[] parameters={myInt,myStr}; Plugins.HookAddCode(this,"FormClaim....
by allends
Thu Jul 16, 2015 12:47 pm
Forum: Developers
Topic: Hook Request - FormPayment
Replies: 7
Views: 15117

Re: Hook Request - FormPayment

http://opendental.com/manual/plugins.html Hooks In addition to the obvious buttons from Program Links, any number of hooks are allowed. We add them quickly and we backport them to the beta version so you can get going right away. I have backported these hooks to the 15.2.12 version which will be sta...
by allends
Mon Jul 06, 2015 9:03 am
Forum: Main Forum
Topic: Bad Daily Production and Income Report
Replies: 2
Views: 4984

Re: Bad Daily Production and Income Report

What version are you on?
If you are past version 15.1.21 then I can't think of any bugs that have been reported.
Which report are you using (Annual, Monthly, or Daily)?
by allends
Mon Jun 22, 2015 12:55 pm
Forum: Developers
Topic: Hook Requests - Wiki
Replies: 1
Views: 4512

Re: Hook Requests - Wiki

Hook added and will be available with the release of 15.2.9
by allends
Fri Jun 12, 2015 3:05 pm
Forum: Main Forum
Topic: Invalid Signature on Chart
Replies: 10
Views: 10896

Re: Invalid Signature on Chart

I believe we have a fix for this Dr. Hersh.
In 15.2.7 and 15.1.29 we have deployed a fix that should make your old notes, that were incorrectly displaying as invalid, and display them as valid again.

When you update please update this thread and let me know if this is still occurring.
Thanks,
by allends
Mon Jun 08, 2015 4:54 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37026

Re: Broken, Cancelled and Failed Appointments

Does that mean we WON'T be able to show Broken Appts as Adjustments in the Account Module? Correct, OpenDental won't give you the option to automatically create broken appointment adjustments as long as you have the D9986 code. First of all it is important that patients can see on their statements ...
by allends
Mon Jun 08, 2015 4:13 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37026

Re: Broken, Cancelled and Failed Appointments

When you update to 15.2 you should be able to get the latest version of the D-Codes. As for the adjustments, broken appointments will be using procedures from now on, with a commlog option as there has always been.
by allends
Tue Jun 02, 2015 9:12 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37026

Re: Broken, Cancelled and Failed Appointments

What will happen to all those entries? Will they now show up in reports as "Broken Appt"? Nothing will change about those entries. The new 2015 ADA code will never be imported if it already exists in the DB. Broken Appts will now create "Bleaching Syringe" procs whenever they are broken though. In ...
by allends
Mon Jun 01, 2015 2:36 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37026

Re: Broken, Cancelled and Failed Appointments

The code will make D9986 procedures from all adjustments that match the current default broken appointment adjustment type. All future broken appointments will create one of the procedures. The new broken appointment report will use all D9986 procedures to determine metrics for broken appointments. ...
by allends
Tue May 26, 2015 3:34 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37026

Re: Broken, Cancelled and Failed Appointments

We have not added a "Canceled" option to appointments as of yet and because of that we did not implement the usage of D9987. It would be a feature request to allow appointments to be "Canceled" in addition to "Broken". If we implemented that request then we would most likely implement the usage of D...
by allends
Wed May 20, 2015 11:49 am
Forum: Developers
Topic: Hook Request: butText_Click in FormApptEdit.cs
Replies: 5
Views: 9367

Re: Hook Request: butText_Click in FormApptEdit.cs

Code: Select all

if(Plugins.HookMethod(this,"FormApptEdit.butText_Click_start",pat,AptCur,this)) {
	return;
}

Code: Select all

Plugins.HookAddCode(this,"FormApptEdit.Load_end2",AptCur);
These two hooks were committed to 15.2.4. Note that I did lower case the end of the method to fall in line with our newer hook patterns.
by allends
Wed May 20, 2015 11:46 am
Forum: Developers
Topic: Hook Request: butText_Click in FormConfirmList.cs
Replies: 3
Views: 6448

Re: Hook Request: butText_Click in FormConfirmList.cs

Also you pass the form (this) into the method, but you should already have access to it.

Code: Select all

private void FillMain(){
if (Plugins.HookMethod(this, "FormConfirmList.FillMain_Start", this))
return;
Is there a specific reason you need it passed in?
by allends
Tue May 19, 2015 9:11 am
Forum: Developers
Topic: Hook Request: butText_Click in FormApptEdit.cs
Replies: 5
Views: 9367

Re: Hook Request: butText_Click in FormApptEdit.cs

We cannot modify existing hooks because other plugins may rely on them. I can add another hook at the end that does what you want.

Code: Select all

Plugins.HookAddCode(this,"FormApptEdit.Load_end2",AptCur);
It would look like this.
by allends
Mon May 18, 2015 9:51 am
Forum: Developers
Topic: Hook Request: butText_Click in FormConfirmList.cs
Replies: 3
Views: 6448

Re: Hook Request: butText_Click in FormConfirmList.cs

I am confused. Where do you want this hook? private void FillMain(){ if (Plugins.HookMethod(this, "FormConfirmList.FillMain_End", this)) return; Do you want it in butText or FillMain? Also if wherever you want it, do you want it at the beginning or end of the method? I would assume at the beginning,...
by allends
Thu Apr 30, 2015 9:13 am
Forum: Developers
Topic: Open Dental Grid Formating
Replies: 1
Views: 4311

Re: Open Dental Grid Formating

Since the ODGrid is a custom control that overrides/doesnt use the default settings for a control, you will need to go and manually edit the ODGrid source code to change the colors. That will change the grid colors for every single window though. If you are looking for a solution where each grid you...
by allends
Wed Apr 22, 2015 2:45 pm
Forum: Developers
Topic: Hook request -> FormTxtMsgEdit -> SendText
Replies: 3
Views: 6477

Re: Hook request -> FormTxtMsgEdit -> SendText

I have added this hook to the next beta update v15.1.22. Sadly, I can't backport the hook to a non-beta version. Hooks would require another release of a stable version and that is against our current policy. From http://opendental.com/manual/plugins.html In addition to the obvious buttons from Prog...
by allends
Wed Apr 22, 2015 8:07 am
Forum: Developers
Topic: Hook Requests - Commlogs / Tasks
Replies: 1
Views: 4178

Re: Hook Requests - Commlogs / Tasks

Plugin Hooks added to 15.1.22.
by allends
Mon Apr 20, 2015 9:17 am
Forum: Main Forum
Topic: total collection per provider based on receive date
Replies: 10
Views: 14523

Re: total collection per provider based on receive date

The software currently uses the claim's date received to create an inurance payment. If you have access to our source code, you can see the behavior in FormInsPayFix at line 32 and 43.
by allends
Thu Apr 16, 2015 9:37 am
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 16611

Re: SMS plug-in questions

If you tested that hook and it works then all you need to do is make a hook request in this forum asking for "true" code I wrote. I will add it to our latest beta version so you can use it with the next beta release.
by allends
Wed Apr 15, 2015 7:31 am
Forum: Developers
Topic: SMS plug-in questions
Replies: 14
Views: 16611

Re: SMS plug-in questions

The way I understand this issue is that you want this if(Plugins.HookMethod(this,"FormTxtMsgEdit.SendText_Start",patNum,wirelessPhone,message,txtMsgOk)) { return false; } to return true. The best way I can think of to accomplish this for your plug-in would simply be to write a new hook directly belo...
by allends
Thu Apr 02, 2015 2:05 pm
Forum: Developers
Topic: Hook Requests - Wiki
Replies: 1
Views: 4047

Re: Hook Requests - Wiki

Hooks added to 15.1.18
by allends
Tue Mar 17, 2015 3:16 pm
Forum: Main Forum
Topic: Payment by Type, Previous Month
Replies: 2
Views: 3541

Re: Payment by Type, Previous Month

For any customers on 15.1, the Payments report will now give you the payments grouped by payment type and ordered by date.
by allends
Thu Mar 12, 2015 9:10 am
Forum: Developers
Topic: Method Overwrite Contact Edit Form
Replies: 1
Views: 4076

Re: Method Overwrite Contact Edit Form

First, if you want to overwrite the method OK click, this: public override bool HookAddCode(object sender, string hookName, params object[] parameters) needs to be this: public override bool HookMethod(object sender, string hookName, params object[] parameters) Next, your hook doesn't exist in the p...
by allends
Wed Feb 25, 2015 7:07 am
Forum: Main Forum
Topic: Discounts do funky math
Replies: 5
Views: 6776

Re: Discounts do funky math

The current treatment plan discount feature isn't designed to work with PPO plans. It would be a feature request to add this functionality. I am not sure about the legality of that feature in all states though. Adding a feature that discounts contractual PPO fees, regardless if the insurance company...
by allends
Mon Feb 23, 2015 9:22 am
Forum: Main Forum
Topic: Locked out of Security as Admin
Replies: 3
Views: 4728

Re: Locked out of Security as Admin

There are checks to prevent the database from having no security admins. Most likely there is another user in your database that has security admin permissions. If you know who that would be then they could simply give you your security admin permissions back as well.
by allends
Thu Feb 19, 2015 4:29 pm
Forum: Main Forum
Topic: Perio Charting - Voice
Replies: 5
Views: 10122

Re: Perio Charting - Voice

Hello, I am the engineer that recently improved the perio chart to be more accessible with Dragon Naturally Speaking (as of Version 14.3) I didn't mark FR#83 as done because I believe the spirit behind that request is for us to implement our own voice recognition system for use in perio charting. I ...
by allends
Wed Feb 04, 2015 7:39 am
Forum: Main Forum
Topic: Clinics selection in V 15.1.6
Replies: 2
Views: 3473

Re: Clinics selection in V 15.1.6

I have gotten this fixed for the 15.1.8 release.
by allends
Fri Jan 23, 2015 5:05 pm
Forum: Developers
Topic: How to add patient.ChartNumber to Daily Payments Report
Replies: 3
Views: 6557

Re: How to add patient.ChartNumber to Daily Payments Report

I am sure there is a way to add in those columns, but I am not familiar enough with the old framework used to generate that report to give you any helpful hints. https://technet.microsoft.com/en-us/library/ms170667(v=sql.105).aspx This link may be helpful with figuring out the RDL syntax used to gen...
by allends
Wed Jan 21, 2015 12:20 pm
Forum: Developers
Topic: How to add patient.ChartNumber to Daily Payments Report
Replies: 3
Views: 6557

Re: How to add patient.ChartNumber to Daily Payments Report

If you are willing to update to our beta version of 15.1 when it is released then this will be much easier to implement. In 15.1, in FormRpPaySheet in the butOK_Click method, after this line +DbHelper.Concat("patient.LName","', '","patient.FName","' '","patient.MiddleI")+@") lfname, add patient.Char...
by allends
Thu Dec 11, 2014 1:26 pm
Forum: Developers
Topic: Hook request - ContrChart.pd2_PrintPage()
Replies: 3
Views: 5052

Re: Hook request - ContrChart.pd2_PrintPage()

Sorry, I meant to comment on this before.

I have added this to version 14.3.24 (sans comment code) and it will be available when it is released.
by allends
Thu Nov 20, 2014 8:27 am
Forum: Developers
Topic: Hook requests - OpenDental.FormLogOn & FormSecurity
Replies: 7
Views: 8177

Re: Hook requests - OpenDental.FormLogOn & FormSecurity

No problem! Hooks are easy to add and you followed our naming convention quite well. As for hooks in OpenDentBusiness, we have recently changed our policy to be more accepting of hooks. Generally, hooks in OpenDentBusiness will query the main opendental database directly. This is ok, but should be d...
by allends
Mon Oct 27, 2014 6:50 am
Forum: Developers
Topic: Hook requests - OpenDental.FormLogOn & FormSecurity
Replies: 7
Views: 8177

Re: Hook requests - OpenDental.FormLogOn & FormSecurity

Hooks have been added to 14.3.15 and will be available in the next release.
by allends
Tue Oct 21, 2014 7:21 am
Forum: Main Forum
Topic: Broken appt query broken?
Replies: 4
Views: 5308

Re: Broken appt query broken?

That query appears like it should work and from the tests that I just ran it should work fine. Broken appointments could have had their status changed somehow, based on the query's date range of 700 days and returning 3 appointments I would wager that is the case. You could run this query SELECT Cou...
by allends
Tue Sep 09, 2014 9:40 am
Forum: Advanced Topics
Topic: Treatment Plan Discount v14.3
Replies: 3
Views: 7033

Re: Treatment Plan Discount v14.3

"Per patient discounts can be applied to Treatment Plan procedures. The discount amounts will be based on a percentage of the total procedure fee. " From the page: http://opendental.com/manual/treatmentplandiscounts.html A feature request could be added as an option to switch between total procedur...
by allends
Mon Sep 08, 2014 9:55 am
Forum: Developers
Topic: Daily Producion and Income Report Sort order
Replies: 6
Views: 16537

Re: Daily Producion and Income Report Sort order

FormRpProdInc.RunDaily() is where you would want to start. Since the query doesn't make use of appointments you would need to JOIN appointments in the query and then change the ORDER BY at the end to use the appointment date instead of the proc date. This line: +") ORDER BY "+DbHelper.UnionOrderBy("...