Search found 84 matches

by drtmz
Sat Dec 10, 2011 2:55 am
Forum: Main Forum
Topic: Script to start / stop mysql in Windows 7
Replies: 1
Views: 2873

Script to start / stop mysql in Windows 7

To my fellow gearheads out there I need a script to start and stop mysql in Windows 7. In Windows XP Pro 'net stop mysql' and 'net start mysql' worked nicely. But you have to run it as an administrator in Windows 7. 'Net stop mysqladmin' and 'net start mysqladmin' don't seem to work. I am looking to...
by drtmz
Fri Nov 04, 2011 3:49 pm
Forum: Main Forum
Topic: Query for language
Replies: 3
Views: 4115

Re: Query for language

Try this:

SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;

drtmz
by drtmz
Wed Nov 02, 2011 3:25 am
Forum: Main Forum
Topic: Query for language
Replies: 3
Views: 4115

Re: Query for language

Try this:

SELECT Language, COUNT(*)
FROM patient
GROUP BY Language

Modified from another query.

drtmz
by drtmz
Tue Oct 18, 2011 7:10 am
Forum: Main Forum
Topic: Post It Notes
Replies: 3
Views: 4142

Re: Post It Notes

'Note area under chart.'
That's it. And in front of my eyes all the time.
Thanks

drtmz
by drtmz
Tue Oct 18, 2011 3:17 am
Forum: Main Forum
Topic: Post It Notes
Replies: 3
Views: 4142

Post It Notes

Is there any way to put a post-it-note on the patients chart in OD? I have a patient with open margins on the mesial and distal of a crown on tooth 19. I would like to watch these as there is not decay or sensitivity. I did note it in the tx notes. But you would have to read through all the notes to...
by drtmz
Mon Oct 10, 2011 7:08 am
Forum: Main Forum
Topic: Additional column for Treatment Finder
Replies: 4
Views: 5796

Re: Additional column for Treatment Finder

Requested and added to 11.1.3
Thank you

drtmz
by drtmz
Thu Oct 06, 2011 2:12 am
Forum: Main Forum
Topic: Can I go from v11.1 back to v11.0 ???
Replies: 22
Views: 17701

Re: Can I go from v11.1 back to v11.0 ???

Front desk hates batch processing. Most of our bulk checks are 10 patients or less. Occasionally they are larger but not often.
Can't wait until the old way is restored. They are forming a 'flash mob'. Ykes!!

drtmz
by drtmz
Thu Oct 06, 2011 2:08 am
Forum: Advanced Topics
Topic: 11.1 Appointment book print bug
Replies: 10
Views: 9914

Re: 11.1 Appointment book print bug

My Bad!
The row height does in fact scale with the font size. We were using too small of a change in fonts, 6 to 7, to notice the difference.
Also we tried it on a different printer and it works as advertized.

drtmz
by drtmz
Wed Oct 05, 2011 11:12 am
Forum: Advanced Topics
Topic: 11.1 Appointment book print bug
Replies: 10
Views: 9914

Re: 11.1 Appointment book print bug

This is a problem for us also. We use 15 minute increments and regardless of the font used the spacing per hour is the same.
That is, the distances between each hour, from 10:00 to 11:00, is standard, about an inch.
Is there a way to shrink this spacing with the decreasing of the font?

drtmz
by drtmz
Thu Sep 01, 2011 12:01 am
Forum: Main Forum
Topic: Additional column for Treatment Finder
Replies: 4
Views: 5796

Additional column for Treatment Finder

I am looking for a report similar to treatment finder that also includes the patient's current insurance plan. Could that column be added to the present treatment finder report? That would work nicely. I need patient name, date of last visit, unfinished tx plan and insurance coverage. Any body know ...
by drtmz
Sat Aug 27, 2011 12:12 am
Forum: Main Forum
Topic: Replacement query for #280
Replies: 2
Views: 4166

Re: Replacement query for #280

