Skip to main content
Solved

How to Link SOOrder and SupplyPOLine


Forum|alt.badge.img

I am trying to create a GI that pulls the sales orders as well as the PO orders tied to them to the same GI but I am having trouble figuring out how to properly link these two tables in relations to get the data to pull properly.

 

Best answer by dcomerford

You will need to join the SOLineSplit to the SOLine

The 

The join the POLine to the SOSplitLine

You can join the POORder by 

 

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

10 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • Answer
  • August 28, 2024

You will need to join the SOLineSplit to the SOLine

The 

The join the POLine to the SOSplitLine

You can join the POORder by 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • August 28, 2024

@dcomerford I am getting this error now. Did I miss something?
 

 


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • August 28, 2024

@BrendanL Can you share the GI


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • August 28, 2024

@dcomerford Actually I figured it out, I forgot to relate the SOOrder to the SOLine table, but after getting that done I am just struggling to find the right result field to pull so I can get those PO numbers to show up as most of the fields I try are pulling blanks.


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • August 28, 2024

@BrendanL  Need to share GI as it works for me


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • August 28, 2024
dcomerford wrote:

@BrendanL  Need to share GI as it works for me

@dcomerford How do I do that exactly? I haven’t actually shared a GI across here before as I am quite new to Acumatica administration, basically flying by the seat of my pants on most of this.


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • August 28, 2024

@BrendanL No worries on GI select Export as XML

Attach the file to post


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • August 28, 2024

@dcomerford hopefully this works.


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • August 28, 2024

@BrendanL Your join on SOOrder to SOLine is wrong should be OrderNbr and OrderType. 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • August 28, 2024
dcomerford wrote:

@BrendanL Your join on SOOrder to SOLine is wrong should be OrderNbr and OrderType. 

 

@dcomerford that was it, seems to be working now. thank you so much.


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