Skip to main content

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?

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

This Relation setup also seems to not work.

@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

@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?

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

 

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.

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

@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.

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.

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

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.

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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved