Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee: Difference between revisions

From AutoCount Resource Center
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 packet1.png]]
[[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



Go to menu

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