Skip to Content
avatar image
Former Member

Linking from the Inventory Transactions Logs table (OITL)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 08, 2015 at 06:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded