Query For FRIEGHT

[sanjo_joseph]

Hi all...

I want to generate a query report against A/R invoice in which i want to show the frieght amount(From IPF2/OIPF) we already entered in the landed cost(Puchase module).

please provide the query to display the same and the link between IPF2 and OINV

Thanks in Advance

Sanjo

[Former Member]

Hi Sanjo,

Try this,

SELECT *  FROM IPF2 T0 INNER JOIN OINV T1 ON T0.[DocEntry]=T1.[LndCstNum]

SELECT *  FROM IPF2 T0 , OINV T1 WHERE T0.[DocEntry]=T1.[LndCstNum]

Regards,

Madhan.

[Former Member]

Hi Sanjo,

I don't think there are any link between IPF2 and OINV. Landed cost is for AP use only.

Thanks,

Gordon