Overview

This report shows multiple buckets of information concerning Product Sales.


Usage

This report can be used to break down sales patterns over months and years or gain insight into fast or slow moving Products.


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.
  • GP %: 
  • Markup: 
  • QoH: The current quantity of the Product at the given Location.
  • 4 Wk Avg: The average Quantity sold of the Product over the last 4 weeks at the given Location.
  • 8 Wk Avg: 
  • 13 Wk Avg: The average Quantity sold of the Product over the last 13 weeks (3 months) at the given Location.
  • MTD Qty:
  • PY MTD Qty: 
  • MTD Variance: 
  • YTD Qty: 
  • PY YTD Qty: 
  • YTD Variance:
  • Qtr Qty: 
  • PY Qtr Qty: 
  • Qtr Variance:
  • CY Qty: 
  • PY Qty: 
  • Year Variance: 
  • Jan Qty: 
  • PY Jan Qty:
  • Feb Qty: 
  • PY Feb Qty:
  • Mar Qty: 
  • PY Mar Qty:
  • Apr Qty: 
  • PY Apr Qty:
  • May Qty: 
  • PY May Qty:
  • Jun Qty: 
  • PY Jun Qty:
  • Jul Qty: 
  • PY Jul Qty:
  • Aug Qty: 
  • PY Aug Qty:
  • Sep Qty: 
  • PY Sep Qty:
  • Oct Qty: 
  • PY Oct Qty:
  • Nov Qty: 
  • PY Nov Qty:
  • Dec Qty: 
  • PY Dec Qty:
  • 1 Wk Qty: 
  • 2 Wk Qty:
  • 3 Wk Qty:
  • 4 Wk Qty: The total Quantity sold of the Product over the last 4 weeks at the given Location.
  • 5 Wk Qty:
  • 6 Wk Qty:
  • 7 Wk Qty:
  • 8 Wk Qty:
  • 13 Wk Qty: The total Quantity sold of the Product over the last 13 weeks (3 months) at the given Location.
  • 52 Wk Qty: 
  • Primary Supplier: 
  • Last Received: 
  • Last Rcvd Qty: 
  • Last Cost: 

  • Location Code:
  • Product Code: 
  • Subcategory: 
  • Max: 
  • Min: 
  • Price A: 
  • Price B: 
  • Price C: 
  • Sales Price: 
  • Sale Start: 
  • Sale End: 
  • 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.


References