Stock Items (SKUs)

Joined up, real-world model

If you keep any level of inventory you need joined-up visibility of both perspectives to manage your stock accurately and efficiently.
SKUs are represented as Stock Items in the system. These Stock items are joined-up models of the physical and accounting perspectives of an SKU. This is the optimal strategy for:
  • 100% accurate stock tracking
  • a high degree of process automation

Creating a new Stock Item

To create a new Stock Item go to Products/Services > Items and click 'Create New' from the Item List.

Stock Instance tracking

Only available if you are using the WMS.
You can use the warehouse management system (WMS) to model SKUs as instances. For example, Instances with a quantity of 1 can be tracked by serial number, and instances with a quantity greater than 1 can be tracked as Lots. Instances can store detail about themselves, i.e. Location, Purchased from, Sold to, Warranty, Service history, etc.
Because instances enable you to create a real-world representation of a physical SKU, you can track stock to the level of granularity you require to achieve the best possible optimization of your inventory management.
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).

Units of Measure (UOM)

The system (including the WMS) enables you to model and track the quantitative relationships between Stock Units and their counterparts, Purchase Units and Sales Units.
Stock Item>Stock Tab>Units of Measure
Configure the relationship between:
Stock Units - enter a description to be displayed on the Document Line Item table that describes to viewers the name of the quantitative unit. For example, Each, Case, Pack, etc.
Purchase Units - enter the number of Purchase units that constitute a single unit of the Item. This can be a fraction, for example, 0.3, or an integer, i.e. 12.
Sales Units - enter the number of Sales units that constitute a single unit of the Item. This can be a fraction, for example, 0.3, or an integer, i.e. 12.
The system automatically calculates the results of transactions. For example:
Stock in units of 1, Purchase in units of 5, Sell in units of 2 would mean the configuration would be
Stock Units = Each
Purchase Units = 0.2
Sales Units = 0.5

Accounting

The system’s accounting functions enable you to track the costs, sales, and value of your stock assets. The system uses the average cost method to track the cost of goods.
The system automatically keeps track of all stock ‘adjustments’ so it can dynamically calculate the stock's value. When you purchase stock, the system increases the stock value. When you sell the stock, the system automatically recalculates the value based on the unit costs.
See ‘Accounting

Customizable Instances and Item Masters

You can adapt instances to fit exactly with the business needs and go further to increase the detail and value of your insight into SKU lifecycles.
You can add custom fields and functionality to Item masters to store more data and do more with it.

Categories and Attributes

You can create and assign Categories i.e. Brand, Style, Genre, Product Line, etc, and Attributes i.e. dimension, color, capacity, volume, etc to Items.

Location

You can track the entire physical journey of every instance of stock from intake to being received by a Customer.
The Stock manager tracks the Item’s journey through the Document workflows i.e. Purchase Order > Item Receipt > Purchase Invoice, > Sales Order > Shipment > Sales Invoice > Delivery note, and even transfer between Customers. See ‘Using the Stock Manager’
The WMS (warehouse management system) tracks the physical journey i.e. Goods In > Location > Pick > Pack > Staging > Skid/Pallet.

Status and availability

You can track the quantity, status, and availability, i.e. Allocated, On Hand, Free, Quarantine, Reserved, on Back Order, on Purchase Order, etc.

Lot Tracking

From the Lot List, you can view which Purchase Orders the Lots were received from and drill down on each Lot to view which Sales Orders the Items from the Lot were sold on, and therefore which customers Lots were sold to. You can also track Lot activity on RMAs.

Preferred Supplier

You can assign multiple preferred Suppliers to an Item, together with their respective minimum order quantity, lead times, and last cost.

Actions

Action
Description
Retire
The Item will no longer appear in the lookups. Unchecks the Active box
Show WMS Stock
Show SKU qty and location
Find>On Sales Orders (Allocated)
List Documents with this Item
Find>On Sales Orders (Not Allocated)
Find>On Purchase Orders (Not Received)
Find>On Purchase Orders (Not Billed)
Actions>New Stock Adjustment
Actions>New Stock Transfer
See Stock Transfers

Stock Item Fields

Use Ctrl-F and the field name to locate and review the field and description
Tab / Section / Field
Definition
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)
This value does not affect Free or On hand stock values. It's just a pre-allocation value.
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