OLDN relationship to DLN1

[former_member239601]

Hi all

Sorry if this is a basic question, but can someone tell me if there is a defined relationship between OLDN and DLN1 tables as I want to query against both with a join but not sure which I can use.

Thanks

[former_member191694 · Accepted solution]

Hi John,

The Table Name OLDN is not there 

You Mast use ODLN   and DLN1 With Inner join On DocEntry.

Regards,

Mayank Shah

[former_member239601]

Thanks guys!

[kothandaraman_nagarajan]

Hi,

Please close this thread by marking correct answer.

Thanks & Regards,

Nagarajan

[former_member239601]

Hi Guys

Sorry delayed reply, yes ODLN is the table I was referring to.

Thanks for advice on to use Docentry, worked as I wanted.

Thanks

[kothandaraman_nagarajan]

Hi,

Please close this thread by marking correct/helpful answer.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Please advice OLDN or ODLN? If ODLN then, you can join ODLN and DLN1 by docentry.

ODLN T0  INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry

Thanks & Regards,

Nagarajan