on 12-30-2014 9:12 AM
Hi all,
Other than relationship map, is there any other method or query to identify receipt from production is from return component or normal receipt from production.
Thanks
Hi,
Not sure your question has been answered. Mr.Karthik replied to show different between Receipt from prodcution with Good receipt (under inventory transactions).
But your question is, "How to identify a production order with receipt from production and return components( for this also same receipt from production is used).
Let me know your comments.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, I got what you mean. Actually is not a direct answer.
End up I found out that my query also include records from Good receipt (under inventory transactions), after applied Mr.Karthik query, at least it help to filter and only show records from receipt from production or return components( for this also same receipt from production is used)
Since I need it in hurry, so I had export all the records and make filtering by using excel to display only if one WO link to 2 or more receipt from production.
Or is there any better solution ?
Anyway, really appreciate your help.
Thank you
Try this:
SELECT T0.[DocNum], T0.[ItemCode], T3.[DocNum], T2.[ItemCode], T5.[DocNum], T4.[ItemCode] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry left join IGN1 T2 on T1.[ItemCode] = T2.[ItemCode] and T2.[BaseRef] = T0.docnum INNER JOIN OIGN T3 ON T2.DocEntry = T3.DocEntry INNER JOIN IGN1 T4 ON T4.[ItemCode] = T0.[ItemCode] and T4.[BaseRef] = T0.docnum and T4.trantype = 'c' INNER JOIN OIGN T5 ON T4.DocEntry = T5.DocEntry
Hi,
When IGN1.BaseEntry=202 then it is a receipt from Production. If IGN1.BaseEntry=-1 then it is a normal Goods Receipt Document.
Cheers
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.