Skip to main content
Solved

POOrder - SOLineSplit3 relation

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?

12 replies

B
Rank
Userlevel 3
Badge

I posted the wrong image of the Relationships, here is the correct one.

1 Attachment
B
Rank
Userlevel 3
Badge

This Relation setup also seems to not work.

1 Attachment
Naveen Boga
Rank
Userlevel 7
Badge +19

@BrendanL No, POOrder with SOLinesplit3 join result in duplicates.

 

Have you tried with POLine with SOLinesplit3 like below?

 

Table Name SOLineSplit3 JOIN POLine
Column Name pOType   orderType
pONbr   orderNbr
pOLineNbr   lineNbr
Naveen B
B
Rank
Userlevel 3
Badge

@BrendanL No, POOrder with SOLinesplit3 join result in duplicates.

 

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?

Naveen Boga
Rank
Userlevel 7
Badge +19

As you shared above, you can just modify the POOrder to POLine and add the right conditions and verify please

 

Naveen B
B
Rank
Userlevel 3
Badge

As you shared above, you can just modify the POOrder to POLine and add the right conditions and verify please

 

@Naveen Boga so I attempted that but it is still printing the Customer ID field as empty. here is an image of the data links and table relation.

1 Attachment
Naveen Boga
Rank
Userlevel 7
Badge +19

@BrendanL  Okay! In that case we need to review every other join and its conditions to identify the root cause.

Naveen B
B
Rank
Userlevel 3
Badge

@BrendanL  Okay! In that case we need to review every other join and its conditions to identify the root cause.

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.

Naveen Boga
Rank
Userlevel 7
Badge +19

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.

Naveen B
B
Rank
Userlevel 3
Badge

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.

@Naveen Boga I tried that as well and it either keeps breaking the XML format or continuing to print blanks.

Naveen Boga
Rank
Userlevel 7
Badge +19

Hi @BrendanL Could you please attach your report here for our review? We'll let you know if we find anything that needs to be changed.

Naveen B
A
Rank
Userlevel 5
Badge +2

Hi @BrendanL 

 

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

https://www.linkedin.com/in/aleks-iwan-mbcs-03705b240/

Reply


Terms & ConditionsCookie settings