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