Overview
Inventory Item by Location provides a view of the locations where inventory is held. In addition to Stock Location ID and Stock Location Number, each Inventory record identifies several of the item’s attributes; Item Number, Site, Lot or Serial Numbers, Quantity, etc. If an Item resides in multiple locations, the list view will display the item multiple times.
Application
This function is used to view the inventory locations in which the item has or had on-hand inventory.
Navigation
Inventory Item by Location
Fields (Maintainable)
In edit mode, updates can be made to the following fields:
Backflush Indicator: Indicates whether this item in this location can be backflushed.
Vendor Location Indicator: Indicates whether this item in this location is a vendor location.
Available for Picking Ind: Indicates whether this item in this location is available for picking.
Replenishment Trigger Qty: Dictates the color code indicated in the Replenishment Status field. When the quantity of this item in this location falls below the number entered here, the Status will change to Red. Otherwise, it remains green.
Comments: Comments entered by the user in the Location Comments field when performing transactions that put this item into this Inventory Location.
Inventory Container: The Inventory Container associated with this Inventory by Location record.
Fields (Not Maintainable)
Division: Identifies the Division in which this inventory exists.
Site: The site within the Division.
Item Number: The identifier of the item.
Lot Expiration Date: The date on which the lot in this location will expire. This date comes from the Item By Lot record where it is entered by the user on a Purchase Order or Work Order receipt, otherwise, it is set to the date the Lot record was added plus the Shelf Life on the Inventory Item Master.
Last Issue Date: The date of the last issue from inventory.
Replenishment Status: When inventory in this location goes below the Replenishment Trigger Qty, the status changes to Red. Otherwise, it is Green.
Tracking Indicator: Values are Serial Number for serial controlled items, Lot Number for lot controlled items. Items that are serial and lot controlled will display the serial number. Item not Serial or Lot Controlled will be blank.
Item Description: The description of the item is displayed in parenthesis to the right of the Item Number.
Project: The project for which the item is in inventory. Projects in the Division must be active to specify anything other than the Home Project.
Quantity: Quantity in this location.
Loc Type: Values are "O" = on hand; "C" = Consigned; "N"=Non Nettable.
Location ID: The Location ID associated with the given location record.
Location Number: The Location Number associated with the given location record.
Lot/Serial Number: If the item is Lot and Serial controlled, contains the serial number. If Lot Controlled only it contains the Lot number.
Lot Issue Expiration Date: Date this lot expires. It is the Lot Expiration Date minus the Lot Issue Expiration Issue Lead Time. Applicable when a Lot expiration date has been set.
Lot On Hold: When checked, this lot is blocked from being issued.
IMPORTANT The 'Allow Change to Serialized Inventory Loc' indicator on the System Configuration record controls the Inventory Location ID and Stock Location Number updates on the Inventory by Serial Number record. If it is checked, the Inventory Location ID and Stock Location Number can be changed without generating an Inventory Cost Transaction record. The Inventory Location ID on the Inventory by Serial Number record can be changed only when Inventory Location Type and Site are the same for the new and old Inventory Location IDs. When the Inventory Location ID on the Inventory by Serial Number record is changed, the following fields on the Inventory by Location record will be updated from the new Inventory Location ID record:
- Backflush Indicator
- Available for Picking Ind
- Issue Sequence for Backflush
- Receiving Inspection Indicator
- Vendor Location Indicator
SEE ALSO
Inventory Location IDs
Inventory Location Numbers
Inventory Location Adjust
Inventory Cost Transactions
Inventory by Serial Number
Inventory Item by Lot Number
Inventory Item Master Lead Times tab
Expiration Behavior for Lot Controlled Items
