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.