E1: 42: Grade and Potency Preference (Type 08) Uses Promised Ship Date not Promised Delivery Date to Calculate Grade Availability

(Doc ID 1953024.1)

Last updated on NOVEMBER 17, 2015

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

The Grade and Potency Preference (Type 08) is using Promised Ship Date in Sales Order Entry (P4210) to calculate when the grade expires in order to determine if quantity will be available for the customer. It should be using the Promised Delivery Date which is what Pick Slip Print (R42520) uses for committing inventory committing inventory.

Steps to Duplicate
-------------------
1. In the Grade and Potency Preference, Days Before Expiration (EXDP) is set to 25 days for a particular item and customer.
2. The Lot Master (P4108) shows the lot expiration date as Jan-07-2015 (F4108.MMEJ). So this lot grade should not be delivered to this customer later than Dec-13-2015 (25 days before Jan-07-2015).
3. The Grade and Potency Preference is activated in the Sales Order (P4210) processing options and the Preference Selection (R40400) UBE.
4. The order is entered for the customer and item with an order date of Dec-09-2014, a Promised Ship Date of Dec-09-2014 and a Promised Delivery Date of Dec-16-2014 which is more than 25 days before lot expiration on Dec-13-2015. No warning message is given.
5. The user changes the Promised Ship Date from Dec-09-2014 to Dec-16-2014 and the system issues the "order Quantity Exceeds what's Available" proving that the expiration for that item grade for that customer is calculated on the Promised Ship Date instead of the Promised Delivery Date.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms