1. Using Inventory Management
  2. How the Dates in Lot Attributes Are Calculated

How the Dates in Lot Attributes Are Calculated

When you create a receipt on a lot-controlled item, key dates default for the lot based on the values defined for the lot-controlled item during setup in the Product Information Management work area.

Here are the lot attribute dates:

  • Origination date

  • Expiration date

  • Retest date

  • Maturity date

  • Expiration action date

  • Hold until date

Origination Date

When creating a lot or assigning lot numbers within transactions, the system date defaults as the origination date. This is essentially the lot creation date and you can modify this date. The values for the maturity date, hold date, retest date, and expiration date (if an item is shelf-life controlled), default from or are calculated based on the origination date.

Origination Date = Lot Creation Date

Expiration Date

The expiration date controls the availability of the lot for transacting and planning purposes. This field populates automatically based on the lot origination date plus shelf-life days that you define in the item master. You can modify the expiration date if the lot is under shelf-life control.

Expiration Date = Origination Date + Shelf-Life Days

Here are some important characteristics of expired lots:

  • Aren't considered as on-hand supply when performing min-max, reorder point, or MRP planning calculations.

  • Can't be reserved for a date beyond the expiration date.

  • Are included in on-hand quantities, and can be transacted.

  • Are included in a cycle count. Cycle count entry and adjustments are allowed.

  • Are included in all inquiries and reports, including inventory valuation reports.

Retest Date

The retest date is the date to retest the lot. The retest date automatically defaults based on the sum of the lot origination date and the retest interval that you define in the item master.

You define the retest interval in terms of days for an item in the item master. So, if you create a lot on 31-July-2020 (origination date) and the retest interval was previously defined as 365 for the item, then the default retest date is 31-July-2021. You can view the retest date on the Manage Lots and Edit Lots pages.

Retest Date = Origination Date + Retest Interval

Maturity Date

The maturity date is the date when the lot reaches full maturity. The maturity date defaults automatically based on the sum of the lot origination date and the maturity days that you define in the item master. If maturity days aren't defined, the application assumes the lot is mature at creation.

Maturity Date = Origination Date + Maturity Days

Expiration Action Date

The expiration action date identifies the date that the defined expiration action for the item is to occur. The application calculates the default expiration action date by adding the lot expiration action interval to the lot expiration date.

Expiration Action Date = Lot Expiration Action Interval + Lot Expiration Date

Hold Until Date

The hold until date is the date that the lot can be released for usage in inventory. The hold date defaults automatically based on the sum of the lot origination date and the hold days that you define in the item master.

Hold Until Date = Origination Date + Hold Days