Report - Products that were checked in but not recently sold

Modified on Sat, 23 Dec 2023 at 02:35 AM

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.


References

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article