Skip to main content
Solved

Add Current/Active Position Title to Employee Listing Screen (EP2030PL)


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 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

View original
Did this topic help you find an answer to your question?

3 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @avankooten 

can you check attached standard GI from Acumatica


meganfriesen37
Captain II
Forum|alt.badge.img+11

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


  • Author
  • Freshman I
  • 2 replies
  • March 30, 2023

Perfect, I got it added.  Thank you for your replies!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings