Configuring Shelf Life Validation

Shelf Life validation can be performed against the Manufacturing Date or Expiration Date. This ensures product being received meets minimum shelf life requirements before it is brought into inventory

These are various configuration elements that determine how shelf life validation is used:

Configuration element Description
Item
  • Shelf Life Indicator - Check if shelf life should be checked
  • Shelf Life Code Type - Manufacture Date or Expiration Date
  • Inbound Shelf Life - A minimum number of days for the item to ensure the warehouse has the correct number of days to store and ship the product to customers
Lottable Validation The Shelf Life Validation flag on the Lottable Validation screen must be turned on for the system to use the validation settings configured for the item.
Shelf Life Validation on Expiration Date

The expiration date can be used to check that current product is received within X number of days of its expiration date. This allows the facility to store the product for an expected amount of time and allow shipment to a customer with an allowable shelf life.

To perform this shelf life validation, the application subtracts the current date of receipt from the expiration date entered during receipt. If the resulting number is less than the Inbound Shelf Life value configured for the item, a message will display and the receipt will not be allowed. For example:

  • Inbound Shelf Life = 365 (defined on the item)
  • Date of receiving = February 10
  • Expiration Date input at receiving = December 10 (in the same year)

Result: The calculated value is 303 (December 10 minus February 10).

Since this is less than the Inbound Shelf Life (365), the receipt is rejected because it will expire too soon to be effectively stored and shipped to a customer.

Shelf Life Validation on Manufacturing Date

The manufacture date can be used to check that current product is received within X number of days of being manufactured. For example, if an item was manufactured 30 days ago it may be considered too old and should not be included in the current inventory.

To perform this shelf life validation, the application subtracts the manufacture date entered from the date of the receipt. If the resulting number is greater or equal to the Inbound Shelf Life value configured for the item, a message will display to the operator and the receipt will not be allowed. For Example:

  • Inbound Shelf Life = 14 (defined on the item)
  • Date of receiving = February 16
  • Manufacture Date input at receiving = February 1 (in the same year)

Result: The calculated value is 15 (February 16 minus February 1).

Since this (15) is greater than the Inbound Shelf Life (14), the receipt is rejected because it was manufactured too many days prior to being received.

For additional information on setting up date formats, lottable capture validation, and shelf life checks, see the Infor WMS Configuration User Guide.