Sales Order Details Report with comprehensive stock status

I am needing is a report like the Sale Backorder Details Report or the Sales Order Details Report but with added information to show the full stock situation on a per line item and per sale basis:

- Qty of stock on customer order 

- Qty of stock on hand 

- Qty of stock on supplier order

I have a number of applications that I require this for on a regular basis and even if I run multiple reports and stitch them together with VLOOKUP etc I can’t really get the report data I need (due to priority of allocations etc.), I would like Cin7 to add the above data columns to either the Sales Backorder Details Report or Sales Order Details Report.