Activity Exception

Report Options

Field Description

Report sequence

Option

Description

Stock code

Select this to generate the report in order of stock codes.

Description

Select this to generate the report in order of stock code descriptions.

Product class

Select this to generate the report in order of product classes.

Supplier

Select this to generate the report in order of suppliers.

Stock value

Select this to generate inactive stock in descending stock value.


	When you select this option, the value generated in the Total cost field for each stock item is the total of the quantity multiplied by the unit cost for the item in ALL warehouses. This is irrespective of the range of warehouses for which you selected to generate the report. The report is generated in descending order of this total cost. Cost values are only generated on the report when this option is selected.

Stock options Refer to Stock Options for details on the effects of selecting or deselecting these options.

Report on stock items

Option Description

All stock items Select this to generate a selective list of stock codes, regardless of the amount of activity recorded against them.

Any monthly activity Select this to generate a selective list of stock codes against which any month-to-date activity has been recorded.

Inactive stock items

Select this to generate a selective list of stock items against which no activity has been recorded since a specified cut-off date.

The program checks if the last Sale date or last Issue date against the stock warehouse record is after the No activity since date entered and if it is, then the warehouse is ignored.

If you selected Include stock adjustments, then the program also checks the INVMOV file to ascertain when last an adjustment was processed. If an adjustment is processed after the No activity since date, then the warehouse is ignored.

No activity since

Indicate the cut-off date according to which stock items must be selected for generating. Stock items are selected if there has been no activity since this date.


	This option is only enabled when you select the option: Inactive stock items.

Include zero quantity on hand Select this if you want to include stock items where the warehouse quantity on hand is zero.

Include stock adjustments

Select this to indicate whether you want to include inactive stock against which adjustments have been processed.

This option is not available if you selected the option: All stock items.

Show all warehouses

Select this to list all warehouses in which the stock item resides, if at least one warehouse matches your selection criteria (i.e. warehouses that do not match the selection criteria, but in which the stock item is held, are also listed).

Do not select this option if you only want to list warehouses in which a stock item resides that matches the selection criteria.


	This option does not override your Warehouse selection (Report Filters tab). Stock items are listed only for the warehouses you indicated at the Warehouse selection option.

ABC class selection

Select this to include stock items based on the ABC classification assigned to them (Stock Codes).


	Ensure that you have run the ABC Analysis program to assign each stock item to its correct class.

Stock Options

The following table indicates the effect of selecting/deselecting the various Stock options:

Stock Options	Selection	All stock items	Any monthly activity	Inactive stock items
	Report Type	Report includes all stock items.	Report includes stock items against which any month-to-date sales or other activity has been recorded.	Report includes stock items against which no activity has been recorded since a specified cut-off date.
Include zero quantity on hand	Selected	Quantity on hand is not checked.	Quantity on hand is not checked.	Quantity on hand is not checked.
Include zero quantity on hand	Deselected	Excludes warehouses with zero quantity on hand.	Excludes warehouses with zero quantity on hand, unless some activity is recorded.	Excludes warehouses with zero quantity on hand.
Include stock adjustments	Selected	Not applicable.	Includes warehouses against which only adjustments were recorded.	Ignores adjustments.
Include stock adjustments	Deselected	Not applicable.	Ignores adjustments.	Excludes warehouses against which adjustments were recorded.
Show all warehouses	Selected	A stock item is listed in all selected warehouses if it meets the criteria in at least one warehouse.	A stock item is listed in all selected warehouses if it meets the criteria in at least one warehouse.	A stock item is listed in all selected warehouses if it meets the criteria in at least one warehouse.
Show all warehouses	Deselected	A stock item is listed only in the selected warehouse(s) in which it meets the criteria.	A stock item is listed only in the selected warehouse(s) in which it meets the criteria.	A stock item is listed only in the selected warehouse(s) in which it meets the criteria.

Report Filters

The options on this tab page enable you to indicate additional criteria according to which the report must be generated.

Selection criteria

Field	Description
Stock code selection	Indicate the stock code(s) for which to generate the report.
Warehouse selection	Indicate the warehouse(s) for which to include stock codes in the report.
Supplier selection	This enables you to include stock items for a selection of suppliers in the report. The default supplier is defined against the stock item using the Stock Codes program.
Product class selection	This enables you to include stock items for a selection of products classes in the report. The product class is defined against the stock item using the Stock Codes program. If a specific product class is entered, then only stock items belonging to that product class are included in the report.
Cycle count selection	This enables you to include stock items based on the cycle count number assigned to the stock items (Stock Codes).

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).