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!
Best answer by meganfriesen37View original
can you check attached standard GI from Acumatica
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
Perfect, I got it added. Thank you for your replies!