Search found 84 matches
- Sat Dec 10, 2011 2:55 am
- Forum: Main Forum
- Topic: Script to start / stop mysql in Windows 7
- Replies: 1
- Views: 2896
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...
- Fri Nov 04, 2011 3:49 pm
- Forum: Main Forum
- Topic: Query for language
- Replies: 3
- Views: 4151
Re: Query for language
Try this:
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;
drtmz
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
ORDER by Language;
drtmz
- Wed Nov 02, 2011 3:25 am
- Forum: Main Forum
- Topic: Query for language
- Replies: 3
- Views: 4151
Re: Query for language
Try this:
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
Modified from another query.
drtmz
SELECT Language, COUNT(*)
FROM patient
GROUP BY Language
Modified from another query.
drtmz
- Tue Oct 18, 2011 7:10 am
- Forum: Main Forum
- Topic: Post It Notes
- Replies: 3
- Views: 4168
Re: Post It Notes
'Note area under chart.'
That's it. And in front of my eyes all the time.
Thanks
drtmz
That's it. And in front of my eyes all the time.
Thanks
drtmz
- Tue Oct 18, 2011 3:17 am
- Forum: Main Forum
- Topic: Post It Notes
- Replies: 3
- Views: 4168
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...
- Mon Oct 10, 2011 7:08 am
- Forum: Main Forum
- Topic: Additional column for Treatment Finder
- Replies: 4
- Views: 5844
Re: Additional column for Treatment Finder
Requested and added to 11.1.3
Thank you
drtmz
Thank you
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: 17863
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
Can't wait until the old way is restored. They are forming a 'flash mob'. Ykes!!
drtmz
- Thu Oct 06, 2011 2:08 am
- Forum: Advanced Topics
- Topic: 11.1 Appointment book print bug
- Replies: 10
- Views: 10030
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
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
- Wed Oct 05, 2011 11:12 am
- Forum: Advanced Topics
- Topic: 11.1 Appointment book print bug
- Replies: 10
- Views: 10030
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
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
- Thu Sep 01, 2011 12:01 am
- Forum: Main Forum
- Topic: Additional column for Treatment Finder
- Replies: 4
- Views: 5844
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 ...
- Sat Aug 27, 2011 12:12 am
- Forum: Main Forum
- Topic: Replacement query for #280
- Replies: 2
- Views: 4416
Re: Replacement query for #280
Works as advertised in version 11.0. Thanks.
drtmz
drtmz
- Fri Aug 26, 2011 2:13 am
- Forum: Main Forum
- Topic: Replacement query for #280
- Replies: 2
- Views: 4416
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
#280 works in previous versions but it won't work in version 11.0.
Anyone have a work-around?
drtmz
- Wed Aug 10, 2011 2:21 am
- Forum: Main Forum
- Topic: Show Primary Insurance in Appointment
- Replies: 1
- Views: 2650
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
Anything simpler than designing a custom field and manually entering each insurance plan into it?
Thanks,
DRTMZ
- Wed May 25, 2011 10:01 am
- Forum: Main Forum
- Topic: print fee schedule?
- Replies: 4
- Views: 5705
Re: print fee schedule?
Lists, Procedure Codes, Select Standard Fees
drtmz
drtmz
- Sat May 14, 2011 11:24 am
- Forum: Main Forum
- Topic: Reverse e-mail search
- Replies: 3
- Views: 3800
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...
- Wed May 11, 2011 8:25 am
- Forum: Main Forum
- Topic: Looking for Paperless system
- Replies: 8
- Views: 10144
Re: Looking for Paperless system
Amen Rick!
Tom Zaccaria
drtmz Temple '71
Tom Zaccaria
drtmz Temple '71
- Wed Apr 20, 2011 12:32 am
- Forum: Main Forum
- Topic: Show year in Setup/Schedules
- Replies: 1
- Views: 2660
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
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
- Fri Apr 15, 2011 1:55 pm
- Forum: Main Forum
- Topic: Kudos to tech #21
- Replies: 2
- Views: 3420
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...
- Fri Apr 01, 2011 2:49 am
- Forum: Main Forum
- Topic: procedure code look up
- Replies: 1
- Views: 2738
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
Copy and paste it into the queries box under reports and change the variables as needed.
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: 2595
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
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
- Wed Feb 16, 2011 2:10 pm
- Forum: Main Forum
- Topic: Tablet Use
- Replies: 12
- Views: 11461
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...
- Wed Feb 16, 2011 2:06 pm
- Forum: Main Forum
- Topic: searching for patient by thier wireless Number/Mobile
- Replies: 4
- Views: 4973
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
SELECT PatNum, WirelessPhone from Patient
WHERE WirelessPhone = '(###)-### ####'
# add phone number above
drtmz
- Thu Feb 10, 2011 2:45 pm
- Forum: Main Forum
- Topic: Subscriber last name on web forms
- Replies: 2
- Views: 3256
Re: Subscriber last name on web forms
I did not look at that close enough. Thanks for the prompt reply.
Tom Zaccaria
Tom Zaccaria
- Thu Feb 10, 2011 9:34 am
- Forum: Main Forum
- Topic: Subscriber last name on web forms
- Replies: 2
- Views: 3256
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...
- Sat Jan 15, 2011 10:50 am
- Forum: Main Forum
- Topic: Query for Carrier, Patients and Provider
- Replies: 1
- Views: 2543
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...
- Sat Jan 15, 2011 2:58 am
- Forum: Main Forum
- Topic: Query for Carrier, Patients and Provider
- Replies: 1
- Views: 2543
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...
- Fri Dec 10, 2010 1:09 am
- Forum: Main Forum
- Topic: PSR records
- Replies: 4
- Views: 6568
Re: PSR records
We just enter it like this 222/222
drtmz
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: 6133
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...
- Wed Nov 10, 2010 3:20 pm
- Forum: Main Forum
- Topic: Stuck on version 7.3.7
- Replies: 5
- Views: 4646
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...
- Tue Nov 09, 2010 1:40 am
- Forum: Main Forum
- Topic: Stuck on version 7.3.7
- Replies: 5
- Views: 4646
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
drtmz
- Sat Nov 06, 2010 11:39 am
- Forum: Main Forum
- Topic: Stuck on version 7.3.7
- Replies: 5
- Views: 4646
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? ...
- Tue Nov 02, 2010 10:25 am
- Forum: Main Forum
- Topic: Tooth numbers missing on scheduled procedures
- Replies: 5
- Views: 5083
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
Also if you notice it removed the tooth numbers from previously completed procedures.
TMZ
- Thu Oct 28, 2010 6:29 am
- Forum: Main Forum
- Topic: Tooth numbers missing on scheduled procedures
- Replies: 5
- Views: 5083
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
Need to double click on the procedure and then click OK and the correct tooth numbers return.
Bug?
Tom Zaccaria
- Wed Sep 29, 2010 5:56 am
- Forum: Main Forum
- Topic: Tablet PC
- Replies: 5
- Views: 5326
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
Does the OD team have any recommendations?
Anyone else?
drtmz
- Wed Sep 29, 2010 2:31 am
- Forum: Main Forum
- Topic: Tablet PC
- Replies: 5
- Views: 5326
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
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
- Sat Sep 18, 2010 1:59 am
- Forum: Main Forum
- Topic: Print time cards
- Replies: 4
- Views: 3727
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
Deleted it and everything is in order.
Comes under the category of 'my bad'.
Tom Zaccaria
- Fri Sep 10, 2010 10:35 am
- Forum: Main Forum
- Topic: Print time cards
- Replies: 4
- Views: 3727
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
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
- Fri Sep 10, 2010 3:58 am
- Forum: Main Forum
- Topic: Print time cards
- Replies: 4
- Views: 3727
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
Is it a custom report?
We are on 7.1.39
Tom Zaccaria
- Wed Sep 01, 2010 4:22 am
- Forum: Main Forum
- Topic: Change billing cycle
- Replies: 1
- Views: 2388
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
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
- Wed Sep 01, 2010 1:47 am
- Forum: Main Forum
- Topic: Importing PDF's
- Replies: 10
- Views: 8467
Re: Importing PDF's
We pretty much to the same thing and it works.
Tom Zaccaria
Tom Zaccaria
- Tue Aug 17, 2010 1:53 am
- Forum: Main Forum
- Topic: Open Dental closing spontaneously
- Replies: 2
- Views: 2804
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
Thanks.
Tom Zaccaria
- Mon Aug 16, 2010 4:07 pm
- Forum: Main Forum
- Topic: Open Dental closing spontaneously
- Replies: 2
- Views: 2804
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...
- Thu Jul 29, 2010 1:58 am
- Forum: Main Forum
- Topic: 7.2 features
- Replies: 40
- Views: 23455
- Sun Jul 25, 2010 2:07 am
- Forum: Main Forum
- Topic: Raising fees
- Replies: 2
- Views: 3259
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
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
- Sat Jul 24, 2010 7:53 am
- Forum: Main Forum
- Topic: Raising fees
- Replies: 2
- Views: 3259
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...
- Fri Jun 11, 2010 12:16 pm
- Forum: Main Forum
- Topic: Video #3 - Sorting the OD Referral List
- Replies: 4
- Views: 4351
Re: Video #3 - Sorting the OD Referral List
Simple but very effective. Nice Job!
Tom Zaccaria
Tom Zaccaria
- Sun May 23, 2010 2:43 am
- Forum: Main Forum
- Topic: Treatment Plan default note
- Replies: 1
- Views: 2195
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...
- Fri May 21, 2010 9:47 am
- Forum: Main Forum
- Topic: Payment plan and patient new charges
- Replies: 6
- Views: 5749
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
Tom Zaccaria
- Tue Mar 09, 2010 10:25 am
- Forum: Main Forum
- Topic: Problem with Sheets Checkboxes
- Replies: 1
- Views: 2199
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...
- Wed Mar 03, 2010 9:03 am
- Forum: Main Forum
- Topic: OD 7 issue with VMware Fusion?
- Replies: 4
- Views: 4866
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...
- Thu Jan 07, 2010 4:49 pm
- Forum: Main Forum
- Topic: Problem updating from 6.8.32 to 6.9.50
- Replies: 6
- Views: 5005
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
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: 5005
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...
- Thu Jan 07, 2010 2:04 am
- Forum: Main Forum
- Topic: Problem updating from 6.8.32 to 6.9.50
- Replies: 6
- Views: 5005
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...
- Wed Jan 06, 2010 4:38 pm
- Forum: Main Forum
- Topic: Problem updating from 6.8.32 to 6.9.50
- Replies: 6
- Views: 5005
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
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
- Tue Sep 15, 2009 2:44 pm
- Forum: Main Forum
- Topic: Dentrix to OD conversion
- Replies: 0
- Views: 2472
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...
- Tue Sep 15, 2009 2:38 pm
- Forum: Main Forum
- Topic: Primary insurance claims that aren't needed
- Replies: 4
- Views: 4530
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...
- Sat May 09, 2009 7:00 am
- Forum: Main Forum
- Topic: Correct Insurance Plan setup
- Replies: 4
- Views: 4220
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 ......
- Thu May 07, 2009 12:55 am
- Forum: Main Forum
- Topic: Correct Insurance Plan setup
- Replies: 4
- Views: 4220
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..........
- Fri May 01, 2009 1:22 pm
- Forum: Main Forum
- Topic: List of recalls due between two dates
- Replies: 3
- Views: 3506
Re: List of recalls due between two dates
That did it. I wasn't hitting the Refresh button. Thank you
- Fri May 01, 2009 1:35 am
- Forum: Main Forum
- Topic: List of recalls due between two dates
- Replies: 3
- Views: 3506
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 ...
- Mon Apr 27, 2009 7:22 am
- Forum: Main Forum
- Topic: Insurance Breakdown
- Replies: 2
- Views: 2805
Re: Insurance Breakdown
I would like a breakdown by plan type, as in PPO 15%, Capitation 5% or PPO 135 patients, Capitation 45 patients.
- Sun Apr 26, 2009 9:24 am
- Forum: Main Forum
- Topic: Insurance Breakdown
- Replies: 2
- Views: 2805
Insurance Breakdown
Can anyone point me to a report that breaks down active patients by insurance type. As in PPO, HMO, Capitaiton?
- Fri Mar 20, 2009 12:50 am
- Forum: Developers
- Topic: Lab slips & fluoride
- Replies: 8
- Views: 8222
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...
- Sat Feb 21, 2009 1:54 am
- Forum: Main Forum
- Topic: Printing statements in color
- Replies: 1
- Views: 2236
Printing statements in color
The treatment plans print in color. How about the statements?
Or is this a features request?
DRTMZ
Or is this a features request?
DRTMZ
- Sat Feb 14, 2009 10:55 am
- Forum: Main Forum
- Topic: Date field for sheets
- Replies: 1
- Views: 2419
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...
- Fri Feb 13, 2009 3:34 pm
- Forum: Main Forum
- Topic: Payment type totals
- Replies: 2
- Views: 3235
Re: Payment type totals
Perfect. Exactly what I was looking for.
DRTMZ
Tom Zaccaria
DRTMZ
Tom Zaccaria
- Fri Feb 13, 2009 2:19 am
- Forum: Main Forum
- Topic: Payment type totals
- Replies: 2
- Views: 3235
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
I would like to generate a total of all the payments by cash, credit card and personal check for the year 2008.
Thanks.
DRTMZ
- Thu Jan 29, 2009 1:12 am
- Forum: Main Forum
- Topic: Hide former employee's name on time card.
- Replies: 1
- Views: 2188
Re: Hide former employee's name on time card.
Never mind. Found it under Lists, Employees.
DRTMZ
DRTMZ
- Thu Jan 29, 2009 1:09 am
- Forum: Main Forum
- Topic: Hide former employee's name on time card.
- Replies: 1
- Views: 2188
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
Thanks
DRTMZ
- Wed Dec 24, 2008 1:38 am
- Forum: Main Forum
- Topic: Total employee hours
- Replies: 1
- Views: 2626
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
I would like to calculate the total hours worked for 2008 for each employee.
Would I need a special query for this?
Thanks
- Fri Dec 05, 2008 3:22 pm
- Forum: Main Forum
- Topic: Printing Sheets in Landscape mode
- Replies: 6
- Views: 5247
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...
- Fri Dec 05, 2008 1:20 am
- Forum: Main Forum
- Topic: Printing Sheets in Landscape mode
- Replies: 6
- Views: 5247
Re: Printing Sheets in Landscape mode
We are on 6.1.12.
- Thu Dec 04, 2008 3:07 pm
- Forum: Main Forum
- Topic: Daily and monthly production reports don't match
- Replies: 4
- Views: 4133
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.
I will dig into 12/1 again to see what happened.
- Thu Dec 04, 2008 3:04 pm
- Forum: Main Forum
- Topic: Printing Sheets in Landscape mode
- Replies: 6
- Views: 5247
Re: Printing Sheets in Landscape mode
We tried that box several times but no help. Anyone else have success with this?
- Thu Dec 04, 2008 1:43 am
- Forum: Main Forum
- Topic: Printing Sheets in Landscape mode
- Replies: 6
- Views: 5247
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...
- Thu Dec 04, 2008 1:34 am
- Forum: Main Forum
- Topic: Daily and monthly production reports don't match
- Replies: 4
- Views: 4133
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/...
- Wed Dec 03, 2008 4:06 pm
- Forum: Main Forum
- Topic: Daily and monthly production reports don't match
- Replies: 4
- Views: 4133
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...
- Sat Nov 08, 2008 1:32 am
- Forum: Main Forum
- Topic: Default billing entity
- Replies: 5
- Views: 5028
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.
Is this a bug? We are on version 6.1.6.0.
- Tue Nov 04, 2008 6:28 am
- Forum: Main Forum
- Topic: XCopy backup problem
- Replies: 13
- Views: 19410
Re: XCopy backup problem
No. I do restore via xcopy to the same directory every night. Is this the problem?
- Mon Nov 03, 2008 6:34 am
- Forum: Main Forum
- Topic: XCopy backup problem
- Replies: 13
- Views: 19410
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
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
- Sun Nov 02, 2008 1:43 am
- Forum: Main Forum
- Topic: XCopy backup problem
- Replies: 13
- Views: 19410
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...
- Sun Nov 02, 2008 1:29 am
- Forum: Main Forum
- Topic: Default billing entity
- Replies: 5
- Views: 5028
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!
- Sat Nov 01, 2008 2:00 am
- Forum: Main Forum
- Topic: Default billing entity
- Replies: 5
- Views: 5028
Re: Default billing entity
That would be the claims form we all know and love.
- Sat Nov 01, 2008 1:58 am
- Forum: Main Forum
- Topic: Default billing entity
- Replies: 5
- Views: 5028
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...