Works as advertised in version 11.0. Thanks.

drtmz
by drtmz
Fri Aug 26, 2011 2:13 am
Forum: Main Forum
Topic: Replacement query for #280
Replies: 2
Views: 4166

Replacement query for #280

I need a query for unscheduled patients with work to be done and their insurance plan.
#280 works in previous versions but it won't work in version 11.0.
Anyone have a work-around?

drtmz
by drtmz
Wed Aug 10, 2011 2:21 am
Forum: Main Forum
Topic: Show Primary Insurance in Appointment
Replies: 1
Views: 2623

Show Primary Insurance in Appointment

Any way to show the patients primary insurance coverage in the appointment in version 7.9.24?
Anything simpler than designing a custom field and manually entering each insurance plan into it?

Thanks,

DRTMZ
by drtmz
Wed May 25, 2011 10:01 am
Forum: Main Forum
Topic: print fee schedule?
Replies: 4
Views: 5664

Re: print fee schedule?

Lists, Procedure Codes, Select Standard Fees

drtmz
by drtmz
Sat May 14, 2011 11:24 am
Forum: Main Forum
Topic: Reverse e-mail search
Replies: 3
Views: 3772

Re: Reverse e-mail search

Might be easier than you think. It's just two lines of code. SELECT PatNum, email from Patient WHERE email LIKE '%name@yahoo.com%' Cut and paste this code into the query box. (Reports, query) Change the email name portion to fit your needs. The first time you do it, save it to you favorites. Done. N...
by drtmz
Wed May 11, 2011 8:25 am
Forum: Main Forum
Topic: Looking for Paperless system
Replies: 8
Views: 10073

Re: Looking for Paperless system

Amen Rick!
Tom Zaccaria
drtmz Temple '71
by drtmz
Wed Apr 20, 2011 12:32 am
Forum: Main Forum
Topic: Show year in Setup/Schedules
Replies: 1
Views: 2632

Show year in Setup/Schedules

Is there any way to display the year in setting up scheduled?
Now it shows the month and day. But in going out a couple of years it sometimes becomes confusing to remember just which August 12th your are on.

Seems like a simple addition.

Tom Zaccaria
drtmz
by drtmz
Fri Apr 15, 2011 1:55 pm
Forum: Main Forum
Topic: Kudos to tech #21
Replies: 2
Views: 3397

Kudos to tech #21

Just want to take a minute guys 'n gals to heap praise on OD support especially #21. She was well versed in OD, concise and very entertaining at the same time in helping my IT guy fix a longstanding network glitch. He was blown away by the expertise and promptness of OD support. Just a shout out. Ke...
by drtmz
Fri Apr 01, 2011 2:49 am
Forum: Main Forum
Topic: procedure code look up
Replies: 1
Views: 2716

Re: procedure code look up

Looks like query example #294 should do the trick.
Copy and paste it into the queries box under reports and change the variables as needed.

drtmz
by drtmz
Tue Mar 01, 2011 3:42 am
Forum: Main Forum
Topic: Count patients by provider and date range for a provider
Replies: 0
Views: 2578

Count patients by provider and date range for a provider

I am having a brain freeze!
Need a report that will Count patients by provider and date range for a particular insurance plan.
I had one but can't seem to find it.

Thanks

drtmz
by drtmz
Wed Feb 16, 2011 2:10 pm
Forum: Main Forum
Topic: Tablet Use
Replies: 12
Views: 11364

Re: Tablet Use

We love the tablet. Got a used Motion Computer Tablet. They seem to be the standard. In fact, they are coming out with a sub $1000.00 in a couple of months. The only problem is the Treatment Status Box won't show up properly no matter what the resolution. I think this was addressed before and the an...
by drtmz
Wed Feb 16, 2011 2:06 pm
Forum: Main Forum
Topic: searching for patient by thier wireless Number/Mobile
Replies: 4
Views: 4866

Re: searching for patient by thier wireless Number/Mobile

