17.4.34 Procedure fee x7 in account & appt window

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

17.4.34 Procedure fee x7 in account & appt window

Post by drtech » Tue Feb 13, 2018 1:21 pm

We ran into a problem with 17.4.34 and all 17.4.x as far as I know, but just noticed this today on some cash patients where our prophy code shows the correct fee when you double click the procedure, but in the account and in the procedure list in the appt edit window, etc, the amount is multiplied by 7! You can change the fee in the procedure edit window and it always shows the amount you enter x7 after you push ok. It is NOT for all procedures, only all my existing D1110 related ones. (I have D1110-6MR, D1110-Prophy, etc) I made a NEW procedure code, D1110-1stVisit, and it works fine! Anyone see this or know that the issue might be? Seems like something wrong in the database with those codes, but then why does it show correctly when you open the procedure edit window? That seems to point more to a program math error....
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by jsalmon » Tue Feb 13, 2018 2:11 pm

I instantly suspect someone setting the Base Units when something like this happens.
http://www.opendental.com/manual/procedurecodeedit.html
That or there was a bug and hopefully it is fixed since v17.3 is now up to v17.3.62. However, it doesn't look promising when you say it happens for all of v17.4. That just leans more towards my base units idea.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by drtech » Tue Feb 13, 2018 5:07 pm

and my gals just informed me we received back an EOB for a prophy for $574 where we had to write off $500! :p Obviously they were not checking for accuracy of the fee when checking the pt out!
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by tgriswold » Wed Feb 14, 2018 11:40 am

I agree with Jason that it sounds exactly what base units is meant to do, so possibly someone filled some in by accident at some point and fixed it so new procs do not have it anymore. You'll see the normal proc fee on procedures and everywhere else (including reports) it should count the base units. If the code was changed after you updated to 17.4, the audit trail would show any base unit changes to the procedure code itself. You can look at them by going to the procedure code edit window like Jason linked, and clicking the audit trail button. The base units would have been copied from when the procedure was first added to the chart though, which may have been a while before you updated.
To check if this is the issue, you can run a query and look at the procedurelog.BaseUnits, it should be 0 for almost all procedures.
Travis Griswold
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by drtech » Fri Feb 16, 2018 10:09 am

Ok, finally figured out where base units were, and yes, they had been changed to 6 on those codes. Not sure how or why, but when I changed them back to 0, it fixed the problem!

Thanks guys!
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by drtech » Mon Feb 26, 2018 11:31 am

hum, just had it do it again today. Completed prophy code and created insurance claim and all of a sudden the fee jumps from $83 to $581 (x7). I checked and the base units were still at 0 on the procedure code. I had to use my newly created similar prophy code from last week to check the person out. Any other ideas? Still on 17.4.34
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by cmcgehee » Mon Feb 26, 2018 12:35 pm

I believe that when the procedure is created it will have its base units set to whatever the procedure code's base units was at the time. The procedure would then keep those base units when it is completed even if the procedure code has changed its base units.
Chris McGehee
Open Dental Software
http://www.opendental.com

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by tgriswold » Mon Feb 26, 2018 2:01 pm

There is a DBM tool called "ProcedurelogBaseUnitsZero" that should set all of your procedures base units back to 0 if the procedure code base unit is set to 0. That should probably take care of it for you, and you can confirm it fixed them all by running:

Code: Select all

/*TP or Completed Procedures with BaseUnits not set to 0*/
SELECT PatNum, ProcDate, ProcFee, ProcStatus, BaseUnits
FROM procedurelog 
WHERE procedurelog.ProcStatus IN (1,2)
AND procedurelog.BaseUnits!=0
And this will tell you if you have any other procedure codes out there with base units that are not 0:

Code: Select all

/*Procedure codes with BaseUnits not set to 0*/
SELECT procedurecode.ProcCode, procedurecode.Descript, procedurecode.BaseUnits
FROM procedurecode
WHERE procedurecode.BaseUnits!=0
Travis Griswold
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: 17.4.34 Procedure fee x7 in account & appt window

Post by drtech » Tue Feb 27, 2018 10:34 am

ok, had about 50 procedures with base units not 0, rand the DBM again and then it looks like it cleared them. Will keep you posted if I see another problem. Thanks.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

Post Reply