Inventory Analysis

This page is used for analyzing the items. The classification of the items are based on their consumption value, current value of stock in inventory, movement of the stock from inventory and their relative importance with respect to each other in the day to day operations in the location. All analyses can be performed for an item type or group type. But combination analyses can be carried out only at OU level.

Select the "Inventory Analysis" link under the "Stock Maintenance" business component.

The “Inventory Analysis” page appears.

The system displays the following:

Process ID	The identification number of the process. This number is system generated.
	Help facility available.

Select any one or two of the following in the “Analysis Type” group box:

ABC	Select the check box to indicate if the item type or item group type should be categorized under ABC analysis.
XYZ	Select the check box to indicate if the item type or item group type should be categorized under XYZ analysis.
FSN	Select the check box to indicate if the item type or item group type should be categorized under FSN analysis.
VED	Select the check box to indicate if the item type or item group type should be categorized under VED analysis.

Note: Atleast one analysis type has to be selected. A maximum of two types can be selected.

Select the required check boxes in the “Item Types” group box:

Component	These are the items procured as Bought-Out-Finished and used directly in the assembly.
Raw Material	These are basically items, which are converted into some other component, which will be used in the final assembly.
Consumable	These are the items, which will be consumed in the process of manufacturing.
Spare Part	These items are used mainly as spare parts for other major items.
Finished Product	These are the items basically manufactured by the company. These items are sold and manufactured and hence this needs to maintain both production and sales information
Intermediate	These are the items, which are in between the raw material stage and component stage (which will be used in assembly) that is, they are items, which are waiting for further processing before used in assembly.
Tool	These are the items, which will be used in production and manufacture.
Utility	These are items which aid in production / manufacture of the finished component.
Capital Item	These are basically capital items like machinery, building etc. For items of this type variants are not allowed.
Pack	These are packing materials, which will be used for packing of finished goods to the customer.
Scrap	Items of this type are treated as scrap. No planning should be done for this type of items. These items can be only sold. These items cannot be purchased. These items can be used in manufacturing.
Sundry	These items are not used regularly. Items of this type captures very important data like item description, stock UOM and Item account group. These items cannot be planned and mostly of one time use. Variants are not allowed for this item type.
Container	These are specific stockable items that are used to store other items inside them.
All	All the above items. This check box is selected by default on launch of the page.

Note: In the selection of the item types, one item type is mandatory. Any number of items can also be selected. When “All” is selected, then other item types cannot be selected. Either item type or item group type can be selected. When item type is selected, item group type cannot be selected and vice versa.

Select any one of the following in the “Item Group Type” group box:

System Defined	Select the check box to indicate if the item group type is system defined.
User Defined	Select the check box to indicate if the item group type is user defined.

Select the following in the “Analysis Options” group box:

Analysis By	Select the Date radio button if the analysis is to be done by date wise or select the Financial Period radio button if the analysis is to be done by financial period.
Level	Select the OU radio button if the analysis is to be done at OU level or select the Warehouse radio button if the analysis is to be done at Warehouse level.
Warehouse Code	The code identifying the warehouse for which the analysis is to be carried out. (Alphanumeric, 10).Mandatory when Warehouse level is selected.

The system displays the following:

Warehouse Description

The textual description of the warehouse.

Enter the following in the “Range Details” group box:

Financial Year From	Use the drop-down list box to select the financial year from which the analysis is applicable.
Financial Year To	Use the drop-down list box to select the financial year upto which the analysis is applicable.
Financial Period From	Use the drop-down list box to select the financial period from which the analysis is applicable.
Financial Period To	Use the drop-down list box to select the financial period upto which the analysis is applicable.

Note: The above fields are Mandatory when Financial Period radio button is selected in the Analysis Options.

From Date	The date from which the analysis is applicable.
To Date	The date upto which the analysis is applicable.

Note: The above fields are Mandatory when Date radio button is selected in the Analysis Options.

Item Code From	The item code from which the items are to be considered for the analysis. (Alphanumeric, 32).
Item Code To	The item code upto which the items are to be considered for the analysis. (Alphanumeric, 32).

Click the “Analyse” pushbutton to analyse and classify the items based on the analysis type selected.

When the analysis is completed, the process id is automatically generated by the system as per the numbering type defined in Numbering class component.

The items are classified based on the analysis type selected and the parameter set in ‘Set Function Parameter’ activity

The system displays the following:

Created By	The login id of the user who created the inventory analysis.
Created Date	The system date on which the inventory analysis is created

To proceed, carry out the following

Select the “View Analysis” link at the bottom of the page to view the details of analysis of the generated process id.