I need to add the project manager employee ID (AcctCD) to the PM-Projects GI but keep getting the Account ID (BAccountID) instead. This is my setup. EPEmployee is linked to PMProject. How do I get the employee id that starts with “E”?
I need to add the project manager employee ID (AcctCD) to the PM-Projects GI but keep getting the Account ID (BAccountID) instead. This is my setup. EPEmployee is linked to PMProject. How do I get the employee id that starts with “E”?
Best answer by meganfriesen37
Hi
the Owner ID field is a Contact field not an Employee (BAccount) field. So the ID # you’re getting is the Contact ID (not the Employee ID). If all you need is the email address, you can link the PMProject table to the Contact Table on OwnerID = ContactID
The email address will be available on the Contact DAC. You can get the BAccountID on the Contact screen, but this will be the system ID not their Employee ID (AcctCD). If you want their AcctCD, then you can join PMProject.OwnerID to EPEmployee.DefContactID and then from the Employees table you can get the AcctCD.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.