How to Link SOOrder and SupplyPOLine

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

@BrendanL Can you share the GI

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

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

@BrendanL No worries on GI select Export as XML

Attach the file to post

@dcomerford hopefully this works.

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

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