View Full Version: Employee With Two Lawson Numbers

LawsonTalk > HR/Payroll > Employee With Two Lawson Numbers


Title: Employee With Two Lawson Numbers
Description: Merge hist if an emp is duplicated?


jph826 - September 15, 2006 07:40 PM (GMT)
We have an employee in Lawson twice because someone overlooked/ignored? the warning about duplicate social security numbers.

One record is as a termed employee and one is a now active employee. I am being asked if there is a way to combine the two histories. Does anyone have any recommendations? Thanks

dogeco - September 15, 2006 07:48 PM (GMT)
We don't use PR so it's a little easier....

Rekey all transactions (including benefits) against original employee number.

Term second employee number.
Purge employee benefit history.
Purge employee transaction history.
Purge employee.

Create a query that looks for dup SSNs and run it weekly!!!



Hosted for free by InvisionFree