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.