E1: 42: Wrong Ship Quantity After Changing The Quantity On An Existing Sales Order Line (Doc ID 2109598.1)

Last updated on AUGUST 08, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When modifying the quantity on a back-ordered sales order line with a manually added lot (hard committed), the system creates a second line and puts the initial quantity into shipped quantity instead of leaving it into the Back-order bucket.
The lot has been manually inserted into sales order line and base preference 08 (Grade and Potency) is being used to calculate the Days before expiration.

Steps to duplicate:

  1. Define an item with Lot Process type = 2 (using NN) – shelf life days = 120
  2. Enter qty into some lots
  3. P40070 - Form exit to Item Group. Set item into item group GRDA and set customer into Customer Group GRDA.
  4. Add details for Grade and Potency preference (08) for Customer Group and Item Group combination. Set the Days Before Expiration field to 255 (the number of days subtracted from the Expiration date of the lot)
  5. P4210 enter a sales order for a qty of 5 and manually put in the lot number 24927. A warning that Qty Exceeds what’s available is displayed. The qty of 5 will be put on backorder. This is because the Expiration date of lot – 255 is prior to today’s date.
  6. P4210 go back into the sales order and modify the qty from 5 to 7. Again the same warning is displayed. This is correct. Save the order.
  7. Inquire on the order and see there are 2 lines on the order now. One line for the original qty of 5 – showing the qty as being shipped (This is wrong). Another line for the remaining 2 – in backorder (This is correct).

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