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'
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
Special Filters
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
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.
Ensure to scroll to the right to view more column detail.
Return to Top
Want more information? Find related articles here:
Sales Report
How do I report on how a particular Product / Style is performing?