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:
- 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.)

- 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.

- The report can be printed or exported to a
file by using either of the top left buttons that appear with the report preview.
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.
|