Viewing Statistics

In this page, you can specify the level at which you wish to view the statistical details for a part. You can view the stock statistics at the location level or at the warehouse level. You can also specify the financial year and the financial period for which you wish to view the stock statistics. The system retrieves the start date and end date for the corresponding financial year and the financial period.

You can view the statistical details of the part such as its opening balance, the closing balance, total receipt quantity, total issue quantity, total transfer quantity and total correction quantity with the values for a financial year & period.

Select the “View Statistics” link under the “Stock Maintenance” business component.

The “View Statistics” page appears.

Enter the following in the “Search Criteria” group box:

Statistical Level	Use the drop-down list box to select the level at which you wish to view the statistics. The system provides the following options:
	Location - Select this option if you wish to view the statistical details at the location level Warehouse - Select this option if you wish to view the statistical details at the warehouse level. By default, the system leaves the field blank.
Stock Status	Use the drop-down list box to select the status of the stock for which you wish to view the statistics. The system displays all the “Active” system defined and user-defined stock statuses that have been already defined in the “User Defined Stock Status“ business component along with the option “Consolidated”. By default, the system sets the field to “Accepted”. Leave this field blank, to view the statistical details irrespective of the stock status.
Warehouse #	Use the drop down list box to select the warehouse for which you wish to view the statistics. The system displays all the “Active” warehouses as defined in the “Storage Area Administration” business component. Leave this field blank, to view the statistical details irrespective of the warehouse.

Note: Ensure that the “Warehouse #” is entered if the "Statistical Level" is set as “Warehouse”.

Part Category	Use the drop-down list box to select the category of the part. The system displays all the quick codes for the type “Part Category” defined in the "Part Administration" business component. Leave this field blank, to view the statistical details irrespective of the part category.
Part Type	Use the drop-down list box to select the category of the part for which you wish to view the statistics. The system displays the options as "Raw Material", "Component", "Expendable", "Tool", "Consumable", "Kit", "Miscellaneous" and "Blank". Leave this field blank, to view the statistical details irrespective of the part type.
Part Group	Use the drop-down list box to select the part group. The system displays all the “Active” part groups defined in the “Part Administration” business component. Leave this field blank, to view the statistical details irrespective of the part group.
Financial Year	Use the drop-down list box to select the financial year for which the statistical details are to be viewed. The system displays all the financial years as defined in the “Accounting Setup” business component.

Note: The system displays only those financial years, which are earlier than or same as the system date.

Financial Period

Use the drop-down list box to select the financial period for which the statistical data is to be viewed.

Note: The system displays the financial period corresponding to the financial year selected in the “Financial Year” field.

The system displays the following:

Financial Year Start Date	The starting date of the selected financial year.
Financial Year End Date	The ending date of the selected financial year.
Financial Period Start Date	The starting date of the selected financial period.
Financial Period End Date	The ending date of the selected financial period.

Click the “Search” pushbutton to retrieve the details in the multiline.

The system displays the following in the “Search Results” multiline:

Part #	The number identifying the part.
Stock UOM	The unit of measurement of the stock.
Stock Status	The status of the stock. This field will be left blank, if “Consolidated” is the value selected in the Stock Status combo.
Period Opening value	The total value of the stock at the beginning of the selected financial period
Period Opening Qty	The quantity of the stock available at the beginning of the selected financial period
Receipt Quantity	The total quantity of the part received through various transactions during the specified financial year and period.
Receipt Value	The total value of the receipts corresponding to the receipt quantity.

Issued Quantity	The total quantity of the part issued during the specified financial year and period.
Issue Value	The total value of the issues corresponding to the issued quantity

Return Quantity	The total quantity of the part returned to the warehouse during the specified financial year and period
Return Value	The total value of the returned parts corresponding to the returned quantity

Adjustment Quantity	The quantity of stock that has been adjusted owing to discrepancy between physical stock and system stock.
Adjustment Value	The total value of stock corresponding to the adjustment quantity.

Transfer In Qty	The total quantity of the part that has been transferred into the location / warehouse.
Transfer In Value	The total value of the parts corresponding to the quantity transferred into the location / warehouse.
Transfer Out Qty	The total quantity of the part that has been transferred out from the location / warehouse.
Transfer Out Value	The total value of the parts corresponding to the transferred out the location / warehouse.

Period Closing Qty

The total quantity of the part available at the end of the specified financial year and period

Note: The system calculates the “Period Closing Quantity” as follows:

Period Opening Qty + Opening Balance Qty + Receipt Qty + Adjustment Qty ( positive quantity corrections) + Return Qty + Transfer In Qty - Issue Qty – Transfer Out Qty - Adjustment Qty (Negative Quantity Corrections)

Period Closing Value

The total value of the parts available at the end of the specified financial year and period

Note: The system calculates the “Period Closing Value” as follows:

Period Opening Value + Opening Balance Value + Receipt Value + Adjustment Value ( Positive value corrections) + Return Value + Transfer In Value + Revaluation Value - Issue Value – Transfer Out Value - Adjustment Value ( Negative value corrections)

Revaluation Value	The difference in value when the standard cost of the part is changed. The revaluation of the part is made only when the standard cost of the part of valuation method “Standard Cost" changes.
Part Description	The textual description of the part

Prerequisite

The execution of Daemon Executor for the financial period, for which you wish to view the statistical details. All the quantity and values displayed in this page, are retrieved from the “Deamon ( Batch Process ) run Inventory Statistics table”.