The Sales Report (Limited) is a reduced version of the Sales Report. This report is recommended to be used when you want staff to access the Sales Report, but don't wish for them to view Cost or GP information.
Tip: This report should not be used as a single reference for overall sales information but in conjunction with the Stock Value vs Sales Report
Using the Sales Report (Limited)
To use the Sales Report (Limited):
- Open Retail Express
- Navigate to Reports > Sales Reports > Sales Report (Limited)
- Use the Search fields and Filters as required (see below for detailed information)
- Click Search
- To Export the report click either the XML or CSV buttons in the top right-hand corner
Most of the filters are self-explanatory, however, see the detailed information below for the more advanced filtering explanations.
The order number for the invoice
Note: Entering an Order Number will ignore all other filters and display this order only
|Product PLU Code||
Can be used to enter multiple codes when separated by a comma e.g. 1234, 1235, 1236. Valid codes for this field are:
Note: When filtering by a PLU the report will show the entire order including the matching PLU; not just the line item for that product only. For reports on specific products only refer to the Product Sales Report.
|Date From/Date To||
The date range for the transactions on the report (used in conjunction with other filters).
Tip: Match date and time with your Income Report
|Filter by Processed Date||Tick this box to report on sales that reached the Processed status within the date range. This will exclude any orders marked as Awaiting Payment.|
|Do not Summarise by Outlet||Tick to display invoices in a consecutive order, not grouped by Outlet|
If a sale was processed while the system was Online or operating in Offline Mode
Used to filter orders by a current status where the order was created within the date from/to range
Note: this filter should not be confused with the Filter by Processed Date filter
Where the sale originated from.
Note: All sales placed through the eCommerce API are from an order source of "WebService". The "Webstore" option is a legacy system.
Tip: if you require assistance or training is using Excel, free help is available directly from Microsoft - https://support.office.com/en-IN/Excel