Skip to main content
Solved

Trying to get PR and PO # onto Landed Cost GI PO3030PL


Hello,

I’m trying to edit the default Landed Cost GI (PO3030PL) to also include just two more columns on the results grid – the Purchase Receipt Nbr and the Purchase Order Nbr. This will help our accounting and logistics teams more easily match landed cost to invoices and reconsiliations since the invoices are always by PO or PR. 

I found the correct tables to add and can grab the field on the results grid, but the column(s) can’t pull data since it’s flagging the relations tab not joining the tables correctly. However, I’ve tried adding the new table as both inner, right, and left join but none of those work. Can someone let me know what the ‘relations’ tab should look like in order to make this work? (Add X as a left join… etc) Screencap below is what relations tab looks like without me adding anything. 

 

 

Best answer by nhatnghetinh

Hi @AHanke 

Please refer to the screenshots below.

 

 

 

 

 

 

Best Regards,

NNT

View original

nhatnghetinh
Captain II
Forum|alt.badge.img+7

Hi @AHanke 

Please refer to the screenshots below.

 

 

 

 

 

 

Best Regards,

NNT


  • Freshman I
  • August 22, 2024

Thank you @nhatnghetinh that worked perfectly! 


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