How about this little down and dirty query?

SELECT PatNum, WirelessPhone from Patient
WHERE WirelessPhone = '(###)-### ####'
# add phone number above


drtmz
by drtmz
Thu Feb 10, 2011 2:45 pm
Forum: Main Forum
Topic: Subscriber last name on web forms
Replies: 2
Views: 3238

Re: Subscriber last name on web forms

I did not look at that close enough. Thanks for the prompt reply.

Tom Zaccaria
by drtmz
Thu Feb 10, 2011 9:34 am
Forum: Main Forum
Topic: Subscriber last name on web forms
Replies: 2
Views: 3238

Subscriber last name on web forms

We are having trouble with our patient registration web form. The patient portion works fine. But the subscriber information for patients with insurance is not properly imported into OD. They only problem we can see is that there isn't a field for subscriber last name only patient last name. There i...
by drtmz
Sat Jan 15, 2011 10:50 am
Forum: Main Forum
Topic: Query for Carrier, Patients and Provider
Replies: 1
Views: 2523

Re: Query for Carrier, Patients and Provider

I found the following code: SET @Start='2011-01-01' , @Before='2011-01-31'; /*Adjust above Dates as needed*/ SELECT carrier.CarrierName, COUNT(DISTINCT claimproc.PatNum) AS 'Patients' FROM carrier INNER JOIN insplan ON carrier.CarrierNum=insplan.CarrierNum INNER JOIN claim ON insplan.PlanNum=claim.P...
by drtmz
Sat Jan 15, 2011 2:58 am
Forum: Main Forum
Topic: Query for Carrier, Patients and Provider
Replies: 1
Views: 2523

Query for Carrier, Patients and Provider

I need a query for the total number of patients seen over a time period by carrier and provider. I'm trying to see how many capitation patients each provider treats per month. I did use the one that gives me CarrierName and Total Patients but I need to add Provider to the mix. We are using 7.5.25 An...
by drtmz
Fri Dec 10, 2010 1:09 am
Forum: Main Forum
Topic: PSR records
Replies: 4
Views: 6537

Re: PSR records

We just enter it like this 222/222

drtmz
by drtmz
Sun Nov 14, 2010 3:16 pm
Forum: Main Forum
Topic: [OT] How many PCs do you have in your office?
Replies: 7
Views: 6068

Re: [OT] How many PCs do you have in your office?

1) How many total PCs in your office (excluding server) 8 2) How are they distributed (how many front desk/business office vs. operatories vs. elsewhere - feel free to elaborator 4 op 1 office 2 reception 1 tablet 3) How many docs? 1 full time and 1 part time 4) How many are hard wired ...7 vs. tabl...
by drtmz
Wed Nov 10, 2010 3:20 pm
Forum: Main Forum
Topic: Stuck on version 7.3.7
Replies: 5
Views: 4596

Re: Stuck on version 7.3.7

Called OD support today for the purpose of having them upload a copy of our database as Jordan suggested. But then with the help of #11 Britt and #13 Luke we were able to upgrade our server from 7.3.7 to 7.4.10 with no problem. Backed up the office data, came home and was able to restore the current...
by drtmz
Tue Nov 09, 2010 1:40 am
Forum: Main Forum
Topic: Stuck on version 7.3.7
Replies: 5
Views: 4596

Re: Stuck on version 7.3.7

Tried to go to the latest version of 7.5 this AM on my test machine and still the same error message.

drtmz
by drtmz
Sat Nov 06, 2010 11:39 am
Forum: Main Forum
Topic: Stuck on version 7.3.7
Replies: 5
Views: 4596

Stuck on version 7.3.7

Tried to go from 7.3.7 to 7.3.8 and then to 7.4.10 and get this message, "You have an error in your SQL syntax, check the manual that corresponds to your MYSQL server version for the right syntax to use near 'of account' at line 1. Had to down grade back to 7.3.7 again. 7.3.7 works fine. Any ideas? ...
by drtmz
Tue Nov 02, 2010 10:25 am
Forum: Main Forum
Topic: Tooth numbers missing on scheduled procedures
Replies: 5
Views: 5039

