Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee: Difference between revisions
(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}} |
Revision as of 06:49, 3 April 2018
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?
Possible Reason:
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.
Solution:
Login SQL console, browse the database file. Database file is usually located at C:\Program Files (x86)\AutoCount\Payroll\Data.
Drill down to EMPLOYEE and find the EMPLOYEE_KEY for the related employee.
Key in the query as below:
update EMPLOYEE set joindate='01/01/18' where employee_key=93
Then click on Execute.
Note: You may modify the join date and employee key as these 2 variables may be vary.
Click on OK to exit from SQL Console, you will be able to re-edit the employee.
By: Julee 180202, KM 180327, P180403
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|