I am trying to bring over the Customer from the Sales Order through the Purchase Order Details by Inventory Item Report. I can see that the SO Demand section is pulling the Data through on the SOLineSplit3 table and I have attempted to join the tables together with the settings shown in the picture but it just prints out blank. does anyone know how I should be Joining these two tables together to get that Customer ID as a Field I can add?
Solved
POOrder - SOLineSplit3 relation
Best answer by aiwan
Hi
I think you should try to link SOLineSplit3 to SOLine based on OrderType = OrderType
OrderNbr = OrderNbr
OrigLineNbr = LineNbr
Then join SOLin to SOOrder on OrderType = OrderType
OrderNbr = OrderNbr
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.