Search found 296 matches

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

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: 126

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: 1
Views: 153

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: 236

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: 275

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: 289

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: 310

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: 381

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: 679

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: 679

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: 679

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: 602

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: 2204

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: 2204

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: 2204

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: 2204

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: 2204

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: 2508

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 6:16 am
Forum: Main Forum
Topic: Creating of Sheets
Replies: 2
Views: 2901

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 8:00 am
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 3176

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 12:49 pm
Forum: Main Forum
Topic: Adjustment types
Replies: 3
Views: 3176

Re: Adjustment types

Thank you

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

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 7:01 am
Forum: Main Forum
Topic: Query
Replies: 1
Views: 2529

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: 4587

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: 4587

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: 4587

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: 4587

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: 4587

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: 14
Views: 7207

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: 14
Views: 7207

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: 2673

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: 2673

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: 1618

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: 3083

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: 1078

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: 990

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: 2461

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: 1081

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: 1766

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: 1766

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: 1693

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: 1693

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: 2127

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: 2127

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: 2127

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: 1101

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 9:56 am
Forum: Main Forum
Topic: Changing deceased account Guantor
Replies: 5
Views: 1945

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 5:59 pm
Forum: Main Forum
Topic: Welcome Back
Replies: 9
Views: 3195

Welcome Back

Did my eyes deceive me?
Welcome Back Arna !

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

Re: Unearned income column

Thanks for the input.

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

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 9:44 am
Forum: Main Forum
Topic: Unearned income column
Replies: 4
Views: 1705

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 11:57 am
Forum: Main Forum
Topic: Statement Note
Replies: 2
Views: 1177

Re: Statement Note

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

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: 2429

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: 2429

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: 1514

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: 1828

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: 1828

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: 2446

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: 2446

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: 2446

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: 5538

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: 5538

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: 5538

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: 1813

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: 1813

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: 17585

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: 1925

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: 7821

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: 7821

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: 7821

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: 1708

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: 2460

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: 5980

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 3:43 am
Forum: Main Forum
Topic: Add Insurance Plan to Query #164
Replies: 4
Views: 2480

Re: Add Insurance Plan to Query #164

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

Re: Add Insurance Plan to Query #164

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

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 4:55 am
Forum: Main Forum
Topic: Wrong patient's name on Pan
Replies: 1
Views: 1281

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 3:45 am
Forum: Main Forum
Topic: Gray shade in graphical tooth chart
Replies: 9
Views: 8204

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 3:50 am
Forum: Main Forum
Topic: Prescription report
Replies: 2
Views: 1575

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 3:52 am
Forum: Main Forum
Topic: Potential bug? Ver. 17.3.31
Replies: 2
Views: 1936

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: 5592

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: 5592

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: 4638

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: 4638

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: 2412

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: 2412

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: 2
Views: 3736

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: 2
Views: 3736

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: 2660

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: 6097

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: 1904

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: 1904

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: 1904

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 7:28 am
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 6153

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 5:47 pm
Forum: Main Forum
Topic: query for ppo/medicaid not seen in over 6 months
Replies: 4
Views: 6153

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 4:21 am
Forum: Main Forum
Topic: Today was my last day at Open Dental
Replies: 8
Views: 4283

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 4:04 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 6537

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 4:05 am
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 6537

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 2:44 pm
Forum: Main Forum
Topic: AR, how to break down by time chunks ins/pt
Replies: 5
Views: 6537

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 3:31 pm
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 4395

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 4:11 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 4395

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 4:40 am
Forum: Main Forum
Topic: 2016 payment report for taxes
Replies: 4
Views: 4395

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 2:33 pm
Forum: Main Forum
Topic: OpenDental Newsletter
Replies: 2
Views: 3104

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 9:15 am
Forum: Main Forum
Topic: query help
Replies: 5
Views: 6047

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 2:25 pm
Forum: Main Forum
Topic: query help
Replies: 5
Views: 6047

Re: query help

You may want to try query #1184

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

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: 4273

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: 2514

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: 2379

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: 13898

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: 13898

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: 13898

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: 4724

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: 6422

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: 5031

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: 5031

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: 2682

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: 3466

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: 3466

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: 11119

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: 3524

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: 3786

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: 3786

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: 4057

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: 4047

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: 4230

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 5:33 pm
Forum: Main Forum
Topic: How about this report?
Replies: 9
Views: 7296

