Skip to Content
Former Member
Jul 26, 2011 at 08:23 AM

Required SQL Query


Dear All,

I want a query which gives me following result.

1) Finished Goods from open sales order with order No.

2) All child item of above (Up to depth 18)

3) Ordered Qty from sales order

4) Instock Qty.

5) Planned Qty

6) Releases Qty

7) Pending to release qty

Please help me for the above query

Ashish Gupte