Search found 353 matches

by Tom Zaccaria
Thu Oct 12, 2023 8:36 am
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3759

Re: Query question

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
by Tom Zaccaria
Wed Oct 04, 2023 11:03 am
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3759

Re: Query question

Just tried it with 'N2010' a code we use for BW from another office and it picked it up.

drtmz
by Tom Zaccaria
Wed Oct 04, 2023 2:15 am
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3759

Re: Query question

Works. Use this format;

AND pc.ProcCode IN('D0120','D1110','D0210')

drtmz
by Tom Zaccaria
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: 2098

Re: Where can I see how many appointments a patient has missed?

You would have to write a query for that.

drtmz
by Tom Zaccaria
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: 2098

Re: Where can I see how many appointments a patient has missed?

This is recorded in the Account Module.

drtmz
by Tom Zaccaria
Mon Jun 05, 2023 6:36 am
Forum: Main Forum
Topic: OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'
Replies: 2
Views: 4161

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
by Tom Zaccaria
Wed Mar 15, 2023 4:28 am
Forum: Main Forum
Topic: To set up a referral letter
Replies: 3
Views: 6477

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
by Tom Zaccaria
Wed Feb 01, 2023 3:39 pm
Forum: Main Forum
Topic: Removing implant from tooth chart
Replies: 6
Views: 4380

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
by Tom Zaccaria
Wed Jan 25, 2023 12:33 pm
Forum: Main Forum
Topic: Removing implant from tooth chart
Replies: 6
Views: 4380

Re: Removing implant from tooth chart

You have to delete all the codes related to the implant in the chart module.

