Stock Items

The Stock Items dataset lists stock items with their costs, stock levels and stock settings.

At a glance

Item Value
Picker heading Data Tables
One row is One stock item
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area
Default presentation Table
Default period None. This dataset has no Period.
Date basis None
Default columns Material Number, Description, Measurement Unit, Currency, Unit Cost, Stock Take Enabled, Serialised, Consignment
Group Modes Detail tables. Charts are Consolidated.
Drill-through Column Chart only

Measures

Measure Unit Aggregation Definition
Stock item count Stock items Count Number of stock items.

Columns

Column Type Description
ID Number The stock item's internal ID.
Material Number, Description Text The stock item.
Measurement Unit, Currency Text Its unit and currency.
Unit Cost, Last Cost Number The current cost and the last cost.
Reorder Point, Stock Min, Stock Max Number The stock level settings.
Cycle Count Freq Number How often the item is counted.
QR Code, Barcode Text The item's scan codes.
Default Location Code Text Its default location.
Stock Take Enabled, Serialised, Consignment Yes/No The item's stock settings.
Consignment Supplier Text The consignment supplier.

Filters

Filter Choice Behaviour
Measurement Unit, Currency Multiple The item's unit and currency.
Consignment Supplier Multiple The consignment supplier.
Serialised, Consignment, Stock Take Enabled All, Yes, No Limits to items with or without the setting.

Group By

Group By Groups by
By Measurement Unit, By Currency The item's unit and currency.
By Consignment Supplier The consignment supplier.
By Serialised, By Consignment, By Stock Take Enabled Yes or No.

Records with no value appear under Unknown.

Chart notes

  • Line and Area charts draw one point per group, because this dataset has no time periods.
  • Charts count stock items. They do not plot costs or stock levels.
  • Series by, Compare and Compare with are not available.

Business rules

  • There is no Period. The dataset shows stock items as they stand now.
  • Dashboard filters do not apply. Stock items are not linked to Assets, so Asset-based Dashboard filters do not narrow this widget.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.