Field
Description
Control Type
How the material is tracked, for example, as a detail lot. Select one of the following options:
-
None - All products are interchangeable and require no individual identification or inspection.
-
Lot - The product is tracked individually or by group, such as a spool of wire or a group of tile from a particular dye batch. When receiving the product, record a lot number so when the product ships, you can identify it with that lot number. Lots can have any quantity from zero. Products with no on-hand amounts do not require lot numbers for a location without inventory. Common lot control products are items such as wire that you cut from a spool and tile that requires color matching.
-
DetailLot - The product is set up as a detail lot, which allows you to closely monitor manufacturing quality of selected inventory at the lot level. Along with manufacturing information, Detail Lot Maintenance allows you to track the original cost of a product, value of any enhancements, and the current appraised value.
Type
The type for the product, such as S for stock and F for defective. 
Select a type.
Location
The product's location in your warehouse. Location codes identify the physical location in your warehouse where you store the product. For example, your location codes may be XX-XX-XX-XX for a four dimensional locator for zone, row, section, and shelf location, or a description such as South Yard.
Lot/Serial#
The lot ID for the products in this warehouse location, if the product is lot controlled. Lot controlled products have a control type of Lot in the Control Type area.
If the product requires serial numbers, the serial number of the products in this location. Select Serial Queue from the Inquiry menu to set the serial numbers for the product.
Note: The system limits this field display to 15 characters.
Note: You can assign lot numbers automatically, if your increment your lot numbers sequentially.
Tag ID
The sales order, purchase order, transfer order, or adjustment number for types other than Stock. The tag ID only displays when stock in the location is associated with an order. If the location holds vendor consignment inventory, the vendor name displays in the this field.
On-Hand
The on-hand quantity of the product at the matching location.
Any change to a quantity assigned to a location results in a posting to Inventory Adjustments noted with a Locations Adjustment comment, regardless of whether the overall on-hand quantity changed.
UM
The unit of measure for the product quantity, such as each (ea) or box (bx).
Location Status
The location status for the product:
-
Primary - First location to stock the product.
-
Secondary - Backup location when the primary location is full.
-
Floating - Temporarily assigned location that is used only until supply in that location reaches zero quantity.
-
Remnant - Location for material that contains less than the original amount. For example, half a spool of wire. For more information about remnants, see Assigning Products a Remnant Location Status.
-
In Process - Processing location that cannot be changed.
-
Blank Status - System-assigned location. If a location is not assigned a status, the system deletes the location when the on-hand quantity in that location reaches zero, if the
Last Count
The date the product was last counted in the warehouse.
Pick Status
Notes for the pick status. This is a free form field.