• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

HR 11 Upload

 3 Replies
 1 Subscribed to this topic
 69 Subscribed to this forum
Sort:
Author
Messages
Akshay
Basic Member
Posts: 7
Basic Member
New Poster
New Poster
Congrats on posting!
7/16/2021 10:11 PM

Hi I did HR11 upload and for some reason the employee number skipped, so instead of taking the next available employee number it too +100, skipping the employee number. what can be the reason and solution?

Ragu Raghavan
Veteran Member
Posts: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
7/16/2021 11:10 PM
The next employee# is obtained from the field PRSYSTEM.LAST_EMPLOYEE + 1. Possible that your table PRSYSTEM is out of sync with the EMPLOYEE table.
Akshay
Basic Member
Posts: 7
Basic Member
New Poster
New Poster
Congrats on posting!
7/17/2021 1:52 AM

Hi, 

 

Thanks for the reply, but I am not able to see the last employee number in PRsystem table?

How should I check that, I am at lawson 10 version.

Ragu Raghavan
Veteran Member
Posts: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
7/17/2021 1:34 PM
You can see the field on the screen HR00.1 under the "options" tab. Or use Excel Add-ins to query the PRSYSTEM table. Or have somebody with the necessary access to dump the table.