Select Page
Skip to main content
< All Topics
Print

Expired Products

Enabling Expiry For Products

  1. To enable expiry, go to Settings -> Business Settings -> Product section. And check the “Enable Product Expiry” checkbox.
  2. On enabling Product expiry, you can choose either “Add Item Expiry” or “Add
  • “Add Item expiry” => Choose this option if you want to directly add the expiry of the item to the purchase screen.
  • “Add manufacturing date & Expiry date” => Choose this option if you want to add the manufacturing date of the item and the expiry period. The expiration date will auto-calculate based on the manufacturing date and expiry period. And this expiry date can be edited. You will have to add the expiry period for the product in the “Add or Edit Product” screen. And the manufacturing date in the “Add Purchase” screen.
  1. “On Product Expiry” => With this option, you can set what the system should do when a product expires.
  • “Keep Selling” => Choose this option if you want the application to keep selling the product even after expiry.
  • “Stop Selling n days before” => Choose this option to stop selling the item n days before the expiry. You will have to specify the value of n (which is the number of days before you stop selling)
  1. “Stock Accounting Method” => This feature is used to set the way the product should be sold. This can be seen at Products, under Business Settings.
  • FIFO (First In First Out) => In this, the old stock should be sold first.
  • LIFO (Last In First Out) => In this, the most recent purchase stock should be sold.

For Example:

  1. Purchase 20 pcs of product A on 20 March 2018. Expiry date 10 April 2018
  2. Purchase 20 pcs of the same product  A on 23 March 2018. Expiry date 8 April 2018
  3. Today, I sold 22 pcs.

If the “Stock Accounting Method” is FIFO => Then the Product purchased on 20 March 2018 will be deduced with 20 pcs, and after that, the product purchased on 23 March 2018 will be deduced with two pcs.

So in stock, we will have products from 23 March 2018 with 18 pcs.

If the “Stock Accounting Method” is LIFO => The opposite of the above will happen.

NOTE: You must set the required accounting method before selling the item for that accounting method to be used.

Stock Expiry Report:

  1. Go to Reports => Stock Expiry Reports.
  2. Here, you can filter stock “Category”, Brands, “Stock expiry date”
  3. Click on “Edit” to modify the stock left and expiry period.
  4. If the stock left is decreased, the unit purchase price will be adjusted accordingly.

Stock Expiry Alert:

– You can view stock expiry alerts on the homepage at the bottom. Here is a list of products expiring soon shows.

– You can set the number of days before which the expiry alter should be shown on the Homepage from “Settings -> Business Settings -> Dashboard Section” View Stock Expiry Alert For input field.

Displaying product expiry date in invoice

  1. Make sure the product expiry feature is enabled, as mentioned above.
  2. Go to invoice layout and enable “Show Product expiry”
  3. If the product expiry date is added when adding purchase or opening stock, then when making sales, the product expiry dropdown will be displayed. Select the expiration date on which you want to sell.  Then, the print invoice will show the expiration date.
Table of Contents