Product Movement
The Product Movement Report gives you data on each SKU received within a given date range. See Figures 11-x below for a sample report. 


Figure 12-14



  • All Items/In Stock Options – Choose one of these options for the products in which you want information.
    • All Items Ordered – All items within the date range will be selected.
    • ...Greater Than Normal Level – All items in stock with more than the "Normal Stock" value (found in the Stock tab when editing an inventory item).
    • ...Greater Than Minimum Level – All items in stock with more than the "Reorder Level" value (found in the Stock tab when editing an inventory item).
    • ...Greater Than Average Month – All items in stock with more than the monthly average value (calculated for you).
  • Earliest/Latest P. O. Date – Allows you to set a date range when searching for Purchase Orders.
  • Vendor Code Matches – Allows you to search for a single vendor at a time.
  • Generate Report – Creates the report based on your settings.
  • Exit – Closes the Product Movement Report window.

Figure 12-15



 

Product Turnover 

This report will show you your inventory levels as they stood for any given date range. 

  • Starting Date – The inventory level for items with this date will be displayed in the "Start" column.
  • Ending Date – The inventory level for items with this date will be calculated based on quantities received, sold and marked down since the "Starting Date" and displayed in the "Ending" column.
  • Include Date Range in Filter – If searching by Filter (department, style, etc.), you can elect to search by date range as well by turning this option on.

Figure 12-16

  • Sort By Description – By default, the report will be sorted by SKU. If this option is enabled, the report will be sorted by item descriptions instead.
  • Unit/Dollar Report – Changes the units used in the quantity columns. 
    • If "Unit" is selected, the numbers displayed will represent the number of items, or units.
    • If "Dollar" is selected, the numbers displayed will represent the retail value.
  • Set/Clear Filter – Allows you to create (or clear) filters by which to search.
  • Generate Report – Creates the report based on your settings.
  • Exit – Closes the Product Turnover Report window.

   

Figure 12-17

 

Assembled/Unassembled

Report listing items that may require assembly, used in conjunction with the Bike Shop module.
 

Inventory Valuation 

Gives cost of goods details for a single SKU.  


Figure 12-18Figure 12-19