Overview
This report is a tailored view of our Report - Product Sales Analysis that filters for Products that have not been sold in the last 13 weeks but have been checked in within the last 7 days at a given Location.
Usage
The report can be used to find Products that are slow movers that may be taking up shelf space, or Products that could be nearing expiration.
Default Properties
- Filtered by 13 Wk Qty <= 0 AND Last Counted >= [7 days before today] AND Location Name equals [provided by link]
- Ordered by Description
Columns
- Location Name: The Location that is carrying the Product.
- Description: The description of the Product.
- Size: The size of the Product.
- Department: The name of the Department the Product is a member of.
- Category: The name of the Category the Product is a member of.
- Price: The retail price of the Product at the given Location.
- Avg Cost: The Average cost for the Product at the given Location.
- QoH: The current quantity of the Product at the given Location.
- 13 Wk Avg: The average Quantity sold of the Product over the last 13 weeks (3 months) at the given Location.
- 13 Wk Qty: The total Quantity sold of the Product over the last 13 weeks (3 months) at the given Location.
- Last Counted: The date and time the Product was last checked in at the given Location. This column is hidden by default.
- Product Created: The date the Product was added to the system. This column is hidden by default.
NOTE: To see information on additional columns, see Report - Product Sales Analysis.