Time card entry error-SOLVED

[dentalguru]

Hi all,
I have run into this Time card error after upgrading to version 15.3 +.
On pressing Calc Daily
“ Employee has the following errors:
Time card rule errors:
Multiple matches of OverHoursPerDay found only one allowed.”


We have not changed or altered the time card rules as existed before the upgrade and even currently the time card rules have only a single Overtime Rule. In fact it is just not possible to make two rules even if you want to by design of the software.


Any and every help would be much appreciated as we use Open dental not only for attendance but totally for calculation of salary as well.
Thanking in anticipation
DR MK PILLAI

[Ryan]

DR MK PILLAI,

It looks like there may be either two separate time card rules for Dr. Ninad Khatal, or there could be a conflict between a timecard rule for everyone and the timecard rule for Dr. Khatal.

[drmkpillai]

Thanks Ryan for your Prompt reply, Much appreciated and grateful.

I too had earlier thought on similar lines

1.Dr.Ninad Khatal was just an example, this is happening with each and every employee.

2. I had run the Following query-''Select* from timecardrule t left join employee e on e.employeenum= t.employeenum"
--- No duplicate entries on either tables


2a. Calc weekly does not throw the error, If it was a entry or database error then it should have been duplicated here as well.

3.That's what made me think this could be a genuine bug in the program as the same was working absolutely smooth with the previous version and then on we have made no changes to the database. This is happening with every version of 15.3.++. Because of database upgrade can't move down to older versions.
When I use a still use a older version with a backed up copy of database -Flawless.
Really surprising!!!

4.Suspect that separation into individual Clinics could be a possibility as we have 3 different clinics set up.

Thanking all in Anticipation

[Ryan]

Can you run the following query and post the result? If not, can you please call Open Dental at 503-363-5432 and ask for Ryan.

SELECT * FROM timecardrule WHERE OverHoursPerDay>0 ORDER BY EmployeeNum;

I should be able to determine if this is a data issue or a bug from your query results.

[dentalguru]

7243524879427839760 0 04:30:00 00:00:00 00:00:00
3120162761221351184 0 08:30:00 00:00:00 00:00:00
5679193979087 0 04:18:00 00:00:00 00:00:00
6429477414160841488 1 06:50:00 00:00:00 00:00:00
7161872397170124560 2 10:00:00 00:00:00 00:00:00
3229940201161762576 3 05:00:00 00:00:00 00:00:00
8210626170161473296 4 09:50:00 00:00:00 00:00:00
1508425483226 2417767026419 05:00:00 00:00:00 00:00:00
243938585764 4244277634611 04:00:00 00:00:00 00:00:00
4084109073960365328 877623790379476752 04:45:00 00:00:00 00:00:00
2097734320255936272 900498236442158864 04:30:00 00:00:00 00:00:00
8160470297993029392 1254261705216635664 04:30:00 00:00:00 00:00:00
8647042547073479440 2535275670810809616 04:00:00 00:00:00 00:00:00
9206006899961505552 2753077060392986384 04:00:00 00:00:00 00:00:00
6877267110855190288 3066353211913807632 05:00:00 00:00:00 00:00:00
7019582398396376848 3771667106265835280 05:30:00 00:00:00 00:00:00
9109913178528666384 4147359784116430608 04:30:00 00:00:00 00:00:00
4393048309383466768 4663129566912289552 04:50:00 00:00:00 00:00:00
6026817164752135952 4818110644362071824 04:30:00 00:00:00 00:00:00
4117055450275742992 4863682424942272272 05:00:00 00:00:00 00:00:00
6793704776900028176 5464882302569948944 07:30:00 00:00:00 00:00:00
2809872068546229008 5568803535720598288 04:15:00 00:00:00 00:00:00
8043633138154436368 5694893538030921488 04:50:00 00:00:00 00:00:00
4014289288839 6237909895396468496 08:30:00 00:00:00 00:00:00
860401843801532816 6606521168608372496 07:00:00 00:00:00 00:00:00
5679499825486243600 6690416654586750736 05:00:00 00:00:00 00:00:00
2270030953424365328 6731526844593481488 03:30:00 00:00:00 00:00:00
7559452416564865808 6780616190482982672 06:30:00 00:00:00 00:00:00
7051664823833665296 7040011009891127056 03:20:00 00:00:00 00:00:00
7429673847277758224 7128084954604381968 03:30:00 00:00:00 00:00:00
4462133043055390480 7157819047554328336 07:00:00 00:00:00 00:00:00
3840137818496050960 7194688421212727056 05:00:00 00:00:00 00:00:00
3419650212296140560 7217841387314620176 04:30:00 00:00:00 00:00:00
215383603448285872 7235798061463643920 08:00:00 00:00:00 00:00:00
257415102494418704 7553089079693289232 04:00:00 00:00:00 00:00:00
523496796157126416 7629504038312093456 09:00:00 00:00:00 00:00:00
7067841298470539024 8304397469580535568 05:00:00 00:00:00 00:00:00
7005452702284038928 8382874171023813392 04:50:00 00:00:00 00:00:00
1755072858011642384 8493346004148215568 04:30:00 00:00:00 00:00:00
2935357396580574992 8517171111497049872 06:30:00 00:00:00 00:00:00
5512664329134024464 8929213094006105872 08:00:00 00:00:00 00:00:00

[dentalguru]

Sorry I tried andbut could not format the out put any better , its clear in edit view so if you have admin privileges on the board pl look at it in the edit window
There is no duplication anywhere,The structure is pretty much as it should be.
that's the reason I thought it was a coding error and also un upgraded database woks fine with the previous version of OD
thanks

[dentalguru]

Hi there all,
Thanks Ryan I was awaiting your reply as the database shows no discrepancy and there are no duplicate entries
Thanking you in anticipation
Dr Pillai

[dentalguru]

There were Time-card rules for employees, who had Quit Job and been deleted from the employee list.
Deleted rows where employeenum=0 from table Timecardrule and that worked.
THE PROGRAM HAS A BUG AS IT SHOULD ENSURE WHEN THE EMPLOYEE IS DELETED THE TIME-CARD RULE FOR THE EMPLOYEE SHOULD BE DELETED AS WELL.
THANKS ALL FOR THE HELP

[allends]

THE PROGRAM HAS A BUG AS IT SHOULD ENSURE WHEN THE EMPLOYEE IS DELETED THE TIME-CARD RULE FOR THE EMPLOYEE SHOULD BE DELETED AS WELL.

This has been fixed as of version 14.3.30.

If you are wondering why TimeCardRule rows with an employeenum of 0 were not deleted, then it is because those rows are not attached to anyone and will not be deleted when an employee is deleted.

[drmkpillai]

Thanks for your prompt reply.

If you are wondering why TimeCardRule rows with an employeenum of 0 were not deleted, then it is because those rows are not attached to anyone and will not be deleted when an employee is deleted.

NO,instead I was wondering how they got created???
and also why they were not detected and corrected when I ran the Database Maintenance tool.
Thanks again

[tgriswold]

DBM does not do anything because time card rules with an EmployeeNum of zero are valid to OpenDental. They are timecardrules that apply to all employees, instead of just a specific employee. They are manually created by selecting "All Employees" in the time card setup window when adding a new time card rule.
In your situation, my guess is that you opened a time card rule entry attached to a now hidden employee and then clicked OK. Since the employee was no longer in the list, the selection defaulted to All employees. Then you ran DBM after that, which cleared out the other invalid entries but any ones you opened and clicked OK now looked valid, so DBM left them alone.