Skip to main content
Solved

POOrder - SOLineSplit3 relation


Forum|alt.badge.img

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?

Best answer by aiwan

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

View original
Did this topic help you find an answer to your question?

12 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 21, 2024

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 21, 2024

This Relation setup also seems to not work.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 21, 2024

@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

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 21, 2024
Naveen Boga wrote:

@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
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 22, 2024

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

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 24, 2024
Naveen Boga wrote:

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.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 24, 2024

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 24, 2024
Naveen Boga wrote:

@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
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 24, 2024

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • June 28, 2024
Naveen Boga wrote:

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
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • June 28, 2024

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.


Forum|alt.badge.img+7
  • Captain II
  • 295 replies
  • Answer
  • July 1, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings