# Stock/Inventory

***

### Inventory Valuation Report

A non-configurable report summarising the value of your held stock, broken down by Location and Store.

**Metrics**

The **Inventory Valuation Report** provides the following information:

<table><thead><tr><th width="176">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Location</strong></td><td>The physical Location of the product, e.g. Warehouse name.</td></tr><tr><td><strong>Store</strong></td><td>The specific Store where the stock is held.</td></tr><tr><td><strong>Unique SKUs</strong></td><td>The number of unique stock-keeping units available.</td></tr><tr><td><strong>Stock Level</strong></td><td>The quantity of stock on hand.</td></tr><tr><td><strong>Cost Value</strong></td><td> The total cost value of stock on hand, based on your Cost Prices.</td></tr></tbody></table>

{% hint style="info" %}
**About the Inventory Valuation Report**

The Inventory Valuation Report utilises your products’ Cost Prices to provide a basic valuation of the inventory that you hold across the business.

This report is an essential tool for assessing stock value across different Locations and Stores. It enables you to make informed decisions regarding inventory management and financial planning.
{% endhint %}

***

### Inventory Valuation Breakdown Report

This report summarises non-sold stock values for a specific Location and Store.

**Configuration**

To generate an **Inventory Valuation Breakdown Report**, you can configure the following options:

{% stepper %}
{% step %}

#### Choose a Store/Location

Select a specific Store or Location to evaluate.
{% endstep %}

{% step %}

#### Apply Filters

Apply Filters to narrow down the evaluated products. Choose from:

* **Manufacturer**: Filter by the Manufacturer of the products.
* **Season**: Choose a specific Season to analyse.
* **Product Code**: Filter by specific Product Codes.
* **Supplier**: Select the supplier associated with the stock.
* **Sales Audience**: Specify the Sales Audience for the products.
* **Departments**: Filter by Department categories.
* **Product Categories**: Choose specific Product Categories.
* **Product Tags**: Use Product Tags assigned to the inventory for additional filtering.
  {% endstep %}
  {% endstepper %}

**Metrics**

The report provides the following information:

<table><thead><tr><th width="213">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Brand</strong></td><td>The Brand associated with the stock.</td></tr><tr><td><strong>Unique SKUs Count</strong></td><td>The number of unique stock-keeping units.</td></tr><tr><td><strong>Stock Level</strong></td><td>The quantity of non-sold stock on hand.</td></tr><tr><td><strong>Cost Value</strong></td><td>The total cost value of the non-sold stock.</td></tr><tr><td><strong>Retail Value</strong></td><td>The total retail value of the non-sold stock.</td></tr><tr><td><strong>Margin (%)</strong></td><td>The percentage margin is calculated on the retail value compared to the cost value.</td></tr></tbody></table>

{% hint style="info" %}
**About the Inventory Valuation Breakdown Report**

The Inventory Valuation Breakdown Report provides insight into non-sold stock values specific to your location and store.

By offering detailed breakdowns across various dimensions, this report aids in identifying trends and managing inventory more effectively.
{% endhint %}

***

### Inventory Status Report

This non-configurable report displays information regarding the "Qualifies for Web" status of non-qualifying products, and explains why a product does not qualify.

The report can be run for one or multiple websites.

**Metrics**

The report shows the following information:

<table><thead><tr><th width="198">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product ID</strong></td><td>The unique identifier for each product.</td></tr><tr><td><strong>Product Code</strong></td><td>The specific code associated with the product.</td></tr><tr><td><strong>Qualifies for Web</strong></td><td>Indicates whether the product qualifies for web publication, including explaining why the product is disqualified.</td></tr><tr><td><strong>Is Purchaseable</strong></td><td>Indicates if the product is available for purchase, including an explanation of why the product isn't purchaseable.</td></tr><tr><td><strong>Stock Level (Primary Location)</strong></td><td>The quantity of stock available in the primary Location.</td></tr><tr><td><strong>Stock Level</strong><br><strong>(Other Locations)</strong></td><td>The quantity of stock available elsewhere.</td></tr></tbody></table>

{% hint style="info" %}
**About the Inventory Status Report**

The Inventory Status Report helps you clearly understand which products are ineligible for publishing on your website, and the reasons why.

For instance, it identifies products that may be missing images or other necessary attributes, enabling you to take corrective actions so they can be published.
{% endhint %}

***

### Stock Returned Damage Report

This report lists products that have been returned with a Return Reason listed as ‘Damaged.’

**Configuration**

You only need to choose a Date Range to generate a **Stock Returned Damaged Report**.

**Metrics**

The report shows the following information:

