You mean scheduled treatment as in the patients have an appointment vs treatment planned as in it it in the treatment plan but no appointment on the books? If this is the case there are variables you can change to reflect this. I think!!
drtmz
Search found 353 matches
- Thu Oct 12, 2023 8:36 am
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 4519
- Wed Oct 04, 2023 11:03 am
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 4519
Re: Query question
Just tried it with 'N2010' a code we use for BW from another office and it picked it up.
drtmz
drtmz
- Wed Oct 04, 2023 2:15 am
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 4519
Re: Query question
Works. Use this format;
AND pc.ProcCode IN('D0120','D1110','D0210')
drtmz
AND pc.ProcCode IN('D0120','D1110','D0210')
drtmz
- Tue Aug 29, 2023 2:16 am
- Forum: Main Forum
- Topic: Where can I see how many appointments a patient has missed?
- Replies: 4
- Views: 2799
Re: Where can I see how many appointments a patient has missed?
You would have to write a query for that.
drtmz
drtmz
- Mon Aug 28, 2023 11:51 am
- Forum: Main Forum
- Topic: Where can I see how many appointments a patient has missed?
- Replies: 4
- Views: 2799
Re: Where can I see how many appointments a patient has missed?
This is recorded in the Account Module.
drtmz
drtmz
- Mon Jun 05, 2023 6:36 am
- Forum: Main Forum
- Topic: OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'
- Replies: 2
- Views: 4270
Re: OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'
Did they direct you to a script in images to correct this?
We get this error from time to time and have go back to the server to repair the files.
drtmz
We get this error from time to time and have go back to the server to repair the files.
drtmz
- Wed Mar 15, 2023 4:28 am
- Forum: Main Forum
- Topic: To set up a referral letter
- Replies: 3
- Views: 6676
Re: To set up a referral letter
Try using a PatientForm with input fields for customization.
If you can't find a specific input field use misc. and customize it to fit your needs.
drtmz
If you can't find a specific input field use misc. and customize it to fit your needs.
drtmz
- Wed Feb 01, 2023 3:39 pm
- Forum: Main Forum
- Topic: Removing implant from tooth chart
- Replies: 6
- Views: 4612
Re: Removing implant from tooth chart
Bill,
Great tip. I did not know we could do that in OD.
Just used it to remove the 'X' over treatment planned extractions that were referred out and completed.
drtmz
Great tip. I did not know we could do that in OD.
Just used it to remove the 'X' over treatment planned extractions that were referred out and completed.
drtmz
- Wed Jan 25, 2023 12:33 pm
- Forum: Main Forum
- Topic: Removing implant from tooth chart
- Replies: 6
- Views: 4612
Re: Removing implant from tooth chart
You have to delete all the codes related to the implant in the chart module.
drtmz
drtmz
- Wed Oct 12, 2022 4:25 am
- Forum: Main Forum
- Topic: Associate production and collections
- Replies: 1
- Views: 1337
Re: Associate production and collections
This should help with collections. drtmz /*85 Sum of patient and insurance payments for date range for given provider*/ SET @StartDate='2021-10-01',@EndDate='2021-10-31'; SET @ProviderAbbreviation='DrL'; -- Enter provider abbreviation here. Uses partial matching. Leave blank for all. /*-------------...
- Wed Sep 21, 2022 12:05 pm
- Forum: Main Forum
- Topic: Query for accounts with particular insurance carrier
- Replies: 2
- Views: 1315
Re: Query for accounts with particular insurance carrier
This will get you the guarantor information. drtmz ~~~~~~~~~~~~~~~~~ /*118 Mailing list of guarantors of patients with a particular carrier, unlike some others, returns the guarantors of all patients with plan, not the subscriber, also if you drop the plan it goes off the list*/ SET @CarrierName='%D...
- Wed Sep 07, 2022 6:37 am
- Forum: Main Forum
- Topic: few query questions
- Replies: 2
- Views: 1326
Re: few query questions
Does this help your appointment count in the future? /*1218 Count of patient appointments for new and exisiting patients per date created in date range. Counts only Scheduled and Completed appointments.*/ SET @Fromdate='2021-12-01',@ToDate='2021-12-31'; /* Enter date range here */ /*----------------...
- Wed Sep 07, 2022 6:12 am
- Forum: Main Forum
- Topic: few query questions
- Replies: 2
- Views: 1326
Re: few query questions
# Count of active patients seen between two dates SET @pos=0; SELECT Year(ProcDate) AS Year, Month(ProcDate) AS month, COUNT(patient.PatNum) AS Patients from patient, procedurelog WHERE procedurelog.patnum = patient.patnum AND patient.patstatus = '0' AND procedurelog.procstatus = 2 AND procedurelog....
- Mon Apr 18, 2022 5:25 am
- Forum: Main Forum
- Topic: Provider reorder (Up and Down) button does not show
- Replies: 2
- Views: 1856
Re: Provider reorder (Up and Down) button does not show
Did you click on the column header?
drtmz
drtmz
- Thu Apr 14, 2022 2:30 am
- Forum: Main Forum
- Topic: Calling all query wizards!
- Replies: 2
- Views: 1971
Re: Calling all query wizards!
Try this Change dates in line 2. Change insurance to replace Careington in the second last line. drtmz /*Modified #93, Insurance and Patient income for time period summed carrier. Patient income only shows on primary insurance carrier*/ SET @FromDate='2021-1-01', @ToDate='2021-12-31'; SELECT A.Carri...
- Thu Mar 31, 2022 3:36 am
- Forum: Main Forum
- Topic: Custom Query for Discount Plan
- Replies: 10
- Views: 4532
Re: Custom Query for Discount Plan
How about this way?
When you want to assign a patient this computer generated plan and its fee schedule, what is it called in the insurance panel.
For example if they have Cigna it would be called Cigna PPO etc or MetLife.
drtmz
When you want to assign a patient this computer generated plan and its fee schedule, what is it called in the insurance panel.
For example if they have Cigna it would be called Cigna PPO etc or MetLife.
drtmz
- Thu Mar 31, 2022 2:43 am
- Forum: Main Forum
- Topic: Custom Query for Discount Plan
- Replies: 10
- Views: 4532
Re: Custom Query for Discount Plan
It has to be called something. Use Main Menu, Lists, Carriers and see if it is listed.
Maybe support can give you a hint.
drtmz
Maybe support can give you a hint.
drtmz
- Wed Mar 30, 2022 5:13 am
- Forum: Main Forum
- Topic: Custom Query for Discount Plan
- Replies: 10
- Views: 4532
Re: Custom Query for Discount Plan
Does this help? Change the date in line 1 and change whatever you call your discount plan near the end, third last line. We use' Value Plan'. drtmz /*264 List of procedures for a date range and specified carrier showing patient name, service date, procedure code, primary insurance carrier, fee, sum ...
- Thu Mar 24, 2022 11:45 am
- Forum: Main Forum
- Topic: Payment by one insurance company over a given period of time
- Replies: 2
- Views: 1951
Re: Payment by one insurance company over a given period of time
Try this. Change the Name, second to last line, and Date range, first line, to fit your needs drtmz /*Modified #93, Insurance and Patient income for time period summed carrier. Patient income only shows on primary insurance carrier*/ SET @FromDate='2021-1-01', @ToDate='2021-12-31'; Set @row_number=0...
- Mon Mar 14, 2022 4:40 am
- Forum: Main Forum
- Topic: Columns overlapping in query reports
- Replies: 5
- Views: 2982
Re: Columns overlapping in query reports
Looks like the printing work-a-rounds I described above will work on a locally installed printer. When using our network printer here at the office same old issue with predetermined column widths that won't change.
Anyone else having these issues?
Both printers are HP BTW.
drtmz
Anyone else having these issues?
Both printers are HP BTW.
drtmz
- Sun Mar 13, 2022 5:29 am
- Forum: Main Forum
- Topic: Columns overlapping in query reports
- Replies: 5
- Views: 2982
Re: Columns overlapping in query reports
Forgot. You have to make the column headings narrower also as in PtRecall. Change code to PtRecall as 'Rcl'.
drtmz
drtmz
- Sun Mar 13, 2022 5:24 am
- Forum: Main Forum
- Topic: Columns overlapping in query reports
- Replies: 5
- Views: 2982
Re: Columns overlapping in query reports
This has been fixed in the latest version 21.4.28 to a degree. It seems the column headers determine the width of the column as in Excel. For example, 'Recall' as a column heading will reserve at least 6 to 8 spaces. The return is only a one digit answer eg 6. This wastes a lot of space on the page....
- Tue Mar 08, 2022 3:03 am
- Forum: Main Forum
- Topic: Search for blockouts
- Replies: 4
- Views: 2564
Re: Search for blockouts
Not sure but this one will, select SchedDate, SchedType, Note from schedule where schedtype = 2 AND Note <> " " AND SchedDate > '2020,1,1' ******** AND Note <> " " ... will bring up all the blockouts that have text in them use this line AND Note like '%DrZ%'...to bring up and notes with a specific t...
- Mon Mar 07, 2022 1:25 pm
- Forum: Main Forum
- Topic: Search for blockouts
- Replies: 4
- Views: 2564
Re: Search for blockouts
Would this help /*1385 Blockout list in a date range, defaults to current date up to date specified.*/ SET @FromDate='2020-11-1', @ToDate=curdate(); /*Change here to look for blockouts past this date*/ /*---------------------DO NOT MODIFY BELOW THIS LINE---------------------*/ /*Query code written/m...
- Thu Feb 17, 2022 3:43 am
- Forum: Main Forum
- Topic: Columns overlapping in query reports
- Replies: 5
- Views: 2982
Columns overlapping in query reports
Updated to the latest version of OpenDental yesterday and noticed that some of the columns in query reports are overlapping. It seems to be when a text column, like email address, is next to a number column, like cell number, the text runs into the numbers even though there is plenty of room on the ...
- Wed Feb 16, 2022 5:05 am
- Forum: Main Forum
- Topic: Vaailable Hygiene Appointments
- Replies: 1
- Views: 1616
Vaailable Hygiene Appointments
Looking for a query that will list any hygiene openings over a time period, say 30 days, in the future.
Can anyone point me in that direction or will it have to be a custom query?
Thanks,
drtmz
Can anyone point me in that direction or will it have to be a custom query?
Thanks,
drtmz
- Sun Feb 06, 2022 3:05 am
- Forum: Main Forum
- Topic: Crashed table
- Replies: 9
- Views: 5955
Re: Crashed table
Thanks Jordan.
My day is not complete until I verify a backup on my home PC. And from time to time I back up to a laptop that I can haul in on a moment's notice.
All xrays to an external hard drive once a week,
I am old school. I like my 'sneaker network' just fine.
drtmz
My day is not complete until I verify a backup on my home PC. And from time to time I back up to a laptop that I can haul in on a moment's notice.
All xrays to an external hard drive once a week,
I am old school. I like my 'sneaker network' just fine.
drtmz
- Sat Feb 05, 2022 2:49 am
- Forum: Main Forum
- Topic: Crashed table
- Replies: 9
- Views: 5955
Re: Crashed table
Doesn't say which table it is. Backup to USB drive. I changed disks. No cloud involvement. It works fine for three out of four nights. I have to go thru database maintenance and backup again to solve the problem. Database maintenance takes a little over an hour. In the past the dataintegretycheck li...
- Fri Feb 04, 2022 1:51 pm
- Forum: Main Forum
- Topic: Crashed table
- Replies: 9
- Views: 5955
Crashed table
Been getting this a lot when trying to restore to my home computer since converting to MariaDB. Any ideas? Tried the old Dataintregrity program but it doesn't work. 'Crashed table detected. Table status will be automatically monitored for 1 minute. Call support for help repairing table Click Retry t...
- Thu Dec 16, 2021 10:39 am
- Forum: Developers
- Topic: Converting to MariaDB
- Replies: 2
- Views: 4009
Re: Converting to MariaDB
Worked for me. Just open the file as administrator. Took about an hour.
drtmz
drtmz
- Fri Nov 05, 2021 5:14 am
- Forum: Main Forum
- Topic: Overdue Hygiene Query
- Replies: 1
- Views: 2929
Re: Overdue Hygiene Query
Been using this forever. Change the procedure codes to search for whatever you want. Time interval is in days to search. drtmz /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ /*Just change the i...
- Thu Oct 21, 2021 5:32 am
- Forum: Main Forum
- Topic: Query to compare insurance reimbursements by ADA code
- Replies: 4
- Views: 4738
Re: Query to compare insurance reimbursements by ADA code
To get rid of the procedures with no fee(s), procedures you do not do in your practice such as ortho, export the report to Excel. Data sort on the Standard column from low to high value. Then delete all the rows with zero Standard fees. Lastly, resort on ProcCode column to get your final report. drtmz
- Tue Oct 19, 2021 11:50 am
- Forum: Main Forum
- Topic: Query to compare insurance reimbursements by ADA code
- Replies: 4
- Views: 4738
Re: Query to compare insurance reimbursements by ADA code
Did a little fiddling with a list of Fee Schedules and their corresponding Plan Numbers and it works perfectly. Exactly what I was looking for.
Thanks again,
drtmz
Thanks again,
drtmz
- Tue Oct 19, 2021 10:48 am
- Forum: Main Forum
- Topic: Query to compare insurance reimbursements by ADA code
- Replies: 4
- Views: 4738
Re: Query to compare insurance reimbursements by ADA code
Thanks for your help.
drtmz
drtmz
- Fri Oct 15, 2021 1:42 pm
- Forum: Main Forum
- Topic: Query to compare insurance reimbursements by ADA code
- Replies: 4
- Views: 4738
Query to compare insurance reimbursements by ADA code
Looking for a query to compare insurance plan reimbursement in a spreadsheet form for all or some of the ADA procedure codes such as: Insurance Plan...............Aetna......MetLife....Cigna......Delta Ada code....Description.....Fee.........Fee........Fee.........Fee It would be helpful if you coul...
- Thu Oct 07, 2021 8:37 am
- Forum: Main Forum
- Topic: A query/report
- Replies: 3
- Views: 4452
Re: A query/report
Does this help? Just change the recall type. You can reorganize the list by columns by clicking on the column heading. drtmz /*807 List of patients who have a specific insurance or specific employer, and their interval for recall.*/ SET @InsCarrier='%%'; /*Set to '%%' to include all carriers*/ SET @...
- Mon Aug 30, 2021 4:33 am
- Forum: Main Forum
- Topic: MYSQL to MariaDB conversion
- Replies: 3
- Views: 5219
MYSQL to MariaDB conversion
Anyone out there made the conversion from MYSQL to MariaDB that was not a new installation? I did it over the weekend on a backup machine. Uses the file on the installation page. Fairly straight forward. One minor glitch overall. Took about an hour. Unless they can somehow speedup the process or I a...
- Wed Jul 28, 2021 11:20 am
- Forum: Main Forum
- Topic: You know what would be really cool?
- Replies: 3
- Views: 4682
Re: You know what would be really cool?
It was modified from the query examples list. Plus,I like to be in the 'Cool' category.
drtmz
drtmz
- Wed Jul 28, 2021 10:35 am
- Forum: Main Forum
- Topic: You know what would be really cool?
- Replies: 3
- Views: 4682
Re: You know what would be really cool?
This will list all the pans you took depending on the date range you put in. drtmz /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @FromDate='2021-1-01' , @ToDate=curdate(); /* change date h...
- Wed Jun 23, 2021 7:33 am
- Forum: Advanced Topics
- Topic: Message=Duplicate entry '4657089' for key 'PRIMARY'
- Replies: 3
- Views: 15682
Re: Message=Duplicate entry '4657089' for key 'PRIMARY'
That should work. I have found that this happens, error message, whenever I try to backup hot. That is when anybody is using OD. All users have to be signed out .Been happening for a long time. OD central hasn't been able to find a fix.
BTW I use xcopy for backups.
drtmz
BTW I use xcopy for backups.
drtmz
- Mon Mar 29, 2021 4:34 pm
- Forum: Advanced Topics
- Topic: Appointment Mouse Over Info Customization
- Replies: 3
- Views: 10606
Re: Appointment Mouse Over Info Customization
Try
Main Menu / Display Fields / Appointment Bubble
drtmz
Main Menu / Display Fields / Appointment Bubble
drtmz
- Mon Mar 29, 2021 8:18 am
- Forum: Main Forum
- Topic: social security numbers
- Replies: 2
- Views: 6592
Re: social security numbers
Didn't think we could ever delete things in this version of mysql by design. Only hide. And that had to be done by OD central.
drtmz
drtmz
- Sat Mar 20, 2021 12:25 pm
- Forum: Main Forum
- Topic: "Unhandled exception has occured in your application"
- Replies: 3
- Views: 5453
Re: "Unhandled exception has occured in your application"
You might try stopping and starting mysql service, On your server, R click on Home Select Computer Management Select Services and Applications Select Services Scroll down to mysql service Then stop and restart the mysql service Or a server reboot might get it going Then try the databaseintegrity fix...
- Sat Mar 20, 2021 2:49 am
- Forum: Main Forum
- Topic: "Unhandled exception has occured in your application"
- Replies: 3
- Views: 5453
Re: "Unhandled exception has occured in your application"
Try this.
Log on to your server as a regular user. Then go to the folder called Opendentimages\Updatefiles\Databaseintregitycheck.exe
Click on that exe file and let it run as is. No changes to that screen.
drtmz
Log on to your server as a regular user. Then go to the folder called Opendentimages\Updatefiles\Databaseintregitycheck.exe
Click on that exe file and let it run as is. No changes to that screen.
drtmz
- Thu Mar 18, 2021 7:10 am
- Forum: Main Forum
- Topic: Multiple Instances of OpenDental running on server
- Replies: 8
- Views: 9336
Re: Multiple Instances of OpenDental running on server
Fix seems to be working.
Thanks
drtmz
Thanks
drtmz
- Wed Mar 10, 2021 8:33 am
- Forum: Main Forum
- Topic: Multiple Instances of OpenDental running on server
- Replies: 8
- Views: 9336
Re: Multiple Instances of OpenDental running on server
Right. When checking in Task Manager there were multiple (4) copies running.
drtmz
drtmz
- Wed Mar 10, 2021 4:47 am
- Forum: Main Forum
- Topic: Multiple Instances of OpenDental running on server
- Replies: 8
- Views: 9336
Multiple Instances of OpenDental running on server
Updated on Friday to version 20.5.31 because we were getting multiple copies of OD on our server. This issue was supposed to be fixed. Checked this AM and there were four copies of OD running. Is this still an unresolved issue?
Thanks,
drtmz
Thanks,
drtmz
- Sat Jan 02, 2021 2:52 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Re: Problem printing forms and letters
OK. Makes sense. We will wait for the bug to be corrected.
drtmz
drtmz
- Wed Dec 30, 2020 2:50 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Re: Problem printing forms and letters
They are all running the latest version of Windows 10 pro. Not much of an issue any more.
Thanks,
drtmz
Thanks,
drtmz
- Mon Dec 28, 2020 5:02 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Re: Problem printing forms and letters
That seemed to help a lot.
Thanks
drtmz
Thanks
drtmz
- Tue Dec 22, 2020 6:01 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Re: Problem printing forms and letters
Microsoft Zoom is turned off on all work stations.
drtmz
drtmz
- Sun Dec 20, 2020 2:52 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Re: Problem printing forms and letters
Yes. I tried adjusting the Zoom but it didn't help. The display resolution in Windows is set to 'recommended'.
It is happening on laptops not the desktops. We have some of each.
drtmz
It is happening on laptops not the desktops. We have some of each.
drtmz
- Fri Dec 18, 2020 5:33 am
- Forum: Main Forum
- Topic: Problem printing forms and letters
- Replies: 10
- Views: 9176
Problem printing forms and letters
Looks like all our forms and letters on some of our work stations, laptops, are printing in 6 or 7 (very small) cpi since updating to version 20.4.28.
Any ideas? Fixes? Bug?
Thanks
drtmz
Any ideas? Fixes? Bug?
Thanks
drtmz
- Thu Dec 17, 2020 11:11 am
- Forum: Main Forum
- Topic: Report: patients by a specific code
- Replies: 2
- Views: 3711
Re: Report: patients by a specific code
Try this. Change the procedure code in the fourth line from the bottom to search whatever code you want and the date range where indicated. /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @F...
- Sat Dec 05, 2020 2:50 am
- Forum: Main Forum
- Topic: Custom Sheet
- Replies: 4
- Views: 4801
- Tue Oct 27, 2020 3:04 pm
- Forum: Main Forum
- Topic: TEMPERATURE LOG
- Replies: 5
- Views: 6196
Re: TEMPERATURE LOG
You have to know the FieldName you are using to store the temperatures. Run this query SELECT * from Apptfield limit 50 This will give you the FieldName and the value in it. For example, the FieldName might be Temperature and the Fieldvalue(s) 97.5, 98.0 etc. Once you have the proper name the query ...
- Thu Oct 22, 2020 4:18 am
- Forum: Main Forum
- Topic: TEMPERATURE LOG
- Replies: 5
- Views: 6196
Re: TEMPERATURE LOG
Nice evening's work.
Thanks,
drtmz
Thanks,
drtmz
- Thu Sep 17, 2020 2:32 am
- Forum: Main Forum
- Topic: Issue with Forms and Letters
- Replies: 3
- Views: 4270
Re: Issue with Forms and Letters
Yes it was. Thank you.
drtmz
drtmz
- Tue Sep 08, 2020 6:35 am
- Forum: Main Forum
- Topic: PDF Hell - Acrobat DC not a solution
- Replies: 5
- Views: 7372
Re: PDF Hell - Acrobat DC not a solution
Try Foxit free version. My IT guys are gravitating towart it.
drtmz
drtmz
- Wed Aug 19, 2020 7:20 am
- Forum: Main Forum
- Topic: learning sql
- Replies: 2
- Views: 3653
Re: learning sql
Hi Sam,
You may want to start with the tutorials on Youtube. Then look at the query examples on OD website
Note - you won't be able to change any of the tables as described on YT but they are great for query writing.
drtmz
You may want to start with the tutorials on Youtube. Then look at the query examples on OD website
Note - you won't be able to change any of the tables as described on YT but they are great for query writing.
drtmz
- Thu Aug 13, 2020 5:43 am
- Forum: Main Forum
- Topic: Issue with Forms and Letters
- Replies: 3
- Views: 4270
Issue with Forms and Letters
Anyone notice that when you select Forms or Letters, Forms or Letters Add, the form or letter selected is too big for the screen. They have to be dragged up to view the entire form? Is this a preview of the upcoming changes in zooming ability ? or a bug in Version 20.3.13? Hasn't been a issue in pre...
- Mon Aug 03, 2020 2:32 am
- Forum: Main Forum
- Topic: Unearned Income
- Replies: 2
- Views: 3674
Re: Unearned Income
Here is the work around
Reports, Standard, More Options, Uncheck Include Unearned
drtmz
Reports, Standard, More Options, Uncheck Include Unearned
drtmz
- Wed Jul 29, 2020 5:09 am
- Forum: Main Forum
- Topic: Mass Email and Queries
- Replies: 1
- Views: 3000
Mass Email and Queries
Any plans to be able to import any Queries generated in OpenDental into the Mass Email screen? It would seem that this would increase the functionality of the Email option without any additional programming. For example, if you wanted to send a note to all the patients that are due for a Pan at thei...
- Mon Jul 20, 2020 8:36 am
- Forum: Main Forum
- Topic: Report of procedures by year with patient names
- Replies: 1
- Views: 2709
Re: Report of procedures by year with patient names
Try this but substitute the date you want and the procedure codes. /*264 List of procedures for a date range with patient name, service date, procedure code, primary insurance carrier, fee, sum of ins est, sum ins paid*/ SET @FromDate='2019-1-01' , @ToDate='2019-1-30'; /* change date here, change li...
- Tue Jul 14, 2020 1:04 pm
- Forum: Main Forum
- Topic: Breaks between appointments
- Replies: 1
- Views: 3109
Re: Breaks between appointments
To the best of my knowledge they backed off of that edict soon after it was declared. No need to wait.
drtmz
drtmz
- Thu Jun 18, 2020 5:01 am
- Forum: Main Forum
- Topic: A/R (filters) query
- Replies: 4
- Views: 4947
Re: A/R (filters) query
Part of my problem is I do not have your situation to check the query. Our accounts are up to date. You always want to test run a query before using it live. I can play around with the paysplit table a little and see what might work.
Or a quick shout out to support may help.
drtmz
Or a quick shout out to support may help.
drtmz
- Tue Jun 16, 2020 8:34 am
- Forum: Main Forum
- Topic: A/R (filters) query
- Replies: 4
- Views: 4947
Re: A/R (filters) query
This one might be better for your situation. drtmz /*6*/ SELECT CONCAT(LName,', ',FName,' ',MiddleI) ,Bal_0_30,Bal_31_60,Bal_61_90,BalOver90 ,BalTotal,InsEst,BalTotal-InsEst AS $pat, DATE_FORMAT(MAX(paysplit.ProcDate),'%m/%d/%Y') AS lastPayment FROM patient LEFT JOIN paysplit ON paysplit.PatNum=pati...
- Tue Jun 16, 2020 7:46 am
- Forum: Main Forum
- Topic: A/R (filters) query
- Replies: 4
- Views: 4947
Re: A/R (filters) query
Does this help your situation? drtmz /*590 List of Patients with balance over 90 days AND Billing Type is "Bad Debt-Sent to collections". Includes Patients Name, Patient Address, Phone Numbers, SSN, DOB, Patnum, Last Date of Service, Date of Last Payment, Last Amount Paid, Balance Due Amount*/ SELEC...
- Wed Jun 10, 2020 8:21 am
- Forum: Main Forum
- Topic: NP Query/Report
- Replies: 3
- Views: 4506
Re: NP Query/Report
I think this is what you are after. It is currently set for 2020. We use it all the time. drtmz /*Annual new patient count by Carrier broken down by month */ /*Query code written/modified: 08/11/2016*/ SET @Year='2020'; /*choose year, use 4 digits - i.e. 'yyyy' */ SELECT IFNULL(ca.CarrierName,'NONE'...
- Tue Apr 14, 2020 3:05 am
- Forum: Main Forum
- Topic: User query help
- Replies: 8
- Views: 8799
Re: User query help
It does as written, PatStatus=0, is code for active patients.
Now you may have entry errors in that an archived patient is still coded as active. But the report will return only those patients that are listed as active.
drtmz
Now you may have entry errors in that an archived patient is still coded as active. But the report will return only those patients that are listed as active.
drtmz
- Sat Apr 11, 2020 4:59 am
- Forum: Main Forum
- Topic: User query help
- Replies: 8
- Views: 8799
Re: User query help
Ok. Here is the same code modified for both sexes grouped by age. I think this is what you want. /*175 Patients of specified age range and gender*/ SET @Young='1', @Old='100'; #Change age range here. SET @pos=0; SELECT @pos:=@pos+1 AS 'Count', PatNum, (YEAR(CURDATE())-YEAR(Birthdate)) - (RIGHT(CURDA...
- Sat Apr 11, 2020 4:49 am
- Forum: Main Forum
- Topic: User query help
- Replies: 8
- Views: 8799
Re: User query help
Do do know that will only give one specific gender. You would have to run it once for males and again for females. If you want to remove the gender variable, let me know. And I think we can group it by age.
drtmz
drtmz
- Thu Apr 09, 2020 2:28 pm
- Forum: Main Forum
- Topic: User query help
- Replies: 8
- Views: 8799
Re: User query help
This should do it. If you want work phone, it is easy to add /*175 Patients of specifed age range and gender*/ SET @Young='1', @Old='100'; #Change age range here. SET @Gender='1'; #Change gender here. 0-Male, 1-Female, 2-Unknown SET @pos=0; SELECT @pos:=@pos+1 AS 'Count', PatNum, (YEAR(CURDATE())-YE...
- Tue Apr 07, 2020 2:59 am
- Forum: Main Forum
- Topic: User query help
- Replies: 8
- Views: 8799
Re: User query help
Post the code you have so far and I will see what help to offer you.
drtmz
drtmz
- Tue Mar 10, 2020 3:57 am
- Forum: Main Forum
- Topic: Tooth Chart Updating
- Replies: 2
- Views: 5382
Re: Tooth Chart Updating
Adjust the graphics on that workstation as detailed here...
https://www.opendental.com/manual/graphics.html
drtmz
https://www.opendental.com/manual/graphics.html
drtmz
- Mon Feb 17, 2020 5:16 am
- Forum: Main Forum
- Topic: Creating of Sheets
- Replies: 2
- Views: 5839
Re: Creating of Sheets
Not knowing your situation I would have to say that your will have to setup all your custom forms. Use what OD gives you as defaults and modify or create from that point. Look at it this way, once you create all the forms you can use them forever. That's what we did 12 years ago and still use the sa...
- Mon Feb 10, 2020 7:00 am
- Forum: Main Forum
- Topic: Adjustment types
- Replies: 3
- Views: 6533
Re: Adjustment types
Actually the following query works better.
SELECT * FROM definition
Switch to Raw View and look at DefNum and ItemName columns.
drtmz
SELECT * FROM definition
Switch to Raw View and look at DefNum and ItemName columns.
drtmz
- Thu Feb 06, 2020 11:49 am
- Forum: Main Forum
- Topic: Adjustment types
- Replies: 3
- Views: 6533
Re: Adjustment types
Thank you
drtmz
drtmz
- Thu Feb 06, 2020 7:59 am
- Forum: Main Forum
- Topic: Adjustment types
- Replies: 3
- Views: 6533
Adjustment types
Is there a way to see the AdjTypes in the Adjustment table without having to switch between raw and human readable windows?
Basically, I want to know what each generated AdjNum refers to in plain English as in #10 = 10% cash discount when I query this table.
Thanks,
drtmz
Basically, I want to know what each generated AdjNum refers to in plain English as in #10 = 10% cash discount when I query this table.
Thanks,
drtmz
- Sun Jan 26, 2020 6:01 am
- Forum: Main Forum
- Topic: Query
- Replies: 1
- Views: 4813
Re: Query
You could probably get numbers from this query:
#1451 Percentage of total patients seen in the specified date range by insurance carrier, including not insured -
Just need the total patient visits for the time period in question. This can be calculated.
drtmz
#1451 Percentage of total patients seen in the specified date range by insurance carrier, including not insured -
Just need the total patient visits for the time period in question. This can be calculated.
drtmz
- Fri Nov 01, 2019 12:03 pm
- Forum: Main Forum
- Topic: Error in home backup
- Replies: 7
- Views: 10651
Re: Error in home backup
Cmcgehee,
Just copied a new version of C:\Program Files (x86)\Open Dental\DataConnectionBase.dll to my home computer and it worked like a charm. Back in business.
Thanks for the input.
drtmz
Just copied a new version of C:\Program Files (x86)\Open Dental\DataConnectionBase.dll to my home computer and it worked like a charm. Back in business.
Thanks for the input.
drtmz
- Fri Nov 01, 2019 2:35 am
- Forum: Main Forum
- Topic: Error in home backup
- Replies: 7
- Views: 10651
Re: Error in home backup
C:\Program Files (x86)\Open Dental\DataConnectionBase.dll V 1.0.0.0
C:\Program Files (x86)\Open Dental\OpenDental.exe V19.3.15.0
Should I just copy the .dll file from office to home?
drtmz
C:\Program Files (x86)\Open Dental\OpenDental.exe V19.3.15.0
Should I just copy the .dll file from office to home?
drtmz
- Thu Oct 31, 2019 1:08 pm
- Forum: Main Forum
- Topic: Error in home backup
- Replies: 7
- Views: 10651
Re: Error in home backup
Tried that twice. Deleted Opendental data but not OD Images. No luck. I will delete everything, do a clean install and go from there.
Very frustrating.
drtmz
Very frustrating.
drtmz
- Thu Oct 31, 2019 7:39 am
- Forum: Main Forum
- Topic: Error in home backup
- Replies: 7
- Views: 10651
Re: Error in home backup
No, I do not.
I did upgrade from 19.2.35 to 19.3.9 at home and the office . Discovered 19.3.9 was too buggy. Decided to go back and install 19.2.35 or one of those versions, at home. That is when the error occurs.
We still have 19.3.9 at the office.
drtmz
I did upgrade from 19.2.35 to 19.3.9 at home and the office . Discovered 19.3.9 was too buggy. Decided to go back and install 19.2.35 or one of those versions, at home. That is when the error occurs.
We still have 19.3.9 at the office.
drtmz
- Wed Oct 30, 2019 6:43 pm
- Forum: Main Forum
- Topic: Error in home backup
- Replies: 7
- Views: 10651
Error in home backup
Been trying to restore 19.3.9 to home computer. Got this error Unhandled exception: Field not found: 'DataConnectionBase.DataConnection.DataReaderNullTimeoutSeconds'. System.MissingFieldException at OpenDental.FormOpenDental.FormOpenDental_Load(Object sender, EventArgs e) at System.EventHandler.Invo...
- Tue Oct 29, 2019 12:58 pm
- Forum: Main Forum
- Topic: Much more efficient way of charting
- Replies: 17
- Views: 28468
Re: Much more efficient way of charting
That seems to be what I have read in several places. Thanks for clearing it up.
drtmz
drtmz
- Mon Oct 28, 2019 1:58 pm
- Forum: Main Forum
- Topic: Much more efficient way of charting
- Replies: 17
- Views: 28468
Re: Much more efficient way of charting
Correct me if I am wrong but doesn't scripting like this pose a security risk?
I may have read something somewhere to that effect.
drtmz
I may have read something somewhere to that effect.
drtmz
- Wed Oct 23, 2019 10:46 am
- Forum: Main Forum
- Topic: Update taking a long time (getting longer)
- Replies: 3
- Views: 6082
Re: Update taking a long time (getting longer)
I do understand it is the backup that is the problem. I will call in next time we update.
Thanks for the reply
drtmz
Thanks for the reply
drtmz
- Wed Oct 09, 2019 4:39 am
- Forum: Main Forum
- Topic: Update taking a long time (getting longer)
- Replies: 3
- Views: 6082
Update taking a long time (getting longer)
Seems it is taking longer and longer to update versions of OpenDental. Then I found this: "Usually Open Dental will automatically backup the database during an update as a preventive measure. Large enterprise organizations that update often and have a comprehensive backup strategy can contact Open D...
- Wed Oct 02, 2019 6:48 am
- Forum: Main Forum
- Topic: Landscape vs Portrait
- Replies: 4
- Views: 7137
Re: Landscape vs Portrait
Had this issue! If you include the unearned income column in the report it will print in landscape b/c there are too many columns for portrait. Trick is to unselect this option and then you will be back to portrait view.
drtmz
drtmz
- Mon Sep 30, 2019 4:49 am
- Forum: Main Forum
- Topic: Problems with Dexis bridge.
- Replies: 3
- Views: 7302
Re: Problems with Dexis bridge.
I see you have a compatibility tab as a choice. in VixWin when this happens with an update we select the Compatibility and change the selection to Windows 7.
This may or may not be your problem.
drtmz
This may or may not be your problem.
drtmz
- Thu Sep 19, 2019 6:16 am
- Forum: Main Forum
- Topic: Scheduling Template
- Replies: 1
- Views: 3324
Re: Scheduling Template
Have you reviewed this page?
https://www.opendental.com/manual/schedule.html
It takes some time but once the template is set up you can copy by day or week.
drtmz
https://www.opendental.com/manual/schedule.html
It takes some time but once the template is set up you can copy by day or week.
drtmz
- Sun Jun 30, 2019 4:29 am
- Forum: Main Forum
- Topic: cannot find or create the font. on statement PDFs
- Replies: 2
- Views: 3954
Re: cannot find or create the font. on statement PDFs
1. Check that you have the proper printer selected.
2. What are you using to view PDF files? We use Acrobat Reader DC. It's free.
drtmz
2. What are you using to view PDF files? We use Acrobat Reader DC. It's free.
drtmz
- Sun Jun 16, 2019 4:26 am
- Forum: Main Forum
- Topic: Patient Dashboard - 19.1 Version
- Replies: 5
- Views: 8219
Re: Patient Dashboard - 19.1 Version
Agree. Been playing around with 19.1 at home. If I implemented it in the office, the front desk would kill me. We have eight columns showing in the appointment module. The dashboard seriously reduces the column width of each provider.
I know OD will fix this.
drtmz
I know OD will fix this.
drtmz
- Thu Jun 13, 2019 3:05 am
- Forum: Main Forum
- Topic: Help finding report
- Replies: 2
- Views: 3870
Re: Help finding report
Try this. drtmz /*449 List of active patients (not subscribers) with primary insurance plan listed, Carrier Names and group names are cutoff for space consideration Check RAW button to show both PatNum and Patient Name*/ SELECT IFNULL(Left(c.CarrierName, 15), 'None') AS CarrierName, Left(GroupName, ...
- Thu May 16, 2019 8:41 am
- Forum: Main Forum
- Topic: Query Help!!
- Replies: 5
- Views: 6659
Re: Query Help!!
The simplest solution may be to export the query to an excel spreadsheet and then just highlight and print the rows you want.
drtmz
drtmz
- Tue May 14, 2019 1:47 pm
- Forum: Main Forum
- Topic: Query Help!!
- Replies: 5
- Views: 6659
Re: Query Help!!
try changing the last line to
ORDER by status;
drtmz
ORDER by status;
drtmz
- Mon Apr 08, 2019 2:22 pm
- Forum: Main Forum
- Topic: Add recall type to default list of recalls for new patients.
- Replies: 3
- Views: 5071
Re: Add recall type to default list of recalls for new patie
See my post. That is how you setup new recalls.
drtmz
drtmz
- Thu Apr 04, 2019 5:11 pm
- Forum: Main Forum
- Topic: Add recall type to default list of recalls for new patients.
- Replies: 3
- Views: 5071
Re: Add recall type to default list of recalls for new patie
Main Menu, click Setup, Appointments, Recall Types.
drtmz
drtmz
- Mon Mar 25, 2019 2:53 am
- Forum: Main Forum
- Topic: Printing my Insurance Carriers list
- Replies: 7
- Views: 8475
Re: Printing my Insurance Carriers list
Work around:
Make the window as large as you can by stretching it to the top and bottom of the screen. Then use screen shots.
drtmz
Make the window as large as you can by stretching it to the top and bottom of the screen. Then use screen shots.
drtmz
- Sun Mar 24, 2019 7:37 am
- Forum: Main Forum
- Topic: Printing my Insurance Carriers list
- Replies: 7
- Views: 8475
Re: Printing my Insurance Carriers list
There is:
Main Menu, Lists, Insurance Carriers
drtmz
Main Menu, Lists, Insurance Carriers
drtmz
- Sat Mar 23, 2019 12:13 pm
- Forum: Main Forum
- Topic: Printing my Insurance Carriers list
- Replies: 7
- Views: 8475
Re: Printing my Insurance Carriers list
Try this,
drtmz
select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
drtmz
select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
- Thu Mar 21, 2019 6:54 am
- Forum: Main Forum
- Topic: Inactive Pt Report
- Replies: 2
- Views: 3768
Re: Inactive Pt Report
Try this, drtmz SELECT IFNULL(Left(c.CarrierName, 15), 'None') AS CarrierName, Left(GroupName, 15) AS GroupName, PlanType, p.PatNum, CONCAT(p.LName,', ',p.FName,' ',p.MiddleI) AS PatName, ib.SubscriberId,p.Patstatus FROM patient p LEFT JOIN patplan pp ON pp.PatNum=p.PatNum LEFT JOIN inssub ib ON ib....
- Wed Jan 09, 2019 8:56 am
- Forum: Main Forum
- Topic: Changing deceased account Guantor
- Replies: 5
- Views: 7112
Re: Changing deceased account Guantor
How about this for a start?
select patnum from patient
where patstatus = 5
It will at least give you a list of deceased patients. Then you could edit the individual records.
drtmz
select patnum from patient
where patstatus = 5
It will at least give you a list of deceased patients. Then you could edit the individual records.
drtmz
- Tue Dec 04, 2018 4:59 pm
- Forum: Main Forum
- Topic: Welcome Back
- Replies: 9
- Views: 13180
Welcome Back
Did my eyes deceive me?
Welcome Back Arna !
drtmz
Welcome Back Arna !
drtmz
- Tue Dec 04, 2018 4:57 pm
- Forum: Main Forum
- Topic: Unearned income column
- Replies: 4
- Views: 5245
Re: Unearned income column
Thanks for the input.
drtmz
drtmz
- Tue Dec 04, 2018 2:56 pm
- Forum: Main Forum
- Topic: Unearned income column
- Replies: 4
- Views: 5245
Re: Unearned income column
Looks like that box has to be unchecked every time a report is viewed.
Any way to make it the defalut?
drtmz
Any way to make it the defalut?
drtmz
- Sun Dec 02, 2018 8:44 am
- Forum: Main Forum
- Topic: Unearned income column
- Replies: 4
- Views: 5245
Unearned income column
Just noticed there is an 'Unearned Income' column in the Monthly Production and Income reports. This forces the print out to be landscape.
We don't need this column. Any way to hide it?
Version18.3.20
Thanks,
drtmz
We don't need this column. Any way to hide it?
Version18.3.20
Thanks,
drtmz
- Mon Nov 12, 2018 10:57 am
- Forum: Main Forum
- Topic: Statement Note
- Replies: 2
- Views: 3514
Re: Statement Note
Got it. Fairly well hidden.
drtmz
drtmz
- Mon Nov 12, 2018 5:11 am
- Forum: Main Forum
- Topic: Statement Note
- Replies: 2
- Views: 3514
Statement Note
Looking for the Statement Note. According to the manual it is at Manage Module, Billing, Billing Options. Is it only for clinics?
Can't seem to find it. We are on version 18.3.22
Thanks,
drtmz
Can't seem to find it. We are on version 18.3.22
Thanks,
drtmz
- Wed Oct 10, 2018 11:49 am
- Forum: Main Forum
- Topic: Create template database
- Replies: 6
- Views: 8252
Re: Create template database
I was searching for the right word, Split, but had one of those moments.
We are all here to help each other. This was my turn. (Plus I like seeing my name in print!!)
drtmz
We are all here to help each other. This was my turn. (Plus I like seeing my name in print!!)
drtmz
- Wed Oct 10, 2018 2:45 am
- Forum: Main Forum
- Topic: Create template database
- Replies: 6
- Views: 8252
Re: Create template database
We have done it multiple times. We are on monthly support. Check with the conversions department. There is a cost involved but they were able to give us just what you want when we opened satellites.
drtmz
drtmz
- Mon Sep 03, 2018 2:58 am
- Forum: Main Forum
- Topic: @ActivePatCount
- Replies: 1
- Views: 3675
Re: @ActivePatCount
This will give you the number of patients that visited at least one time over the last 18 months. For a longer or shorter time in the past change the '....interval 18 month;' to what ever you want. /*22 Count patients seen in last 18 months*/ Set @FromDate = curdate()-interval 18 month; set @ToDate ...
- Wed Aug 15, 2018 7:24 am
- Forum: Main Forum
- Topic: reports help
- Replies: 3
- Views: 5018
Re: reports help
Try this. It should get everyone, /*130 modified*/ SELECT patient.PatNum, patient.birthdate, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(procedurelog.ProcNum) AS '# Procs Total' FROM patient,procedurelog WHERE procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patie...
- Wed Aug 01, 2018 11:38 am
- Forum: Main Forum
- Topic: reports help
- Replies: 3
- Views: 5018
Re: reports help
Does this help /*130*/ SELECT patient.PatNum, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(procedurelog.ProcNum) AS '# Procs Total' FROM patient,procedurelog WHERE procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patient.PatStatus=0 GROUP BY procedurelog.PatNum HAV...
- Sun Jul 01, 2018 3:52 am
- Forum: Main Forum
- Topic: Appointment box info
- Replies: 5
- Views: 6640
Re: Appointment box info
This is the page you want. It controls the information in the appointment block.
http://www.opendental.com/manual/appoin ... indow.html
drtmz
http://www.opendental.com/manual/appoin ... indow.html
drtmz
- Sun Jul 01, 2018 2:36 am
- Forum: Main Forum
- Topic: Appointment box info
- Replies: 5
- Views: 6640
Re: Appointment box info
That information is controlled here:
Main Menu, Setup, Appointment Views, F1 or whatever view you are working on
Move the rows you want to display over to the right
drtmz
Main Menu, Setup, Appointment Views, F1 or whatever view you are working on
Move the rows you want to display over to the right
drtmz
- Sat Jun 30, 2018 10:30 am
- Forum: Main Forum
- Topic: Appointment box info
- Replies: 5
- Views: 6640
Re: Appointment box info
Change your appointment View by pushing F-1, F-2 etc. See if that helps
drtmz
drtmz
- Mon Jun 25, 2018 2:19 pm
- Forum: Main Forum
- Topic: Strange Unhandled Exception
- Replies: 8
- Views: 22094
Re: Strange Unhandled Exception
Although I did not stop mysql noone was logged in at the time of the backup.
drtmz
drtmz
- Mon Jun 25, 2018 2:27 am
- Forum: Main Forum
- Topic: Strange Unhandled Exception
- Replies: 8
- Views: 22094
Re: Strange Unhandled Exception
I was able to run the database maintenance tool on the server, take a new backup and restore with no problem.
drtmz
OD 17.3.66
drtmz
OD 17.3.66
- Sat Jun 23, 2018 1:46 pm
- Forum: Main Forum
- Topic: Strange Unhandled Exception
- Replies: 8
- Views: 22094
Strange Unhandled Exception
When trying to restore a backup at home I am getting; Unhandled exception from ProgramEntry: Table '.\opendental\sigmessage' is marked as crashed and should be repaired MySql.Data.MySqlClient.MySqlException at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.Get...
- Wed Jun 06, 2018 11:48 am
- Forum: Main Forum
- Topic: Remove patients with zero payments from daily report
- Replies: 2
- Views: 4489
Re: Remove patients with zero payments from daily report
I will look into the employee issue. Thank you.
drtmz
drtmz
- Wed Jun 06, 2018 3:09 am
- Forum: Main Forum
- Topic: Remove patients with zero payments from daily report
- Replies: 2
- Views: 4489
Remove patients with zero payments from daily report
We are having an issue with patients that are coming in for treatment, managed care, and pay nothing but still showing up on the daily payments report (Reports, Standard, Make the from and to the same date, Payments) with $0.00 payment. I thought I was able to switch this off previously but can't se...
- Wed May 16, 2018 2:22 pm
- Forum: Main Forum
- Topic: can't connect to mysql host after windows update
- Replies: 19
- Views: 40167
Re: can't connect to mysql host after windows update
I have had this problem from time to time after an update. Very frustrating. I usually just Right click on the Start Menu, Select File Explorer, Navigate to our server which is the 'F' drive. The server usually has a red 'X' over it which means the local machine is not connected to the server. I rig...
- Sat May 05, 2018 2:53 am
- Forum: Main Forum
- Topic: List of Emergency patients who never had cleaning done
- Replies: 1
- Views: 4007
Re: List of Emergency patients who never had cleaning done
Try this /*217 Patients who need followup-Patients with a procedure in a given list completed in date range but no other procedures on another date, apts are counted by procedures summed by date, so it works even if you so not use appointments*/ SET @FromDate='2016-1-01' , @ToDate='2016-12-31'; SELE...
- Wed Apr 18, 2018 11:18 am
- Forum: Main Forum
- Topic: Time card reports specifics
- Replies: 9
- Views: 14501
Re: Time card reports specifics
That did it. Perfect.
Very useful freebie!!
drtmz
Very useful freebie!!
drtmz
- Wed Apr 18, 2018 3:06 am
- Forum: Main Forum
- Topic: Time card reports specifics
- Replies: 9
- Views: 14501
Re: Time card reports specifics
Yes. No data in the daterange column.
At least on my version 17.4.50
drtmz
At least on my version 17.4.50
drtmz
- Tue Apr 17, 2018 12:49 pm
- Forum: Main Forum
- Topic: Time card reports specifics
- Replies: 9
- Views: 14501
Re: Time card reports specifics
It seems to work but the daterange field doesn't populate. It only returns employee and hours.
drtmz
drtmz
- Wed Mar 21, 2018 2:57 pm
- Forum: Main Forum
- Topic: Procedure report
- Replies: 1
- Views: 3729
Re: Procedure report
You can start with this: Reports/Released user Queries Copy and paste below.. /*54*/ SET @FromDate='2007-01-01' , @ToDate='2007-01-15'; SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) As Patient, pc.ProcCode, pl.ProcDate, pl.ProcFee, ps.SplitAmt FROM patient INNER JOIN procedurelog pl ON patient.PatN...
- Sun Mar 18, 2018 1:20 pm
- Forum: Main Forum
- Topic: Dr. Old and Dr. Young
- Replies: 2
- Views: 5553
Dr. Old and Dr. Young
Question posed to me last week. Dr. Old is selling his practice, patient charts, to Dr. Young. Both are Using OpenDental. The same version or very close to the same version I think. Is there any way to import the patients of Dr. Old on a patient by patient basis? I said,' No'. It would have to be a ...
- Mon Mar 12, 2018 5:04 pm
- Forum: Main Forum
- Topic: Login window out of focus. Bug?
- Replies: 7
- Views: 11985
Re: Login window out of focus. Bug?
Me too. On startup. I have to click the OD window to get focus and then it will let me enter my password and start. Otherwise nothing.
Thought it was fixed but so far not so lucky.
drtmz
Version 17.3.66
Thought it was fixed but so far not so lucky.
drtmz
Version 17.3.66
- Thu Mar 01, 2018 2:43 am
- Forum: Main Forum
- Topic: Add Insurance Plan to Query #164
- Replies: 4
- Views: 6111
Re: Add Insurance Plan to Query #164
OK Thanks
drtmz
drtmz
- Wed Feb 28, 2018 11:41 am
- Forum: Main Forum
- Topic: Add Insurance Plan to Query #164
- Replies: 4
- Views: 6111
Re: Add Insurance Plan to Query #164
Perfecto. OD support to the rescue again.
Great Work.
drtmz
Great Work.
drtmz
- Wed Feb 28, 2018 3:41 am
- Forum: Main Forum
- Topic: Add Insurance Plan to Query #164
- Replies: 4
- Views: 6111
Add Insurance Plan to Query #164
I am trying to add the patient's current insurance plan to query #164 (below). Any help would be appreciated. Thanks drtmz /*164 Returns all treatment planned procedures for active patients without a scheduled OR planned apt, who were last seen in a given date range with phone numbers, useful for th...
- Tue Jan 16, 2018 3:55 am
- Forum: Main Forum
- Topic: Wrong patient's name on Pan
- Replies: 1
- Views: 3519
Wrong patient's name on Pan
Yesterday we took a panarex x-ray while in the wrong patient panel. The pan was supposed to be for Mrs. Jones (not her real name) but the panel selected was for Mrs. Smith (also not her real name). We are able to export the panarex and import it to the correct patient's file. The only thing now is t...
- Sun Dec 31, 2017 2:45 am
- Forum: Main Forum
- Topic: Gray shade in graphical tooth chart
- Replies: 9
- Views: 19335
Re: Gray shade in graphical tooth chart
This has been an ongoing issue which was supposed to be fixes a couple of versions ago. We still get it randomly. Sometimes if you select another module and then go back to the chart it is fixes.
drtmz
drtmz
- Mon Dec 25, 2017 2:50 am
- Forum: Main Forum
- Topic: Prescription report
- Replies: 2
- Views: 4101
Re: Prescription report
Try this
SET @FromDate='2017-01-01' , @ToDate='2017-12-31';
SELECT PatNum, RxDate, Drug, Disp, Refills, ProvNum
FROM rxpat
WHERE RxDate BETWEEN @FromDate AND @ToDate;
drtmz
SET @FromDate='2017-01-01' , @ToDate='2017-12-31';
SELECT PatNum, RxDate, Drug, Disp, Refills, ProvNum
FROM rxpat
WHERE RxDate BETWEEN @FromDate AND @ToDate;
drtmz
- Wed Dec 13, 2017 2:52 am
- Forum: Main Forum
- Topic: Potential bug? Ver. 17.3.31
- Replies: 2
- Views: 4398
Re: Potential bug? Ver. 17.3.31
Yes the Mouse focus on startup is very annoying.
drtmz
drtmz
- Fri Oct 27, 2017 2:39 am
- Forum: Main Forum
- Topic: maximum connections
- Replies: 8
- Views: 14586
Re: maximum connections
The .ini trick seemed to work for now.
Thanks
drtmz
Thanks
drtmz
- Wed Oct 25, 2017 4:16 am
- Forum: Main Forum
- Topic: maximum connections
- Replies: 8
- Views: 14586
maximum connections
Having an issue connecting to mysql that network guys can't seem to fix. Getting an error message 'unable to connect to mysql, maximum connections reached'. We are running windows server 2012, mysql 5.5, OD 17.2.13 with a combination of 20 desktops, laptops and notebooks, some wireless, some hard wi...
- Wed Sep 20, 2017 1:23 pm
- Forum: Main Forum
- Topic: Query 1238
- Replies: 5
- Views: 8830
Re: Query 1238
Try this one /*972 New patients with first appointment in date range*/ /*Query code written/modified: 05/05/2014*/ SET @FromDate='2014-04-01', @ToDate='2014-05-05'; SELECT DISTINCT CONCAT(p.FName, ' ', p.LName) AS 'Name', DATE_FORMAT(a.AptDateTime, '%m/%d/%Y %h:%i %p') AS 'Appointment', prd.Abbr AS ...
- Wed Sep 20, 2017 1:20 pm
- Forum: Main Forum
- Topic: Query 1238
- Replies: 5
- Views: 8830
Re: Query 1238
Yes. You would need a completely different query.
drtmz
drtmz
- Wed Sep 20, 2017 10:35 am
- Forum: Main Forum
- Topic: Query for list of guarantors
- Replies: 2
- Views: 5033
Re: Query for list of guarantors
Been working with that one. It might be what I need.
Thanks for the input.
drtmz
Thanks for the input.
drtmz
- Tue Sep 19, 2017 3:20 pm
- Forum: Main Forum
- Topic: Query for list of guarantors
- Replies: 2
- Views: 5033
Query for list of guarantors
Need a list of guarantors for patients treated over a time span, say 2 years, and their insurance coverage (plan).
Checked query examples but nothing seems to quite fit my needs.
Any help or direction would be appreciated
Thanks
drtmz
Checked query examples but nothing seems to quite fit my needs.
Any help or direction would be appreciated
Thanks
drtmz
- Mon Jul 10, 2017 11:26 am
- Forum: Main Forum
- Topic: Tooth chart on Treatment Plan
- Replies: 7
- Views: 11998
Re: Tooth chart on Treatment Plan
That did it. Thank you
drtmz
drtmz
- Mon Jul 10, 2017 7:00 am
- Forum: Main Forum
- Topic: Tooth chart on Treatment Plan
- Replies: 7
- Views: 11998
Tooth chart on Treatment Plan
Just updated to 17.1 Now the graphic tooth chart prints on the Treatment Plan.
Where is the switch to turn this option off.
Thanks
drtmz
Where is the switch to turn this option off.
Thanks
drtmz
- Tue Apr 25, 2017 10:46 am
- Forum: Main Forum
- Topic: Total patient visits query
- Replies: 1
- Views: 4673
Total patient visits query
I am looking for a query to total the patient visits by time period, usually for one month, and by insurance carrier. Something like this with a total per carrier and per month; Patient visits CarrierName................................Jan...Feb...March../.....Total Aenta Medicare Hmo Premier..........
- Sun Apr 16, 2017 2:44 am
- Forum: Main Forum
- Topic: Update from 15.3 to 16.4
- Replies: 4
- Views: 9705
Re: Update from 15.3 to 16.4
I think the new version failed to copy on those workstations. On the machine affected go to File Explorer, Your server drive (in our case F), Opendentimages, SetupFiles, double click on Setup16.4, let it install and then do that for each workstation. There was an issue back then with the installer n...
- Wed Mar 15, 2017 2:55 am
- Forum: Main Forum
- Topic: Query for write-offs and or adjustments by insurance plan
- Replies: 3
- Views: 4975
Re: Query for write-offs and or adjustments by insurance pla
Cool. Not exactly what I needed but this should help.
Thank you
drtmz
Thank you
drtmz
- Tue Mar 14, 2017 10:22 am
- Forum: Main Forum
- Topic: Query for write-offs and or adjustments by insurance plan
- Replies: 3
- Views: 4975
Re: Query for write-offs and or adjustments by insurance pla
OK so I have this much so far: SELECT patnum, DateService, PlanNum, Claimfee, InspayAmt, dedapplied, writeoff FROM claim WHERE dateservice >'2017-1-1' AND dateservice < '2017-4-1' Group by plannum But I would like to add the ADA procedures to the line, or abbrdesc from the Proccode table. I stink at...
- Tue Mar 14, 2017 6:23 am
- Forum: Main Forum
- Topic: Query for write-offs and or adjustments by insurance plan
- Replies: 3
- Views: 4975
Query for write-offs and or adjustments by insurance plan
Been asked if we have a report/query similar to Softdent that shows the fee charged, amount paid and writeoff per insurance plan? Guessing it would be: Insurance....procedure..fee...amt paid by ins..amt paid by patient...writeoff Delta dental, prophy, fee charged, amount paid by ins, amount paid by ...
- Thu Feb 09, 2017 6:28 am
- Forum: Main Forum
- Topic: query for ppo/medicaid not seen in over 6 months
- Replies: 4
- Views: 10149
Re: query for ppo/medicaid not seen in over 6 months
Thanks for the superlative. This is a modification of query #1026 from OD's query examples page. Not my code. Try this: /*1026 Recall info for patients due in date range that don't have any future scheduled appointment. Only shows patients with any insurance carrier, showing date of last visit*/ /*C...
- Wed Feb 08, 2017 4:47 pm
- Forum: Main Forum
- Topic: query for ppo/medicaid not seen in over 6 months
- Replies: 4
- Views: 10149
Re: query for ppo/medicaid not seen in over 6 months
Looks like you want some kind of recall query. Does this help? Change the date range in line 5. /*1026 Recall info for patients due in date range that don't have any future scheduled appointment. Only shows patients with any insurance carrier, showing date of last visit*/ /*Change dates as needed in...
- Sat Feb 04, 2017 3:21 am
- Forum: Main Forum
- Topic: Today was my last day at Open Dental
- Replies: 8
- Views: 12030
Re: Today was my last day at Open Dental
Noooo! Say it isn't so!!
Rant over. Best of Luck. You were a valuable asset here on the forum.
drtmz
Rant over. Best of Luck. You were a valuable asset here on the forum.
drtmz
- Wed Feb 01, 2017 3:04 pm
- Forum: Main Forum
- Topic: AR, how to break down by time chunks ins/pt
- Replies: 5
- Views: 10685
Re: AR, how to break down by time chunks ins/pt
BTW Our founder, Jordan, turned me on to a way to control the AR many, many moons ago. Send bills out every day. Get get most of the payments upfront before the patient's go back for Tx. The balances from insurance payments or whatever are then billed every day. Insurances we follow up on after two ...
- Mon Jan 30, 2017 3:05 am
- Forum: Main Forum
- Topic: AR, how to break down by time chunks ins/pt
- Replies: 5
- Views: 10685
Re: AR, how to break down by time chunks ins/pt
You can put in today's date or try
SET @AsOf=CURDATE();
drtmz
SET @AsOf=CURDATE();
drtmz
- Sun Jan 29, 2017 1:44 pm
- Forum: Main Forum
- Topic: AR, how to break down by time chunks ins/pt
- Replies: 5
- Views: 10685
Re: AR, how to break down by time chunks ins/pt
Try this. (below) Most reports / queries are found here http://opendentalsoft.com:1942/ODQueryList/QueryList.aspx If you don't know how to do this, let us know. Change the date in line #2 /*781 Aging for families with any balance with patient and insurance estimates separated*/ SET @AsOf='2014-02-03...
- Mon Jan 09, 2017 2:31 pm
- Forum: Main Forum
- Topic: 2016 payment report for taxes
- Replies: 4
- Views: 7997
Re: 2016 payment report for taxes
Just stumbled upon this query from our query list. Surprised no one else pointed it out. /*1222 Income Tax Receipt */ /*Provides the guarentor who paid, when they paid, the amount, and the payment type. Each row is for a single family. Ordered by Guarentor name, date paid, and amount.*/ /*Query code...
- Sat Jan 07, 2017 3:11 am
- Forum: Main Forum
- Topic: 2016 payment report for taxes
- Replies: 4
- Views: 7997
Re: 2016 payment report for taxes
Since the report is by patient number you have to run it multiple times. Once for each person who made any payments.
drtmz
drtmz
- Wed Jan 04, 2017 3:40 am
- Forum: Main Forum
- Topic: 2016 payment report for taxes
- Replies: 4
- Views: 7997
2016 payment report for taxes
The ball had just hit bottom in Times Square when we got our first call of 2017. It was a request for 'everything I paid you in 2016 for taxes'. For newbies to OD or those of you who may have forgotten. We use the following: /*75*/ SET @StartDate='2016-01-01'; SET @EndDate='2016-12-31'; SET @Patient...
- Tue Nov 29, 2016 1:33 pm
- Forum: Main Forum
- Topic: OpenDental Newsletter
- Replies: 2
- Views: 5785
OpenDental Newsletter
I am surprised that no body mentioned the spiffy OpenDental Newsletter that we received on Monday. Very useful information on the growth of the company. Equally surprised that no one mentioned the new building being planned and could it possibly be in the shape of a lower first molar. (Would have gu...
- Thu Nov 17, 2016 8:15 am
- Forum: Main Forum
- Topic: query help
- Replies: 5
- Views: 17557
Re: query help
No need. There are almost 1200 examples on the query page to fit most needs. Usually you can cobble something from the examples. If not, post to this group for added guidance.
drtmz
drtmz
- Wed Nov 09, 2016 1:25 pm
- Forum: Main Forum
- Topic: query help
- Replies: 5
- Views: 17557
Re: query help
You may want to try query #1184
drtmz
drtmz
- Mon Nov 07, 2016 4:59 am
- Forum: Main Forum
- Topic: New Patient report
- Replies: 4
- Views: 9071
Re: New Patient report
Can anybody help clear this up?
Which number is used for practice management purposes?
drtmz
Which number is used for practice management purposes?
drtmz
- Fri Sep 30, 2016 2:53 am
- Forum: Main Forum
- Topic: appointment view
- Replies: 4
- Views: 8374
Re: appointment view
We use Appointment view F-2 which has all the information contained in Appointment view F-1 except it uses the patient's id number. Very ease to switch back and forth. Works great for us
drtmz
drtmz
- Sun Sep 25, 2016 4:15 am
- Forum: Main Forum
- Topic: Query help add 'AbbrDesc' abbreviated description
- Replies: 1
- Views: 4323
Query help add 'AbbrDesc' abbreviated description
Looking for some help. Need to add field 'AbbrDesc' to the following query. Can't seem to get it to click. /*# 1022 Query code written/modified: 10/30/2014*/ SET @FromDate='2014-01-10', @ToDate='2014-01-10'; SELECT A.Provider,A.ProcCode, COUNT(A.ProcCode) AS 'Quantity', SUM(A.ProcFee) AS $ProcFee_, ...
- Wed Sep 21, 2016 3:06 pm
- Forum: Main Forum
- Topic: Need help to add email to a query
- Replies: 2
- Views: 4815
Re: Need help to add email to a query
try adding this line right after p.WirelessPhone,
p.email,
drtmz
p.email,
drtmz
- Fri Sep 02, 2016 12:54 pm
- Forum: Main Forum
- Topic: Trick to show missing crown/retained root tips on chart
- Replies: 18
- Views: 28646
Re: Trick to show missing crown/retained root tips on chart
What I am calling Condition is 'Entry Status' eg Treatment Planned, Existing Other, Existing Current...
Lists, Procedure Codes
Tooth is selected.
Maybe I have something else turned off or not selected!
I will try again tomorrow.
drtmz
Lists, Procedure Codes
Tooth is selected.
Maybe I have something else turned off or not selected!
I will try again tomorrow.
drtmz
- Fri Sep 02, 2016 11:07 am
- Forum: Main Forum
- Topic: Trick to show missing crown/retained root tips on chart
- Replies: 18
- Views: 28646
Re: Trick to show missing crown/retained root tips on chart
I tried to take a picture of my setting but can't figure out how to post it but here is what I have.
Paint Type = Crown Light (Tried Filling Light, no luck)
Treatment Area = Tooth
Color Override = Dark Blue
Category = Oral Surgery
Condition = Existing Other
drtmz
Paint Type = Crown Light (Tried Filling Light, no luck)
Treatment Area = Tooth
Color Override = Dark Blue
Category = Oral Surgery
Condition = Existing Other
drtmz
- Fri Sep 02, 2016 6:40 am
- Forum: Main Forum
- Topic: Trick to show missing crown/retained root tips on chart
- Replies: 18
- Views: 28646
Re: Trick to show missing crown/retained root tips on chart
Sorry guys/gals. I followed your directions and used green for color but nothing happened. Setup the code and the properties as you described, used a missing tooth area, Selected Existing Other from conditions but no luck. It is listed in the chart as a root tip but no graphic. We are on 16.2.30 drtmz
- Mon Aug 15, 2016 2:45 am
- Forum: Main Forum
- Topic: Updating OD - Stuck in File Copier loop
- Replies: 3
- Views: 8003
Re: Updating OD - Stuck in File Copier loop
We had a problem with this in the past.
On the Workstations, try going to OpenDentalImages folder, Setupfiles. Then double click on the latest version. This should install the new version on that workstation.
You sill have to do this with each workstation.
drtmz
On the Workstations, try going to OpenDentalImages folder, Setupfiles. Then double click on the latest version. This should install the new version on that workstation.
You sill have to do this with each workstation.
drtmz
- Thu Aug 11, 2016 2:52 am
- Forum: Main Forum
- Topic: OD settings for second office
- Replies: 4
- Views: 9943
Re: OD settings for second office
A split is the way to go. We did it and it works fine. Like with a conversion they do a trial split and let you see it and go from there.
There was a small fee but worth the trouble.
drtmz
There was a small fee but worth the trouble.
drtmz
- Sat Jul 23, 2016 3:03 am
- Forum: Main Forum
- Topic: Problems restoring OpenDental
- Replies: 3
- Views: 7796
Re: Problems restoring OpenDental
I have been on OD since it was OpenDentalSoft, one of the originals, and use Karen's Replicator for backup. Currently we are on 16.2.30. I have never had to stop MYSQL in the past to backup successfully. I do stop the service on my home computer before restoring. If I kick everybody off OD and run t...
- Fri Jul 22, 2016 8:30 am
- Forum: Main Forum
- Topic: Problems restoring OpenDental
- Replies: 3
- Views: 7796
Problems restoring OpenDental
For the past few months unless I Optimize OpenDental and then back it up to a jump drive I am getting this error when trying to restore at home.
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1665470' for key 'PRIMARY'
Any ideas?
Thanks,
drtmz
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1665470' for key 'PRIMARY'
Any ideas?
Thanks,
drtmz
- Fri Jun 17, 2016 7:28 am
- Forum: Main Forum
- Topic: Query for new patients and insurance plans
- Replies: 1
- Views: 4524
Query for new patients and insurance plans
Can someone direct me to a query that will return the count of new patients for each insurance plan over a time period? I would like to input the start and end date like we do with many of the present queries. Or yearly by month would be perfect! I am looking for: ................Jan....Feb...Mar......
- Fri Jun 17, 2016 7:21 am
- Forum: Main Forum
- Topic: Printing reports in landscape mode
- Replies: 2
- Views: 5808
Re: Printing reports in landscape mode
Not a big deal. I could take a column out or as I said export to excel.
Just thought there was an enhancement I missed along the way.
drtmz
Just thought there was an enhancement I missed along the way.
drtmz
- Fri Jun 17, 2016 6:06 am
- Forum: Main Forum
- Topic: Printing reports in landscape mode
- Replies: 2
- Views: 5808
Printing reports in landscape mode
Is it possible to print certain reports in landscape mode? Some of the reports have too many columns to fit portrait mode. Currently I have been exporting to excel and reformatting but that gets old.
Any other workaround I am missing?
Thanks,
drtmz
Any other workaround I am missing?
Thanks,
drtmz
- Wed Jun 15, 2016 3:54 pm
- Forum: Main Forum
- Topic: Insurance Carrier list printed
- Replies: 8
- Views: 17217
Re: Insurance Carrier list printed
Try this: /*122*/ SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients' FROM carrier INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum INNER JOIN inssub ib ON ib.PlanNum=ip.PlanNum INNER JOIN patplan pp ON pp.InsSubNum=ib.InsSubNum INNER JOIN patient p ON pp.PatNum=p.PatNum WHER...
- Fri Jun 03, 2016 2:58 am
- Forum: Main Forum
- Topic: Hygiene production
- Replies: 2
- Views: 5972
Re: Hygiene production
Would this work? /*126*/ SET @FromDate='2016-01-01' , @ToDate='2016-06-30'; SELECT Count(*),pv.Abbr, pc.ProcCode, pc.AbbrDesc, AVG(pl.ProcFee) as '$Ave. Fee' , SUM(pl.ProcFee) AS '$Tot. Prod' FROM patient INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum INNER JOIN procedurecode pc ON pl.CodeNu...
- Tue May 31, 2016 2:49 am
- Forum: Main Forum
- Topic: Surface Pro
- Replies: 3
- Views: 6988
Re: Surface Pro
They all work very well but we use laptops for X-rays.
drtmz
drtmz
- Mon May 30, 2016 9:30 am
- Forum: Main Forum
- Topic: Surface Pro
- Replies: 3
- Views: 6988
Re: Surface Pro
We have three that we us use all the time on WIFI. Just set them up on a secure WIFI network.
drtmz
drtmz
- Sun Apr 24, 2016 2:42 am
- Forum: Main Forum
- Topic: Adding a simple Dr Note (not a procedure note)
- Replies: 4
- Views: 7563
Re: Adding a simple Dr Note (not a procedure note)
CommLog is the best.
Built in already, nothing to add, kind of the industry standard for after hours communication or any communication, easily searchable later on.
drtmz
Built in already, nothing to add, kind of the industry standard for after hours communication or any communication, easily searchable later on.
drtmz
- Wed Mar 23, 2016 11:33 am
- Forum: Main Forum
- Topic: Patient Info Custom Fields
- Replies: 4
- Views: 7913
Re: Patient Info Custom Fields
Nice little query. Very useful.
drtmz
drtmz
- Sun Mar 20, 2016 3:32 am
- Forum: Main Forum
- Topic: Export/Import Auto Notes
- Replies: 4
- Views: 9219
Re: Export/Import Auto Notes
You can copy the auto notes to Word. Save to a USB drive. Then copy and past them to the new office.
May take a few minutes but it is once and done, so to speak.
drtmz
May take a few minutes but it is once and done, so to speak.
drtmz
- Fri Dec 18, 2015 4:33 pm
- Forum: Main Forum
- Topic: How about this report?
- Replies: 9
- Views: 13882
Re: How about this report?
Great. Thank you,
drtmz
drtmz
- Wed Dec 16, 2015 3:17 am
- Forum: Main Forum
- Topic: How about this report?
- Replies: 9
- Views: 13882
Re: How about this report?
I wasn't looking for it but I like this query very much.
Would be even better if we could pull AbbrDesc from Procedurecode. This way you wouldn't have to remember what the ADA codes represent.
Nice find!
drtmz
Would be even better if we could pull AbbrDesc from Procedurecode. This way you wouldn't have to remember what the ADA codes represent.
Nice find!
drtmz
- Wed Nov 18, 2015 1:47 pm
- Forum: Developers
- Topic: OD DataBase
- Replies: 3
- Views: 7277
Re: OD DataBase
Not a good idea. Access is not robust enough to handle all the tables in OD.
drtmz
drtmz
- Wed Oct 28, 2015 1:41 pm
- Forum: Main Forum
- Topic: Search patient chart notes
- Replies: 7
- Views: 12227
Re: Search patient chart notes
That is exactly what I wanted.
Is this query detailed anywhere else? Can't believe I'm the only one who would find this useful. But maybe I'm the only forgetful-one.
OpenDental support comes thru again in record time.
Many thanks,
drtmz
Is this query detailed anywhere else? Can't believe I'm the only one who would find this useful. But maybe I'm the only forgetful-one.
OpenDental support comes thru again in record time.
Many thanks,
drtmz
- Wed Oct 28, 2015 9:31 am
- Forum: Main Forum
- Topic: Search patient chart notes
- Replies: 7
- Views: 12227
Re: Search patient chart notes
Guess I wasn't 100% clear. I was referring to the procedure notes. The notes that are written after a completed procedure. Better example for procedure D1110 Adult Prophy the notes might say, 'did prophy in the usual manner. Patient does not like Cavitron. Always requests topical. Might need deep cl...
- Wed Oct 28, 2015 9:14 am
- Forum: Main Forum
- Topic: Search patient chart notes
- Replies: 7
- Views: 12227
Re: Search patient chart notes
I will try both methods. Thanks
drtmz
drtmz
- Wed Oct 28, 2015 4:46 am
- Forum: Main Forum
- Topic: Search patient chart notes
- Replies: 7
- Views: 12227
Search patient chart notes
Is there a way to search the patients' chart notes?
For example, I note during an exam that the patient moved to our area from California. But later forget the conversation but want to reference it for some reason.
Anyway to query for that information?
drtmz
For example, I note during an exam that the patient moved to our area from California. But later forget the conversation but want to reference it for some reason.
Anyway to query for that information?
drtmz
- Wed Oct 21, 2015 2:55 am
- Forum: Main Forum
- Topic: Query for free time by provider
- Replies: 1
- Views: 4205
Query for free time by provider
Need a query that returns free time (time units) for a provider over length of time. For example, Doc A works three 8 hour days a week. That is 24 total hours. We us 15 minute intervals so that would be 96 time units total. I want to find the number of time units that were free as in cancelled or br...
- Thu Sep 17, 2015 12:06 pm
- Forum: Main Forum
- Topic: Patients with remaining 2015 insurance benefits
- Replies: 1
- Views: 3849
Patients with remaining 2015 insurance benefits
Looking for a query to return list of active patients with work to be done and unused 2015 insurance benefits.
I think we discussed and did this before but can't seem to find it.
Any help or direction will be appreciated.
drtmz
I think we discussed and did this before but can't seem to find it.
Any help or direction will be appreciated.
drtmz
- Wed Jul 22, 2015 2:47 am
- Forum: Main Forum
- Topic: Bulk commlog note
- Replies: 1
- Views: 3581
Bulk commlog note
Is there a way to add a Commlog note to multiple patients on OpenDental. We are changing our broken appointment policy from 24 to 48 hours. I want to send out emails to say 1000 of our patients. Since I can only do this one at a time in OD and have it recorded I was looking to use Google or Yahoo fo...
- Tue Jun 09, 2015 3:35 am
- Forum: Main Forum
- Topic: Broken, Cancelled and Failed Appointments
- Replies: 23
- Views: 37486
Re: Broken, Cancelled and Failed Appointments
Didn't really need to make a procedure. Still was listed on a statement when we charged for a missed appointment as though it was a procedure. Still could track it with a query of the adjustment table. I guess some of these original features that are changed should be made optional as OD gets more a...
- Fri Jun 05, 2015 10:21 am
- Forum: Main Forum
- Topic: Glitch with employee hours totals
- Replies: 2
- Views: 4037
Re: Glitch with employee hours totals
That's what I thought would have to happen. We have to pretend they were in.
Will clock them in and out before the adjustment.
Thank you,
drtmz
Will clock them in and out before the adjustment.
Thank you,
drtmz
- Fri Jun 05, 2015 2:58 am
- Forum: Main Forum
- Topic: Glitch with employee hours totals
- Replies: 2
- Views: 4037
Glitch with employee hours totals
Noticed recently that there is a glitch in query 538, below, 746 and 756. If the employee does not work any regular hours in the time period searched they are ignored in the queries. In two cases we had an employee not work but were given adjustment hours, one for maternity and one for a honeymoon, ...
- Thu May 28, 2015 2:20 pm
- Forum: Main Forum
- Topic: Broken, Cancelled and Failed Appointments
- Replies: 23
- Views: 37486
Re: Broken, Cancelled and Failed Appointments
We called support today. No way to change the Font on the missed appointment in the chart because it is now a procedure. But if you click on the appointment after it is broken and then click on 'Add Adjustment' in the bottom of the window you can differentiate between the type of adjustments. In our...
- Tue May 26, 2015 9:10 am
- Forum: Main Forum
- Topic: Broken, Cancelled and Failed Appointments
- Replies: 23
- Views: 37486
Re: Broken, Cancelled and Failed Appointments
Thought it changed the Font but seems it did not.
Went to:
Setup/Appointments/Appointment View/ProcColors
entered one for D9986 and changed the color back to Blue
Checked Show Previous Date
Saved everything
But no luck
Help! Staff is after me!
drtmz
Went to:
Setup/Appointments/Appointment View/ProcColors
entered one for D9986 and changed the color back to Blue
Checked Show Previous Date
Saved everything
But no luck
Help! Staff is after me!
drtmz
- Mon May 25, 2015 12:41 pm
- Forum: Main Forum
- Topic: Broken, Cancelled and Failed Appointments
- Replies: 23
- Views: 37486
Re: Broken, Cancelled and Failed Appointments
OK That took care of the font issue. Never would have guessed it would be under Appointment View.
But any way to differentiate between the adjtypes?
I took a peek at the appointment table and everything there under aptstatus is recorded as 'Broken'.
Thanks
drtmz
But any way to differentiate between the adjtypes?
I took a peek at the appointment table and everything there under aptstatus is recorded as 'Broken'.
Thanks
drtmz