Inventory Counting Recommendation Dashboard 
The Inventory Counting Recommendation dashboard enables managers to have a comprehensive view of the current status of the company warehouses as regards inventory counting execution. It analyzes the values of warehouses, and recommends the start of inventory counting process in certain warehouses according to user-defined rules.
The dashboard comprises the following two reports:
Warehouse Valuation Report
Inventory Counting Risk Assessment Report
In addition, a section in the lower left part of the dashboard displays last count date, last counted warehouse, and the days since last count.
Note
The Last Count Date field displays the count date that appears in the latest inventory counting document or inventory posting document that is not based on an inventory counting document. The same logic applies to the Last Counted Warehouse field and the Days Since Last Count field.
Warehouse Valuation
This report appears in the upper part of the dashboard. It presents the warehouses’ value according to the items’ value, which is calculated by the selected price source or according to the items’ quantities.
The bar chart displays only the top 10 warehouses with the highest total value or total quantity.
Field and Chart Series |
Description |
|---|---|
Source Price List for Item Value |
Select a source price for the calculation of the items’ value from the dropdown list. This field is disabled when you choose to valuate warehouses by quantity. |
Warehouse Valuation by |
Choose to valuate warehouses by Item Value or Quantity. |
Relative Count Date |
Specify a date. The report takes into account only the items in inventory counting documents (or inventory posting documents that are not based on inventory counting documents) with the count date of the one you specify and onwards. By default, this field displays the beginning date of the fiscal year. Note that you cannot enter a future date. |
Currency |
Displays the local currency in the upper right corner of the dashboard. |
Counted Value/Quantity |
The total value or quantity of items in the warehouse which were counted since the Relative Count Date. |
Uncounted Value/Quantity |
The total value or quantity of items in the warehouse that were not counted since the Relative Count Date. |
Total Value/Quantity |
Total Value/Quantity = Counted Value/Quantity + Uncounted Value/Quantity Value = Quantity × Price ( from selected price source) |
Note
If an item in a specific warehouse was counted even if only in one bin of the warehouse, SAP Business One considers the item as counted.
SAP Business One considers a negative quantity as zero quantity in this dashboard.
Inventory Counting Risk Assessment
This report appears in the lower right part of the dashboard, and displays the assessment of inventory counting risk by warehouse. It comprises the following three parts:
Pie Chart
It shows the proportions of warehouses with high risk, medium risk, and low risk, respectively.
Warehouse Risk Rank
When you click different risks in the pie chart, you see the top 6 warehouses at the corresponding risk level. By default, warehouses with high risk are displayed.
Detailed Risk Assessment Report
When you click the Details link in the Reference field under the pie chart, a detailed report appears to show you the risk assessment per item per warehouse. This detailed report presents all warehouses at the corresponding risk level and all items in these warehouses, except the items that are linked to these warehouses but have never been used in any transactions involving these warehouses.
In this report, you can select item rows and press the Inventory Counting button to initiate an inventory counting process for them.
The following chart illustrates how the report calculates the risk level of a certain warehouse based on the risk levels of the items in it. The KPIs and related values given in the following chart are only default ones. You can change them to suit your own situation.
Each KPI has two values, value 1 and value 2 (value1 < value 2), and the system calculates the risk level of an item based on rules involving these values.
Risk Level |
KPI |
Rule |
|---|---|---|
Item Risk Level |
Days Since Last Inventory Count: The more time that passes since last inventory counting, the higher the risk is. If the item is new and has never been counted before, the creation date of the item is used as the last count date. Transaction Volume: The larger the transaction volume (since last inventory count), the higher is the priority for inventory counting, and therefore, the higher the risk. The transaction volume is calculated according to the inventory turnover. One transaction with a large quantity is also considered as a high-risk case. Item Value: The higher the cost of the item, the higher is the priority for inventory counting, and therefore, the higher the risk. |
Low Risk Item: The values of all KPIs are below value 1. Medium Risk Item: The value of the first KPI (Days Since Last Inventory Count) is between value 1 and value 2, or the value of the first KPI is above value 2, but the values of the other two KPIs are below value 2. High Risk Item: The value of the first KPI (Days Since Last Inventory Count) is above value 2, and the value of at least 1 more KPI (second or third) is above value 2. |
Warehouse Risk Level |
Percentage of Items at High Risk: The percentage of items that belong to the “High Risk Item” category according to the KPIs and values that you define at the item level. |
Low Risk Warehouse: The percentage of items at high risk in this warehouse is below 25% (value1). Medium Risk Warehouse: Includes all the cases which do not fit the low risk warehouse and the high risk warehouse categories. High Risk Warehouse: The percentage of items at high risk in this warehouse is above 75% (value2). |