on 01-08-2015 3:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.