Re: Tooth numbers missing on scheduled procedures

Glad to see it is not just us.
Also if you notice it removed the tooth numbers from previously completed procedures.

TMZ
by drtmz
Thu Oct 28, 2010 6:29 am
Forum: Main Forum
Topic: Tooth numbers missing on scheduled procedures
Replies: 5
Views: 5039

Tooth numbers missing on scheduled procedures

Just updated to 7.3.7 and noticed the tooth numbers were removed from scheduled procedures.
Need to double click on the procedure and then click OK and the correct tooth numbers return.

Bug?

Tom Zaccaria
by drtmz
Wed Sep 29, 2010 5:56 am
Forum: Main Forum
Topic: Tablet PC
Replies: 5
Views: 5275

Re: Tablet PC

Rick, Thanks for the input. The Motion brand does seem to be the standard.
Does the OD team have any recommendations?
Anyone else?
drtmz
by drtmz
Wed Sep 29, 2010 2:31 am
Forum: Main Forum
Topic: Tablet PC
Replies: 5
Views: 5275

Tablet PC

Need a recommendation for a good, economical (dentist talk for cheap) tablet PC.
Time to junk the paper forms and the scans.

Motion seems to be the most popular name out there but what works best with OpenDental?

Thanks,
drtmz
by drtmz
Sat Sep 18, 2010 1:59 am
Forum: Main Forum
Topic: Print time cards
Replies: 4
Views: 3688

Re: Print time cards

Figured it out. I had entered a duplicate pay date that was off by one day. It was throwing the index off.
Deleted it and everything is in order.
Comes under the category of 'my bad'.
Tom Zaccaria
by drtmz
Fri Sep 10, 2010 10:35 am
Forum: Main Forum
Topic: Print time cards
Replies: 4
Views: 3688

Re: Print time cards

Not for everybody. Just for individual staff as needed.
We pay q 2 weeks and I would like to give the employees a copy of their hours recorded in OD.
I thought we could do this in previous versions.

Tom Zaccaria
by drtmz
Fri Sep 10, 2010 3:58 am
Forum: Main Forum
Topic: Print time cards
Replies: 4
Views: 3688

Print time cards

How do I print the hours by pay period. I tried but it only will print out all the hours of record for the selected employee.
Is it a custom report?
We are on 7.1.39

Tom Zaccaria
by drtmz
Wed Sep 01, 2010 4:22 am
Forum: Main Forum
Topic: Change billing cycle
Replies: 1
Views: 2361

Change billing cycle

Is there any way to change the billing cycle from 30, 60, 90 days?
I would like to set up 30 days for first bill, 45 for past due and then 60 for final notice.
Is this hard coded in OD?
Feature request?

Tom Zaccaria
by drtmz
Wed Sep 01, 2010 1:47 am
Forum: Main Forum
Topic: Importing PDF's
Replies: 10
Views: 8376

Re: Importing PDF's

We pretty much to the same thing and it works.

Tom Zaccaria
by drtmz
Tue Aug 17, 2010 1:53 am
Forum: Main Forum
Topic: Open Dental closing spontaneously
Replies: 2
Views: 2782

Re: Open Dental closing spontaneously

Tried it early this AM (Eastern) and the problem seems to be resolved. Guess it was a time issue because I didn't do anything since last night.
Thanks.
Tom Zaccaria
by drtmz
Mon Aug 16, 2010 4:07 pm
Forum: Main Forum
Topic: Open Dental closing spontaneously
Replies: 2
Views: 2782

Open Dental closing spontaneously

