Skip to main content

Expired Goods

Report Module Guide: Expired Goods Report

Module Location

Inventory > Reports > Expired Goods

Module Objective

The Expired Goods Report module is used to generate a list of all items in inventory that will or have already passed their expiration date. This report is crucial for companies that manage goods with a limited shelf life (such as food, beverages, or chemicals) to minimize losses and ensure product quality.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

  • Warehouse / Item/Service Category Type:

    • Filter the report for a specific Warehouse or Category Type (e.g., FINISHED GOODS).

  • Period:

    • Specify the date range in the From and To fields.

  • Based on:

    • Important! Select the basis for the period filter:

    • Arrival Date: Displays goods that were received in that period.

    • Expiry Date: Displays goods that will expire in that period.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need. To see goods that will expire this month, select Based on: Expiry Date and set the Period for the current month.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

  • [Display Report]: To preview the report directly on your screen.

  • [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items managed by batch or lot, along with their expiration dates.

This report displays important details such as:

  • Item/Service Code and Item/Service Name.

  • Arrival Date: When this batch of goods was received.

  • Expiry Date: The expiration date for that batch.

  • Lot No: The batch or lot number of the goods.

  • Qty: The remaining quantity of that batch.

Tips & Important Notes

  • Use this report proactively to identify goods that are approaching their expiration date.

  • Goods nearing expiration can be prioritized for sale (using the FEFO - First Expired, First Out principle) or be used for a promotional program to avoid losses.

  • This report is crucial for the Warehouse Management, Quality Control (QC), and Sales teams.

No comments to display

Back to top