There are different types of products available in the distribution business, for the case of pharmacy products, these are maintained with based on Expiry Date, if the product expired then we cannot keep it for sales in the store. So, these products all have particular shelf life days. Shelf life days for a product are ‘Recommended maximum no of time for the product can be stored, during which the defined quality of the product remains acceptable’.

Compiere supports to manage shelf life in an efficient way for each product and also allow to configure customer required shelf life for product wise, the below lines describes how it is achieved in the Compiere,

There three level of configuration available,

  1. Product Level configuration
  2. Customer Level Configuration
  3. Customer wise product configuration

For the entire above, total shelf life of the product should be configured in the product.

In the product level configuration, you can configure minimum shelf life for the product and this is common for all customers. While create shipment for the product the system verifies whether the product having minimum shelf life configured and if it is then only the creation of shipment allowed. The shelf life is calculated based on the Expiry Date so the product should have expiry date.

In the Customer Level configuration, you can configure the customer required Shelf life in the customer screen. While create shipment for the product the system verifies whether the product having the configured shelf life and if it is then only the creation of shipment allowed.

In the Customer wise product configuration, In the product screen there is provision to configure customer wise Shelf life for the product, which can be in number or Percentage, if you configured both then the number is taken finally and calculated the shelf life for the product and shipped to customer.

If Product has lot & expiry date, then Compiere generate the Customer Shipment as per below table

Shelf Life Configured in Business Partner Screen
Product Lot Ex Date Shelf Life BP Movement Date Expected Shelf Life Actual Shelf Life Result
WOOD 3X4 Lot1 31/10/17 180 45.00% 02/08/17 400 90 Not Allow to create Shipment
Lot2 30/09/17 180 45.00% 02/08/17 400 59 Not Allow to create Shipment
Lot3 30/10/18 180 45.00% 02/08/17 400 454 Allow to create Shipment
Shelf Life not Configured in Business Partner Screen
Lot Ex Date Shelf Life BP Movement Date Expected Shelf Life Actual Shelf Life Result
WOOD 3X4 Lot1 31/10/17 180 02/08/17 90 90 Allow to create Shipment
Lot2 30/09/17 180 02/08/17 59 59 Allow to create Shipment
Lot3 30/10/18 180 02/08/17 454 454 Allow to create Shipment

Expected Shelf life Formula:

Shelf Life *100/BP => 180*100/45% =>400

Actual Shelf Life formula:

Expiry Date-Movement Date => 31/10/17 – 02/08/17=>90