How to view, print, export or analyze a Product expiry report in Retailgraph Software

Product Expiry Report

How to view Expiry Detail Report in SwilERP (RetailGraph)


What is Expiry Detail Report

The product expiry report helps the users to check expiration dates and if they are nearing the end of life. The users can customize this report either by date, product, manufacturer, or vendor. It shows stocks expiring within the given date range along with details like Product Name, Category, Marketing Group, Lot No, Exp Date, Stock details, and other details related to the products.

With the product expiry report, the user can see which products expire within a specified time. Users can also view categories data by selecting Category, MktgCo, Brand, Strength, Product, Generic, and Schedule.
Here is the process to view the expiry report in SwilERP:

Start with login in the SwilERP dashboard to initiate the process 

  1. Go to the Reports> Inventory Reports> Expiry Detail
Reference image:
SwilERP Dashboard Window

Process to view the Report 

A new window of Expiry Detail will appear in the next slide. Follow the below-mentioned steps to view the report: 
  1. Select the Date Range "From" to "To", in which you want to view the report.  
  2. Users can also Filter the Product/Vendor/Manufacturer from the given options.
  3. Tick-Mark on the options, if required. 
    1. Print Nil Stock Lots
    2. Print Lot wise detail 
    3. Print Near expiry 
  4. Users can also select the following options to view the details category wise: 
    1. Category
    2. MktgCo
    3. Brand
    4. Strength
    5. Product
    6. Generic
    7. Schedule
  5. Click on the View tab.
  6. And, users can view the products details on the below-given screen. 
Reference image: 


How can you analyze product expiry report?

In this section, you can analyze your expiry detail report. You can find this report similar to the pivot table, in which you can view the stock details. 
  1. Go to the   Analysis  section .
  2. Select the details as same as you selected in the  Home   section .
  3. Click on the   View  option. 
  4. After that,  Choose fields to add to report.  Tick-mark on the options; then, they will automatically field in the below-given areas. 
  5. You can also   Drag fields between below-given four areas :   Filter, Columns, Rows, Values. 
  6. The data reflect in the   Analysis Grid   section. 
Reference image:  



  1. Click on the  Chart  tab to view the report in chart format.
  2. Here you'll see the  report's chart along with reflected every detail .  
Reference image: 


  1. You can also view the report in  Raw Data , where you can find every detail.
  2. Click on the   raw data and  there you will see  expiry report. 
Reference image:


To Print and Preview the Report 

  1. Go to the  Display   section.
  2. Select the  Print  and  Preview  option to take printout of the report. 
Reference image: 


To export the file in excel format 

  1. Go to the  Display   section. 

  2. Click on the  ''T'' button,  and there, you'll see the options to convert your report into an excel file. 

Reference image:






      • Related Articles

      • View Product Wise Stock Valuation Report

        How to view Product wise report in SwilERP A product-wise report is a report of your stock valuation. In which you can view details lot number and product name wise. After Stock Valuation, users can view the Product Wise Stock Report in Queries ...

      • Supplier Wise Near Expiry Analysis

        How to do Supplier Wise Near Expiry Analysis in SwilERP What is Near Expiry Products? Near expiry, Drugs refer to drugs with efficacy of which is about to lapse within three months from the expiry date printed on the label by its manufacturer. ...

      • Supplier Shelf Wise Expiry Detail

        How to view Supplier Shelf Wise Expiry Detail in SwilERP What does mean by Expiry Details? In SwilERP, the Drug expiration is the date after which a drug might not be suitable for sale as manufactured. Pharmacists can determine the shelf life of a ...

      • Product Bill Wise Report

        How To View Product Bill Wise Report In SwilERP What Is Product Bill Wise Report? This report displays the product bill wise details of all the purchase invoices. In this report, users can view the list of all the bills receivable from every party. ...

      • New Product List Report

        How to Generate a New Product List Report in SwilERP When a business person wants to know which products are new in our store, to know this, they can generate a New Product List Report in SwilERP. SwilERP software has a feature to view New Product ...