Linking from the Inventory Transactions Logs table (OITL)

[Former Member]

Hi Everyone,

I am interested in linking from the Inventory Transactions Log (OITL table) to relevant documents; these being Deliveries (ODLN), Goods Issues (OIGE), Goods Receipts (OIGN), Goods Receipt Purchase Orders (OPDN) and Inventory Transfers (OWTR).

Is there any way of linking from the Log table (OITL) to the afore mentioned tables? Is so can you please share your wisdom?

Kind Regards,

David

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this link for OWTR and same way try for other documents:

FROM
OWTR T0  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry left join
OITL T2 on t1.docentry = T2.[ApplyEntry] and  T1.[LineNum]  =
T2.[ApplyLine] and T2.[ApplyType] = 67

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thank you Nagarajan