cancel
Showing results for 
Search instead for 
Did you mean: 

Open Purchase Order report....if received partially add "GoodReceipt Date"

Former Member
0 Kudos

Have a Open PO Report using : OPOR and POR1. If received partially then I need to add the field "GoodsReceipt Date" from table OPDN.

PO would be Base document and GR would be Target document. Whatever does not have a GR will be blank or null.

Not sure how to link OPDN to the existing report.

Help Please!!

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try to link by means formatted search query.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Thanks Nagarajan, but I'm not on a level to write queries....just trying to add the table and link by left or inner join....is that possible or how would the query be written and where do I add to my existing table structure?

thanks appreciate the help!!