<table><thead><tr><th width="178">Metrics</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product Code</strong></td><td>The unique code associated with each returned product.</td></tr><tr><td><strong>Product Title</strong></td><td>The title of the product that has been returned.</td></tr><tr><td><strong>Brand</strong></td><td>The Brand of the returned product.</td></tr><tr><td><strong>No. Returned</strong></td><td>The quantity of the product returned as damaged.</td></tr><tr><td><strong>Total (exc. Tax)</strong></td><td>The total value of the returned products, excluding Tax.</td></tr></tbody></table>

{% hint style="info" %}
**About the Stock Returned Damaged Report**

The Stock Returned Damaged Report provides a straightforward snapshot of returned products because the customer listed them as Damaged.

You can then review the items and write them off or book them back for allocation.
{% endhint %}

***

### Mark Down Report

The Mark Down Report lists products on sale for a given day and Sales Channel.

**Configuration**

To generate a **Mark Down Report**, you can configure the following options:

{% stepper %}
{% step %}

#### Choose a Day

Select the specific day you want to analyse.
{% endstep %}

{% step %}

#### Apply Filters

Apply filters to narrow the report based on either Store/Location or Sales Channel.
{% endstep %}
{% endstepper %}

**Metrics**

The report shows the following information:

<table><thead><tr><th width="228">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product Code</strong></td><td>The unique identifier for each product.</td></tr><tr><td><strong>Product Title</strong></td><td>The title of the product.</td></tr><tr><td><strong>Brand</strong></td><td>The Brand associated with the product.</td></tr><tr><td><strong>Variation</strong></td><td>Details regarding any product variations (e.g., Size, Colour)</td></tr><tr><td><strong>Stock</strong></td><td>The quantity of the product available.</td></tr><tr><td><strong>Current Price (inc. Tax)</strong></td><td>The current selling price of the product, including Tax.</td></tr><tr><td><strong>Sale Price (inc. Tax)</strong></td><td>The discounted price of the product, including Tax.</td></tr></tbody></table>

{% hint style="info" %}
**About the Mark Down Report**

The Mark Down Report offers a snapshot of items currently on sale.

This information can help you catch pricing discrepancies, implement further markdowns, or generally review and manage your ongoing sales pricing.
{% endhint %}

***

### What's in the Bin Report

This report provides a breakdown of stock held within a specific Bin.

**Configuration**

To generate a **What’s in the Bin Report**, you only need to select the Bin you want to review.

**Metrics**

The report shows the following information:

| Metrics                        | Summary                                                |
| ------------------------------ | ------------------------------------------------------ |
| **Bin**                        | The specific Bin in which the stock is located.        |
| **Store**                      | The Store within which the Bin is contained.           |
| **Product**                    | The Title and Description of the product.              |
| **Master Code**                | The unique identifier for the Master product.          |
| **SKU**                        | The stock-keeping unit for each product in the Bin.    |
| **Barcode**                    | The barcode assigned to the product.                   |
| **Colour**                     | The colour variant of the product.                     |
| **Size**                       | The size variant of the product.                       |
| **Brand**                      | The Brand associated with the product.                 |
| **Product Category**           | The category to which the product belongs.             |
| **Department**                 | The department associated with the product.            |
| **Available Stock**            | The quantity of stock available in the Bin.            |
| **Allocated Stock**            | The quantity of stock allocated for Orders or tasks.   |
| **Allocated to Picking Stock** | The quantity of stock set aside for picking processes. |
| **Available Cost**             | The cost value of the available stock.                 |
| **Allocated Cost**             | The cost value of the allocated stock.                 |
| **Allocated to Picking Cost**  | The cost value of the stock allocated for Picking.     |

{% hint style="info" %}
**About the What’s in the Bin Report**

The What’s in the Bin Report provides a clear overview of what is expected to be stored in a particular storage Bin.&#x20;

You can use this report to inspect the Bin to ensure that the records match visually.
{% endhint %}

***

### Stock Take Report

The Stock Take Report is a robust and detailed report that provides a breakdown of current stock levels across all Locations in your business at the time of running the report.

**Configuration**

To generate a **Stock Take Report**, you can apply the following Filters to narrow your inventory down to the subset that you would like to evaluate:

