How to do Supplier Wise Near-Expiry Products Analysis in SwilERP Software

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. Medicines have expiry dates, so you know when to sell them. This report would help pharmacists find near-expiry product dates. The Near expiry date helps you to find the best before-use date for the medicines.

In SwilERP, there is an option to view the near-expiry report supplier wise. You can find the product's expiry details as per the supplier and do an analysis for the same. Also, the option of Expiring Within days min or max is available in the report.


Start with login in SwilERP dashboard to initiate the process 

  1. Go to the Reports> Expiry/Breakage/Purchase Return Detail> Supplier Wise Near Expiry Analysis  
Reference image:

Supplier Wise Near Expiry Analysis


How to view the Analysis Report
  1. A new window of Supplier Wise Near Expiry Analysis will appear in the next slide.
  2. Select the "Date Range" From to To in which you want to view the report.
  3. Select Print Value From as Sale Rate, Purchase Rate, MRP, and Cost Rate from the column.
  4. Similarly, select Near Expiry From as Purchase or Last Date.
  5. If you want to Print Nil Stock Batch No then Tick-Mark on it.
  6. Now, enter the Expiring within days count, that means this report shows the products which will be expired in the mentioned days: 
    1. For example, you entered 60, 120, 180, and 240 days in the expiring within days columns. The report will reflect the data according to the entered days. 
  1. To apply the filter on vendor click on the Vendor option.
  2. Click on the View option.
  3. After that, you will see the Supplier Wise Near Expiry Analysis as shown in the following reference image according to the selected parameters.
Reference image:

Analysis Report
  

To view the Reports in Chart Format 

  1. Select Any Column from the shown details in the window.
  2. Click on the Chart option to view the report in chart format.
  3. Here you will see multiple options for chart format.
Reference image:

Chart Format


To Take Print or Preview and Convert into Excel format

  1. Go to the Display section.
  2. Click on the Print or Preview option to take a printout of report.
  3. Go to the "T" button and click on the excel option to convert report. 
Reference image:

Print or Preview and Convert into Excel format



      • Related Articles

      • 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 ...
      • Group Wise/Group Supplier Wise Purchase Analysis

        How to view the Group Wise And Group Supplier Wise Purchase Analysis (Old) Report in SwilERP Meaning of Group Wise/Group Supplier wise purchase Analysis. The purchase analysis report details the costs of purchasing every product during a given ...
      • Product Wise Purchase Analysis (Old) Report

        How To View Purchase Analysis Report: Product Day Wise/Month Wise/Product Wise/Product Supplier Rate Wise/Product Type Wise  Meaning of Product Wise Purchase Analysis Report. The purchase analysis report details the costs of purchasing every product ...
      • Supplier Product/Bill Wise Analysis Report

        How to View Supplier Product/Bill Wise Analysis Reports in SwilERP Meaning of Supplier Product wise and Bill wise Purchase Analysis. The purchase analysis report details the costs of purchasing every product during a given period. This report helps ...
      • 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, ...