> 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-batch-lot-wise-stock-status-report.md).
# 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.
---
# 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-batch-lot-wise-stock-status-report.md?ask=
```
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.