Skip to main content
Solved

How to get Employee Name for POOrder


Forum|alt.badge.img

How can I get value from EPEmployee for POOrder? I tried to join them by EmployeeID for POOrder and AcctCD for EPEmployee but got error that EmployeeID does not exist in POOrder. How should I join them?

Best answer by Sagar Greytrix

Hi @VadymBoichenko96 ,

You need to join them by OwnerID for POOrder and BAccountID for EPEmployee and then select AcctName as Employee Name.

​​​​​​​Hope this solution works for you!

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

Instead of EMployee ID can you check Owner ID for employee information ?


Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hi @VadymBoichenko96 ,

You need to join them by OwnerID for POOrder and BAccountID for EPEmployee and then select AcctName as Employee Name.

​​​​​​​Hope this solution works for you!


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1178 replies
  • June 5, 2024

@VadymBoichenko96  Inner Join POOrder to Contact and then Inner Join Contact to BAccount and use the below fields on them respectively

POOrder.OwnerID = Contact.ContactID
Contact.BAccountID = BAccount.BAccountID

then from BAccount use AcctCD for Code and AcctName for name. If you want your data from Employee then you can Inner Join BAccount to EPEmployee on

BAccount.BAccountID = EPEmployee.BAccountID

 


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