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!
Answer
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
+15Hi
can you check attached standard GI from Acumatica
Acumatica Functional Consultant & Customer Experience Supervisor
+12Add 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
Megan Friesen, Contego Software Solutions, Canada
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.