Use the Sales Report - Outstanding Order Balance, to display ALL products not fulfilled, across Processed and Awaiting Payment Orders.
Considerations when using this report:
- the calculation used is: Qty NOT Fulfilled x Unit Price for Processed/Awaiting Payment Orders, separated by Brand
- Products without an associated Brand will display in the results as 'Undefined'
Note: you can create or edit Brands to suit your requirements, please see : Settings - Product Attributes
To access the Sales Report - Outstanding Order Balance, navigate to: Reports > Finance Report > Sales Report - Outstanding Order Balance
Most of the filtering fields are self explanatory, however see the detailed information below for the more advanced fields.
Inc Tax - tick to include tax in the report values
Country - if no Country is selected, all countries will be included by default
Note: there is no option for date range selection - this report will display values for ALL unfulfilled products across Awaiting Payment and Processed Order.
Apply filters as required > click Search.
You can view this report in-page, however due to it's extensive nature we recommend you Export to Excel.
Tip: ensure to scroll to the right to view more column detail.
Want more information? Find related articles here: