> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-closing-stock-report-with-multiple-units-of-measure.md).

# Generate Closing Stock Report with Multiple Units of Measure

**YouTube:** [How to view Closing Stock Report with multiple units of measure?](https://youtu.be/PNzeZaLiZ94)

## How to view Closing Stock Report with Multiple Units of Measure?

In this tutorial, we’ll learn how to configure the **Stock Report** based on various conversion factors, such as strips and tablets, and how to display stock quantities in multiple units.

***

### **Open and Create a New Configuration**

* Navigate to the **Reports & Queries** section.
* Under **Stock Reports** open the **Stock Query Report**.
* Click on **Configuration** to create a new report setup.
* Assign a **suitable configuration name** for identification.

<figure><img src="/files/7K4QQT1CtvSnXmKidbXv" alt=""><figcaption></figcaption></figure>

***

### **Select Required Columns**

* Under **Print Options**, click on **Print Columns** to view the available list.
* Select the checkboxes for the following key columns:
  * **Item Name**
  * **Pack Name**
  * **CF 1**
  * **CF 2**
  * **Closing Stock 1**
  * **Closing Stock 2**
* Press the **Space Key** to rename columns (as shown in the tutorial).
* Use the **Arrow Keys** to rearrange the column order, if required.

<figure><img src="/files/3zhqmOeVTsM6zQbGamGv" alt=""><figcaption></figcaption></figure>

* Once done, **save the changes**.

***

### **Define Totals**

* Navigate to the **Totals** section.
* Choose how totals should be displayed in the report (e.g., group-wise or overall total).

<figure><img src="/files/SwB4ZyF1was0QS5GVF0r" alt=""><figcaption></figcaption></figure>

***

### **Configure Conversion Factor (CF) Options**

* Go to the **CF Options** section.
* Under **Opening CF Options**, set:
  * **CF 1** → *Item CF 1* (for example, strips)
  * **CF 2** → *Item CF 2* (for example, tablets)

<figure><img src="/files/9Z2EN9ikzdDUhJA9g5Mn" alt=""><figcaption></figcaption></figure>

* These options control how the stock is displayed in different conversion units.

***

### **Adjust Other Settings**

* Navigate to **Other Options 1**.
* Set the following:
  * **Item View** → *Item Order Wise*
  * **Item Sorting** → *Item + Size*
  * **Transaction Filter** → *Transacted*

<figure><img src="/files/7INM2fsUqR0zDH3y6X1u" alt=""><figcaption></figcaption></figure>

* Click **Save Configuration** to apply the settings.

***

### **Generate the Report**

* From the list of available configurations, select the one you just created.

<figure><img src="/files/I9oG6BmRPu0V7JKjsqPI" alt=""><figcaption></figcaption></figure>

* Click **Create Report**.
* The generated report will display **Closing Stock** in both **strips** and **tablets**, based on the conversion factors defined.

<figure><img src="/files/myvu2f48yCkZUh3iW1cE" alt=""><figcaption></figcaption></figure>

***

### **View Stock Report Lot-Wise**

* To view the stock **Lot-Wise**, press **F5** to open the configuration window.
* Under **Other Options 1**, change **Item View** to *Lot Wise*.

<figure><img src="/files/nehP0WhPxHKQMeSS9Mnu" alt=""><figcaption></figcaption></figure>

* Save the configuration.

***

### **Enable Lot Number Column**

* Open **Setup Column Attributes**.
* Enable the **Lot Number** column.

<figure><img src="/files/4v9uFu0piwIyl7WNdsrx" alt=""><figcaption></figcaption></figure>

* Save the settings and press **F2** to refresh the report.

***

### **Review the Final Report Output**

The final report displays **Lot-Wise Stock Details**, showing available quantities in both **strips** and their **equivalent tablets**, providing a clear multi-unit view of your inventory.

<figure><img src="/files/VMyQqw8pncfpKt3eK5TB" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-closing-stock-report-with-multiple-units-of-measure.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.