What tables need to be added to the employee listing (Screen ID EP2030PL) so the current Position Title can be displayed as well (is this possible)? What is the relation/link for the new table(s) that need to be added in order to get this information to be displayed on the listing? The Position Title is located on the Employment History Tab in the employee record. Thanks!
Solved
Add Current/Active Position Title to Employee Listing Screen (EP2030PL)
Best answer by meganfriesen37
Add the EPEmployeePosition table to the existing Employees GI and join as follows
EP Employee Left Join to EP Employee Position
on bAccountID = bAccountID AND
EPEmployeePosition.IsActive = True
Then, in the results grid, add EPEmployeePosition - Position ID and/or Position ID Description
+16Hi
can you check attached standard GI from Acumatica
Translate
+13Add the EPEmployeePosition table to the existing Employees GI and join as follows
EP Employee Left Join to EP Employee Position
on bAccountID = bAccountID AND
EPEmployeePosition.IsActive = True
Then, in the results grid, add EPEmployeePosition - Position ID and/or Position ID Description
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.