E1: 42: Negative Hard Commit Creates False Availability Causing Pick Slip to Print (Doc ID 1936789.1)

Last updated on NOVEMBER 16, 2015

Applies to:

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

Symptoms

On : 9.0 version, Sales
Pick Slip Print (R42520)
Tools Release 9.1

ACTUAL BEHAVIOR
---------------
Pick Slip Print (R42520) does not backorder if quantity on-hand is 0, quantity hard committed is -1 and quantity available is 1. This occurs if a credit order from history creates a negative hard commitment of -1 creating a false available of +1 and a sales order is then entered for 1 that does not go on backorder. As a result a pick slip is sent for the warehouse to pick when there is no inventory available in the warehouse.

EXPECTED BEHAVIOR
-----------------------
Pick Slip Print (R42520) should backorder a sales line if quantity on-hand is 0, quantity hard committed is -1 and quantity available is +1.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup a new item with a quantity of 1 in a secondary location.
2. Create a sales order, ship confirm from the secondary location and process it through sales update.
3. Verify the secondary location the item was shipped from is populated on the sales ledger record.
4. Check availability and verify quantity on-hand, hard committed and available is 0.
5. Create a credit order from history, quantity is -1 and location the original order was shipped from is hard committed on the credit order.
6. Check availability and verify quantity on-hand is 0, hard committed is -1 and available is +1.
7. Create another sales order for 1. Instead of going on backorder, the quantity shippable is set to 1.
8. Run Pick Slip Print (R42520). Instead of putting the item with 0 on-hand on backorder, a pick slip is sent to the warehouse for picking even though there is no inventory available in the warehouse to pick.

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