Just downloaded 7.2.14. Opened OD for maybe 10 seconds and get a message 'All copies of Open Dental will close in 15 seconds. Click OK to save your work.' Then it closes down. Tried several times but same result. I am running OD as a server here at home. No workstations. Windows XP Pro Wassup? Tom Z...
by drtmz
Thu Jul 29, 2010 1:58 am
Forum: Main Forum
Topic: 7.2 features
Replies: 40
Views: 23230

Re: 7.2 features

by drtmz
Sun Jul 25, 2010 2:07 am
Forum: Main Forum
Topic: Raising fees
Replies: 2
Views: 3238

Re: Raising fees

That's a good question. But I think the visible name doesn't matter.
The computer uses '0s' and '1s' to internally identify the fee schedules not the letters. This internal numbering and file associations never change.

Right?

Tom Zaccaria
by drtmz
Sat Jul 24, 2010 7:53 am
Forum: Main Forum
Topic: Raising fees
Replies: 2
Views: 3238

Raising fees

This is the time of year I like to raise our fees. What I do is goto Reports, Procedure Codes and generate a current Standard fee schedule. I export this to Excel and then block and raise the fees say 3%. This is my guide. If I like the numbers generated here I then do the same with a new fee schedu...
by drtmz
Fri Jun 11, 2010 12:16 pm
Forum: Main Forum
Topic: Video #3 - Sorting the OD Referral List
Replies: 4
Views: 4325

Re: Video #3 - Sorting the OD Referral List

Simple but very effective. Nice Job!
Tom Zaccaria
by drtmz
Sun May 23, 2010 2:43 am
Forum: Main Forum
Topic: Treatment Plan default note
Replies: 1
Views: 2177

Treatment Plan default note

We are using version 7.1.16. I unchecked the choice to use the graphic tooth chart. We did not want it to print on the treatment plans. But now the Default Note is abbreviated. It looks like it is limited to only one line and cuts off after 'if your deductible has not bee'. Other than that the treat...
by drtmz
Fri May 21, 2010 9:47 am
Forum: Main Forum
Topic: Payment plan and patient new charges
Replies: 6
Views: 5715

Re: Payment plan and patient new charges

I too got it working without any problem. Looks nice and sleek. And you can't beat the price!

Tom Zaccaria
by drtmz
Tue Mar 09, 2010 10:25 am
Forum: Main Forum
Topic: Problem with Sheets Checkboxes
Replies: 1
Views: 2183

Problem with Sheets Checkboxes

Just updated from 6.9.22 to 7.0.3. Now the checkboxes on our referral forms aren't working. If you have a series of checkboxes checked and you check one then later select a different one in another category the first one unchecks automatically. eg We have a lab slip designed in referral forms with t...
by drtmz
Wed Mar 03, 2010 9:03 am
Forum: Main Forum
Topic: OD 7 issue with VMware Fusion?
Replies: 4
Views: 4832

Re: OD 7 issue with VMware Fusion?

We had a similar problem on Monday with the manifest.txt file but no one was in the office due to the storm (East Coast) over the weekend since last Thursday. We were on version 6.9 at the time. Shannon and James had to dial in to resolve the situation. They upgraded us to 7.0 and it was fixed. So s...
by drtmz
Thu Jan 07, 2010 4:49 pm
Forum: Main Forum
Topic: Problem updating from 6.8.32 to 6.9.50
Replies: 6
Views: 4948

Re: Problem updating from 6.8.32 to 6.9.50

Kudos to Shannon and James. We somehow got some corrupt files which they had to remove. Then we were good to go.
drtmz
by drtmz
Thu Jan 07, 2010 7:09 am
Forum: Main Forum
Topic: Problem updating from 6.8.32 to 6.9.50
Replies: 6
Views: 4948

Re: Problem updating from 6.8.32 to 6.9.50

Jordan, Ran the database maintenance tool and this is what I got 01/07/2010 10:42:24 AM------------------------------------------------------------------------------------------ Corrupt file found for table graphicassembly Repair log: colmar.graphicassembly,repair,error,Incorrect information in file...
by drtmz
Thu Jan 07, 2010 2:04 am
Forum: Main Forum
Topic: Problem updating from 6.8.32 to 6.9.50
Replies: 6
Views: 4948

