Module Human Resourse !

[Former Member]

I have aproblem:

For example: In Module Human Resourse, I removed existing 24 employeesu2019 records in OHEM table in SQL Database. Now the OHEM table is empty.

But when I want to add new a employee record, the Employee No textbox not start at the number 1 in stead it showed the 25

It must be to start with Employee No = 1.

Everyone have some Ideas?

Plz guide me !

[jitin_chawla · Accepted solution]

Hi,

Did you run any update or delete query in SQL?

If the same is done then database becomes out of SAP Support Scope. You can check Note No. : 896891 for the same.

Regards,

Jitin

[Former Member · Accepted solution]

Thks for help !

I removed records from B1 and SQl command.

any solution to reset it?

Thks & Rgds !

[Former Member · Accepted solution]

Employee Number field is similar to that of 'Call ID' field of 'Service Call'.

Once employee is added, the number is automatically incremented. You cannot do anything for that.

As a alternate, we started using, 'ID No.' filed available in the 'Personal Tab'.

One more recommendation is don't ever try for any backdoor methods with SAP B1.

[former_member583013]

Pham,

Did you remove the Employee records directly from SQL Server. If you did so...you did a big mistake. You are not suppose to use any DML statements on the SAP company database.

The Employee ID is a key field and once used, you may not re-use the numbers. So it is going to start in your case from 25

[Former Member]

Hi Suda Sampath,

Thks for reply soon !

So we have any solution to reset it?

Because The user can't key in Emp No with Emp ID starts with No25

Thks & rgds !