Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee: Difference between revisions
Content added Content deleted
(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: | Line 2: | ||
[[File:Mismatch |
[[File:Mismatch in packet 1.png| 1100px]] |
||
<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}} |