Shelf Life Control in JDE

[jwebster77]

I have a couple of questions in regards to shelf life control for inventory items in JDE. The manual, which I have reviewed does not really explain what I am after.

1. Is there a way to not have a lot controlled item as shelf life controlled. Meaning, I have items with no shelf life but it seems as if I have to designate a shelf life date for all items. Doesn't seem right to me.

2. From what I can tell, the shelf life days are added to the receipt date. More than likely, the clock didn't start when I received in the material but rather when the customer shipped the material or perhaps before that. I did see that you could leave the shelf life days blank on the item setup, and it supposedly will prompt for a expiration date at receipt. Is there any other way to accomplish this. Example: Enter the actual ship date from the vendor somewhere and have it look at the shelf life days to calculate? Often we may not know without looking up what the shelf life days are. And then you have to hope the person receiving is calculating the days correctly.

Thanks for any help on the above.

 

[aaro]

To my understanding, E1 expects all lot-controlled items to have an expiry date whose calculation is hard-coded to be based upon SLD in item branch unless the user manually populates an expiry date on the transactional forms like W4312A.

If you wish the lot never to expire, you should set SLD to something like 9999 or 99999 etc so that the calculated MMEJ falls several years into future.

Hope it helps!

 

[aaro]

Additional Info about similar request that might help you!!


BUG: 21022274 : SHELF LIFE DAYS SHOULD NOT BE REQUIRED WITH PEFD AND LEDD
DESCRIPTION OF PROBLEM
======================
When entering a Purchasing or Manufacturing Effective Days (PEFD, LEDD) value
in P41026 (Item Branch/Plant), a Shelf Life Days (SLD) value is also
required.
Shelf Life Days should NOT be required. The Shelf Life Days value is used to
calculate an expiration date (The date on which a lot of items expires).
The Purchashing/Manufacturing effective days is the number of days after
receipt/completion of an item/lot that the lot becomes available for use or
shipment.
An automatic expiration date calculation should not be required.
An item can be setup as 'lot controlled' (Lot Process Type (SRCE) not =
blank) without also defining a Shelf Life Days. If Shelf Life Days is not
entered, the expiration date is manually entered each time an item/lot is
received into inventory.

This should not be considered an enhancement request as a system calculated
expiration date should not be required with a lot effective days setup.
The prompt to enter an expiration date (when processing receipts P4312,
completions P31114, inventory adjustments P4114, etc) should be made
available.

Example Business case: When purchased goods are received, 3 days are
required for inspection type activities before the items can be used in
production or sold. The supplier documented expiration date must be entered.
This expiration date varies and is not always a specific number of days from
the receipt of the product. The user should be prompted to enter the
expiration date. It cannot be a system calculated date.
(It is too cumbersome to set up and maintain a Receipts Routing record for a
very large number of items. And. receipts routing adds to the receiving
process time unnecessarily. The PEFD is neccessary in the MRP and
manufacturing commitment process).

The following error is displayed if an SLD is not entered:
Shelf Life Days invalid
The Shelf Life Days must be greater than the Lot Effective Days.
ER Details:
Form P41026_W41026A
Source File n4101060.c
Source Line 37435
Error ID 492B
BSFN DSTR Item 100

Note the definition of the following effective days and expiration
fields/data items (on the Bug attachment): Manufacturing Effective Days LEDD,
Purchasing Effective Days PEFD, Days - Shelf Life Days SLD, Lot Effectivity
Date DLEJ and Date - Lot Expiration MMEJ.



STEPS TO REPRODUCE
==================
1. Access a purchased item branch/plant record (P41026).
2. Click into the Lot Processing tab.
3. Enter a value in the Purchasing Effective Days field. Click OK (save).
4. Error 'Shelf Life Days invalid' will be displayed.
Shelf Life Days invalid
The Shelf Life Days must be greater than the Lot Effective Days.
ER Details:
Form P41026_W41026A
Source File n4101060.c
Source Line 37435
Error ID 492B
BSFN DSTR Item 100

DESIRED OUTCOME
===============
A system calculated expiration date should not be required with a lot
effective days setup.
The prompt to enter an expiration date when processing receipts P4312,
completions P31114, inventory adjustments P4114, etc. should be made
available.

POTENTIAL WORKAROUNDS
=====================
1. Ensure that the users know to change the expiration date calculated by the
system to the 'actual' expiration date. This is risky as users must know
which items require a unique expiration date.

Cheers,
aaro