Skip to Content
avatar image
Former Member

What is the Link Between OCRD and OINV

I want to create a query that will verify how many back order there is between the

Order OCRD and Invoice OINV table per month

but I can't make a link between both tables

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 13, 2017 at 11:19 AM

    Hi,

    Here the link between OCRD and OINV tables,

    OINV T0 INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 13, 2017 at 07:58 PM

    Sorry I did a typo

    I meant ORDR and OINV

    So sales order and Sales Invoice

    Thank You

    Add comment
    10|10000 characters needed characters exceeded

    • Try this link between ORDR and OINV

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