<table><thead><tr><th width="203">Filter</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Sales Channel</strong></td><td>Select the specific Sales Channel where the products are sold, e.g. Websites, Amazon, or a physical store.</td></tr><tr><td><strong>Brand</strong></td><td>Choose the Brand associated with the products to view stock levels for specific brands.</td></tr><tr><td><strong>Department</strong></td><td>Filter by Department.</td></tr><tr><td><strong>Product Category</strong></td><td>Specify the category to which the products belong.</td></tr><tr><td><strong>Season</strong></td><td>Select the season relevant to the products.</td></tr><tr><td><strong>Sales Audience</strong></td><td>Filter by the target audience for the products.</td></tr><tr><td><strong>Condition</strong></td><td>Choose the condition of the products.</td></tr><tr><td><strong>Product Status</strong></td><td>Specify the status of the products.</td></tr><tr><td><strong>Size</strong></td><td>Filter by the size options available for the products.</td></tr><tr><td><strong>Location</strong></td><td>Select a specific Location to stock take.</td></tr><tr><td><strong>Store</strong></td><td>Select a specfiic Store to stock take.</td></tr><tr><td><strong>Bin</strong></td><td>Select a specific Bin to stock take.</td></tr><tr><td><strong>SKU</strong></td><td>Filter by stock-keeping unit.</td></tr><tr><td><strong>Supplier</strong></td><td>Choose the Supplier from whom the products were sourced.</td></tr><tr><td><strong>Product Tag</strong></td><td>Stock take tagged products.</td></tr></tbody></table>

**Metrics**

To identify individual products, the report can generate any of the following information based on your configuration:

<table><thead><tr><th width="206">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product Code</strong></td><td>The unique identifier for each product.</td></tr><tr><td><strong>Master Code</strong></td><td>The unique identifier for the master product.</td></tr><tr><td><strong>Product Title</strong></td><td>The name or description of the product.</td></tr><tr><td><strong>Barcode</strong></td><td>The Barcode assigned to the product.</td></tr><tr><td><strong>HMRC Import Code</strong></td><td>The code used for customs importation.</td></tr><tr><td><strong>HMRC Export Code</strong></td><td>The code used for customs exportation.</td></tr><tr><td><strong>Location</strong></td><td>The specific Location where the stock is held.</td></tr><tr><td><strong>Store</strong></td><td>The Store where the stock is held.</td></tr><tr><td><strong>Bin</strong></td><td>The specific Bin in which the stock is located.</td></tr><tr><td><strong>ISR Category</strong></td><td> The ISR (Inventory Stock Report) category assigned to the product.</td></tr><tr><td><strong>Product Category</strong></td><td>The category to which the product belongs.</td></tr><tr><td><strong>Department</strong></td><td> The department associated with the product.</td></tr></tbody></table>

To analyse stock levels, the report can generate any of the following information based on your configuration:

<table><thead><tr><th width="208">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Available Stock</strong></td><td>The quantity of stock currently available.</td></tr><tr><td><strong>Allocated Stock</strong></td><td>The quantity of stock that is allocated for orders or tasks.</td></tr><tr><td><strong>Counted Stock</strong></td><td>The quantity of stock counted during the stock take (this column will be empty initially).</td></tr><tr><td><strong>Available Cost</strong></td><td>The cost value of the available stock.</td></tr><tr><td><strong>Allocated Cost</strong></td><td>The cost value of the allocated stock.</td></tr></tbody></table>

{% hint style="info" %}
**About the Stock Take Report**

The Stock Take Report offers a comprehensive view of your current stock levels across all locations that you manage.

Detailed filtering and configuration help you to hone in on particular product types or individual locations and monitor stock availability/allocation.
{% endhint %}

***

### Goods In By Manufacturer/Supplier Report

The Goods In By Manufacturer/Supplier Report provides a breakdown of new stock received into the business.

**Configuration**

To generate a **Goods In By Manufacturer/Supplier Report**, you can configure the following options:

{% stepper %}
{% step %}

#### Choose a Manufacturer/Supplier

&#x20;Select whether to view the report based on a specific Manufacturer or Supplier, or all.
{% endstep %}

{% step %}

#### Choose a Date Range

To narrow down the data, apply a filter based on the date the Goods Receipt Note (GRN) was created.
{% endstep %}
{% endstepper %}

**Metrics**

The report shows the following key information:

<table><thead><tr><th width="155">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Brand</strong></td><td>The Brand associated with the stock being reported.</td></tr><tr><td><strong>Quantity</strong></td><td>The total quantity of stock booked from the selected Manufacturer or Supplier, for that Brand.</td></tr></tbody></table>

**Breakdown Report**

In addition to the main report, an accompanying **Breakdown Report** provides further information by breaking the report down into individual products. It includes:

<table><thead><tr><th width="191">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product</strong></td><td>The Product Title and Code.</td></tr><tr><td><strong>Quantity</strong></td><td>The quantity of each specific product booked in.</td></tr><tr><td><strong>Brand</strong></td><td>The Brand the product belongs to.</td></tr><tr><td><strong>Description</strong></td><td>Short and Long Product Descriptions.</td></tr><tr><td><strong>Composition</strong></td><td>The materials or ingredients used in the product.</td></tr><tr><td><strong>Care Instructions</strong></td><td>Guidelines on how to care for or maintain the product.</td></tr><tr><td><strong>Sizes</strong></td><td>The size options available for the product.</td></tr><tr><td><strong>Colours</strong></td><td>The colour options available for the product.</td></tr></tbody></table>

