Hello,
Anyone who can help me be able to display Department ID of the (salesperson) in an SO order? I tried connecting EPEmployee to Salesperson which is connected to SOOrder by SalespersonID, by using either ordernbr, ownerid, baccountid, salespersonID, etc. and there’s no error message in the field which makes me think the Tables did get connected but I got no display of data though. Pls help, thank you!
Hi Paula,
After you add the SOOrder table to the GI, click on the ADD RELATED TABLE button and then type SalesPerson in the Child Table lookup field. The only one that came up for me was the AR.Salesperson table. You can then click SELECT RELATED TABLE to add that table and it will add the RELATIONS info for the join. After that, highlight AR.Salesperson table and repeat the ADD RELATED TABLE button push and type Employee in the child table to make the join between AR.Salesperson and Employee.
Best Regards,
David Eichner, CPA
Sr. Solutions Architect
Kensium
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.