What is the Link Between OCRD and OINV

[former_member491962]

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

[former_member491962]

Sorry I did a typo

I meant ORDR and OINV

So sales order and Sales Invoice

Thank You

[kothandaraman_nagarajan]

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]

[kothandaraman_nagarajan]

Hi,

Here the link between OCRD and OINV tables,

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

Regards,

Nagarajan