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.