Determining order volume / what to backorder

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!