Open Dental

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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...

Tom Zaccaria

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

drtmz

Tom Zaccaria

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......

Tom Zaccaria

Thank you

drtmz

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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 ...

Tom Zaccaria

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

drtmz

Tom Zaccaria

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...

Tom Zaccaria

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

Tom Zaccaria

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

drtmz

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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 ...

Tom Zaccaria

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...

Tom Zaccaria

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

Tom Zaccaria

OD won't start at all.
drtmz

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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

drtmz

Tom Zaccaria

ok. Great. I will give them a call when ready.
drtmz

Tom Zaccaria

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...

Tom Zaccaria

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

Tom Zaccaria

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' ...

Tom Zaccaria

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

Tom Zaccaria

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

Tom Zaccaria

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

drtmz

Tom Zaccaria

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

Enter amount used at another office.

drtmz

Tom Zaccaria

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

Tom Zaccaria

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

Thanks
drtmz

Tom Zaccaria

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...

Tom Zaccaria

That is even better. I'm gonna have fun with this new report.
Thanks again,
drtmz

Tom Zaccaria

Kevin,
That is exactly what I was looking for.
Thank you,
drtmz

Tom Zaccaria

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

Thanks
drtmz

Tom Zaccaria

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

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

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...

Tom Zaccaria

I changed this line,

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

and it worked for tomorrow.

drtmz

Tom Zaccaria

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

Tom Zaccaria

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...

Tom Zaccaria

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

Tom Zaccaria

Agreed. We use direct deposit for all the companies whenever possible.
No more looking for the mailman. Saves trips to the bank.
drtmz

Tom Zaccaria

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...

Tom Zaccaria

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 ...

Tom Zaccaria

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

Tom Zaccaria

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

drtmz

Tom Zaccaria

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 ...

Tom Zaccaria

IT guy advised against Win8.0, 8.1 for now because of similar compatibility issues.
We went to Windows 7 Pro 64 bit.

drtmz

Tom Zaccaria

Query # 746 calculates RawHours or clock hours employees work. Considering hygiene only, can anyone direct me to a query that will calculate the time a clocked in hygienist does not or did not have a patient scheduled? For example, she was clocked in all morning but did not have a patient scheduled ...

Tom Zaccaria

I finally got my Windows tablet working with 8.0 and upgraded to 8.1. Everything was a challenge. Took a couple of weeks. Nice display but the interface is so radically different than the XP and Win7 machines I would hesitate to take it to the office for fear of physical harm, mine. I literally sit ...

Tom Zaccaria

IT guy is telling me that as of April 2014 HIPPA will no longer allow Windows XP to be running personal data. Windows 7 pro will be the minimum. He does not like Windows 8. Sounds dire to me. Let me throw this out to the OpenDental community for comment(s). Anybody hear anything on this? We are in t...

Tom Zaccaria

Thanks. Will give that a try.
It sounds a lot better than me just throwing it out the window.

drtmz

Tom Zaccaria

Must say it has been a struggle. Not a fan of Metro. Downloaded a classic startup. Got OD downloaded and installed but not able to start it. Have Windows 8.0 Says, "OpenDental has stopped working. Windows looking for a solution to the problem. Which is doesn't find. Need more time to fiddle with it....

Tom Zaccaria

Anyone out there running OD on any of Microsoft new surface tablets with windows 8?
I am looking to upgrade from our Motion computing tablets.

Thanks,
drtmz

Tom Zaccaria

We use the templates that came with the imaging software and bridge the images to OpenDental.
What digital package are you using?

drtmz

Tom Zaccaria

I use this on on a weekly basis to go after overdue claims. We give then 20 days and then check. You could make the interval longer or shorter by changing the 'INTERVAL xx DAY' line below. /*133 */ SELECT cl.PatNum, cl.DateService,cl.DateSent, cl.ClaimType, ca.CarrierName, ca.Phone, cl.claimfee FROM...

Tom Zaccaria

Very nice work but I don't get the purpose.
There are other reports for following up on outstanding claims by date of service.

drtmz

Tom Zaccaria

We're in PA outside of Philly

drtmz

Tom Zaccaria

1,2,3,4 and four done exactly as you described did the trick.
Thanks,
Another kudo for the OD team

drtmz

Tom Zaccaria

Don't get that option when choosing continue.
The page never loads so I can't see its history.

