Skip to Content

Invoice report

Hi Experts

I need a Invoice Report how to join Ar Invoice + Ar credit note is there any link between these two

Thanks

Vinoth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 08, 2017 at 03:11 PM

    Hi Vinoth,

    SELECT * FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN ORIN T2 ON T1.[TrgetEntry] = T2.[DocNum]

    Regards:

    Balaji

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 10:10 AM

    Hi,

    Check this :

    select T0.DocNum as 'AR Invoice Num', T2.DocNum as 'AR Credit Num'

    from OINV T0 INNER JOIN INV1 T1 on T1.DocEntry = t0.DocEntry INNER JOIN ORIN T2 on T2.DocEntry = T1.TrgetEntry

    WHERE TargetType = '14'

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • May 14, 2017 at 12:38 PM

    Hi,

    Try this link,

    OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] left join RIN1 T2 on T2.[BaseEntry] = T1.[DocEntry] and T2.[BaseLine] = T1.[LineNum] INNER JOIN ORIN T3 ON T2.[DocEntry] = T3.[DocEntry]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      while executing the query its shows wrong result compare with sales analysis report for invoice.

      invoice raised values not showing in output

      invoice and credit not raised values only displaying.

      while comparing with sales analysis it has to match

      Thanks

      Vinoth