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,
- Product Level configuration
- Customer Level Configuration
- 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