Inventory Number

Internal ID: inventorynumber

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
expirationdate date Expiration Date false
externalid text false ExternalId false
inventorynumber text false Serial/Lot Number false
memo textarea false Memo false Optionally enter a memo. Later, you can search for the text you enter in this field.
status text false Status false
units select Stock Unit false

Sublists

locations -

Internal ID Type Label Required Help
location select Location false Choose a location to associate with this item. Note: If you have not enabled the Multi-Location Inventory feature, the location you select is used for role restriction purposes only. Select New to enter a new location record. Go to Lists > Locations for details about existing location records.
quantityavailable float Available false
quantityintranist float In Transit false
quantityonhand float On Hand false This field shows the quantity of this item you have on hand.
quantityonorder float On Order false This field shows the quantity of this item you currently have on order with the vendor.

Search Joins

Join ID Join Description Actual Join Name
user User Employee

Search Filters

Internal ID Type Label
expirationdate date Expiration Date
externalid select External ID
externalidstring text External ID (Text)
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
internalid select Internal ID
internalidnumber integer Internal ID (Number)
inventorynumber text Number
isonhand checkbox Is On Hand
item select Item
location select Location
memo text Memo
quantityavailable float Availabile
quantityintransit float In Transit
quantityonhand float On Hand
quantityonorder float On Order

Search Columns

Internal ID Type Label
expirationdate date Expiration Date
externalid select External ID
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
internalid select Internal ID
inventorynumber select Number
isonhand checkbox Is On Hand
item select Item
location select Location
memo text Memo
quantityavailable float Available
quantityintransit float In Transit
quantityonhand float On Hand
quantityonorder float On Order