Displaying Warehouse Locations for Products

The type for the product, such as S for stock and F for defective. To change the type, press F10 and select a type.

S - Stock. Sellable product available for shipment.
F - Defective. Defective product, not available for a normal sale. Defective quantity types have an associated sales order, purchase order, transfer order, or inventory adjustment number in the Tag ID column identifying from where the product came.
O - Over Shipment. An over shipment from the vendor. Over shipment quantity types have an associated sales order, purchase order, or transfer order number listed in the Tag ID column.
T - Tagged. The product is committed to the associated sales order, purchase order, transfer order, or inventory adjustment number listed in the Tag ID column. The system assigns a tagged type when a product is procured from another branch or vendor. You cannot manually tag an item in the system.
R - Review. The product needs reviewing or inspecting. Review quantity types have an associated sales order, purchase order, or transfer order number listed in the Tag ID column identifying from where the product came. For example, if the product has a review type, is tagged to a sales order, and shows a quantity, the product was returned.
L - Display. Sellable product reserved for display, but available for shipment if specifically requested. Display quantity types have an associated sales order, purchase order, transfer order, or adjustment number listed in the Tag ID column that identifies from where the product came. If a display type product is added to a sales order and the quantity requested exceeds the stock available, the system indicates there is also product quantity on display.
C - Consignment. Product that is a customer or vendor consignment. The Tag ID links the location type with the consignment order. If no consignment location type exists for the customer/vendor, all future transfers or shipments are recorded as a running total for the quantity on the consignment type record for that entity.

Field	Description
Control Type	How the material is tracked, for example, as a detail lot. Press F10 and select one of the following choices: 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. Detail Lot - 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.
Total On-Hand	The total number of products per unit on-hand in your warehouse.
Ser# Balance	The total number of products that are serialized and on-hand in your warehouse.
T (Type)	The type for the product, such as S for stock and F for defective. To change the type, press F10 and select a type. S - Stock. Sellable product available for shipment. F - Defective. Defective product, not available for a normal sale. Defective quantity types have an associated sales order, purchase order, transfer order, or inventory adjustment number in the Tag ID column identifying from where the product came. O - Over Shipment. An over shipment from the vendor. Over shipment quantity types have an associated sales order, purchase order, or transfer order number listed in the Tag ID column. T - Tagged. The product is committed to the associated sales order, purchase order, transfer order, or inventory adjustment number listed in the Tag ID column. The system assigns a tagged type when a product is procured from another branch or vendor. You cannot manually tag an item in the system. R - Review. The product needs reviewing or inspecting. Review quantity types have an associated sales order, purchase order, or transfer order number listed in the Tag ID column identifying from where the product came. For example, if the product has a review type, is tagged to a sales order, and shows a quantity, the product was returned. L - Display. Sellable product reserved for display, but available for shipment if specifically requested. Display quantity types have an associated sales order, purchase order, transfer order, or adjustment number listed in the Tag ID column that identifies from where the product came. If a display type product is added to a sales order and the quantity requested exceeds the stock available, the system indicates there is also product quantity on display. C - Consignment. Product that is a customer or vendor consignment. The Tag ID links the location type with the consignment order. If no consignment location type exists for the customer/vendor, all future transfers or shipments are recorded as a running total for the quantity on the consignment type record for that entity.
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.
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 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, for example, each (ea).
S (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.

Hot Key	Function
Fut Ldgr	Displays the Future Ledger screen. Use this screen to view the product's future activity, such as committed sales orders.
Hist Ldgr	Displays the History Ledger screen. Use this screen to view every transaction for the product that resulted in the current on-hand quantity.
Inv Inq	Displays the Inventory Inquiry screen. Use this screen to view up-to-the-minute product inventory data.
View Tag	Displays the purchase order, sales order, transfer order, or return to which the product is attached, if any.
Actv Log	Displays the product's activity log.
View	Displays the Views screen. Use this screen to change the Product Location Maintenance view
Serial #	Displays the Serial Number Entry screen. Use this screen to list or assign available serial numbers for the product in the location selected by your cursor in the Product Location Maintenance screen.
DetLots	Displays the Detail Lot screen. Use this screen to view the detail lots tied to the product

Displaying Warehouse Locations for Products

Display All Locations for Products in the Warehouse

To display the locations for a product:

Changing the Location Display Order

To change the location display order: