Inventory Period Activity

This report gives a view  of the activity in the Store between dates as defined by the dates on selected  opening and closing Stock Sheet .

The Period Activity Report is valuable:
  • when you require a picture of the actual dollar and/or percentage profit figures that your Store generated  over a defined period.
  • If you wish to see a definitive over/short (shrinkage) report for the entire period with supporting Stock Sheet count entries.
If you want to see a store wide report, then at least two good complete stock counts for the entire store are required, one at the start, and one at the end of the period.
  • If you don't want to physically count the stock for the entire store, the stock sheets can default to the most current figures when compiled. So another approach is to do smaller, more manageable counts thoughout the period and post each stock count following a planned store count rotation.  Then, at the end of each period, just compile a stock sheet with counts, close them and use the default system counts in the Period Activity Report. 
  • The report is driven by the figures taken from two separate stock sheets made more than a day apart. 
    e.g. May 31st and June 30th closing Inventory counts.
  • The stock sheets have to be built, completed and CLOSED in the Stock Sheets form before they will appear as a line in the opening/closing stock sheet lists.  
  • If a Stock sheet is made at the beginning of a period and another on the end of the period, you can then see all the Items Received, Sold, Transfered, and Returned For Credit activity between those dates
  • Choose the beginning counts as an 'Opening Stock Sheet' and the ending counts as a 'Closing Stock sheet.
  • The ending counts then count as the beginning of the next period and so on.
Choose Inventory - Period Activity' from the Menu to see the initital report Stock Sheet selection window:

Manual Picture
  • Select (Click) on an 'Opening Stock Sheet' line
  • Select a 'Closing Stock Sheet' line.
Select the options in the'Report Options' Tab depending on how you want the data compiled. (This Tab will not be shown until a sensible Open/Closing Sheet combination is chosen - the Opening Sheet date must be at least one day ahead of the Closing Sheet Date.)
 
Manual Picture

  • The 'Invoice Costs' options show either the cost of items extended less any included purchase taxes and Vendor Discounts, or inclusive of Taxes and before discounts.
  • Select the Category - Type or Location - Bin options to define how the report structure is organized.
  • The 'Closing Sheet' constraint option constrains the report to just the items on the closing sheet,  
    otherwise all items on the database are shown. This allows a partial Inventory to be comapred to an earlier full Inventory count.
  • The 'Display Inventory Controlled Items Only' flag allows you to see only the items set as Controlled on the system. Set the flag using the 'Controlled' option in Inventory Item Maintenance
    This allows you to compile the data for a subset of specified (controlled) items only.

The 'Report Type' print Options are as follows : -
  • Executive Summary  - Gives a one page summary of the Period Activity.
  • Detailed Report - Shows each item on it's own line - Unchecked gives a Department Summary.
  • Show unit and count figures only - When unchecked this option extends all figures out to a dollar value. 
  • Discrepancy Report - Use the options in this part of the form to show the worst offenders in the list that are causing an overage or shortage.
    For instance you can view a list of all the items that are reporting a shortage of over 3 units. OR you can shows all items ONLY where the Calculated sales differ from the actual sales as reported from the registers. 
Click the 'Functions' Tab Option.

Click 'Print Report' to see the results of your options selection.

Manual Picture
  • The report can be printed or exported to a file by using either of the top left buttons that appear with the report preview.
Manual Picture

 The figures on the report are calculated as follows: - 

  • Opening + Received + Transfered In - Transfered Out - Returns = Available (for sale) 
  • Calculated Sales = Available - Closing
  • Over/Short = Actual (POS) Sales - Calculated Sales 
    A negative value indicates shrinkage on those items! (or possible mistakes entering invoices) 
    A positive value means the good fairy visited the store one night and left items there - or it could mean somebody hasn't entered all of the invoices yet!
  • If, after printing a Period Report, you realize you need to change an entry in a one of the Stock Sheets to correct a figure, click the 'Re-Open StockSheet' button at the bottom of either Opening or Closing section.
  • Close the Stock Sheet again when the corrections are completed. 
    Reprint the Period Activity Report to see the adjusted figures reflected.