Employee ID Look up in AX 2012

Finance and Operations/AX Developer Forum
1

Hi,

  1. I want Employee ID lookup in AX 2012 and also i want to save the Employee ID (Personal Number) in one Table ,

  2. But i dont want to Store as RecId of Employee Id in my own Table …

How to Achieve this and give me step by step process with an example

2

You just have to create a relation on your table that will link your field and HcmWorker.PersonnelNumber. AX will create the lookup for you.

Nevertheless I would store HcmWorker’s RecId and merely show PersonnelNumber in a reference group control (it can be set in the ReplacementFieldGroup property).

3

Thanks for your valuable reply Mr.Martin,

But still im having doubt for using Recid of HcmWorker in my table, If i use Recid of Hcmworker in my Table , But in the Table its Showing only RecId but in the form its showing Name by using Replacement Key . If RecId Hcmworker field is availabel in my table. But my doubt is if i want to filter an Employee personnel number in execute Query there will be only Recid Field there wont be PersonnelNumbe field in my table ,Let us assume, If there is an Enquiry Screen , User will enter only Employee Personnel Number , But in this scenario how to achieve from the Recid… Hope you understood my question…

4

You can filter by the replacement field without any issue. Experiment with it for a while - you’ll see that it’s completely transparent to end-users.

5

You can go for the option of creating new employee ID badges. This would work for sure.

6

Dear Martin,
I did the same, but instead of displaying the Name of the Employee in the form, it displays the REC ID

thanx

7

You are missing the second part of his reply …which is that - "Nevertheless I would store HcmWorker’s RecId and merely show PersonnelNumber in a reference group control (it can be set in the ReplacementFieldGroup property).

8

Did the same as who and when? Do you really have the same question as AX Beginner three years ago?

I think you should rather create a new thread and explain your particular problem there. Make sure you have the right EDT, the right relation, the right form control bound to the right field.

9

Thanks for the reply. My question is different. I shall open a different thread.