Navigation:  Inventory Management > Inventory Analysis >

Inventory Criteria

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Allocate Stock

When yes is selected all inventory allocated will be displayed while if no is selected al the un-allocated inventory will be displayed. The result is however also subject to other selections and filters.

hmtoggle_plus1Buyer

Selecting a buyer will filter the stock to only stock belonging to the selected buyer. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Commodity Code

Selecting a commodity code will filter the stock to only stock belonging to the selected commodity code. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Contract

Selecting a Contract will filter the stock to only stock belonging to project linked to the selected Contract. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Control Defence Items

When Yes is selected inventory in stores where the setting on Part Master which classifies the item as a Control Defense item is checked will be selected while if No is selected, all inventory in stores where the setting on Part Master which classifies the item as a Control Defense item is un-checked will be selected. Selecting Yes and No will result that inventory regardless of the Part Master setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Dangerous Goods

When Yes is selected inventory in stores where the setting on Part Master which classifies the item as a Dangerous Goods Regulation item is checked will be selected while if No is selected, all inventory in stores where the setting on Part Master which classifies the item as a Dangerous Goods Regulation item is un-checked will be selected. Selecting Yes and No will result that inventory regardless of the Part Master setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Designer

Selecting a designer will filter the stock to only stock belonging to the selected designer. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Dev Life Cycle

Selecting a Development Life Cycle will filter the stock to only stock belonging to the selected Development Life Cycle. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Division

Selecting a Division will filter the stock to only stock belonging to the selected Division. The other settings and filters also apply and can influence the result.

hmtoggle_plus1External Organisation

When Yes is selected inventory where the External Organisation column on the location master is not equal to spaces will be selected while if No is selected, all inventory where the External Organisation columns is equal to spaces will be selected. Selecting Yes and No will result that inventory regardless of External Organisation will be selected. The result is however also subject to other selections and filters.  Selecting an external organisation will filter the stock to only stock belonging to the selected organisation. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Financial Year

A Financial year has to be selected when any the part financial year data columns is selected.

hmtoggle_plus1Hazard Classification

Selecting a Hazard Classification will filter the stock to only stock belonging to the selected Hazard Classification. The other settings and filters also apply and can influence the result.

hmtoggle_plus1In Transit Stock

When Yes is selected inventory in stores where the Store on the location Master  is indicated as In Transit Stores will be selected while if No is selected, all inventory in stores where the Store on the location Master  is not indicated as In Transit Stores will be selected. Selecting Yes and No will result that inventory regardless of the stores setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Limited Shelf Life

When Yes is selected inventory in stores where the setting on Part Master for Limited Shelf Life is checked will be selected while if No is selected, all inventory in stores where the setting on Part Master which does not classify the item as having Limited Shelf Life will be selected. Selecting Yes and No will result that inventory regardless of the Part Master setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Load Criteria Set

Load Criteria sets will set the screen settings to the settings saved on a pre saved and selected report set.

hmtoggle_plus1Lot Controlled Parts

When Yes is selected inventory in stores where the setting on Part Master which classifies the item as Lot Controlled  will be selected while if No is selected, all inventory in stores where the setting on Part Master which does not classify the item as Lot Controlled will be selected. Selecting Yes and No will result that inventory regardless of the Part Master setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Negative Stock

When Yes is selected inventory in stores where the Quantity On Hand on the location Master  is Less than zero will be selected while if No is selected, all inventory in stores where the Quantity On Hand on the location Master  is more than zero will be selected. Selecting Yes and No will result that inventory regardless of the quantity on hand will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Node Stock

When Yes is selected inventory where the Node column on the location master is not equal to spaces will be selected while if No is selected, all inventory where the Node columns is equal to spaces will be selected. Selecting Yes and No will result that inventory regardless of Node will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1No Consumption Since

When selected inventory in stores without any consumption movements since the selected date which consist of movements from Stores to Order Requirements or from Stores to Requisitions or From Stores to Customer will be selected while if not selected it will result that inventory regardless of the existence of consumption will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Part Number

