Skip to Content
avatar image
Former Member

Query For FRIEGHT

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 19, 2010 at 02:40 PM

    Hi Sanjo,

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

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2010 at 06:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded