Receiving lottable items

When receiving items into the warehouse, periodically you must capture lot numbers and validate each lottable item. A lot number represents a collection of items with similar attributes. Owner requirements determine attributes that define the lottable criteria. For example, a food manufacturer could create lots for perishable foods according to expiration dates.

During workstation receiving, the application displays lottable fields based on the item specified in each ASN detail line. When a receipt is performed, the application checks the Lottable Validation rule configured for the item to validate that correct data has been specified, prior to saving the receipt. If the data specified does not meet what is expected for the item, the system will display a message so the correct information can be included.

The validation requirements for lottables are configured on the Lottable Validation screen. See the Infor WMS Configuration User Guide for additional information. The Lottable Validation controls these aspects of the receipt:

  • Which lot attributes are required for the item.
  • Lot masking rules used to populate one or more lot attribute with values calculated by the system.
  • If a date format is to be specified in a lot field and converted to a date format to be stored in a date field.
    Note: See the Date Format section of the Infor WMS Configuration User Guide for additional information on configuring date formats to be used in the Lottable Validation.
  • If inbound shelf life needs to be validated on the receipt. Shelf life validation checks are required to ensure the product received meets requirements for date control. Shelf life can be based on Expiration Date (Lottable05) or Manufacture Date (Lottable04).
    • 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 specified 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.

    • 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 specified from the current 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.

If the receipt was received through the APIs and an ExternalLot was specified, then the lottables are already set to the expected values and cannot be changed. The ExternalLot can be changed only through the APIs and not in the workstation. Based on the data specified, the application either processes the receipt or displays an error message.