drtmz

Tom Zaccaria

Need some help deleting a bad WIKI page. We were copying and pasting form one page to another. Must not have gotten all the codes and pasted and saved the error. Now get the 'unhandled exception' when we go to open the page. Can't open the page so can't delete. Any ideas? Help! Other than that WIKI ...

Tom Zaccaria

I would be happy to help you.

610-322-0564
Anytime EST
drtmz@comcast.net

drtmz

Tom Zaccaria

You can do this with Blockouts

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

drtmz

Tom Zaccaria

What I see this as is 'Weenie World'. Dentists are weenies always worried about the smallest nonsense. Air dry, don't extract the day before a holiday, don't do this or don't do that because. Bottom line is ...If they want to getchya, they will getchya. Doesn't matter, signed or unsigned. Personally...

Tom Zaccaria

Need recommendation for new server. OD is freezing on our machines and I am told it is our five year old server that is the problem. Currently we have a Dell PowerEdge 1900 with Windows 2003 server. Use a mixture of Windows XP and Windows 7 pro in the office. Network printer. IT guy wants over 12k t...

Tom Zaccaria

If you ever have a question about OpenDental's support just look at the time the questions are posted and when they are answered by OD support, almost in real time.
You can't beat that for service.
Plus they will encourage you to call in if that will solve the problem.

drtmz

Tom Zaccaria

Yes I can do that but I wanted the subtotal of each carrier in the list eg. Patient 1...UCCI........100.00 Patient 2...UCCI........200.00 .........................300.00 Patient 3...MetLife....100.00 Patient 4...MetLife....200.00 Patient 5...MetLife....400.00 .........................700.00 Final to...

Tom Zaccaria

Did find this in the examples: /*5*/ SELECT patient.ChartNumber, CONCAT(patient.LName,', ',patient.FName,' ',patient.MiddleI) AS Name, claimpayment.CheckDate, carrier.CarrierName,claimpayment.CheckNum, claimproc.ClaimNum,SUM(claimproc.InsPayAmt) as $Amt FROM claimpayment,claimproc,insplan,patient,ca...

Tom Zaccaria

Can someone point me to the code behind the saved reports if possible?
I would like to modify the the Daily Payments report to group the insurance checks by carrier and also subtotal by carrier.

Thanks,
drtmz

Tom Zaccaria

Database tools found three corrupt files.
Fixed them and now home backup is happy as a clam.

Thanks,
drtmz

Tom Zaccaria

Tried it. No luck.
I can access all the modules except the chart module.

drtmz

Tom Zaccaria

Got this message after restoring backup to home computer.Tried to go to patient chart.

Unhandled exception
'Duplicate Entry '344498' for key 'PRIMARY''

Been restoring successfully for days. Any ideas?

drtmz

Tom Zaccaria

Thanks. I will give that a try.

drtmz

Tom Zaccaria

Not sure if this is an OD question or a network issue. Just had a new desktop added to our network. But now when we start OpenDental it will ask for the location of the images folder on the server. Not all but a few of them. Once you direct the program to the right location all work fine. But if you...

Tom Zaccaria

But to see which plan they have, Aetna, MetLife, Delta, you have to setup a custom field, select where you want it to show and manually enter the name in that field.

Tom Zaccaria

I would search online for mysql tutorials for examples and then just jump in. We'll help you.

drtmz

Tom Zaccaria

I think if you open a Word document in Notepad and then save it from Notepad using a different name it should be able to copy it over into the Wiki.
Notepad saves as plain text.

drtmz

Tom Zaccaria

Don't despair. We have been using, as mentioned earlier, the Epson GT-S50 for a long time.
Works great both in and out of OD.

drtmz

Tom Zaccaria

Could go to Manage/Billing/Dunning messages
Either add it into the existing messages boxes for all the time periods or
click add Dunning Message on the lower right side and add it to the statements in either regular or bold text.

drtmz

Tom Zaccaria

Very useful. Should be included in the examples list.

drtmz

Tom Zaccaria

Here it more when they see the digital x-rays.
Usually, "Are those my teeth?" and "That was fast."

Don't normally refer them to the graphics in OD.

drtmz

Tom Zaccaria

Try this:

select PatNum, IsDisabled from recall
WHERE IsDisabled ='1'

Assuming 1 = true

