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

  • 30 March 2023
  • 3 replies

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 31 March 2023, 00:18

View original

3 replies

Userlevel 7
Badge +12

Hi @avankooten 

can you check attached standard GI from Acumatica

Userlevel 7
Badge +10

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!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved