Overview
The Stock module shows the value and distribution of stock in warehouses and the inventory risks. Your organization’s stock_module license opens the module; without the license, the screen redirects you to the features page in Settings. With the license, a user whose role holds the stock.view permission sees the screens; for a user without the permission, the page returns not found. There are no write operations in the module; all of the screens are read-only. Roles and license are described in Chapter 1.
The data is the «Stock balance» records imported with PULS Connect. This record type goes directly into the Stock module’s own table, without a separate import step. Its fields are: Product code, Warehouse code, Quantity, Stock value (€), Product group, Material type, and Unit. Connect is described in Chapter 2.
At the top right of all stock screens there is an «as of» selector. The selector lists the snapshot dates and marks the newest one with «(latest)»; if there is only one date, it writes that date instead of the selector. The date you select is written to the address bar and the five screens show the same snapshot.
Executive summary
A summary of the selected snapshot. There are eight cards: Total stock value (with the number of SKU × warehouse positions beneath it), Distinct SKUs, Top 7 warehouse share, Class A value, Multi-warehouse value, Unattributed brand, Class B / C value, and Dead / worthless SKUs.
Positions that arrive with an empty stock value are not counted as zero: they are kept outside the total, and how many there are is written below the card.
- «Highlighted findings»: warehouse concentration, ABC concentration, unattributed brand, the exact and inferred share of brand attribution, multi-warehouse dispersion, and worthless/dead stock findings. If there are no findings, the card does not appear.
- «Largest warehouses (stock value)»: the top 8 warehouses by value.
- «ABC class distribution»: the stock value of classes A, B and C.
- «Most valuable brands»: the top 10 brands and how much of the attribution rests on inference; the full list is on the ABC & Brand screen.
If a list has no rows to show, the card says there is no data. There is no export on this screen.
Explorer
Lets you freely break down the position rows of the selected snapshot and turn them into charts. The screen’s title is «Stock explorer». The breakdown dimensions are Warehouse, Brand, Type, Group, and ABC; the measures are Value, Quantity, Unit Value, and Position. On opening, a column chart by warehouse is shown.
The strip at the top contains Total Value, Warehouse, Brand, Position, A share, and Quantity. The insights concern warehouse concentration, ABC concentration, and unclassified brands. Controls such as chart type, filter, sorting, and export are common to all Explorer screens and are described in Chapter 7.
Warehouse distribution
Shows the distribution of stock value across warehouses. The strip has Warehouse count, Top 7 warehouse share, Largest warehouse, and Top 3 warehouse value; below it is a chart of the top 10 warehouses by value. The «How was this calculated?» expandable box under the heading explains the calculation.
| Column | Meaning |
|---|---|
| Warehouse | Warehouse name or code |
| Stock value | Total value of the positions in the warehouse |
| Share | Share of total stock value |
| Position | Number of stock rows in the warehouse |
| SKU | Number of distinct materials in the warehouse |
| Quantity | Total quantity in the warehouse |
Clicking a column header sorts the table. The «Download CSV» button downloads the table as a CSV file with semicolon separators (stok-depo-dagilimi.csv).
ABC & brand
The screen’s title is «ABC & brand analysis». The strip shows the A, B, and C class value and the Unattributed brand amount. Below it are three tables: «ABC class distribution» (class, stock value, SKU, value share), the brand table (brand, stock value, material, value share, attribution), and «Material type (top 15)».
Brand attribution rests on two kinds of evidence. If the material has been sold, the brand in the sales is used and the attribution counts as «Exact». If it has never been sold, the brand inferred from the stock label is used and the attribution is an inference. If neither kind of evidence exists, the material remains unattributed. The attribution column shows, as a percentage, how much of the brand’s value is exact. Below the table, the sum of attributed and unattributed value equals the stock value. Brand resolution is the same calculation as brand management in CRM; CRM is described in Chapter 12.
The brand table is downloaded with «Download CSV» together with the exact and inferred attribution amounts (stok-marka.csv). In the material type table, clicking a header sorts only the 15 rows shown.
Risk & dead stock
Reads the inventory arrangement from three lists. The strip contains Multi-warehouse value, Valuation check (number of items), Dead / worthless SKUs, and Unclassified amount. The «Critical finding» card always shows the valuation check, and shows dead stock only if it is greater than zero.
| List | What it shows | Columns | CSV |
|---|---|---|---|
| Valuation checklist | Positions with low quantity and high unit value; may point to a value or unit-of-measure error | Material, Description, Warehouse, Quantity, Unit value, Stock value, ABC | stok-degerleme-kontrol.csv |
| Multi-warehouse distribution | SKUs found in more than one warehouse | Material, Description, Brand, Warehouse count, Warehouses, Stock value, ABC | stok-coklu-depo.csv |
| Dead / zero-value stock | Items that have a quantity but zero value | Material, Description, Brand, Quantity, Warehouses | stok-olu.csv |
The lists are cut off on the server. If the total record count is known, a line under the heading states how many of the total records are shown (the first ones), and clicking a header sorts only this window. Long descriptions are shortened; the full text appears when the pointer is placed over them. If there are no dead-stock records, the list says so.