Re: How about this report?

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

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 2:47 pm
Forum: Developers
Topic: OD DataBase
Replies: 3
Views: 4085

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: 7087

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: 7087

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: 7087

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: 7087

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: 2341

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: 2202

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: 1800

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: 21933

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: 1757

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: 1757

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: 21933

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: 21933

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: 21933

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
by Tom Zaccaria
Fri May 22, 2015 8:40 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 21933

Re: Broken, Cancelled and Failed Appointments

Also noticed that the D9986 is in black text.
We are used to the old blue. Much easier to pick up. Any way to change that font color?

drtmz
by Tom Zaccaria
Fri May 22, 2015 5:37 am
Forum: Main Forum
Topic: Broken, Cancelled and Failed Appointments
Replies: 23
Views: 21933

Broken, Cancelled and Failed Appointments

How are we differentiating

BA (break appointment day of),
CA (break appointment with 24 hours notice) and
FA ( didn't show up, no call)
appointments in version 15.2.3

They all seem to be lumped under Broken Appointments.

drtmz
by Tom Zaccaria
Sun May 03, 2015 3:01 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 9706

Re: XCopy backup problem

I restore from a thumb drive. In my case it is recognized as 'E drive'.
I stop the service, minimize that window,
restore,
maximize the stop window and start the service.
Click on OD, run as administrator and that's it

drtmz
by Tom Zaccaria
Sat May 02, 2015 10:42 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 9706

Re: XCopy backup problem

Are you in the right directory? Right click on the Start button in Windows 7 Pro 64 bit Search for Cmd.exe Right click to run as Administrator Type the following at the command prompt Net stop mysql (this will stop the service) Restore your files from backup and then type Net Start Mysql Exit Should...
by Tom Zaccaria
Fri Mar 20, 2015 5:12 am
Forum: Main Forum
Topic: Report for insures patient payments
Replies: 1
Views: 1000

Re: Report for insures patient payments

As luck would have it I just discovered query example #93 modified slightly was what I wanted.

drtmz
by Tom Zaccaria
Fri Mar 20, 2015 4:59 am
Forum: Main Forum
Topic: Report for insures patient payments
Replies: 1
Views: 1000

Report for insures patient payments

I had this report before but can't seem to put my fingers on it now. I need a report for 2014 or a time period consisting of what patients with a specific insurance plan actually paid our office by date or summary. Example: Patient...........Mr. Thisa Test Delta insurance..Delta Dental 2014-02-03......
by Tom Zaccaria
Thu Mar 05, 2015 12:01 pm
Forum: Main Forum
Topic: Custom statement
Replies: 2
Views: 1420

Re: Custom statement

Thank you

drtmz
by Tom Zaccaria
Tue Mar 03, 2015 1:56 pm
Forum: Main Forum
Topic: Custom statement
Replies: 2
Views: 1420

Custom statement

Designed a custom statement on a backup computer but can't find how to access it.
Does this statement take the place of the regular billing statements or is there a menu choice for it somewhere?

Thanks,
drtmz
by Tom Zaccaria
Fri Feb 27, 2015 9:49 am
Forum: Main Forum
Topic: Report - separate cash from credit card for patient income
Replies: 6
Views: 2520

Re: Report - separate cash from credit card for patient inco

This may help you from the examples page. Adjust the date within the quotes.

/*29*/ SELECT PayDate,PayType,PayAmt,CheckNum,BankBranch,PatNum
FROM payment
WHERE PayDate = '2015-02-23'
ORDER BY PayAmt

drtmz
by Tom Zaccaria
Wed Feb 04, 2015 4:34 am
Forum: Main Forum
Topic: Clinics selection in V 15.1.6
Replies: 2
Views: 1353

Clinics selection in V 15.1.6

Just downloaded OpenDental latest version 15.1.6. 1. Can I remove the 'Clinic' column from the daily payments report? This would make more room for the transactions to fit on one line and we don't use clinics. 2. I tried to look into this as an option and went to Main Menu, List as per the site but ...
by Tom Zaccaria
Thu Jan 29, 2015 9:09 am
Forum: Main Forum
Topic: Notes signing or not
Replies: 5
Views: 2513

Re: Notes signing or not

Typical typical dental folklore!
We don't sign anything. OpenDental inserts the treating doc's and assistant's initials and that's it.

drtmz
by Tom Zaccaria
Wed Jan 28, 2015 4:59 am
Forum: Main Forum
Topic: Morning Huddle Report
Replies: 15
Views: 14911

Re: Morning Huddle Report

This is getting interesting. Could we change the orientation to Landscape and add a column for date of last BW/FMX/PAN for the hygiene patients (those with a periodic exam, PerEx)? As in Column Heading of 'X-rays' BW 6-6-2014 FMX 6-6-2009 This would make it much easier to determine who is due for wh...
by Tom Zaccaria
Sat Jan 17, 2015 11:53 am
Forum: Main Forum
Topic: How to add patient.ChartNumber to Daily Payments Report
Replies: 4
Views: 1875

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

In searching the database documentation I found that 'chart number' was used for previous programs'. I guess this means for docs that converted from another PMS.
OpenDental uses PatientNumber.

Does this help?

drtmz
by Tom Zaccaria
Thu Jan 08, 2015 8:00 am
Forum: Main Forum
Topic: Help me edit an existing Query Example
Replies: 2
Views: 1256

Re: Help me edit an existing Query Example

You can simply run the query, select print preview and record the total from the last page without modifying the query.

drtmz
by Tom Zaccaria
Fri Dec 12, 2014 10:27 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 2746

Re: Need to change this query a little bit....help please!

Lastly, this would give you only the patients with insurance coverage: /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, patient.HasIns, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum I...
by Tom Zaccaria
Fri Dec 12, 2014 8:21 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 2746

Re: Need to change this query a little bit....help please!

This adds a column for insurance coverage; /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, patient.HasIns, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient g ON patie...
by Tom Zaccaria
Fri Dec 12, 2014 7:49 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 2746

Re: Need to change this query a little bit....help please!

This is one way of doing the date range /*505 Balances of patients with appointments on a given date*/ SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient g ON patient.Guarantor=g.PatN...
by Tom Zaccaria
Fri Dec 12, 2014 7:38 am
Forum: Main Forum
Topic: Need to change this query a little bit....help please!
Replies: 8
Views: 2746

Re: Need to change this query a little bit....help please!

This should remove the appointment column /*505 Balances of patients with appointments on a given date*/ SET @AptDate='2010-08-03'; SELECT patient.LName,patient.FName,patient.EstBalance AS PatBal, g.BalTotal FROM appointment INNER JOIN patient ON appointment.PatNum=patient.PatNum INNER JOIN patient ...
by Tom Zaccaria
Thu Dec 11, 2014 1:06 pm
Forum: Advanced Topics
Topic: Active patients or patients seen in the last 24 months
Replies: 1
Views: 1633

Re: Active patients or patients seen in the last 24 months

Change the dates according to your needs # Count of active patients seen between two dates SET @pos=0; SELECT Year(ProcDate) AS Year, Month(ProcDate) AS month, COUNT(DISTINCT patient.PatNum)AS 'Patients' from patient, procedurelog WHERE procedurelog.patnum = patient.patnum AND patient.patstatus = '0...
by Tom Zaccaria
Wed Dec 03, 2014 11:11 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 1894

Re: Error with home restore

Throws Unhandled Exception box and the only thing I can do is Exit

I think we've come across this before but I cannot remember the cure!

drtmz
by Tom Zaccaria
Wed Dec 03, 2014 11:08 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 1894

Re: Error with home restore

OD won't start at all.
drtmz
by Tom Zaccaria
Wed Dec 03, 2014 4:21 am
Forum: Main Forum
Topic: Error with home restore
Replies: 4
Views: 1894

Error with home restore

Trying to restore my daily backup from yesterday and got this error,
'Duplicate entry '688306' for key 'PRIMARY''

I backup and restore the same way every day but do get this error from time to time. Wassup??
drtmz
by Tom Zaccaria
Sun Sep 21, 2014 2:55 am
Forum: Main Forum
Topic: Patient Purge
Replies: 1
Views: 1065

Re: Patient Purge

Yes you can do this. Call support and for a nominal fee they will do exactly what you are looking for.
We did it a while ago with a start-up and it worked great.
All you would have to do is change the pertinent information such as name, address, NIP# etc.
drtmz
by Tom Zaccaria
Thu Aug 21, 2014 7:12 pm
Forum: Main Forum
Topic: Trouble expanding schedule
Replies: 1
Views: 1014

Re: Trouble expanding schedule

Got the answer from our friends at OpenDental. The schedule will only show one year at a time. And I was reminded that I was the one that made this suggestion.
Ooops!!

drtmz
by Tom Zaccaria
Tue Aug 19, 2014 4:40 pm
Forum: Main Forum
Topic: Trouble expanding schedule
Replies: 1
Views: 1014

Trouble expanding schedule

Tried to expand our schedule today but it won't hold. Used Setup, Schedules Made changes which were basically to increase our schedule by one year, Exit schedule screen and then go back to check and the expanded portion of the schedule is gone. Anyone else have this issue? Did I miss something? We a...
by Tom Zaccaria
Wed Aug 13, 2014 3:58 am
Forum: Main Forum
Topic: Modified monthly totals in columns
Replies: 0
Views: 1660

Modified monthly totals in columns

Here is a modified query to find the monthly totals of the more popular procedures in columns. We add an 'AbbrDesc' description column and a yearly total on the right side. With help from our friends at OpenDental. Enjoy! drtmz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ /*839 Count of procedures comple...
by Tom Zaccaria
Mon Aug 11, 2014 5:09 pm
Forum: Main Forum
Topic: Problem with a Case statement
Replies: 3
Views: 1619

Re: Problem with a Case statement

What I am trying to do is run the query on any day of this current week and get the hours totals for the previous two full weeks. For example if I run the query on Tuesday, August 12, 2014 I want the hours from July 28 to August 8. If I run the query on Wednesday, August 13, 2014 I want the same day...
by Tom Zaccaria
Fri Aug 08, 2014 4:13 am
Forum: Main Forum
Topic: Problem with a Case statement
Replies: 3
Views: 1619

Problem with a Case statement

I am trying to run a query of employee hours any day of the week and get the same results. The query works but the Case statement does not. Anyone have any ideas as to why this wont work? Thanks drtmz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ /*Time Card Summary*/ CASE daterun WHEN DAYOFWEEK(C...
by Tom Zaccaria
Thu Jun 05, 2014 4:53 pm
Forum: Main Forum
Topic: Where is "Dentist Name or Practice Title" stored?
Replies: 3
Views: 1410

Re: Where is "Dentist Name or Practice Title" stored?

Did you try,
Setup, Miscellaneous, Text Title box?

drtmz
by Tom Zaccaria
Thu May 29, 2014 12:25 pm
Forum: Main Forum
Topic: Copy of OpenDental for new location
Replies: 2
Views: 1226

Re: Copy of OpenDental for new location

ok. Great. I will give them a call when ready.
drtmz
by Tom Zaccaria
Thu May 29, 2014 4:56 am
Forum: Main Forum
Topic: Copy of OpenDental for new location
Replies: 2
Views: 1226

Copy of OpenDental for new location

Need a fresh copy of OpenDental for a new location. No patients or patient information but maintaining all the functionality and customization we have now such as proc buttons, tx templates, insurance information sheets, etc. What is the best way to do this? Have OD central delete patient data and k...
by Tom Zaccaria
Thu May 15, 2014 2:56 am
Forum: Main Forum
Topic: emailing a specialist, not the patient
Replies: 2
Views: 1209

Re: emailing a specialist, not the patient

Why not add all the specialists in OD as patients. This way you will be able to email them and you have an automatic record of all the correspondences.

drtmz
by Tom Zaccaria
Fri May 02, 2014 6:00 am
Forum: Main Forum
Topic: How many days did i work?
Replies: 6
Views: 3783

Re: How many days did i work?

Ok I tweaked the second qurey to list all the ops used for the month of April 2014 /*Number of days worked in date range (days where appointments were completed)*/ /* Z=4, L =1*/ SET @FromDate='2014-04-01', @ToDate='2014-04-31'; SELECT COUNT(DISTINCT DATE(ap.AptDateTime)) AS 'Number of days worked' ...
by Tom Zaccaria
Fri May 02, 2014 3:36 am
Forum: Main Forum
Topic: How many days did i work?
Replies: 6
Views: 3783

Re: How many days did i work?

even better yet would be full days and half days totaled over a date range by provider, such as;

Dr H 5.0
Dr K 6.5
Dr T 6.0
Hyg 1 3.5

drtmz
by Tom Zaccaria
Fri May 02, 2014 3:21 am
Forum: Main Forum
Topic: How many days did i work?
Replies: 6
Views: 3783

Re: How many days did i work?

I have been searching for one of these forever. Now if we could just modify the first one to include half days that would be even better.
Now it counts a half day as a full day. I need the distinction between the two as in 5.5 days.

drtmz
by Tom Zaccaria
Fri Apr 04, 2014 8:43 am
Forum: Main Forum
Topic: Sheets Question
Replies: 8
Views: 3062

Re: Sheets Question

As a test decrease the font size on just one label and see if more of the label fits on the print out.

drtmz
by Tom Zaccaria
Thu Mar 27, 2014 5:26 pm
Forum: Main Forum
Topic: Updating Insurance Benefits
Replies: 1
Views: 1114

Re: Updating Insurance Benefits

Goto patient's chart
Click on Insurance
Upper right corner "Adjustment to insurance benefits" window click 'Add'

Enter amount used at another office.

drtmz
by Tom Zaccaria
Thu Mar 27, 2014 2:56 am
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Re: Query for total pans taken by month

It would be really helpful if the report were reversed. Since there are many, many more procedures than months it would be better if the months were columns and the procedure codes rows.
Anyone out there with input on this?

Thanks,
drtmz
by Tom Zaccaria
Tue Mar 25, 2014 2:58 am
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Re: Query for total pans taken by month

Got it. I was changing both tables. Once I changed the field in t1 only it works likes a charm.

Thanks
drtmz
by Tom Zaccaria
Sat Mar 22, 2014 3:01 am
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Re: Query for total pans taken by month

I actually expanded the report to include a lot more procedures. But to make all this even better I would like to replace Pan with 3310 in the column heading and do this with all the ADA procedure codes in the report. It would be easer to read in it's expanded form. Changing the field declarations a...
by Tom Zaccaria
Thu Mar 20, 2014 4:12 pm
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Re: Query for total pans taken by month

That is even better. I'm gonna have fun with this new report.
Thanks again,
drtmz
by Tom Zaccaria
Thu Mar 20, 2014 8:21 am
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Re: Query for total pans taken by month

Kevin,
That is exactly what I was looking for.
Thank you,
drtmz
by Tom Zaccaria
Thu Mar 20, 2014 5:16 am
Forum: Main Forum
Topic: Query for total pans taken by month
Replies: 9
Views: 2830

Query for total pans taken by month

Need some help with a query for the number of pans, D0330, taken for a year totaled by month.

Thanks
drtmz
by Tom Zaccaria
Sat Mar 01, 2014 6:04 pm
Forum: Main Forum
Topic: Breakdown of payee type?
Replies: 1
Views: 919

Re: Breakdown of payee type?

May want to start here

http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

Type payment in the first criteria box

#47 will give you what you want for one day. Need to search further if you want results for a date range.

drtmz
by Tom Zaccaria
Wed Feb 26, 2014 2:29 pm
Forum: Main Forum
Topic: dIGITAL PAN ON LAPTOP
Replies: 2
Views: 1392

Re: dIGITAL PAN ON LAPTOP

I understand that the Pan gets connected to the desktop or laptop and the desktop or laptop gets connected to the network. I have all that setup. But will a new laptop be sufficient for this connection? They are telling me no. Laptops usually only have one ethernet connection. But I purchased an eth...
by Tom Zaccaria
Wed Feb 26, 2014 4:26 am
Forum: Main Forum
Topic: dIGITAL PAN ON LAPTOP
Replies: 2
Views: 1392

dIGITAL PAN ON LAPTOP

Any reason we can't install a GenDex digital pan with OpenDental on a laptop running W7 Pro 64 bit? Sales guy is saying it must be a desktop with two ethernet ports. We can get a ethernet to USB adapter for the laptop. Will this work? Am I getting the ole sales pitch here? We current use OD in all o...
by Tom Zaccaria
Tue Feb 25, 2014 5:24 pm
Forum: Main Forum
Topic: Morning Huddle Report
Replies: 15
Views: 14911

Re: Morning Huddle Report

You may be over-thinking the situation here. The only time the morning huddle information is useful is on the day of the huddle. No need for a change of dates capacity as the information in the appointments may change between the time you print the report and the time of the actual huddle. It is a v...
by Tom Zaccaria
Tue Feb 25, 2014 11:17 am
Forum: Main Forum
Topic: Morning Huddle Report
Replies: 15
Views: 14911

Re: Morning Huddle Report

I changed this line,

WHERE DATE(a.AptDateTime) = CURDATE()+1 AND AptStatus=1

and it worked for tomorrow.

drtmz
by Tom Zaccaria
Wed Feb 05, 2014 3:55 am
Forum: Advanced Topics
Topic: Question on Building an advanced metrics query
Replies: 11
Views: 6681

Re: Question on Building an advanced metrics query

Don't feel too bad. After running the query I was amazed to find out how close 'your' numbers were to ours for 2013.
Took me at least ten minutes to realize that the numbers were from our results.
Color me 'stupid'.

drtmz
by Tom Zaccaria
Tue Feb 04, 2014 5:31 pm
Forum: Advanced Topics
Topic: Question on Building an advanced metrics query
Replies: 11
Views: 6681

Re: Question on Building an advanced metrics query

Did run this query on our results for 2013. Problem is $DrProd, $DRDay and $DRHr columns were all '0' . It basically gives all the production and collections to hygiene. Is it something in the query or the way we have things coded internally? I am able to differentiate dr and hyg production in other...
by Tom Zaccaria
Fri Jan 24, 2014 4:02 am
Forum: Main Forum
Topic: XP and Windows 7 compatible?
Replies: 3
Views: 1812

Re: XP and Windows 7 compatible?

Not entirely true

'Microsoft will extend support for Windows XP's anti-malware security until July 2015 and continue to provide updates to its anti-malware signatures and engine for Windows XP users, according to a TechNet blog post. '

drtmz
by Tom Zaccaria
Thu Jan 23, 2014 9:15 am
Forum: Main Forum
Topic: When ins. pays via credit card instead of check
Replies: 9
Views: 3395

Re: When ins. pays via credit card instead of check

Agreed. We use direct deposit for all the companies whenever possible.
No more looking for the mailman. Saves trips to the bank.
drtmz
by Tom Zaccaria
Fri Jan 10, 2014 1:30 pm
Forum: Advanced Topics
Topic: Aged Recall query
Replies: 1
Views: 2278

Re: Aged Recall query

Give this a try. It finds six month adult and child prophies with no appointment scheduled. You can manipulate the Interval to go back even further. Plus at the end you can eliminate any insurance plans if you wish. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ /*Modified 264 List of procedures for a date r...
by Tom Zaccaria
Sat Dec 07, 2013 4:20 am
Forum: Main Forum
Topic: Problem with statement layout & window envelopes
Replies: 4
Views: 1827

Re: Problem with statement layout & window envelopes

The statements are printed for what is called an double window invoice envelope. We have never had a problem with these envelopes. Now they don't fit the same in a standard #10 single window envelope. Is that what you are referring to? As an aside, the invoice envelopes are much more expensive that ...
by Tom Zaccaria
Tue Nov 19, 2013 10:44 am
Forum: Main Forum
Topic: back up
Replies: 13
Views: 4428

Re: back up

Let me add this to whatever has been said here. A backup is not complete until it is properly restored and tested in another location. This way you know the backup is valid.
My day is not finished until I restore and boot up OD at home.

Last piece of the puzzle

drtmz
by Tom Zaccaria
Wed Nov 13, 2013 5:55 pm
Forum: Main Forum
Topic: Shredding Service
Replies: 7
Views: 2829

Re: Shredding Service

We have that exact model. Had it for three years. Works great.

drtmz
by Tom Zaccaria
Mon Nov 11, 2013 5:40 pm
Forum: Main Forum
Topic: Two Win 8 questions
Replies: 15
Views: 4913

Re: Two Win 8 questions

Figured it out over the weekend that if you unlock the Taskbar and drag it to the right, or left I guess, margin of the screen, OpenDental will have enough screen real estate to properly perform on a Microsoft Surface tablet running Windows 8.1. With the Taksbar in its normal position at the bottom ...