View Statistics

This page allows you to choose to specify the level at which you wish to view the statistical details. You can view the stock statistics at the stocking point level or warehouse level. You can also specify whether you wish to view the statistics for a given financial year or financial period. The system retrieves the start date and end date for the corresponding financial year/period.

You need to specify the item code and variant code to inquire the stock statistics. You also need to specify the warehouse code if the stock statistics inquiry is made at the warehouse level. The system displays the issue, receipt, return, adjustment, stock transfer in, stock transfer out, period opening and period closing quantities in stock UOM. The system also displays their corresponding stock values. You can also view the revaluation cost of stock if there is a change in the standard cost of the item.

Select the " View Statistics" link under the "Stock Maintenance " business component

The “View Statistics” page appears.

Enter the following fields:

Statistics Level	Use the drop-down list box to specify the level at which you wish to inquire the stock statistics. The system displays the options, “Stocking Point”, “Warehouse” and “Blank”. You can specify whether you wish to view the statistics for a stocking point or a particular warehouse in an OU. The system sets this field blank by default.
Warehouse Code	A unique code identifying the warehouse (Alphanumeric, 10). This field is mandatory if you wish to view the statistics at warehouse level.
	Press <Enter> Key
	Help facility available.

The system displays the following:

Warehouse Desc.	A textual description of the warehouse.
	Zoom facility available

Enter the following:

Financial Year

Use the drop-down list box to specify the financial year for which you wish to view stock statistics. All the financial years defined in the “Accounting setup” component that are on or before the current system date and that are mapped to the login OU’s Company will be displayed here in ascending order. The system lists only the financial years for which statistics has been updated previously. The system displays the first value by default.

The system displays the following:

Financial Year Start Date	The date on which the financial year commences. The system displays the start date for the corresponding financial year
Financial Year End Date	The date on which the financial year concludes. The system displays the end date for the corresponding financial year.

Enter the following:

View Statistics For	Use the drop-down list box to specify whether you wish to view the statistics for a financial year/period. The system displays the options, “Fin. Year” and “Fin. Period”.
Financial Period	Use the drop-down list box to select the financial period for which you wish to calculate the closing quantity and value. All the financial periods defined for the selected financial year will be displayed here in ascending order. The system lists only the financial periods, which are in closed status for which statistics have been previously updated. The system displays the first value by default.
Financial Period From	The date on which the financial period commences. (Date Format)The system displays the start date for the corresponding financial period.
Financial Period To	The date on which the financial period closes.(Date Format) The system displays the closure date for the corresponding financial period.
Item Code	A unique code identifying the item (Alphanumeric, 32). Mandatory.
	Help facility available.
Variant Code	Variant code of the item (Alphanumeric, 8). .
	Help facility available
Item Variant Desc.	A textual description of the item/variant.(Alphanumeric, 150)
	Zoom facility available
Stock UOM	The unit of measurement of the item stocked in the warehouse.(Alphanumeric, 15)

The system displays the following in the “Item Statistics” multiline:

Period Opening Qty.	The quantity of stock at the beginning of the selected financial year / period.
Period Opening Value	The value of the stock at the beginning of the selected financial year/period.
Opening Balance Qty	The quantity of stock moved into the warehouse during the financial period. The system retrieves the receipt quantity from the “Stock Maintenance” component. The system checks the transaction date of the Opening balance transactions, to determine the period in which the receipt transaction took place.
Opening Balance Value	The value or cost of stock corresponding to the opening balance quantity. The system retrieves this value from the “Stock Maintenance” component for the selected financial year/period.
Receipt Qty.	The quantity of stock received into the warehouse during that financial period. The system retrieves the receipt quantity from the “Stock Receipt” component. The system checks the transaction date of the stock receipt transactions to determine the period in which the receipt transaction took place
Receipt Value	The value or cost of stock corresponding to the receipt quantity. The system retrieves this value from the “Stock Receipt” component for the selected financial year/period.
Issue Qty.	The quantity of stock issued from the warehouse to the various consumption points during that financial period. The system retrieves the receipt quantity from the “Stock Issue” component. The system checks the transaction date of the stock receipt transactions to determine the period in which the stock issue transaction took place.
Issue Value	The value or cost of stock corresponding to the issue quantity. The system retrieves this value from the “Stock Issue” component for the selected financial year/period.
Return Qty.	The quantity of stock returned to the warehouse during that financial period. The system retrieves the return quantity from the “Stock Return” component. The system checks the transaction date of the stock return transactions to determine the period in which the stock return transaction took place.
Return Value	The value or cost of stock corresponding to the returned quantity. The system retrieves this value from the “Stock Return” component for the selected financial year/period.
Adjustment Qty.	The quantity of stock to be adjusted owing to discrepancy between physical stock and system stock. . The system retrieves this quantity from the “Stock Adjustment” component. The system checks the transaction date of the stock adjustment transactions to determine the period in which the stock adjustment transaction took place.
Adjustment Value	The value or cost of stock corresponding to the adjustment quantity. The system retrieves this value from the “Stock Adjustment” component for the selected financial year/period.
Revaluation Value	The difference in value when the item’s std cost is changed The revaluation of the item is made only when the standard cost of the item changes. The system retrieves this value from stock adjustment component.
Transfer In Qty.	The quantity of stock moved into the warehouse from another warehouse. The system retrieves the quantity moved into the warehouse from the “Stock Maintenance” component. The system checks the stock transfer transaction date to determine the period in which the transaction took place.
Transfer In Value	The value or cost of stock corresponding to the quantity moved into the warehouse from another warehouse. The system retrieves this value from the “Stock Maintenance” component for the selected financial year/period.
Transfer Out Qty.	The quantity of stock transferred out to another warehouse from this warehouse. The system retrieves the quantity moved from the warehouse from the “Stock Maintenance” component. The system checks stock transfer transaction date to determine the period in which the transaction took place.
Transfer Out Value	The value or cost of stock corresponding to the quantity moved from the warehouse. The system retrieves this value from the “Stock Maintenance” component for the selected financial year/period.
Period Closing Qty.	The quantity of stock at the end of the selected financial period. This is calculated as Period Opening Qty. + Opening balance qty+ Receipt Qty. + Return Qty. + Adjustment Qty. + Stock Transfer In Qty. - Issue Qty. – Stock Transfer Out Qty.
Period Closing Value	The value of stock at the end of the selected financial period. This value is calculated as follows: Period Opening Value + Opening balance value + Receipt Value + Return Value + Adjustment Value + Revaluation value + Transfer In Value - Issue Value - Transfer Out Value.