# 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.
* Apply **Totals** as required for your report.
***
### **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.
Once all settings are configured, click **Save** to apply the changes.
***
### **Generate the Report**
* Select the **newly created report configuration** from the list.
* 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”).
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.
