> 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-mobile-imei-serial-number-wise.md).

# Generate Closing Stock Report – Mobile/ IMEI Serial Number wise

**YouTube:** [How to Generate Closing Stock Report – Mobile/IMEI Serial Number-wise?](https://youtu.be/-Pla3aN88Kw)

## How to Generate Closing Stock Report – Mobile/ IMEI Serial Number wise?

In this tutorial, we’ll learn how to configure the **IMEI or Serial Number Wise Closing Stock Report** to view item-wise closing stock details based on unique serial numbers.

***

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

* From the **Main Menu**, navigate to **Reports & Queries**.
* Click on **Stock Reports**, then open "**Query Stock Lot Pcs Number Wise"** Report.
* Click on **Configuration** to create a new report setup.
* Assign a **suitable configuration name** for easy identification.

<figure><img src="/files/2PzlRlDNabWiSmVP9ooL" alt=""><figcaption></figcaption></figure>

* Apply **Totals** as required for your report.

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

***

### **Define Report Options**

* Navigate to the **Other Options** tab.
* Set **Report Type** → *Consolidated*.
* Set **Report Order** → *Item + Size*.
* Define **Rate 1** as *MRP* and **Rate 2** as *Sale Rate* from the dropdown lists.
* Enable the **Transacted Items Only** checkbox to include only items with transactions.

<figure><img src="/files/65bJfLWo8p28cCQdQNmV" alt=""><figcaption></figcaption></figure>

Once all settings are configured, click **Save** to apply the changes.

***

### **Generate the Report**

* Select the **newly created report configuration** from the list.

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

* Click **Create** to generate the initial report layout.

***

### **Customize Report Columns**

* Open the **Setup Column Attributes** list.
* First, **Unselect All Columns** to start fresh.
* Then, select only the required columns for display (such as Item Name, Lot Number, IMEI / Serial Number, Quantity, and Rate Details).
* Use the **Arrow Keys** to rearrange the column order as desired.
* Press the **Space Key** to rename the headers for **Rate 1** and **Rate 2** as needed (e.g., “MRP” and “Sale Rate”).

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

Once customization is complete, click **Save**.

***

### **View the Final Report**

* Press **F2** to refresh and regenerate the report.
* The system will now display the **closing stock details IMEI / Serial Number wise**, including MRP, Sale Rate, and available quantity for each item.

<figure><img src="/files/cl3H16odiqWh160wNtQv" 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-mobile-imei-serial-number-wise.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.
