Return Component flag in Good Receipt

[Former Member]

Hello, I'm creating a report which need to know which one is a Good Receipt and a Return Component from Production Order.

I've tried to look at the table, but can't find which is the flag for Return Component and the other (Good Receipt).

Does anyone can help?

Thanks

-Flo

[former_member206488 · Accepted solution]

Hi,

Try this:

SELECT  T0.DocNum as [Receipt No.] ,T1.BaseRef as [Prod Order No.] ,T1.ItemCode ,T1.Quantity 
FROM OIGN T0 
         INNER JOIN IGN1 T1 on T0.DocEntry=T1.DocEntry  
WHERE TranType is null and BaseType=202

Thanks,

Neetu

[Former Member · Accepted solution]

hey, it works!! thank you very much for your quick reply

Anyway, i just checked on the query result, supposedly 4 rows, but using your query, i got only rows... Then when i checked on the receipt production order, i found 1 item which Type (TranType) is Complete, what does it mean? and what is the meaning with TranType = NULL or ' ' ? So sorry, I'm a newbie in B1

[former_member206488 · Accepted solution]

TransType C is for receipt from prodiuction and if transtype is null --it shows return components.

Hope this will help you

[Former Member · Accepted solution]

Thank you very much, Neetu!!! have a good day

[foxitool]

Excelente respuesta, me sirvio, es justo lo que necesitaba.