Field help (DLUBPC)
The use-by date (UBD) conversion factor can only be accessed when the following conditions are met:
- Expiration is managed for the product.
- Expiration management (Management field (EXYMGTCOD)) is not based on a rounded value (start or end of the month).
This conversion factor is used to calculate, in calendar days, the use-by lead time, based on the shelf life defined at the product record level.
UBD lead time = Shelf life x UBD coefficient.
The value of the conversion factor must be between 0.1 and 1. The UBD cannot exceed the expiration date.
This UBD lead time is used to determine the use-by date of the product, based on its stock receipt date.
UBD = Lot receipt date +UBD lead time
Defining a UBD provides the customer receiving the lot with the guarantee that the use-by date of their goods is more or less distant from the expiration date.
Example:
- Shelf life = 2 months (60 days)
- UBD coefficient = 0.5
- UBD lead time = 30 days
- UBD = receipt date + 30 days
A UBD conversion factor can be entered in the product record, in the product-site record and in the customer-product record. The UBD conversion factor entered in the customer-product record is used to determine the use-by date specific to one customer. In this case, when allocating a stock (order, stock issue, etc.), the UBD defined for the customer overrules the one defined for the product-site.
In creation mode, the UBD coefficient is blank.
Example 2 with UBD defined for the client:
Sales order with requested delivery date (determined from the shipment date + lead time): 01/11/2021
Lot A
- Stock receipt date: 01/01/2021
- Shelf life: 20 days - Expiry date: 01/20/2021
- UBD coefficient for product-site: 0.6 - UBD lead time for product-site: 12 days - Product-site UBD date: 01/12/2021
- UBD coefficient for customer-product: 0.4 - UBD lead time for customer-product: 8 days - Customer-product UBD date: 01/08/2021
Lot B
- Stock receipt date: 01/01/2021
- Shelf life: 20 days - Expiry date: 01/20/2021
- UBD coefficient for product-site: 0.6 - UBD lead time for product-site: 12 days - Product-site UBD date: 01/12/2021
- UBD coefficient for customer-product: not specified
Lot | Expiry date | Product-site UBD | Customer-product UBD | Requested delivery date | Allocation |
A | 01/20/2021 | 01/12/2021 | 01/08/2021 | 01/11/2021 | NO |
B | 01/20/2021 | 01/12/2021 | --------------- | 01/11/2021 | YES |
During the allocation:
- Lot A was not selected because the customer-product UBD was dated 01/08/2021, which is prior to the delivery date 01/11/2021.
- Lot B was selected because the product-site UBD was dated 01/12/2021, which is later than the delivery date 01/11/2021.