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?
Answer
How to get Employee Name for POOrder
Best answer by Sagar Greytrix
Hi
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!
+15Hi
Instead of EMployee ID can you check Owner ID for employee information ?
Acumatica Functional Consultant & Customer Experience Supervisor
+3Hi
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
+10POOrder.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*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.