# 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FZvnQHzZ3ZCwqJcE1LhCE%2FConfiguration%20-Name.png?alt=media&#x26;token=e738e30b-b1bc-4b99-88e8-0ff983dff187" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fujg7kWdIcBWKKeqXKtBi%2FSet%20Column%20Attribute.png?alt=media&#x26;token=890425eb-249f-44e1-bbb6-32ff4a60c633" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FszyupU2esAXkNgRcSn8P%2FPrint%20Totals.png?alt=media&#x26;token=76a0ac81-e60d-499a-aeef-92f7d75214c0" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FehnY5wlTrZ26roZ4cknu%2FCF%20Options.png?alt=media&#x26;token=194a7ba5-10eb-4a3c-9d2c-e5bf18752aa9" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FYWhZCIVYUsmMyV0Ax8Oa%2FOther%20Options%201.png?alt=media&#x26;token=29169b7f-4968-49a1-9bfc-c9b86785f7e6" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FmSaPtF83eM8IezDMYA4G%2FCreated%20Report.png?alt=media&#x26;token=73094a0c-193e-42c0-b38b-5300447c76a4" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTlweuwwxwPDRUNk6odoc%2FFinal%20Report%20View%202.png?alt=media&#x26;token=b2d4d71f-f5d9-4e1c-8e7b-cdc9fb02c78f" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FNpJvslyBjvF8RlI5Xot6%2FLOT%20Wise.png?alt=media&#x26;token=5b15895f-0aee-4522-9095-92a4c6481fed" alt=""><figcaption></figcaption></figure>

* Save the configuration.

***

### **Enable Lot Number Column**

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

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FStslz7PIKTs41iQgSzgA%2FSCA%20-%20LOT%20number.png?alt=media&#x26;token=867edbf2-9c2e-492c-ab6c-5e819b6a9d43" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FFpGE17hnhiKY8v6SslwK%2FUp.png?alt=media&#x26;token=94faf7ba-0de7-401d-a538-b368e1d436c0" alt=""><figcaption></figcaption></figure>
