Adding Workforce Management Employee ID (External Employee ID) to the Employees GI (EP2030PL)

This knowledge base article guides you through the process of modifying the default Employees Inquiry (EP2030PL) to display the WFM Employee IDs for Employees, and open the Employee screen directly if you click on the Employee ID.

With the Tables tab, add the MPEmployee Table. (This is the Table storing MYOB Specific employee information for the Australia/New Zealand region. EPEmployee is a base Acumatica table).

Within the relations tab add the MPEmployee Table as an inner join to the EPEmployee Table based on bAccountID

In the Navigation tab, add a new Navigation Target

Link of:: " https://advancedteam.myob.com/employees/((WFMID))/ "

Set the Navigation Parameter to be
Field: ((WFMID))
Parameter: MPEmployee.ExternalAcctCD

Finally, add the MPEmployee.ExternalAcctCD to the Results Grid (And set the Navigate to)

You'll now see the WFM ID column on the right, and if you click the number, it will open the Employee screen from MYOB Acumatica Workforce Management as a new popup.:

As an example screen customisation, you can download the above Generic Inquiry as XML Here:

EP-Employee.xml