Compiere supports to manage shelf life in an efficient way either at Customer/Product level

tenthplanet blog compiere Compiere supports to manage shelf life in an efficient way either at CustomerProduct level

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 efficiently for each product and also allow to configure customer required shelf life for product wise, the below lines describe how it is achieved in the Compiere,

There are three level of configuration available in Compiere,

  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 an 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
ProductLotEx DateShelf LifeBPMovement DateExpected Shelf LifeActual Shelf LifeResult
WOOD 3X4Lot131/10/1718045.00%02/08/1740090Not Allow to create Shipment
Lot230/09/1718045.00%02/08/1740059Not Allow to create Shipment
Lot330/10/1818045.00%02/08/17400454Allow to create Shipment
Shelf Life not Configured in Business Partner Screen
LotEx DateShelf LifeBPMovement DateExpected Shelf LifeActual Shelf LifeResult
WOOD 3X4Lot131/10/1718002/08/179090Allow to create Shipment
Lot230/09/1718002/08/175959Allow to create Shipment
Lot330/10/1818002/08/17454454Allow 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

compiere_customization