Skip to Content
0
Mar 10, 2015 at 05:32 AM

Sale purchase analysis query

128 Views

Dear Gurus

Please advice me a query for extracting data for following things in a given range of date and item group

1) Item Code

2) Item Name

3) Item Group

4) in Stock

5) Vendors name

6) Quantity Purchased

7)Total value of quantity purchased.

8) Customer name

9)Total quantity of item sold.

10)Total value of sales

Your prompt answer is highly needed.

Regards

Ghufran