Re: Problem updating from 6.8.32 to 6.9.50

I have been updating with no problem on my Windows XP pro machines since forever with no problem. I use everything from OD nothing else. I get a message that the conversion to 6.9.50 failed and OD never starts so I can't run the database maintenance tool. I reinstall 6.8.32 and it works just fine. d...
by drtmz
Wed Jan 06, 2010 4:38 pm
Forum: Main Forum
Topic: Problem updating from 6.8.32 to 6.9.50
Replies: 6
Views: 4948

Problem updating from 6.8.32 to 6.9.50

Tried to update from 6.8.32 to 6.9.50 this evening . Got error message. 'Incorrect information in file graphicsassembly.frm'

Checked the contents of the file. It seems to be empty.

Did I miss something in updating? Is there another file to download with this new release?

Thanks
drtmz
by drtmz
Tue Sep 15, 2009 2:44 pm
Forum: Main Forum
Topic: Dentrix to OD conversion
Replies: 0
Views: 2449

Dentrix to OD conversion

A stellar, painless conversion from Dentrix to OpenDental by James, Nathan and the OD gang. Over 2500 records converted with much more information than I had hoped for. There were some glitches but everything was addressed and rectified in a timely manner. Well worth the money. Very nice job guys. I...
by drtmz
Tue Sep 15, 2009 2:38 pm
Forum: Main Forum
Topic: Primary insurance claims that aren't needed
Replies: 4
Views: 4487

Primary insurance claims that aren't needed

For some discount plans we contract with such as Careington the patient pays a discounted fee so we don't have to submit anything to the insurance plan. But in their account the individual procedures are listed as (unsent) and show up on a report. How are other offices handling this? I have found th...
by drtmz
Sat May 09, 2009 7:00 am
Forum: Main Forum
Topic: Correct Insurance Plan setup
Replies: 4
Views: 4187

Re: Correct Insurance Plan setup

The best solution we found is as follows: Discount Plans such as.... Fidelio, Teamsters Health and Welfare, Carpenters, Careington 500 Plans where they have a set fee schedule and that is the patient's total fee for the procedures. Plan Type......................Medicaid/Flat Co-Pay Fee Schedule ......
by drtmz
Thu May 07, 2009 12:55 am
Forum: Main Forum
Topic: Correct Insurance Plan setup
Replies: 4
Views: 4187

Correct Insurance Plan setup