drtmz

Tom Zaccaria

Modified it slightly to this:

Change dates and patient number as needed

/*75*/
SET @StartDate='2012-01-01';
SET @EndDate='2012-12-31';
SET @PatientNumber=424;
SELECT Patnum, ProcDate, SplitAmt, ProvNum, DatePay
FROM paysplit WHERE
DatePay>=@StartDate AND
DatePay<=@EndDate AND
PatNum=@PatientNumber;

Tom Zaccaria

Patient payments for a date range.

Try this but change the dates if necessary.

/*75*/ SET @StartDate='2012-01-01';
SET @EndDate='2012-12-31';
SET @PatientNumber=6179;
SELECT * FROM paysplit WHERE
DatePay>=@StartDate AND
DatePay<=@EndDate AND
PatNum=@PatientNumber;

drtmz

Tom Zaccaria

Anyone here want to reply to the question 'does FastAttach speed up the preauthorization process?'
Do you get approvals back in less that 3-4 weeks?

Tom Zaccaria

How much faster is the turnaround when the attachments are sent in through NEA and FastAttach as opposed to the US mail? Now we are running 3-4 weeks on preauths sent in via mail with the x-rays attached. Does the electronic version speed up the process? Once installed it this pretty seamless? I am ...

Tom Zaccaria

For God's Sake stop acting like a bunch of weenies!!!

The monthly support makes the program better. Just pay it and move on.
Consider it internal marketing when your patient base sees all the cool things OD can do.

Look at the big picture.

drtmz

Tom Zaccaria

She wasn't one of the regular receptionists. Just an assistant jumping in to help out that can't say no. End of story is we don't participate with their insurance plan so they were cancelled out. Should be fairly easy, use guarantor and family members referencing an appointment time stamp of some ty...

Tom Zaccaria

Any way to limit the number patients in the same family from scheduling on the same day?

I would like to make it three per day. Had a new family call yesterday and front desk scheduled seven of them in one afternoon.
Something tells me that isn't going to work out very well.

Thanks,
drtmz

Tom Zaccaria

I really love your PPS. Great idea.

drtmz

Tom Zaccaria

Ok. My fix for this was to: 1. add a new code D1208a with a description of topical application of fluoride varnish. We will use this for children up to 16 or 19 depending on the plan. 2. we went ahead and changed the ADA code for the fluoride applications for 2013 to this new number (D1208a) 3. chan...

Tom Zaccaria

