Expiration Date Calculation Method

You can select the calculation method for lot expiration dates. Typically, the system calculates the lot expiration date using shelf life days when a product is completed. Another type of lot expiration date calculation is based on the active components of a parent item. For example, a parent lot can inherit the lowest expiration date of the active components.

If an item begins to expire during manufacturing, you can assign expiration date based on routing steps of that item. The Based On Date field represents the point from which shelf life days should be used to calculate the expiration date for the item.

This table presents the three methods for calculating a lot expiration date:

Method	Description
Shelf Life Days + Work Order Completion Date	If you use this method, the expiration date of the item is calculated by adding the date that it was completed plus the shelf life days that are defined for the item. If Shelf Life Days field is blank, then the default value for the Lot Expiration Date is the latest system date. You can override this value during work order completions.
Shelf Life Days + Based On Date	If you use this method, the expiration date of the item is calculated by adding the shelf life days plus the based-on date. You can specify the based-on date when you run the Work Order Completions (P31114) program. This type of calculation is required when the end product starts to expire before the last step of the routing process.
Shelf Life Days + Least Expiration Date of Active Ingredients or Components	If you use this method, the expiration date of the item is calculated for the manufactured parent lot based on a lower-level component. For example, if milk is used to produce ice cream, the expiration date for the lot of ice cream can be based on the expiration date of milk. Use this method in conjunction with the Active Ingredient option on the Additional System Information form (Manufacturing Data or Plant Manufacturing), where you specify whether the component is an active ingredient.

Method

Description

Shelf Life Days + Work Order Completion Date

If you use this method, the expiration date of the item is calculated by adding the date that it was completed plus the shelf life days that are defined for the item. If Shelf Life Days field is blank, then the default value for the Lot Expiration Date is the latest system date. You can override this value during work order completions.

Shelf Life Days + Based On Date

If you use this method, the expiration date of the item is calculated by adding the shelf life days plus the based-on date. You can specify the based-on date when you run the Work Order Completions (P31114) program. This type of calculation is required when the end product starts to expire before the last step of the routing process.

Shelf Life Days + Least Expiration Date of Active Ingredients or Components

If you use this method, the expiration date of the item is calculated for the manufactured parent lot based on a lower-level component. For example, if milk is used to produce ice cream, the expiration date for the lot of ice cream can be based on the expiration date of milk.

Use this method in conjunction with the Active Ingredient option on the Additional System Information form (Manufacturing Data or Plant Manufacturing), where you specify whether the component is an active ingredient.