Skip to Content
Former Member
Nov 12, 2012 at 11:48 AM

Production Order


Hi All,

I Want To Make a Query in Which I need

1)Date And Quantity of Item Having ItemCode WH-100 From inventory Transfer

2) Quantity of Component item Whose item Code is 'WH-100' from production order But Here Date Should be From Receipt From Production

Please Help Me to Solve this Problem...

And Also I want to write this query in ms SQL server 2008

Best Regards,

Gayatri Shukla