Determining order volume / what to backorder

Hi,

I am evaluating zoho inventory... and have created some items and sales orders.

For my type of items I can not not blindly purchase everything that has been ordered: I need to aggregate my incoming sales orders first, determine which items I will have my vendors manufacture and then issue a purchase order. (Given I need to invest in raw materials I will not always manufacture everything that was ordered.)

I know the Inventory Details report can give me a count of ordered items (" Quantity Committed") but given it's a count only it is quite brief. (It will only add them for Sales Order which have status Confirmed, which in my case is not really true: I regard it as draft until my manufacturer got the order to make the items..)

Is there a way to get an overview of items ordered including sales order and vendor?

The two reports I am looking for would look like:

report 1:

itemsku A 12

sales order1 2

sales order2 5

sales order3 5

itemsku B 2

sales order 5 1

sales order6 1

report 2:

itemsku A 12

customer7 2

customer8 10

itemsku B 2

customer7 1

customer9 1

Thanks!