Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee: Difference between revisions
Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee (view source)
Revision as of 06:49, 3 April 2018
, 6 years agono edit summary
(Created page with "'''Question:''' when I click on save button after editing an employee, system prompts me an error message ‘Mismatch in datapacket’. Why can’t I save the modified record?...") |
No edit summary |
||
Line 2:
[[File:Mismatch
<u><b>Possible Reason:</b></u>
This is due to you didn’t fill in the join date when create a new employee. System will auto-fill in the join date as the date you create this employee. This is a known issue as error message will prompt out when you edit this employee again.
<u><b>Solution:</b></u>
Login SQL console, browse the database file. Database file is usually located at C:\Program Files (x86)\AutoCount\Payroll\Data.
[[File:Mismatch in packet2.png]]
Drill down to EMPLOYEE and find the EMPLOYEE_KEY for the related employee.
[[File:Mismatch in packet3.png]]
Key in the query as below:
<span style='color:red'>update EMPLOYEE set joindate='01/01/18' where employee_key=93</span>
Then click on <span style='color:red'>Execute</span>.
<i><span style='color:red'>Note:</span> You may modify the join date and employee key as these 2 variables may be vary.</i>
[[File:Mismatch in packet4.png]]
Click on <span style='color:red'>OK</span> to exit from SQL Console, you will be able to re-edit the employee.
By: Julee 180202, KM 180327, P180403
{{NavigateForUser}}
| |||