Report Slow Moving Merchandise

(Slow Moving Merchandise)

Access

This report lists your slowest-selling products (that is, products whose revenue accounts for only 20% (approximately) of total sales for one or all Groups, Categories, Brands, or Vendors within a specified time period). The quantity of these "slow movers" in relation to the total number of items sold is also shown. These quantity and sales figures also calculate by Product Category and Product Group. Sorting can be by Group, Category, Brand or Vendor. Once the run-time options have been selected, choose Run to produce the report.

Selection

GroupEnter the code of the product group you want to include in the report. If you click on the Search button, a list of groups appears from which you can choose.  If you click on the Action button, the Multiple Group Selection Window appears from which you can choose one or more groups.  If you leave this field blank, you report on all groups.  

CategoryEnter the code of the product category you want to include in the report. If you click on the Search button, a list of categories appears from which you can choose.  If you click on the Action button, the Multiple Category Selection Window appears from which you can choose one or more categories.  If you leave this field blank, you report on all categories.  

BrandEnter the code of the product brand you want to include in the report. If you click on the Search button, a list of brands appears from which you can choose.  If you click on the Action button, the Multiple Brand Selection Window appears from which you can choose one or more brands.  If you leave this field blank, you report on all brands.   

VendorEnter the code of the vendor you want to include in the report. If you click on the Search button, the Vendor Name Search appears from which you can choose.  If you click on the Action button, the Multiple Vendor Selection Window appears from which you can choose one or more vendors.  If you leave this field blank, you report on all vendors.  

Purchase StatusEnter the code of the purchase status you want to include in the report. If you click on the Search button,  a list of purchase statuses appears from which you can choose one or more.  If you click on the Action button, the Multiple Purchase Status Selection Window appears from which you can choose one or more purchase statuses.  If you leave this field blank, you report on all purchase statuses.  

Primary Sort

Secondary Sort

RegionEnter the code of the region you want to include in the report. If you click on the Arrow, a list of available regions appears from which you can choose one or more.  If you click on the Action button, the Multiple Region Selection Window appears from which you can choose one or more regions.  If you leave this field blank, you report on all regions.  

Note that if you select a region at this field, you de-activate the Location field.
 

LocationEnter the code of the location you want to include in the report. If you click on the Arrow, a list of available locations appears from which you can choose one or more.  If you click on the Action button, the Multiple Location Selection Window appears from which you can choose one or more locations.  If you leave this field blank, you report on all locations.  

Note that if you select a location at this field, you de-activate the Region field.
 

Exclude Items Received AfterEnter the cutoff date for this report.  The report excludes sales information for items received after the date you specify here.  If you click on the Calendar Icon, a calendar appears from which you can specify a date.

Exclude Zero YTD SalesTo exclude all merchandise with zero sales for the year-to-date, check the box at this field.  Otherwise, leave the field blank.   

Exclude Zero YTD UnitsTo exclude all merchandise with zero units for the year-to-date, check the box at this field.  Otherwise, leave the field blank.   

Include Misc ProductsTo include miscellaneous products (Type 3) in the report such as warranties, service contracts, special handling charges, fabric treatments, etc., check the box at this field.  Otherwise, leave the field blank.  

Include Spec Ord ProductsTo include special-order products in this report, check the box at this field.  Otherwise, leave the field blank.  

Periods Ago to Report onEnter the number of periods prior to the cutoff date specified at the Exclude Items Received After field for which sales you want to include in the report. This field determines the period at which the system looks at when displaying the total quantity and dollars in the RPT Qty & RPT Dollars columns on the report output.

Report Based on

Send Output toThe output destination of the report displays.  To change the output destination, click on the Actions button and select Output Settings.

Export PathIf you select either the Personal Report Viewer (PRV (Personal Report Viewer) A STORIS printer output option that allows you to customize report results, for example to rearrange data columns.), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.