Skip to main content

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!

Hi @avankooten 

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!


Reply