Stock Item: glossary

Notes and Field descriptions
The Stock Item, often referred to as an SKU (stock keeping unit) is a physical and individually identifiable item stored in a specific location.
Use Ctrl-F and the field name to locate and review the description

Stock Instances

If you are using the WMS (warehouse management system), stock Items are stored as ‘Instances’.
A stock 'Instance' represents the physical SKU at a particular location in your warehouse.
An Instance has a 'quantity' which allows it to represent either a single Item (quantity = 1) or multiple Items (quantity > 1) of the same type at a location. For example an Item with a serial number.
If the quantity is greater than 1 then all Items are 'identical'. For example, 32 cans of soup, all at the same location, all received from the same PO can be represented as an Instance with quantity 32. For example, a Lot. If we remove an Item from its respective Lot it becomes an instance but retains the Lot number of the original Lot.
If however, each iPad had a unique serial number this would have to be represented by 32 distinct instances with quantity 1 (each having the respective serial number assigned).
You can Import your Stock Items. Go to Setup>Import Data>Import Items

Fields:

Sales / Prices: Key Information
Item Code
A unique alphanumeric identifier
Sales Description
Matrix Parent
Select an Item (see ‘is Matrix’)
Barcode
For barcode readers. i.e. Item part # or UPC code. This will be printed on Order, pick, pack and ship documents.
Serial Number
Don’t use, check out the Warehouse Management System (WMS)
Item is Active
Is available for use on a new Document
Item is Sold
Is available for use on a Sales Document
Is Matrix
Check and save to make this ‘Matrix master
Commodity Code
Google commodity code for your respective country
Lot Number
not in use
Pricing Details
Unit Price
The base selling price
Sales Units
The sales unit of measure i.e. ‘each’ - see ‘Unit of Measure relationships’
Item Tax
The Item is taxable
Foreign Price
The default price commensurate with the customer’s default currency. I.e. if your base currency is USD and your customer pays you in CAD, then this is a fixed price for this Item in CAD.
Sales / Prices: Selling Information
Free text area
If you enter information here, and ‘i’ will appear on the Line Item when you add this Item to a Sales Document. Links and text allowed
Related website
I.e. a product page on your website
Cross/upsell information
Free text arearee
If you enter information here, and ‘i’ will appear on the Line Item when you add this Item to a Sales Document. Links and text allowed
Sales / Prices: Size and Weight
Dimension Units
i.e inches, centimetres etc
Height
Width
Length
Weight Units
i.e lbs, kg, etc
Weight
Volume Units
i.e. lb/ft³ etc
Volume
Sales / Prices: Shipping Information
Item is drop shipped
Not in use
Pack separately
Info only
Weigh before shipping
Info only
Number of units per box
Info only
Shipping instructions
Info only
Purchasing/Costs: Key Information
Item is Purchased
Item can be used on Purchase Documents
Default Order Type
Standard, Drop Shipped or Special Order?
Purchasing/Costs: Costing details
Unit Cost
The latest purchase cost as manually entered by you.
Purchase Units
See ‘Units of Measure’
Item Tax
Tax code relating to Item or Item Tax option id. (USA only) taxable or not
Foreign Cost
The default price commensurate with the Supplier’s default currency. i.e. if your base currency is USD and your Supplier invoices you in CAD, then this is a fixed price for this Item in CAD.
Purchasing/Costs: Preferred Suppliers
The information in the list is used by these automations:
On Sales Order, Create Dropship Purchase Order, Create Special Order.
On Purchase Order Generator, ‘by Item’ and ‘by Order.’
Supplier
Supplier name from Supplier List
Item Code
The Supplier’s SKU / Item code.
Description
Unit Cost
The latest cost you manually added here
Stock
The current stock level for this Item
Minimum Order Quantity
Used for information and by the Purchase Order generator.
Average Lead Time (days)
Use on Docs
Available for use on Purchase Orders
Default
The default used by the automations, e.g. Purchase Order Generators
Purchasing/Costs: Purchasing Information
Free text area
If you enter information here, and ‘i’ will appear on the Line Item when you add this Item to a Purchasing Document. Links and text allowed
Related Website
i.e the Supplier's product page
Purchasing/Costs: Reorder Levels/Site MOQ
Site
Re-Order Level
For the corresponding site - Used by the Purchase Order Generator by Item
Minimum Order Quantity
For the corresponding site - Used by the Purchase Order Generator by Item / Order
Purchasing/Costs: Size and Weight
Dimension Units
i.e inches, centimeters etc
Height
Width
Length
Weight Units
i.e lbs, kg etc
Weight
Volume Units
i.e. lb/ft³ etc
Volume
Purchasing/Costs: Delivery Information
Free text area
Text and Links allowed.
Stock: Current status and availability
On Hand
The total quantity you currently have in your warehouse, regardless of whether it is available for use or sale. It includes unallocated as well as allocated stock. You can allocate stock for: Assembly or disassembly.
Initial Valuation
The opening balance in the Stock Asset account for this Item. Only visible on the initial creation of the Item when the WMS is not installed.
On Sales Orders (Allocated)
The quantity of this Item allocated to Sales Orders.
Free Stock
Available for allocation i.e. on hand stock minus allocated stock
On WMS Kits
The quantity of Items assigned to Kits. Appears when WMS is installed.
Quarantined
Quantity of Items in stock, but not available for allocation or assignment. Appears when WMS is installed.
Average Cost
The average value of a stock over an accounting period.
On Sales Orders (Not Allocated)
Shortfall
The qty required to fulfill open orders.
On Purchase Orders
The qty of this Item on Purchase Orders with a Document Status of ‘Open’ or Partially Received.
Stock: Stock Status by site
Site by site view of the current status and availability of this Item.
Stock: Units of measure relationships
See ‘Units of Measure
Stock Units
i.e. Each, Case etc
1 Purchase Unit =
i.e. 10
I Sales Unit =
i.e 1
Permit fractional Stock Units (WMSI)
Express the above as floating point numbers e.g. 1.30
Stock: Multi-packs
See ‘Multipacks’ . Appears when WMS is installed
Multipack name (WMSI)
Enter a descriptive name i.e. Six pack. Appears when WMS is installed
Barcode (WMSI)
The barcode for the ‘six pack’. Appears when WMS is installed
Stock Units (WMSI)
The quantity of SKUs in the pack e.g. 6. Appears when WMS is installed
Stock: Stock take information
Location
Info only
Last Stock Take
Info only
Units counted
Info only
Stock Locations by Site
Classifications: Categories
Category
A top-level key i.e. Manufacturer
Classifications: Attributes
Name
I.e. the product color
Value
I.e. red, amber, green
Auto description
Used by Matrix Items
Classifications: Class
Item Class
Classification for the item when it is put on the Line item, and used in the general ledger.
Images
Image 1 thro 4
A placeholder for an uploaded image. Image size: email [email protected] IMages appear in the TAP.
Accounting
Income
where the income is posted on the general ledger (profit & loss)
Cost Of Goods Sold (COGS)
where the cost is posted on the general ledger (profit & loss)
Stock Asset
Where the asset value is posted on general ledger (balance sheet)
Ecommerce
Customer Portal
Available in Portal Cart
Will display this Item in the TAP (Trade Acceleration Portal)
Shopping Cart Information
Cart Mapping
The cart it’s used on
Utility Fields
Price Impact
Contact support.

Actions