Order placement

[Arjun032]

Hello,

My app is like Order capture order but there is some issue related to this when an order placed with 2 or more items and when this item has been packed from the storeroom, if the ordered item available on the store room the order status has changed to dispatch or delivered.
The problem is that when an order has multiple items and some items are no stock in store room and some less quantity as compared to order quantity?

I just created an extra column in table order detail with status with some values like no stock,pending
but

I would like to get the data by if order quantity is less in the storeroom then balance order quantity of the item will be display on the pending tab

is this possible