# Generate Report for Expired Stock

**YouTube:** [How to Generate Report for Expired Stock?](https://youtu.be/tiNbrGNgIe0)

## How to Generate Report for Expired Stock?

In this tutorial, we’ll learn how to configure the **Expiry Stock Report**, which helps in monitoring, tracking, and clearing expired stock items efficiently.

***

### **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 easy identification.

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

***

### **Select and Customize Report Columns**

* Under **Print Options**, click **Print Columns** to view the list of available columns.
* Select the following key columns:
  * **Item Name**
  * **Pack Name**
  * **Lot Number**
  * **Expiry Date**
  * **Closing Stock**
* Press the **Space Key** to rename columns as required.
* Use the **Arrow Keys** to rearrange their order.

<figure><img src="/files/56QddncnvTEReAke7Qt2" alt=""><figcaption></figcaption></figure>

* Once done, **save the changes**.

***

### **Define Totals**

* Go to the **Total Section**.
* Choose the preferred method for displaying totals, such as group-wise or overall totals.

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

***

### **Configure View and Sorting Options**

* Navigate to **Other Options 1**.
* Set the following options from the dropdown menus:
  * **Item View** → *Lot*
  * **Item Sorting** → *Item Name*
  * **Transaction Filter** → *Transacted*

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

***

### **Enable Expiry Report Option**

* Go to **Other Options 2**.
* Enable the **Expiry Report** option.

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

* Click **Save Configuration** to store all changes.

***

### **Generate the Expiry Stock Report**

* From the list of available configurations, select the newly created setup.
* Click **Create Report**.

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

* The generated report will display **Closing Stock along with Expiry Dates**.

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

***

### **Filter Stock by Expiry Date**

* Close the report window.
* In the **Header Section**, define the **Expiry Date (From** and **To)** range.

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

* Click **Create** again to regenerate the report.

***

### **Review the Final Output**

The report now displays **Items and their respective Batches** whose stock has **expired within the specified date range**, allowing you to take timely action for stock clearance.

<figure><img src="/files/8KatpXlGFlnnb0Cf98uu" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: 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-report-for-expired-stock.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.