Skip to Content
0

What is the Link Between OCRD and OINV

May 13, 2017 at 02:20 AM

107

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K May 13, 2017 at 11:19 AM
0

Hi,

Here the link between OCRD and OINV tables,

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

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 13, 2017 at 07:58 PM
0

Sorry I did a typo

I meant ORDR and OINV

So sales order and Sales Invoice

Thank You

Show 1 Share
10 |10000 characters needed characters left 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]

0