Selecting only a part number will filter the stock to only stock belonging to the selected part number. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Parts with a Description Like

Selecting a portion of the description will filter the stock to only stock with descriptions like the selected portion of the description. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Planner

Selecting a planner will filter the stock to only stock belonging to the selected planner. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Preferred Supplier

Selecting a preferred supplier will filter the stock to only stock belonging to the selected preferred supplier. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Product Code

Selecting a product code will filter the stock to only stock belonging to the selected product code. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Product Group

Selecting a Product Group will filter the stock to only stock belonging to products within the selected Product Group. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Project

Selecting a project will filter the stock to only stock belonging to the selected projectThe other settings and filters also apply and can influence the result.

hmtoggle_plus1Project Serial Number

Selecting a project serial number only stock which covers the selected project serial number in its range will be displayed.

hmtoggle_plus1Project Stock

When Yes is selected inventory where the project column on the location master is not equal to spaces will be selected while if No is selected, all inventory where the project columns is equal to spaces will be selected. Selecting Yes and No will result that inventory regardless of Project will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Quality Controller

Selecting a quality Controller will filter the stock to only stock belonging to the selected quality Controller. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Quarintine Stock

When Yes is selected inventory where the Quarantine quantity column on the location master is not equal to zero will be selected while if No is selected, all inventory where the Quarantine columns is equal to zero will be selected. Selecting Yes and No will result that inventory regardless of Quarantine will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Serialised Parts

When Yes is selected inventory in stores where the setting on Part Master which classifies the item as a Serialised Always or Serialised record Later  will be selected while if No is selected, all inventory in stores where the setting on Part Master which classifies the item as neither Serialised Always or Serialised record Later will be selected. Selecting Yes and No will result that inventory regardless of the Part Master setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Shelf Life Date

Selecting a Shelf Life Date will filter the stock to only stock where the shelf life expiry date is less than the selected date. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Source Code

Selecting a Source Code will filter the stock to only stock belonging to the selected Source Code. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Stock Balance Sheet items

Items shown in this list will be excluded in the following fashion. If Both the settings Yes and No is checked, all inventory in inventory will be taken into consideration for display subjects to any other filters deployed. If only Yes is checked the selection of inventory will be limited to items with a Fixed account setting of Yes on the Part Master and Inventory with Stock Statuses of New or Used, and where the Stock of external Organisation equal to Spaces (Stock not belonging to an external Organisation)

If only the No check box is selected Inventory with a part master setting for Fixed account equal to No or where the stock status is Repaired or Waiting Repair or where the stock has an External Organisation not equal to Spaces  will be displayed.  The user must however note that the inventory displayed or the value calculated will be subject to all the other settings or filters applied for the selection.

hmtoggle_plus1Stock in Non-Mrp Stores

When Yes is selected inventory in stores where the Store on the location Master  is indicated as Not Used by Mrp will be selected while if No is selected, all inventory in stores where the Store on the location Master  is indicated as Use by Mrp will be selected. Selecting Yes and No will result that inventory regardless of the stores setting will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Stock Status

Selecting a Stock Status will filter the stock to only stock belonging to the selected Stock Status. The other settings and filters also apply and can influence the result.

hmtoggle_plus1Stock Without Demand

When Yes is selected inventory in stores without any demand consisting of Open Requirements or Open released or in process Stores issue requisitions or Un-Consumed Firm Sales Forecasts or Safety stock will be selected while if No is selected, all inventory in stores where the above does not apply will be selected. Selecting Yes and No will result that inventory regardless of the existence of demand will be selected. The result is however also subject to other selections and filters.

hmtoggle_plus1Store

Store can only be selected in conjunction with a Division. This will limit stock displayed to stock in the selected Division and store.

hmtoggle_plus1Un Id Number

Selecting a Un Id Number will filter the stock to only stock belonging to the selected Un Id Number. The other settings and filters also apply and can influence the result.