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 .