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?
POOrder - SOLineSplit3 relation
I posted the wrong image of the Relationships, here is the correct one.
This Relation setup also seems to not work.
Have you tried with POLine with SOLinesplit3 like below?
Table Name | SOLineSplit3 | JOIN | POLine |
Column Name | pOType | orderType | |
pONbr | orderNbr | ||
pOLineNbr | lineNbr |
Have you tried with POLine with SOLinesplit3 like below?
Table Name | SOLineSplit3 | JOIN | POLine |
Column Name | pOType | orderType | |
pONbr | orderNbr | ||
pOLineNbr | lineNbr |
Is the SOLineSplit3 set as the parent table?
As you shared above, you can just modify the POOrder to POLine and add the right conditions and verify please
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/96f57d99-09fa-484a-adb3-d6b983782a1c.png)
As you shared above, you can just modify the POOrder to POLine and add the right conditions and verify please
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/96f57d99-09fa-484a-adb3-d6b983782a1c.png)
that sounds like it might take a while, I can try to gather some more information but I was also wondering if there might be another table I could use to pull the Customer name from to get it referenced with the PO.
Join the SOLineSplit3 with SOOrder tables and you have CustomerID is available in th SOOrder.
From there you can with SOOrder with BAccount table (with Alias name) and get the Customer name.
Join the SOLineSplit3 with SOOrder tables and you have CustomerID is available in th SOOrder.
From there you can with SOOrder with BAccount table (with Alias name) and get the Customer name.
Hi
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.