According to what Delta Dental sent us; D1206=topical application of fluoride varnish (which we use) D1208=topical application of fluoride (I'm guessing jel) I was going to change and then follow up on non payments. But the description portion needs to be corrected. Anyone else have any input on thi...

Tom Zaccaria

What are we doing for the new ADA codes for 2013? Specifically, the most common changes are D1203 and D1204 child and adult fluoride treatments are being replaced by D1206. D1206 exists now but the description is incorrect according to the 2013 version. Will we have to recode all the quick proc butt...

Tom Zaccaria

This method works but we were never able to get crisp scans to build on. Tried all kinds of flatbed scanners in various dpi. May as well just bite the bullet and start from scratch with a blank lab slip for example. Then you only need to scan any graphics such as the lab's symbol if any or the ponti...

Tom Zaccaria

Also I think it would be even better to change the page orientation to landscape and include a monthly total of each code with the total in the last column. This way you could see which months are most busy for which procedures. Anyone else think this would be of value? Does it exist already somewhe...

Tom Zaccaria

That's it exactly. Very handy.
Never thought it would be under Daily.
Thanks
drtmz

Tom Zaccaria

I want to figure out how to run a report that would tell me how many times during a date range (for example the past year) I completed a certain code. I want a count of how many crowns, dentures, adult prophies, etc. were done over a time period. Searched Dental Town and the answer was 'Reports, Mon...

Tom Zaccaria

No did not know that it was to be imported. Makes a world of difference.
Nice job.

drtmz

Tom Zaccaria

Is it just me but all I get from any of these attachments this is source code.
What am I doing wrong?
drtmz

Tom Zaccaria

Bingo!! That's it.
Thanks,

drtmz

Tom Zaccaria

Couldn't find the file on my hard drive or the backup disk.
Backed up a couple of versions until I got OD to work. Then installed the latest version from the office.

Working as expected. Another bullet dodged!
drtmz

Tom Zaccaria

I am getting the following error when trying to install a backup copy of OD
to a new home desktop running Windows 7 Professional.

Incorrect information in file: '\opendental\tempfambal.frm'

Help!
drtmz

Tom Zaccaria

It is but it isn't. Certain notes are recorded there but the adjustment notes are not. Eg. Employee forgets to clock in for the afternoon. Reminds me at the end of the day. I access her timecard and add a 4 hour positive adjustment with the note 'forgot to clock in after lunch'. That's the note I ca...

Tom Zaccaria

I am looking to write a report that includes the note field placed on employee's time card as in
Manage/Employee/View TimeCard but can't seem to find where the note field is stored.

It is not in the Clockevent or employee tables.

Can someone direct me to which table it is in.

Thanks,
drtmz

Tom Zaccaria

Don't think you can change the type. You can make a new plan of the type you want then copy the new fees into it.

Been there, done that.
drtmz

Tom Zaccaria

It has Windows 7. Should work fine.

drtmz

Tom Zaccaria

Update. This query correctly shows who had an adult prophy 7 to 8 months ago or whatever interval you put in. And now takes into account the fact that may have been in since that time or may have one scheduled already. Couldn't get it on my own so went to support, paid a few bucks and here it is. If...

Tom Zaccaria

You understand that the report is from the time you first created the adjustment.
If you want to include previous months you must go back and manually recode the old accounts as 'Bad Debt'.
Might not be a bad idea because then you will have an accurate report as to the total dollar amount.

drtmz

Tom Zaccaria

Upon further review and with fresh eyes this AM I was able to modify #93 slightly to give we what I wanted.
If anyone needs the modification for a specific carrier, let me know and I will post it here.

drtmz

Tom Zaccaria

I need a query that will return the following for a time period and specific insurance plan. Patient name, date of service and copay actually paid for a specific carrier such as MetLife. I can get the insurance payments but not the patient payment(s). Can't seem to come up with it in the 605 example...

Tom Zaccaria

We use it for referrals but not reminders. Service is dubious at best.
The only screening we went through is, "do you want to sign up with us?"

drtmz

Tom Zaccaria

This may sound daunting for a newbie but it isn't. Input your standard schedule first. Then the first PPO fee schedule by just going right down the line of fees from the paper fee schedule say MetLife to OD. In setting up additional PPO's you can copy the first one and then just edit where necessary...

Tom Zaccaria

Don't think you can. But you can edit it into the format you want once your invoke the sheet.

drtmz

Tom Zaccaria

After a nights sleep I found it.
#264

drtmz

Tom Zaccaria

I am looking for a query that will give the following: Insurance Carrier....Procedure....Our Fee...Allowed fee...Ins payment Delta..................D1110........100.00.....85.00............79.00 MetLife...............D1110........100.00.....70.00............68.00 I know it is here somewhere. I have ...

Tom Zaccaria

We use a member of the same clan..... Mr. Thisis A. Test
To get the most benefit from these fictitious people be sure to fill in all their fields with office information or fake data.

drtmz

Tom Zaccaria

It is possible to have different colors for different crown types? Now we use red for tx plan and blue for completed for P/M crowns. Works fine. No problem. But I would like to color all porcelain, D2740, crowns in a different color combo. Can this be done? If so, How? We tried various combinations ...

Tom Zaccaria

That is exactly how you do it. I just tested it and it works like a charm.
Funny how the solution was right in front of me all this time.
Nice work by you!
Thanks

drtmz

Tom Zaccaria

Can anyone direct me to the location of the defined sheets folder?
We designed a new patient exam sheet and I would like to transport it to our other office.

Thanks
drtmz

Tom Zaccaria

Just one problem remains. This does correctly show who had an adult prophy 7 to 8 months ago or whatever interval you put in. But it does not take into account if they have had one since then and therefore not be due again or for those patients that have been in in six months and one day. Been fiddl...

Tom Zaccaria

This works better for eliminating managed care from the report /*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 interval values below to get the proper month*/ SET @FromDate=Dat...

Tom Zaccaria

Latest revision using the interval command. /*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*/ /* Revised to seek date of last prophy*/ /*Just change the interval values, months, below to get the p...

Tom Zaccaria

Next step in to incorporate your date interval code.
Should be simple enough.
The idea is to get a report that gives a list of patients who are 6, 9, 12 and 18 months over due for their prophies
Run it the first of the month and you have a list to contact by post card, letter email or whatever.

drtmz

Tom Zaccaria

Smokin Hot Sunday. I'm gonna quit while I'm ahead or at least before one of you show me this query done already somewhere else. But here it is; /*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*/ /*...

Tom Zaccaria

Was finally able to re-engineer query #264 to do what I wanted.
Now just need to split PatNum into First Name and Last Name

drtmz

Tom Zaccaria

Drawing a blank and need some help. Tries unsuccessfully to cobble a couple of examples together but no luck. I need a report that will return the following: Pt Lname, Pt Fname, Pt address, PtEmail address, date of last adult prophy (D1110), current insurance plan, for a given date range Any help or...

Tom Zaccaria

Move over and I'll help you row!!! I recently tried to get rid of written hard and soft tissue exam paper sheet. Bought a new Dell 13" Netbook had everything in place to do hard and soft tissue exams in OD. Tested it on two new patients. Everything working as it should. After one day were back to ou...

Tom Zaccaria

I lost myself in translation.

It should be List/Referrals check the hidden box at the top.
Once this is checked the specific referral will not show in the dropdown menus but is still
present in Setup/Sheets

drtmz

Tom Zaccaria

Yes, that is what we did exactly. But the fix was to hide the ReferalSlip by clicking the hidden button in Setup/Sheets, double click on the ReferralSlip. This way, it will not show in any DropDown lists which is was what I was after. Now it can't be selected in error. It still shows in the Setup/Sh...

Tom Zaccaria

That's what I thought. But I was looking for an easier fix.
Thanks

Tom Zaccaria

Here is what is going on. I usually refer to everything as a sheet. But there a many types of sheets. What I really mean is a ReferralSlip. Initially we designed a ReferralSlip for Aetna. This had a Static Image scanned in as a background and fields such as Last Name etc. added as an overlay from OD...

Tom Zaccaria

Sorry. I wasn't too clear in the previous posts. You sometimes get so locked in to what you are doing that you lose site of the big picture. What I am trying to do is delete an old 'Referral Form'. We redesigned several and can't delete or hide the old ones because they are attached to patients. I w...

Tom Zaccaria

Message is, 'Can be deleted being used' For example, we have redesigned our Medical History form among others to take advantage of the improvements in sheets definitions. Want to get rid of the old one or hide it so it can't be selected in error. But can not. We have resorted to putting the word Tra...

Tom Zaccaria

What is recommended for sheets that are no longer used?
We have several that we would like to delete because we designed new ones but can't because they are attached to patients.
Anyway to hide them?

Thanks
drtmz

Tom Zaccaria

I think that the first time you run it on the backup you have to right click and run as administrator.
That's what I had to do in Windows 7.
Should be a simple fix.

drtmz

Tom Zaccaria

Epilog: After vehemently denying that she made changes to her clock-in time card and the time cards of others in the office, employee confessed and asked for forgiveness. No way of knowing how long it went on so we decided to dock her one full weeks pay and move on. This is the first for me in over ...

Tom Zaccaria

ok here is the fix. I thought it was the default setting that they would not be able to edit their timecards. But it isn't. You have to enable it. So after a call to support, and email from support and a couple more calls to support, they were all great and very helpful, here is the fix. First on Se...

Tom Zaccaria

Need help stopping employees from changing their clock in or out time(s).
Edit time cards is unselected but unless I unselect the manage module they are still able to edit the time cards.
If I unselect the manage module then they can't clock in or out.

What am I missing?

Help!!!
drtmz

Tom Zaccaria

Ditto. OD is perfect for this. The only way to go.

drtmz

Tom Zaccaria

When an employee clocks in or out should that event be recorded in the audit trail?
It doesn't seem to be in our office.
Did I miss a switch or setting to turn it on?
drtmz

Tom Zaccaria

Would

e.Lname, e.Fname;

work???

drtmz

Tom Zaccaria

try replacing the last line with this

GROUP BY e.Lname;

drtmz

Tom Zaccaria

I think he means like and excel schedule for employees with their time in, time out and days off listed by days worked.

At least this is what I make of it. And if I am correct, no OD doesn't do this.

drtmz

Search found 353 matches