Warehouse

The Warehouse ID for the warehouse that the Warehouse Item is located in.

Class

The class for the Item that appears on lists and in reports.

Subclass

The Subclass for the Item that appears on lists and in reports.

Manufacturer

The manufacturer of the Item as it appears on lists and in reports.

Product

The name of the product as it appears on lists and in reports.

Part Number

The part number for the Item that appears on lists and in reports.

Bin

The bin number that shows the location in the warehouse for the Item.

Substitute Item

The substitute item for the Item that appears on lists and in reports.

Overhead Percentage

The overhead percentage for this item in the format 0.0000.

Last Cost / Price Change (date field)

The date of the last cost or price change.

Last Received

The date of the last receipt of the Item.

Last Shipped

The date of the last shipment of the Item.

User Code 1 - 3

The User Code for the Item that appears on lists and in reports.

Quantity On Hand

The quantity of the Item that is in the Warehouse.

Quantity On Reserve

The quantity of the Item that is on Reserve.

Quantity Available

The amount of the Item that is available.

Quantity On Order

The quantity of the Item that is on order.

Valuation Quantity

This field shows only when Valuation is used on for Inventory.

Average Cost

The average cost of the Item that is in the Warehouse.

Reorder Point

The unit quantity that indicates that the quantity of an item has reached a level designated for reordering. In other words, the point at which the Item should be reordered.

Economic Reorder Point

The reorder quantity (in units) that has been specified as the most economical to make for a purchase. In other words, the point at which the Item should be reordered.

Lead Time in Days

The number of days that it usually takes for the item to be received after an order has been placed. In other words, the number of days lead time that is needed to reorder the Item.

Automatically Reorder (check box)

The state of the check box indicates whether the Warehouse Item for this Warehouse will be automatically reordered by the system.

Checked - Warehouse Item will be automatically reordered.

Not checked - Warehouse Item will not be automatically reordered.

Reorder Vender ID

The Vender ID for the reorder of this item.

Reorder PropertyCompany

The PropertyCompany for the reorder of this item.

Reorder Expense

The Expense Code ID for the reorder of this item.

Reorder Quantity

The quantity for the reorder of this item.

Standard Unit Cost

The standard unit cost of the Item.

Last Unit Cost

The unit cost of the Item the last time it was ordered.

Unit Price

The amount to charge for each Inventory unit. This is the billing amount that can be used in billing. In other words, the unit price for the item.

Serialized (check box)

The state of the check box indicates whether the substitute Warehouse Item is serialized, meaning a serial number can be recorded for it. This is most commonly used on high-value goods for more precise tracking or for warranty claims.

Checked - Inventory is serialized.

Not checked - substitute Warehouse Item is not serialized.