I/ Overview
To access the Stock Value Report:
1 - On the Left Menu, click on Report
2 - Go to Omni-channel Reports > Inventory Reports > Stock Value
Alternative Path: Go to Omni-channel Reports > Report Dashboard > Overview > Inventory
Reports > Stock Value
The Stock Value Report page is displayed with the default view as below:
...
This report allows you to look into details of current stock value data, by each warehouse or the
whole system, so that you can evaluate the cost of inventory vs. their potential sales.
Main metrics:
Quantity On-hand: the real quantity of a product physically presented in Warehouse(s)/
Source(s).Cost (Moving Average Cost) (also MAC): A moving average (unit) cost is an inventory
costing method wherein after each goods acquisition, the average unit cost of the item is
recomputed. This helps properly count the product quantity & compute the new selling
price.Price: The price at which the product is currently sold. It does not include tax, discount, etc.
Stock Value: The total value of the product in the warehouse (Quantity in Source x MAC)
Potential Revenue: The total potential selling value (Quantity in Source x Price)
Potential Profit: The potential revenue minus stock value.
Potential Profit Margin: The potential profit calculated in percentage.
...
The Summary Data block is displayed on top, giving you a quick overview of important statistics
in the Stock Value Report.
...
Four key metrics include:
• Total Quantity On-hand
• Stock Value
• Potential Revenue
• Potential Profit
All numbers in the Summary Data block are sum totals of their relative columns in the current
report view. If you apply any filters, the total numbers are also updated accordingly.
...
To narrow down what is shown in the analytics and the inventory list, you can use the Filter
function.
1 – Click on the [Filter] button
2 – Key in details in the following filter fields:
...
Field Name | Type | Description |
---|---|---|
SKU | Input |
|
{Custom attribute} | Input |
+ Custom attribute in Report Settings is enabled
{Custom attribute} filter is applied, look up products that have the custom attribute's value containing the search query entered |
Name | Input |
|
Category | Multi-select |
[Done] button
one of the categories selected |
{Supplier} | Dropdown select |
+ the Purchase Management module has been installed
Purchase Management > Suppliers > Manage Suppliers> View Supplier > Product)
Catalog > Products > View Product > Suppliers). If “Blank” option is selected, return the list of non-supplier products. |
Warehouse | Dropdown select |
Inventory Management > Stock Listing > Warehouses)
+ look up products that are stocked in the warehouse selected (Check in Inventory Management > Stock Listing > Warehouses > Stock On-hand or Catalog > Products > View Product > Advanced Inventory > Warehouse) |
Qty On-hand | Input |
|
Cost (Moving Average Cost) | Input |
|
Stock Value | Input |
|
Price | Input |
|
Potential Revenue | Input |
|
Potential Profit | Input |
|
Profit Margin (%) | Input |
|
3 – Click on the [Apply Filter] button
...
You also can drag & drop to change the column's position as you want to customize your own report view.
...
One of the most convenient features in of the Stock Value Report page is the ability to customize the report view and save what is frequently used. Thus, you can quickly access your favorite data in one click instead of filtering and sorting everything from scratch.
...
VII/ List of Stock Value Report Metric
Field Name | Type | Description |
---|---|---|
SKU | String | The unique identification code of each product with a global scope. Values are retrieved from SKU attribute in Catalog product |
{Custom attribute} | String | The custom product attribute that could be used as an ID number for products instead of SKU (E.g. supplier barcode, product EAN code…). Pre-conditions: The custom product attribute
Values & Column name are retrieved from {Custom attribute} attribute in Catalog product |
Name | String | The name of product. Values are retrieved from Name attribute in Catalog product |
Category | String | List all categories that a product belong to, separated by line break Values are retrieved from Category attribute in Catalog product |
{Supplier} | String | List all suppliers in the Purchase Management module that provide a product, separated by line break Pre-conditions: The 'Supplier' column is only displayed if the Purchase Management module has been installed. Values are retrieved from Suppliers data in Catalog product |
Warehouse | String | List all warehouses in the Inventory Management module that a product belong to, separated by line break Values are retrieved from Advanced Inventory >Warehouse Stocks >Stocks Listingin Catalog product |
Qty On-hand | Decimal number | Determine the quantity of a product that physically exist in:
It's the [Qty in Warehouse] in the Inventory Management module Qty On-hand (Qty in Warehouse) = Available Qty. + Qty to Ship Available Qty = Qty in Magento Catalog, which is the number of items left to sell Qty. to Ship = the number of items allocated in sales orders but not shipped yet |
Cost (Moving Average Cost) | Decimal number | Determine the unit cost of a product using the Moving Average Cost (MAC) method. A moving average (unit) cost is an inventory costing method wherein after each goods acquisition, the average unit cost of the item is recomputed. This helps properly count the product quantity & compute the new selling price. Formula:
MAC = Unit Cost defined by Magento's “Cost” attribute in Catalog product.
MAC = [Total Stock Value after Purchase] / [Total Qty. On-Hand after Purchase] In which: Total Stock Value before Purchase = [Current Qty. On-hand in All Warehouses] * [Current MAC] Alternative Use Case 1: Pre-conditions:
Formula : Total Stock Value before PO = [Current Qty On-hand in All Warehouses] * [Cost (product attribute in Catalog)] Alternative Use Case 2: Pre-conditions:
Formula: Total Stock Value before PO = [Current Qty On-hand in All Warehouses] * [Landed Cost (from PO just received & transferred items)] Total Cost of Items Received from PO = [Landed Cost] * [Qty. Received & Transferred] Landed Cost = [Purchase Cost] + [Tax] – [Discount] + [Shipping Cost] Note: Landed Cost in PO whether includes Shipping Cost, tax & discount or not depending on Inventory Costing Methods Settings Total Qty On-Hand after Purchase = Current Qty On-hand in All Warehouses + Qty. Received & Transferred from Purchase Order Items that will not be accounted in MAC include:
|
Stock Value | Decimal number | Determine the total inventory cost of a product in:
Formula: Stock Value = Qty On-hand * Cost (MAC) |
Price | Decimal number | The selling price of a product Values are retrieved from Price attribute in Catalog product |
Potential Revenue | Decimal number | Determine the total expected sales of a product if all items in:
are sold at the normal selling price. Formula: Potential Revenue = Qty On-hand * Price |
Potential Profit | Decimal number | Determine the total expected profit of a product if all items in:
sold at the normal retail price. Formula: Potential Profit = Potential Revenue - Stock Value |
Profit Margin (%) | Decimal number | Determine the expected profitability ratio of a product Profit Margin (%) = Potential Profit/ Potential Revenue *100% |