Undelivered items sales order report

Hello, I was wondering if I can create a sales order report that only shows items that have been undelivered. i.e. If a customer ordered 5 qtys, and 3 have been delivered, the report shows 2 copies.

The main purpose of this report is to get the encumbered (order value) per customer per budget.

Any guidance is appreciated.


This is what I am after

ordered qty - delivered qty != 0

Is this needs customization or can be readily available in erpnext?


1)Actually reports are available i.e “Ordered Items To Be Delivered”
Inside Selling Module->Standard Reports->Ordered Items To Be Delivered
2) Some reports are also available i.e Stock Ledger ,Stock Balance
I think this report will help you…