Skip to main content
Solved

How to get Employee Name for POOrder

  • 5 June 2024
  • 3 replies
  • 50 views

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?

3 replies

aaghaei
Rank
Userlevel 7
Badge +9

@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

 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Sagar Greytrix
Rank
Userlevel 5
Badge +2

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!

Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
Manikanta Dhulipudi
Rank
Userlevel 7
Badge +12

Hi @VadymBoichenko96 

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

Acumatica Functional Consultant /vrsn2709@gmail.com /

Reply


Terms & ConditionsCookie settings