{% hint style="info" %}
**About the Goods In By Manufacturer/Supplier Report**

This report lets you keep tabs on recently received stock and filter that down by individual Suppliers or Manufacturers.

It is helpful for those with regular deliveries of new stock to keep tabs on the overall inventory flow into the business.
{% endhint %}

***

### Purchases Delivered

The Purchases Delivered Report provides an overview of Purchase Orders, detailing the quantities and percentages of items received compared to the total ordered.

**Configuration**

To generate a **Purchases Delivered Report**, you specify the date range for the purchase orders you want to include in the report.

**Metrics**

The report shows the following key information:

<table><thead><tr><th width="237">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Purchase Order Number</strong></td><td>The unique identifier for each Purchase Order.</td></tr><tr><td><strong>Supplier</strong></td><td>The name of the Supplier associated with the Purchase Order.</td></tr><tr><td><strong>Date Created</strong></td><td>The date when the Purchase Order was created.</td></tr><tr><td><strong>GRNs</strong></td><td>The Goods Receipt Notes related to the Purchase Order.</td></tr><tr><td><strong>Items Ordered</strong></td><td>The total quantity of items ordered in the Purchase Order.</td></tr><tr><td><strong>Cost</strong></td><td>The total cost of the items ordered.</td></tr><tr><td><strong>Items Delivered</strong></td><td>The quantity of items delivered against the Purchase Order.</td></tr><tr><td><strong>% Delivered</strong></td><td>The percentage of items delivered relative to the items ordered.</td></tr><tr><td><strong>Cost Delivered</strong></td><td>The total cost of the items that have been delivered.</td></tr><tr><td><strong>% Cost Delivered</strong></td><td>The percentage of the cost delivered relative to the total cost of the order.</td></tr></tbody></table>

**Purchased Delivered (Grouped) Report**

You can also generate a list of Purchase Orders and the quantity and percentage of items received against the total ordered, grouped by Department or Product Category.

{% hint style="info" %}
**About the Purchases Delivered Report**

This report offers valuable insights into your purchase orders by highlighting suppliers' performance in delivering ordered items. You can identify discrepancies and optimise future orders by tracking the quantity and cost delivered against what was ordered.
{% endhint %}

***

### Bestsellers Report

The Bestsellers Report provides an overview of the top-selling products within a specified Date Range.

**Configuration**

To generate a Bestsellers Report you only need to select a Date Range.

**Metrics**

The report shows the following key information:

<table><thead><tr><th width="206">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product</strong></td><td>The Product Title and Product Code.</td></tr><tr><td><strong>Colour</strong></td><td>The Colour options available for the product.</td></tr><tr><td><strong>Quantity Sold</strong></td><td>The total number of units sold during the specified date range.</td></tr><tr><td><strong>Total Sales</strong></td><td>The total revenue generated from sales of the product.</td></tr><tr><td><strong>Profit</strong></td><td>The total profit made from the sales of the product.</td></tr><tr><td><strong>Margin</strong></td><td>The profit margin percentage for the product.</td></tr><tr><td><strong>Last Purchase Date</strong></td><td>The most recent date when the product was purchased.</td></tr></tbody></table>

{% hint style="info" %}
**About the Bestsellers Report**

This report reviews sales data, including profit and margin, to identify your most successful products.

This can help you to strategise on restocking, marketing, and website optimisation to maximise sales opportunities.
{% endhint %}

***

### Outstanding Stock Adjustments Report

The Outstanding Stock Adjustments Report provides an overview of stock adjustments that require attention due to unresolved stock movements related to in-store transactions.

**Metrics**

The report shows the following key information:

<table><thead><tr><th width="213">Metric</th><th>Summary</th></tr></thead><tbody><tr><td><strong>Product SKU</strong></td><td>The specific code associated with each product.</td></tr><tr><td><strong>Product Title</strong></td><td> The name or description of the product.</td></tr><tr><td><strong>Total Adjustments</strong></td><td>The total number of outstanding stock adjustments that must be addressed.</td></tr><tr><td><strong>Variations</strong></td><td>Any product variations, e.g. Size, Style, Colour.</td></tr></tbody></table>

{% hint style="info" %}
**About the Outstanding Stock Adjustments Report**

This report highlights stock discrepancies that Venditan Commerce could not automatically reconcile, such as in-store sales not reflected in the system.

This is crucial for maintaining accurate inventory levels and ensuring stock records align with sales.

You can resolve stock discrepancies directly from the report.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.venditan.com/docs/reports-and-analytics/stock-inventory.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.