AutoCount Resource Center

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

Page Discussion

Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee (view source)

Revision as of 03:10, 1 September 2021

644 bytes removed ,  2 years ago
no edit summary
No edit summary
No edit summary
 
Line 14:
<u><b>Solution:</b></u>
 
Kindly please backup and send your backup file to your software provider for further check on your database.
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 <b>EMPLOYEE</b> and find the <b>EMPLOYEE_KEY</b> for the related employee.
 
 
[[File:Mismatch in packet3.png]]
 
 
Key in the query as below:
 
<b><span style='color:red'>update EMPLOYEE set joindate='01/01/18' where employee_key=93</span></b>
 
 
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.
 
 
LaySwan
authors, Administrators
7,127

edits

Retrieved from "https://wiki.autocountsoft.com/wiki/Special:MobileDiff/18608"