drtmz
by Tom Zaccaria
Wed Oct 12, 2022 4:25 am
Forum: Main Forum
Topic: Associate production and collections
Replies: 1
Views: 1252

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. /*-------------...
by Tom Zaccaria
Wed Sep 21, 2022 12:05 pm
Forum: Main Forum
Topic: Query for accounts with particular insurance carrier
Replies: 2
Views: 1241

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...
by Tom Zaccaria
Wed Sep 07, 2022 6:37 am
Forum: Main Forum
Topic: few query questions
Replies: 2
Views: 1243

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 */ /*----------------...
by Tom Zaccaria
Wed Sep 07, 2022 6:12 am
Forum: Main Forum
Topic: few query questions
Replies: 2
Views: 1243

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....
by Tom Zaccaria
Mon Apr 18, 2022 5:25 am
Forum: Main Forum
Topic: Provider reorder (Up and Down) button does not show
Replies: 2
Views: 1747

Re: Provider reorder (Up and Down) button does not show

Did you click on the column header?

drtmz
by Tom Zaccaria
Thu Apr 14, 2022 2:30 am
Forum: Main Forum
Topic: Calling all query wizards!
Replies: 2
Views: 1869

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...
by Tom Zaccaria
Thu Mar 31, 2022 3:36 am
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

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
by Tom Zaccaria
Thu Mar 31, 2022 2:43 am
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

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
by Tom Zaccaria
Wed Mar 30, 2022 5:13 am
Forum: Main Forum
Topic: Custom Query for Discount Plan
Replies: 10
Views: 4330

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 ...
by Tom Zaccaria
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: 1852

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...
by Tom Zaccaria
Mon Mar 14, 2022 4:40 am
Forum: Main Forum
Topic: Columns overlapping in query reports
Replies: 5
Views: 2869

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
by Tom Zaccaria
Sun Mar 13, 2022 5:29 am
Forum: Main Forum
Topic: Columns overlapping in query reports
Replies: 5
Views: 2869

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
by Tom Zaccaria
Sun Mar 13, 2022 5:24 am
Forum: Main Forum
Topic: Columns overlapping in query reports
Replies: 5
Views: 2869

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....
by Tom Zaccaria
Tue Mar 08, 2022 3:03 am
Forum: Main Forum
Topic: Search for blockouts
Replies: 4
Views: 2480

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...
by Tom Zaccaria
Mon Mar 07, 2022 1:25 pm
Forum: Main Forum
Topic: Search for blockouts
Replies: 4
Views: 2480

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...
by Tom Zaccaria
Thu Feb 17, 2022 3:43 am
Forum: Main Forum
Topic: Columns overlapping in query reports
Replies: 5
Views: 2869

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 ...
by Tom Zaccaria
Wed Feb 16, 2022 5:05 am
Forum: Main Forum
Topic: Vaailable Hygiene Appointments
Replies: 1
Views: 1562

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
by Tom Zaccaria
Sun Feb 06, 2022 3:05 am
Forum: Main Forum
Topic: Crashed table
Replies: 9
Views: 5640

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
by Tom Zaccaria
Sat Feb 05, 2022 2:49 am
Forum: Main Forum
Topic: Crashed table
Replies: 9
Views: 5640

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...
by Tom Zaccaria
Fri Feb 04, 2022 1:51 pm
Forum: Main Forum
Topic: Crashed table
Replies: 9
Views: 5640

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...
by Tom Zaccaria
Thu Dec 16, 2021 10:39 am
Forum: Developers
Topic: Converting to MariaDB
Replies: 2
Views: 3858

Re: Converting to MariaDB

Worked for me. Just open the file as administrator. Took about an hour.

drtmz
by Tom Zaccaria
Fri Nov 05, 2021 5:14 am
Forum: Main Forum
Topic: Overdue Hygiene Query
Replies: 1
Views: 2827

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...
by Tom Zaccaria
Thu Oct 21, 2021 5:32 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 4570

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
by Tom Zaccaria
Tue Oct 19, 2021 11:50 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 4570

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
by Tom Zaccaria
Tue Oct 19, 2021 10:48 am
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 4570

Re: Query to compare insurance reimbursements by ADA code

Thanks for your help.

drtmz
by Tom Zaccaria
Fri Oct 15, 2021 1:42 pm
Forum: Main Forum
Topic: Query to compare insurance reimbursements by ADA code
Replies: 4
Views: 4570

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...
by Tom Zaccaria
Thu Oct 07, 2021 8:37 am
Forum: Main Forum
Topic: A query/report
Replies: 3
Views: 4318

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 @...
by Tom Zaccaria
Mon Aug 30, 2021 4:33 am
Forum: Main Forum
Topic: MYSQL to MariaDB conversion
Replies: 3
Views: 5088

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...
by Tom Zaccaria
Wed Jul 28, 2021 11:20 am
Forum: Main Forum
Topic: You know what would be really cool?
Replies: 3
Views: 4561

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
by Tom Zaccaria
Wed Jul 28, 2021 10:35 am
Forum: Main Forum
Topic: You know what would be really cool?
Replies: 3
Views: 4561

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...
by Tom Zaccaria
Wed Jun 23, 2021 7:33 am
Forum: Advanced Topics
Topic: Message=Duplicate entry '4657089' for key 'PRIMARY'
Replies: 3
Views: 15284

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
by Tom Zaccaria
Mon Mar 29, 2021 4:34 pm
Forum: Advanced Topics
Topic: Appointment Mouse Over Info Customization
Replies: 3
Views: 10253

Re: Appointment Mouse Over Info Customization

Try

Main Menu / Display Fields / Appointment Bubble

drtmz
by Tom Zaccaria
Mon Mar 29, 2021 8:18 am
Forum: Main Forum
Topic: social security numbers
Replies: 2
Views: 6503

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
by Tom Zaccaria
Sat Mar 20, 2021 12:25 pm
Forum: Main Forum
Topic: "Unhandled exception has occured in your application"
Replies: 3
Views: 5376

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...
by Tom Zaccaria
Sat Mar 20, 2021 2:49 am
Forum: Main Forum
Topic: "Unhandled exception has occured in your application"
Replies: 3
Views: 5376

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
by Tom Zaccaria
Thu Mar 18, 2021 7:10 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9176

Re: Multiple Instances of OpenDental running on server

Fix seems to be working.
Thanks

drtmz
by Tom Zaccaria
Wed Mar 10, 2021 8:33 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9176

Re: Multiple Instances of OpenDental running on server

Right. When checking in Task Manager there were multiple (4) copies running.

drtmz
by Tom Zaccaria
Wed Mar 10, 2021 4:47 am
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9176

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
by Tom Zaccaria
Sat Jan 02, 2021 2:52 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

Re: Problem printing forms and letters

OK. Makes sense. We will wait for the bug to be corrected.

drtmz
by Tom Zaccaria
Wed Dec 30, 2020 2:50 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

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
by Tom Zaccaria
Mon Dec 28, 2020 5:02 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

Re: Problem printing forms and letters

That seemed to help a lot.
Thanks
drtmz
by Tom Zaccaria
Tue Dec 22, 2020 6:01 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

Re: Problem printing forms and letters

Microsoft Zoom is turned off on all work stations.

drtmz
by Tom Zaccaria
Sun Dec 20, 2020 2:52 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

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
by Tom Zaccaria
Fri Dec 18, 2020 5:33 am
Forum: Main Forum
Topic: Problem printing forms and letters
Replies: 10
Views: 9009

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
by Tom Zaccaria
Thu Dec 17, 2020 11:11 am
Forum: Main Forum
Topic: Report: patients by a specific code
Replies: 2
Views: 3597

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...
by Tom Zaccaria
Sat Dec 05, 2020 2:50 am
Forum: Main Forum
Topic: Custom Sheet
Replies: 4
Views: 4737

Re: Custom Sheet

Send a copy of it my way and I will see if I can help you out.

drtmz
tmzdds@gmail.com
by Tom Zaccaria
Tue Oct 27, 2020 3:04 pm
Forum: Main Forum
Topic: TEMPERATURE LOG
Replies: 5
Views: 6017

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 ...
by Tom Zaccaria
Thu Oct 22, 2020 4:18 am
Forum: Main Forum
Topic: TEMPERATURE LOG
Replies: 5
Views: 6017

Re: TEMPERATURE LOG

Nice evening's work.
Thanks,

drtmz
by Tom Zaccaria
Thu Sep 17, 2020 2:32 am
Forum: Main Forum
Topic: Issue with Forms and Letters
Replies: 3
Views: 4177

Re: Issue with Forms and Letters

Yes it was. Thank you.
drtmz
by Tom Zaccaria
Tue Sep 08, 2020 6:35 am
Forum: Main Forum
Topic: PDF Hell - Acrobat DC not a solution
Replies: 5
Views: 7192

Re: PDF Hell - Acrobat DC not a solution

Try Foxit free version. My IT guys are gravitating towart it.

drtmz
by Tom Zaccaria
Wed Aug 19, 2020 7:20 am
Forum: Main Forum
Topic: learning sql
Replies: 2
Views: 3592

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
by Tom Zaccaria
Thu Aug 13, 2020 5:43 am
Forum: Main Forum
Topic: Issue with Forms and Letters
Replies: 3
Views: 4177

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...
by Tom Zaccaria
Mon Aug 03, 2020 2:32 am
Forum: Main Forum
Topic: Unearned Income
Replies: 2
Views: 3594

Re: Unearned Income

Here is the work around
Reports, Standard, More Options, Uncheck Include Unearned

drtmz
by Tom Zaccaria
Wed Jul 29, 2020 5:09 am
Forum: Main Forum
Topic: Mass Email and Queries
Replies: 1
Views: 2937

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...
by Tom Zaccaria
Mon Jul 20, 2020 8:36 am
Forum: Main Forum
Topic: Report of procedures by year with patient names
Replies: 1
Views: 2663

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...
by Tom Zaccaria
Tue Jul 14, 2020 1:04 pm
Forum: Main Forum
Topic: Breaks between appointments
Replies: 1
Views: 3059

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
by Tom Zaccaria
Thu Jun 18, 2020 5:01 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 4882

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
by Tom Zaccaria
Tue Jun 16, 2020 8:34 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 4882

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...
by Tom Zaccaria
Tue Jun 16, 2020 7:46 am
Forum: Main Forum
Topic: A/R (filters) query
Replies: 4
Views: 4882

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...
by Tom Zaccaria
Wed Jun 10, 2020 8:21 am
Forum: Main Forum
Topic: NP Query/Report
Replies: 3
Views: 4447

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'...
by Tom Zaccaria
Tue Apr 14, 2020 3:05 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 8714

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
by Tom Zaccaria
Sat Apr 11, 2020 4:59 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 8714

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...
by Tom Zaccaria
Sat Apr 11, 2020 4:49 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 8714

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
by Tom Zaccaria
Thu Apr 09, 2020 2:28 pm
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 8714

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...
by Tom Zaccaria
Tue Apr 07, 2020 2:59 am
Forum: Main Forum
Topic: User query help
Replies: 8
Views: 8714

Re: User query help

Post the code you have so far and I will see what help to offer you.

drtmz
by Tom Zaccaria
Tue Mar 10, 2020 3:57 am
Forum: Main Forum
Topic: Tooth Chart Updating
Replies: 2
Views: 5325

Re: Tooth Chart Updating

Adjust the graphics on that workstation as detailed here...

https://www.opendental.com/manual/graphics.html

drtmz
by Tom Zaccaria
Mon Feb 17, 2020 5:16 am
Forum: Main Forum
Topic: Creating of Sheets
Replies: 2
Views: 5778

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...
by Tom Zaccaria
Mon Feb 10, 2020 7:00 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 6392

Re: Adjustment types

Actually the following query works better.

SELECT * FROM definition

Switch to Raw View and look at DefNum and ItemName columns.

drtmz
by Tom Zaccaria
Thu Feb 06, 2020 11:49 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 6392

Re: Adjustment types

Thank you

drtmz
by Tom Zaccaria
Thu Feb 06, 2020 7:59 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 6392

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
by Tom Zaccaria
Sun Jan 26, 2020 6:01 am
Forum: Main Forum
Topic: Query
Replies: 1
Views: 4769

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
by Tom Zaccaria
Fri Nov 01, 2019 12:03 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 10343

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
by Tom Zaccaria
Fri Nov 01, 2019 2:35 am
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 10343

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
by Tom Zaccaria
Thu Oct 31, 2019 1:08 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 10343

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
by Tom Zaccaria
Thu Oct 31, 2019 7:39 am
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 10343

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
by Tom Zaccaria
Wed Oct 30, 2019 6:43 pm
Forum: Main Forum
Topic: Error in home backup
Replies: 7
Views: 10343

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...
by Tom Zaccaria
Tue Oct 29, 2019 12:58 pm
Forum: Main Forum
Topic: Much more efficient way of charting
Replies: 17
Views: 27813

Re: Much more efficient way of charting

That seems to be what I have read in several places. Thanks for clearing it up.

drtmz
by Tom Zaccaria
Mon Oct 28, 2019 1:58 pm
Forum: Main Forum
Topic: Much more efficient way of charting
Replies: 17
Views: 27813

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
by Tom Zaccaria
Wed Oct 23, 2019 10:46 am
Forum: Main Forum
Topic: Update taking a long time (getting longer)
Replies: 3
Views: 5957

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
by Tom Zaccaria
Wed Oct 09, 2019 4:39 am
Forum: Main Forum
Topic: Update taking a long time (getting longer)
Replies: 3
Views: 5957

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...
by Tom Zaccaria
Wed Oct 02, 2019 6:48 am
Forum: Main Forum
Topic: Landscape vs Portrait
Replies: 4
Views: 7026

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
by Tom Zaccaria
Mon Sep 30, 2019 4:49 am
Forum: Main Forum
Topic: Problems with Dexis bridge.
Replies: 3
Views: 7192

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
by Tom Zaccaria
Thu Sep 19, 2019 6:16 am
Forum: Main Forum
Topic: Scheduling Template
Replies: 1
Views: 3250

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
by Tom Zaccaria
Sun Jun 30, 2019 4:29 am
Forum: Main Forum
Topic: cannot find or create the font. on statement PDFs
Replies: 2
Views: 3874

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
by Tom Zaccaria
Sun Jun 16, 2019 4:26 am
Forum: Main Forum
Topic: Patient Dashboard - 19.1 Version
Replies: 5
Views: 7923

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
by Tom Zaccaria
Thu Jun 13, 2019 3:05 am
Forum: Main Forum
Topic: Help finding report
Replies: 2
Views: 3763

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, ...
by Tom Zaccaria
Thu May 16, 2019 8:41 am
Forum: Main Forum
Topic: Query Help!!
Replies: 5
Views: 6463

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
by Tom Zaccaria
Tue May 14, 2019 1:47 pm
Forum: Main Forum
Topic: Query Help!!
Replies: 5
Views: 6463

Re: Query Help!!

try changing the last line to

ORDER by status;

drtmz
by Tom Zaccaria
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: 4976

Re: Add recall type to default list of recalls for new patie

See my post. That is how you setup new recalls.

drtmz
by Tom Zaccaria
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: 4976

Re: Add recall type to default list of recalls for new patie

Main Menu, click Setup, Appointments, Recall Types.

drtmz
by Tom Zaccaria
Mon Mar 25, 2019 2:53 am
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 8348

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
by Tom Zaccaria
Sun Mar 24, 2019 7:37 am
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 8348

Re: Printing my Insurance Carriers list

There is:

Main Menu, Lists, Insurance Carriers

drtmz
by Tom Zaccaria
Sat Mar 23, 2019 12:13 pm
Forum: Main Forum
Topic: Printing my Insurance Carriers list
Replies: 7
Views: 8348

Re: Printing my Insurance Carriers list

Try this,
drtmz

select CarrierName, Address, Address2, City, State, Zip, Phone, ElectID
from carrier
by Tom Zaccaria
Thu Mar 21, 2019 6:54 am
Forum: Main Forum
Topic: Inactive Pt Report
Replies: 2
Views: 3704

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....
by Tom Zaccaria
Wed Jan 09, 2019 8:56 am
Forum: Main Forum
Topic: Changing deceased account Guantor
Replies: 5
Views: 6926

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
by Tom Zaccaria
Tue Dec 04, 2018 4:59 pm
Forum: Main Forum
Topic: Welcome Back
Replies: 9
Views: 12848

Welcome Back

Did my eyes deceive me?
Welcome Back Arna !

drtmz
by Tom Zaccaria
Tue Dec 04, 2018 4:57 pm
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 5095

Re: Unearned income column

Thanks for the input.

drtmz
by Tom Zaccaria
Tue Dec 04, 2018 2:56 pm
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 5095

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
by Tom Zaccaria
Sun Dec 02, 2018 8:44 am
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 5095

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
by Tom Zaccaria
Mon Nov 12, 2018 10:57 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 3427

Re: Statement Note

Got it. Fairly well hidden.
drtmz
by Tom Zaccaria
Mon Nov 12, 2018 5:11 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 3427

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
by Tom Zaccaria
Wed Oct 10, 2018 11:49 am
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 7933

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
by Tom Zaccaria
Wed Oct 10, 2018 2:45 am
Forum: Main Forum
Topic: Create template database
Replies: 6
Views: 7933

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
by Tom Zaccaria
Mon Sep 03, 2018 2:58 am
Forum: Main Forum
Topic: @ActivePatCount
Replies: 1
Views: 3509

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 ...
by Tom Zaccaria
Wed Aug 15, 2018 7:24 am
Forum: Main Forum
Topic: reports help
Replies: 3
Views: 4922

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...
by Tom Zaccaria
Wed Aug 01, 2018 11:38 am
Forum: Main Forum
Topic: reports help
Replies: 3
Views: 4922

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...
by Tom Zaccaria
Sun Jul 01, 2018 3:52 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 6505

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
by Tom Zaccaria
Sun Jul 01, 2018 2:36 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 6505

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
by Tom Zaccaria
Sat Jun 30, 2018 10:30 am
Forum: Main Forum
Topic: Appointment box info
Replies: 5
Views: 6505

Re: Appointment box info

Change your appointment View by pushing F-1, F-2 etc. See if that helps

drtmz
by Tom Zaccaria
Mon Jun 25, 2018 2:19 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

Re: Strange Unhandled Exception

Although I did not stop mysql noone was logged in at the time of the backup.

drtmz
by Tom Zaccaria
Mon Jun 25, 2018 2:27 am
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

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
by Tom Zaccaria
Sat Jun 23, 2018 1:46 pm
Forum: Main Forum
Topic: Strange Unhandled Exception
Replies: 8
Views: 21808

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...
by Tom Zaccaria
Wed Jun 06, 2018 11:48 am
Forum: Main Forum
Topic: Remove patients with zero payments from daily report
Replies: 2
Views: 4363

Re: Remove patients with zero payments from daily report

I will look into the employee issue. Thank you.

drtmz
by Tom Zaccaria
Wed Jun 06, 2018 3:09 am
Forum: Main Forum
Topic: Remove patients with zero payments from daily report
Replies: 2
Views: 4363

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...
by Tom Zaccaria
Wed May 16, 2018 2:22 pm
Forum: Main Forum
Topic: can't connect to mysql host after windows update
Replies: 19
Views: 39353

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...
by Tom Zaccaria
Sat May 05, 2018 2:53 am
Forum: Main Forum
Topic: List of Emergency patients who never had cleaning done
Replies: 1
Views: 3937

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...
by Tom Zaccaria
Wed Apr 18, 2018 11:18 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

That did it. Perfect.
Very useful freebie!!

drtmz
by Tom Zaccaria
Wed Apr 18, 2018 3:06 am
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

Yes. No data in the daterange column.
At least on my version 17.4.50

drtmz
by Tom Zaccaria
Tue Apr 17, 2018 12:49 pm
Forum: Main Forum
Topic: Time card reports specifics
Replies: 9
Views: 14136

Re: Time card reports specifics

It seems to work but the daterange field doesn't populate. It only returns employee and hours.

drtmz
by Tom Zaccaria
Wed Mar 21, 2018 2:57 pm
Forum: Main Forum
Topic: Procedure report
Replies: 1
Views: 3642

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...
by Tom Zaccaria
Sun Mar 18, 2018 1:20 pm
Forum: Main Forum
Topic: Dr. Old and Dr. Young
Replies: 2
Views: 5427

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 ...
by Tom Zaccaria
Mon Mar 12, 2018 5:04 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 11717

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
by Tom Zaccaria
Thu Mar 01, 2018 2:43 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 5965

Re: Add Insurance Plan to Query #164

OK Thanks
drtmz
by Tom Zaccaria
Wed Feb 28, 2018 11:41 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 5965

Re: Add Insurance Plan to Query #164

Perfecto. OD support to the rescue again.
Great Work.
drtmz
by Tom Zaccaria
Wed Feb 28, 2018 3:41 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 5965

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...
by Tom Zaccaria
Tue Jan 16, 2018 3:55 am
Forum: Main Forum
Topic: Wrong patient's name on Pan
Replies: 1
Views: 3440

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...
by Tom Zaccaria
Sun Dec 31, 2017 2:45 am
Forum: Main Forum
Topic: Gray shade in graphical tooth chart
Replies: 9
Views: 18221

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
by Tom Zaccaria
Mon Dec 25, 2017 2:50 am
Forum: Main Forum
Topic: Prescription report
Replies: 2
Views: 4049

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
by Tom Zaccaria
Wed Dec 13, 2017 2:52 am
Forum: Main Forum
Topic: Potential bug? Ver. 17.3.31
Replies: 2
Views: 4278

Re: Potential bug? Ver. 17.3.31

Yes the Mouse focus on startup is very annoying.

drtmz
by Tom Zaccaria
Fri Oct 27, 2017 2:39 am
Forum: Main Forum
Topic: maximum connections
Replies: 8
Views: 14308

Re: maximum connections

The .ini trick seemed to work for now.
Thanks
drtmz
by Tom Zaccaria
Wed Oct 25, 2017 4:16 am
Forum: Main Forum
Topic: maximum connections
Replies: 8
Views: 14308

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...
by Tom Zaccaria
Wed Sep 20, 2017 1:23 pm
Forum: Main Forum
Topic: Query 1238
Replies: 5
Views: 8678

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 ...
by Tom Zaccaria
Wed Sep 20, 2017 1:20 pm
Forum: Main Forum
Topic: Query 1238
Replies: 5
Views: 8678

Re: Query 1238

Yes. You would need a completely different query.

drtmz
by Tom Zaccaria
Wed Sep 20, 2017 10:35 am
Forum: Main Forum
Topic: Query for list of guarantors
Replies: 2
Views: 4920

Re: Query for list of guarantors

Been working with that one. It might be what I need.
Thanks for the input.

drtmz
by Tom Zaccaria
Tue Sep 19, 2017 3:20 pm
Forum: Main Forum
Topic: Query for list of guarantors
Replies: 2
Views: 4920

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
by Tom Zaccaria
Mon Jul 10, 2017 11:26 am
Forum: Main Forum
Topic: Tooth chart on Treatment Plan
Replies: 7
Views: 11850

Re: Tooth chart on Treatment Plan

That did it. Thank you

drtmz
by Tom Zaccaria
Mon Jul 10, 2017 7:00 am
Forum: Main Forum
Topic: Tooth chart on Treatment Plan
Replies: 7
Views: 11850

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
by Tom Zaccaria
Tue Apr 25, 2017 10:46 am
Forum: Main Forum
Topic: Total patient visits query
Replies: 1
Views: 4620

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..........
by Tom Zaccaria
Sun Apr 16, 2017 2:44 am
Forum: Main Forum
Topic: Update from 15.3 to 16.4
Replies: 4
Views: 9632

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...
by Tom Zaccaria
Wed Mar 15, 2017 2:55 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 4868

Re: Query for write-offs and or adjustments by insurance pla

Cool. Not exactly what I needed but this should help.
Thank you

drtmz
by Tom Zaccaria
Tue Mar 14, 2017 10:22 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 4868

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...
by Tom Zaccaria
Tue Mar 14, 2017 6:23 am
Forum: Main Forum
Topic: Query for write-offs and or adjustments by insurance plan
Replies: 3
Views: 4868

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 ...
by Tom Zaccaria
Thu Feb 09, 2017 6:28 am
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 10064

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...
by Tom Zaccaria
Wed Feb 08, 2017 4:47 pm
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 10064

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...
by Tom Zaccaria
Sat Feb 04, 2017 3:21 am
Forum: Main Forum
Topic: Today was my last day at Open Dental
Replies: 8
Views: 11825

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
by Tom Zaccaria
Wed Feb 01, 2017 3:04 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 10601

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 ...
by Tom Zaccaria
Mon Jan 30, 2017 3:05 am
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 10601

Re: AR, how to break down by time chunks ins/pt

You can put in today's date or try
SET @AsOf=CURDATE();

drtmz
by Tom Zaccaria
Sun Jan 29, 2017 1:44 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 10601

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...
by Tom Zaccaria
Mon Jan 09, 2017 2:31 pm
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 7891

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...
by Tom Zaccaria
Sat Jan 07, 2017 3:11 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 7891

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
by Tom Zaccaria
Wed Jan 04, 2017 3:40 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 7891

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...
by Tom Zaccaria
Tue Nov 29, 2016 1:33 pm
Forum: Main Forum
Topic: OpenDental Newsletter
Replies: 2
Views: 5726

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...
by Tom Zaccaria
Thu Nov 17, 2016 8:15 am
Forum: Main Forum
Topic: query help
Replies: 5
Views: 17471

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
by Tom Zaccaria
Wed Nov 09, 2016 1:25 pm
Forum: Main Forum
Topic: query help
Replies: 5
Views: 17471

Re: query help

You may want to try query #1184

drtmz
by Tom Zaccaria
Mon Nov 07, 2016 4:59 am
Forum: Main Forum
Topic: New Patient report
Replies: 4
Views: 9002

Re: New Patient report

Can anybody help clear this up?
Which number is used for practice management purposes?

drtmz
by Tom Zaccaria
Fri Sep 30, 2016 2:53 am
Forum: Main Forum
Topic: appointment view
Replies: 4
Views: 8244

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
by Tom Zaccaria
Sun Sep 25, 2016 4:15 am
Forum: Main Forum
Topic: Query help add 'AbbrDesc' abbreviated description
Replies: 1
Views: 4289

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_, ...
by Tom Zaccaria
Wed Sep 21, 2016 3:06 pm
Forum: Main Forum
Topic: Need help to add email to a query
Replies: 2
Views: 4771

Re: Need help to add email to a query

try adding this line right after p.WirelessPhone,

p.email,

drtmz
by Tom Zaccaria
Fri Sep 02, 2016 12:54 pm
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 28251

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
by Tom Zaccaria
Fri Sep 02, 2016 11:07 am
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 28251

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
by Tom Zaccaria
Fri Sep 02, 2016 6:40 am
Forum: Main Forum
Topic: Trick to show missing crown/retained root tips on chart
Replies: 18
Views: 28251

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
by Tom Zaccaria
Mon Aug 15, 2016 2:45 am
Forum: Main Forum
Topic: Updating OD - Stuck in File Copier loop
Replies: 3
Views: 7938

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
by Tom Zaccaria
Thu Aug 11, 2016 2:52 am
Forum: Main Forum
Topic: OD settings for second office
Replies: 4
Views: 9790

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
by Tom Zaccaria
Sat Jul 23, 2016 3:03 am
Forum: Main Forum
Topic: Problems restoring OpenDental
Replies: 3
Views: 7716

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...
by Tom Zaccaria
Fri Jul 22, 2016 8:30 am
Forum: Main Forum
Topic: Problems restoring OpenDental
Replies: 3
Views: 7716

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
by Tom Zaccaria
Fri Jun 17, 2016 7:28 am
Forum: Main Forum
Topic: Query for new patients and insurance plans
Replies: 1
Views: 4483

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......
by Tom Zaccaria
Fri Jun 17, 2016 7:21 am
Forum: Main Forum
Topic: Printing reports in landscape mode
Replies: 2
Views: 5736

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
by Tom Zaccaria
Fri Jun 17, 2016 6:06 am
Forum: Main Forum
Topic: Printing reports in landscape mode
Replies: 2
Views: 5736

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
by Tom Zaccaria
Wed Jun 15, 2016 3:54 pm
Forum: Main Forum
Topic: Insurance Carrier list printed
Replies: 8
Views: 17091

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...
by Tom Zaccaria
Fri Jun 03, 2016 2:58 am
Forum: Main Forum
Topic: Hygiene production
Replies: 2
Views: 5921

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...
by Tom Zaccaria
Tue May 31, 2016 2:49 am
Forum: Main Forum
Topic: Surface Pro
Replies: 3
Views: 6918

Re: Surface Pro

They all work very well but we use laptops for X-rays.

drtmz
by Tom Zaccaria
Mon May 30, 2016 9:30 am
Forum: Main Forum
Topic: Surface Pro
Replies: 3
Views: 6918

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
by Tom Zaccaria
Sun Apr 24, 2016 2:42 am
Forum: Main Forum
Topic: Adding a simple Dr Note (not a procedure note)
Replies: 4
Views: 7477

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
by Tom Zaccaria
Wed Mar 23, 2016 11:33 am
Forum: Main Forum
Topic: Patient Info Custom Fields
Replies: 4
Views: 7830

Re: Patient Info Custom Fields

Nice little query. Very useful.

drtmz
by Tom Zaccaria
Sun Mar 20, 2016 3:32 am
Forum: Main Forum
Topic: Export/Import Auto Notes
Replies: 4
Views: 9107

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
by Tom Zaccaria
Fri Dec 18, 2015 4:33 pm
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 13728

Re: How about this report?

Great. Thank you,
drtmz
by Tom Zaccaria
Wed Dec 16, 2015 3:17 am
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 13728

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
by Tom Zaccaria
Wed Nov 18, 2015 1:47 pm
Forum: Developers
Topic: OD DataBase
Replies: 3
Views: 7143

Re: OD DataBase

Not a good idea. Access is not robust enough to handle all the tables in OD.

drtmz
by Tom Zaccaria
Wed Oct 28, 2015 1:41 pm
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 12019

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
by Tom Zaccaria
Wed Oct 28, 2015 9:31 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 12019

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...
by Tom Zaccaria
Wed Oct 28, 2015 9:14 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 12019

Re: Search patient chart notes

I will try both methods. Thanks
drtmz
by Tom Zaccaria
Wed Oct 28, 2015 4:46 am
Forum: Main Forum
Topic: Search patient chart notes
Replies: 7
Views: 12019

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
by Tom Zaccaria
Wed Oct 21, 2015 2:55 am
Forum: Main Forum
Topic: Query for free time by provider
Replies: 1
Views: 4163

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...
by Tom Zaccaria
Thu Sep 17, 2015 12:06 pm
Forum: Main Forum
Topic: Patients with remaining 2015 insurance benefits
Replies: 1
Views: 3802

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
by Tom Zaccaria
Wed Jul 22, 2015 2:47 am
Forum: Main Forum
Topic: Bulk commlog note
Replies: 1
Views: 3534

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...
by Tom Zaccaria
Tue Jun 09, 2015 3:35 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37024

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...
by Tom Zaccaria
Fri Jun 05, 2015 10:21 am
Forum: Main Forum
Topic: Glitch with employee hours totals
Replies: 2
Views: 3940

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
by Tom Zaccaria
Fri Jun 05, 2015 2:58 am
Forum: Main Forum
Topic: Glitch with employee hours totals
Replies: 2
Views: 3940

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, ...
by Tom Zaccaria
Thu May 28, 2015 2:20 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37024

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...
by Tom Zaccaria
Tue May 26, 2015 9:10 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37024

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
by Tom Zaccaria
Mon May 25, 2015 12:41 pm
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 37024

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