cancel
Showing results for 
Search instead for 
Did you mean: 

Producton Order

Former Member
0 Kudos
58

Hi

I want a query that for making a particular product A following item B has been issued how many times group wise of product A.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I think,this query will help u.

SELECT T0.[Type], T0.[ItemCode], T1.[ItemCode], T1.[IssueType], T1.[IssuedQty], T1.[wareHouse] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[ItemCode] =[%0]

Regards

Usha

Answers (3)

Answers (3)

Former Member
0 Kudos

Closed.

Former Member
0 Kudos

Hi,

You need to give a detailed example for others to understand.

Thanks,

Gordon

Former Member
0 Kudos

Hi,

Your requirement is not clear. How are you issuing material for production? Are you using inventory transfer for issuing material ? Or is the material directly received in the production warehouse? Please try to explain your requirement so that it would be easy for forum users to provide solution to your query.

Thanks,

Joseph

Former Member
0 Kudos

Hi

Production Order will be created . From Production Order receipt from production & issue for production will be used.

Thanks