Troubleshooting Payroll: Error ‘Mismatch in datapacket’ when edit an employee: Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 14: | Line 14: | ||
<u><b>Solution:</b></u> |
<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: |
|||
<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. |
|||
Latest revision as of 03:10, 1 September 2021
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:
Kindly please backup and send your backup file to your software provider for further check on your database.
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
|