Shelf Life Management
Setup
General Setup
On Purchase and Payables Setup it is possible to define default minimum shelf life for purchase transactions.
For that, on Quality Requirements & Specifications tab, fill the info on Default Minimum Shelf Life.
On Sales and Receivables Setup it is possible to define default minimum shelf life for sales transactions.
For that, on Quality Requirements & Specifications tab, fill the info on Default Minimum Shelf Life.
Item Setup
When creating a new item the Inbound Minimum Shelf Life and Outbound Minimum Shelf Life are defaulted from the general setup. They can be adjusted manually for the item.
You can find these fields on the Item Card under the Item Tracking tab:
Quality Requirements and Specification
When defining a Quality Requirements and Specification it is possible to define alternative minimum shelf life.
Minimum Shelf Life Check
When creating a lot for a purchase document or selecting a lot for a sales document, the minimum shelf life check is triggered.
The minimum shelf life check is done according to the following calculation,
Expiration Date >= Document Posting Date + Minimum Shelf Life
If an applicable QRS for that item and customer/vendor exists, then the Minimum Shelf Life setup on the QRS will be applied. However, if no QRS is applicable, then the Minimum Shelf Life from the Item Card will be applied.
Impact on Sell-By Date
The Sales Minimum Shelf Life defined on the item card will be used to support the Sell-By Date calculation on Lot Number.
The calculation formula is as follows:
Sell-By Date = Expiraton Date - Sales Minimum Shelf Life
For example, the Default Outbound Minimum Shelf Life for this Item is defined 2 months and Expiration Date is set 3 months.
When purchasing the item on date 09/10/2023, the Expiration date will be calculated for 3 months, so, 09/01/2024.
As the Sales Minimum Shelf Life is set in 2 months, the Sell-by Date field for the associated lot will be filled with 2 months prior the expiration date, so, 09/11/2023.