SAP B1 Query - How to exclude/hide Goods Receipt PO with Goods Return Transaction

[former_member1113324]

Hi,

I need to write a query that can exclude/hide goods receipt po that link/with a goods return transaction

thank you

[msundararaja_perumal]

You cannot simply reject the GRPO that has GR, as it is not necessary that all the items in the GRPO copied to GR, you need to write the query to accomodate by item.

Thanks.

[JesperB1]

You find the link to the target document in table xxx1 (itemline). Target type will refer to the document type.