Link Payroll Employee to GL Control (9.05.701)

Yahoo Archive
1
Thought I'd post the answer in case someone else is looking for the same info. The GL control codes for PREmpMas are in the EntityGLC table. Link company to company and EmpID to Key1. Set criteria to the RelatedToFile to = PREmpMas.

EntityGLC holds GL control codes to a number of tables. I've found the values for RelatedToFile and Keys1-6 are generally the same as the links given in the Epicor spreadsheet with TranGLC links (spreadsheet can be found in the files section). The only difference I've found is the EntityGLC link for APInvHed includes Key3=GroupID; the TranGLC link for APInvHed doesn't use Key3.

Sue
2
I'm trying to make a dashboard to show the GL controls attached to a payroll employee. The GLCTEntity table tells me that PREmpMas is tied to GLControlTypes Division and Department. I can't find a way to tie the payroll employee to the GL Controls he's linked to. Any ideas?

Sue