English
EspañolInventory 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
| 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. |