Inventory Items

Overview

This feature references catalogue items, and contains specific information of the item in an organization, location and warehouse, such as quantity on hand, reorder point, etc.

A screenshot of the Inventory Items feature is available here<. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Inventory Items from within the menu through this navigation path: Inventories ► Support Entities ► Inventory Items

Visible Fields

The following table lists and describes all visible fields for the Inventory Items, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Application ID	Stores the unique identifier for the inventory items. This is a read only field as the value is automatically generated by the system, and is increased based on a sequence.
Item	Allows users to select catalogue item from lookup function.
Warehouse	Represents the physical warehouse where the item is stored.
Last Count Date	Last date when the item was included in an inventory item count request and when the attribute titled inventory item count request status is equal to Finished.
Is In Physical Count	This is a read only attribute and can be modified only when a physical count process has been registered. Default value for this field is false.
Lot Management Required?	System is going to copy the value from attribute titled lot management required from the catalogue item screen. Application users can modify this value.
Average Unit Cost	The average cost of the item on its standard unit of measure.
Quantity On Hand	System calculation (users cannot modify this value), updated every time there is an inventory transaction: goods received notes, incoming transfers quantities, subtracting material requests, outgoing transfers quantities, etc.
Reserved Quantity	System is going to add here the quantity of the item that are in inventory transfer process to reserve this quantity and decreases the quantity available so this quantity won't be available to be use in other transactions. System sets back to 0.00 this attribute once that the transfer is cancelled or delivered.
Available Quantity	This is a read only attribute, represent the available quantity to be use it on any process.
Reorder Point	System is going to copy the value from the attribute titled reorder point from the catalogue item screen.
Order Quantity	System is going to copy the value from the attribute titled order quantity from the catalogue item screen. Application users can modify this value.
Min Order Quantity	System is going to copy the value from attribute titled 'Min Order Quantity' from the catalogue item screen. Application users can modify this value.
Maximum On Hand	System is going to copy the value from the attribute titled maximum on hand from the catalogue item screen. Application users can modify this value.
Inventory Total Cost	System calculation, updated every time there is an inventory transaction processed through the inventory transaction screen.
Inventory Turnover	Inventory turnover details how much inventory is sold over a period of time.
Days Inventory	Number of inventory days.
Last Measuring Warehouse Indicators	Information regarding warehouse indicators.
Language	Users are allowed to select the language to register the description.
Remarks	Users are allowed to add relevant information about the item, special treatment, warranty conditions, etc.
Bar Code	Contains the code recognized by the bar code reader. Mandatory if the parameter titled bar code mandatory is set to true.
Storage Bin	Users are allowed to select the storage bin from lookup function.
Location In Warehouse	User defined attribute. It defines the physical location of the item within the warehouse (bid, rack).
Coding Block	Users are allowed to select the coding block from lookup function.
Active	Default value for this field is true. If this value is changed to false, such inventory item can't be selected again it remains for references purposes only.
Perishable Lot Tab	The system populates and updates Perishable Lots information from business transactions (GRN, adjustments) related to the inventory item only when requires lot management flag is true. Application users can see the information but cannot update it.
Inventory Item Bar Code Alias Tab	This is a collection of bar code aliases associated to a particular inventory item. This is required because the manufacturers may change this code depending on the region or country of manufacture for the same brand/model of a product.

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Inventory Items.

Button Image	Description
	The New button allows users to switch to insert mode. This action button allows users to manually create Inventory Items.
	The Search button allows users to switch to search mode.
	Find button presents a list of existing items as per the selected filter criteria. From the list users may select one record to retrieve the stored information.
	Once a record has been created or searched for, users can return to the results screen when necessary.
	Lookup button allows users to browse and select existing items. Once selected, all available information automatically populates the corresponding fields.
	The Remove button allows users to remove the selected tab.
	The Select All button allows users to highlight all the filter criteria.
	The Unselect All button allows users to unselects all previously highlighted filter criteria.
	Data Import template button allows users to generate the template file related to the
	The Import button allows users to Import file.
	The Save button allows user to save the information inputted.