LInking GRPO and Invoice via query

[Former Member]

Hi,

Is there anyway to link OPDN table(Goods receive) with OINV table(Ar Invoice). The reason is that i am using FIFO for inventory tracking, and when i generate AR invoice, i want to pull the UDF from the GRPO document where the item is bought.

Is it possible?

Thanks

[Former Member · Accepted solution]

Hi Melvin,

AFAIK there are no direct link between OPDN and OINV. But such link can be created by using an additional UDF.

you can assign formatted search to the UDF so that user can select from a list of Goods Receipt to link to the Invoice.

Arief S

[Former Member · Accepted solution]

thats what i thought so. Thanks