We are having trouble with discount insurance plan setup such as Careington. We take this plan and agree to accept their fees as payment in full. Here is what we have: Insurance Plan Type......... PPO Percentage (It is not a Capitated Plan since we don't get any monthly payment.) Fee Schedule..........
by drtmz
Fri May 01, 2009 1:22 pm
Forum: Main Forum
Topic: List of recalls due between two dates
Replies: 3
Views: 3468

Re: List of recalls due between two dates

That did it. I wasn't hitting the Refresh button. Thank you
by drtmz
Fri May 01, 2009 1:35 am
Forum: Main Forum
Topic: List of recalls due between two dates
Replies: 3
Views: 3468

List of recalls due between two dates

Can anyone direct me to a report of 9 month recalls? What I want is a list of patients that are three months late for their recall appointment. I can't seem to get the List / Recall to work. The only thing I get when I change the dates there are the patients due in today. What am I missing here? Or ...
by drtmz
Mon Apr 27, 2009 7:22 am
Forum: Main Forum
Topic: Insurance Breakdown
Replies: 2
Views: 2778

Re: Insurance Breakdown

I would like a breakdown by plan type, as in PPO 15%, Capitation 5% or PPO 135 patients, Capitation 45 patients.
by drtmz
Sun Apr 26, 2009 9:24 am
Forum: Main Forum
Topic: Insurance Breakdown
Replies: 2
Views: 2778

Insurance Breakdown

Can anyone point me to a report that breaks down active patients by insurance type. As in PPO, HMO, Capitaiton?
by drtmz
Fri Mar 20, 2009 12:50 am
Forum: Developers
Topic: Lab slips & fluoride
Replies: 8
Views: 8155

Re: Lab slips & fluoride

We do this now with sheets. Scan in the lab slip and design the input boxes and text areas and save the sheet. Now you just call up the sheet whenever you want to write a slip. Print it out and OD saves it in the patients file. We make them all in portrait orientation because we had a problem with l...
by drtmz
Sat Feb 21, 2009 1:54 am
Forum: Main Forum
Topic: Printing statements in color
Replies: 1
Views: 2216

Printing statements in color

The treatment plans print in color. How about the statements?
Or is this a features request?

DRTMZ
by drtmz
Sat Feb 14, 2009 10:55 am
Forum: Main Forum
Topic: Date field for sheets
Replies: 1
Views: 2402

Date field for sheets

Any chance we could get one more field in the sheets module? We have all our lab Rxs converted to sheets. The only field that is still pesky is the date bue back from the lab. Routinely we use three weeks for crowns. Is there any way to list this now? I was thinking of a function to use today's date...
by drtmz
Fri Feb 13, 2009 3:34 pm
Forum: Main Forum
Topic: Payment type totals
Replies: 2
Views: 3209

Re: Payment type totals

Perfect. Exactly what I was looking for.

DRTMZ
Tom Zaccaria
by drtmz
Fri Feb 13, 2009 2:19 am
Forum: Main Forum
Topic: Payment type totals
Replies: 2
Views: 3209

Payment type totals

Can anyone direct me to a report or query that will total the payments received by payment type?
I would like to generate a total of all the payments by cash, credit card and personal check for the year 2008.

Thanks.
DRTMZ
by drtmz
Thu Jan 29, 2009 1:12 am
Forum: Main Forum
Topic: Hide former employee's name on time card.
Replies: 1
Views: 2178

Re: Hide former employee's name on time card.

Never mind. Found it under Lists, Employees.

DRTMZ
by drtmz
Thu Jan 29, 2009 1:09 am
Forum: Main Forum
Topic: Hide former employee's name on time card.
Replies: 1
Views: 2178

Hide former employee's name on time card.

How can we hide a former employee's name that has been registered a time card?

Thanks

DRTMZ
by drtmz
Wed Dec 24, 2008 1:38 am
Forum: Main Forum
Topic: Total employee hours
Replies: 1
Views: 2609

Total employee hours

Is there any way to calculate the total number of hours worked for a given time period other than a pay period?
I would like to calculate the total hours worked for 2008 for each employee.
Would I need a special query for this?
Thanks
by drtmz
Fri Dec 05, 2008 3:22 pm
Forum: Main Forum
Topic: Printing Sheets in Landscape mode
Replies: 6
Views: 5213

Re: Printing Sheets in Landscape mode

Not sure which form we were using but maybe we can redo it in Rx format. But that might be restricted to a certain size. The whole idea here is for us make OD more useful by scanning in a lab Rx, any lab, and then using sheets to make it more personal, accept computer input, print it out for the lab...
by drtmz
Fri Dec 05, 2008 1:20 am
Forum: Main Forum
Topic: Printing Sheets in Landscape mode
Replies: 6
Views: 5213

Re: Printing Sheets in Landscape mode

We are on 6.1.12.
by drtmz
Thu Dec 04, 2008 3:07 pm
Forum: Main Forum
Topic: Daily and monthly production reports don't match
Replies: 4
Views: 4109

Re: Daily and monthly production reports don't match

We have it isolated to the error on 12/01/2008 because today was fine and I randomly checked other days from previous months with no errors.

I will dig into 12/1 again to see what happened.
by drtmz
Thu Dec 04, 2008 3:04 pm
Forum: Main Forum
Topic: Printing Sheets in Landscape mode
Replies: 6
Views: 5213

Re: Printing Sheets in Landscape mode

We tried that box several times but no help. Anyone else have success with this?
by drtmz
Thu Dec 04, 2008 1:43 am
Forum: Main Forum
Topic: Printing Sheets in Landscape mode
Replies: 6
Views: 5213

Printing Sheets in Landscape mode

Is there any way to get the sheets function to print in landscape mode? We are trying to convert a lab Rx by scanning it into OD and using the data fields to input the patient information and the other features for the check boxes. The form is large such as Glidewell's and we need to turn it to land...
by drtmz
Thu Dec 04, 2008 1:34 am
Forum: Main Forum
Topic: Daily and monthly production reports don't match
Replies: 4
Views: 4109

Re: Daily and monthly production reports don't match

Yes to db maint tool. Everything is the same. I will run the tool again, double check the results and make another backup before calling. Daily does not match monthly or annual. The monthly totals of production and income for 12/01/2008 to 12/31/2008 say; 12/01/2008 -769.00 12/02/2008 1432.00 12/03/...
by drtmz
Wed Dec 03, 2008 4:06 pm
Forum: Main Forum
Topic: Daily and monthly production reports don't match
Replies: 4
Views: 4109

Daily and monthly production reports don't match

Here is the problem. I printed out a Daily Production and Income report as I do every day for December 1, 2 and 3. According to the reports the Total Production (Production + Adjustments - Writeoffs) for 12/1/08 is $769.00 12/2/08 is $1432.00 12/3/08 is $12.40 Total $2,213.40 The Annual Production a...
by drtmz
Sat Nov 08, 2008 1:32 am
Forum: Main Forum
Topic: Default billing entity
Replies: 5
Views: 4991

Re: Default billing entity

Tried setting the default insurance billing provider to the LLC, Setup>Practice>Choose default insurance billing provider several times but it doesn't hold the selection as the default.
Is this a bug? We are on version 6.1.6.0.
by drtmz
Tue Nov 04, 2008 6:28 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 19265

Re: XCopy backup problem

No. I do restore via xcopy to the same directory every night. Is this the problem?
by drtmz
Mon Nov 03, 2008 6:34 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 19265

Re: XCopy backup problem

I did use a different folder every day. Here is the complete script.

for /F "tokens=1-4 delims=/ " %%I IN ('Date /t') DO SET mydate=%%J%%K%%L

cd\mysql\data\opendental

xcopy *.* E:\opendental_backup\opendental\%mydate% /s /e /y /i
by drtmz
Sun Nov 02, 2008 1:43 am
Forum: Main Forum
Topic: XCopy backup problem
Replies: 13
Views: 19265

XCopy backup problem

I previously wrote a bat file using xcopy to backup the data and image folders and sub folders to a removable hard drive using the following line of switches; xcopy *.* e:\Opendentaldata /e /y /i /s I would take the drive home, stop mysql and use xcopy to restore the files to my home computer, resta...
by drtmz
Sun Nov 02, 2008 1:29 am
Forum: Main Forum
Topic: Default billing entity
Replies: 5
Views: 4991

Re: Default billing entity

Great. I looked right past that because there isn't any default choice in the drop down box. Thanks Little Brother!
by drtmz
Sat Nov 01, 2008 2:00 am
Forum: Main Forum
Topic: Default billing entity
Replies: 5
Views: 4991

Re: Default billing entity

That would be the claims form we all know and love.
by drtmz
Sat Nov 01, 2008 1:58 am
Forum: Main Forum
Topic: Default billing entity
Replies: 5
Views: 4991

Default billing entity

How do we set up a default billing entity? Support showed us how to set up an additional provider with the, in our case, LLC's NPI number and it works. But the front desk has to remember to change it each time they generate an insurance form. Can this be done? Or can this information somehow be perm...