How to create a system to track the order quantity of goods, showing how many have already been issued in delivery orders (DO) and how many are still pending for delivery.

How to create a system to track the order quantity of goods, showing how many have already been issued in delivery orders (DO) and how many are still pending for delivery.

I want to be able to create a system that tracks the order quantity of goods, showing how many have already been issued in delivery orders (DO) and how many are still pending for delivery.

An example of what Im looking for:

under sales order module below is the quantity for each product.


I want it to be display the items that are already issued and items that have not been issued yet

just as seen below.


Items already Issued DO

1            A3 Cotton Bag                               200

2            Eco Ball Pen                                  800

3            A5 Kraft Notebook                       0

 

Outstanding Items not yet Issued DO

1            A3 Cotton Bag                               600

2            Eco Ball Pen                                  0

3            A5 Kraft Notebook                       800