# Generate Batch/Lot-wise Stock Status Report
**YouTube:** [How to Generate Batch/Lot-wise Stock Status Report?](https://www.youtube.com/watch?v=AV7h6BPNvSA)
## How to Generate Batch/Lot-wise Stock Status Report?
In this tutorial, we will demonstrate how to **configure and generate a Batch-Wise Stock Status Report** in **Logic ERP**.
***
### **Open Stock Query Configuration**
* Navigate to the **Reports/Queries** section under the **Stock Report** category.
* Open **Stock Query**.
* Click on **Configuration** to create a new report.
* Enter an appropriate **Configuration Name** for the report.
***
### **Define Print Columns**
* Under the **Print Options** tab, click on **Print Columns**.
* A list of available columns will appear.
* Select the checkboxes for the columns you want to include in your report, such as:
* Lot Number
* Item Name
* Opening Stock
* Purchase
* Purchase Return
* Sale
* Sale Return
* Closing Stock
* You can rearrange the column order using the **Arrow Keys** as per your preference.
***
### **Configure Totals**
* Under the **Total** section, select the appropriate options based on how you want the **totals** to be displayed in the report.
***
### **Set Item View and Sorting**
* Move to the **Other Options 1** tab.
* Under the **Item View** section:
* Set **Lot Wise** from the dropdown menu.
* In the **Item Sorting** option, choose **Item**.
* From the **Transaction Filter**, select **Transacted Items** to include only those items that have stock movements.
* Once done, click **Save Configuration**.
***
### **Generate the Report**
* From the **Configuration List**, select the newly created report.
* Click on **Create Report** to generate the **Lot -Wise Stock Status Report**.
***
### **Final Outcome**
The generated report will display **Lot-Wise stock details** for each item, including:
* Opening and Closing Stock
* Purchases and Sales
* Purchase Returns and Sale Returns
This report helps you analyze stock availability and movements **Lot - Wise** for accurate inventory tracking.
