E1: 42: Backorder Release (R42118) Splitting Lines When Inventory Not Available
(Doc ID 1923440.1)
Last updated on NOVEMBER 22, 2019
Applies to:JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
Information in this document applies to any platform.
After upgrading from ERP 8.0 to 9.1, the client finds that sales order lines with no inventory available are being split into two lines. This occurs when the branch availability definition is set to NOT subtract soft committed quantities and when the Backorder Release (R42118) processing option “include backorder quantity as available quantity” is set to 1 (add backorder quantity as available quantity). Backorder Release (R42118) should not split sales order lines with no inventory available into two lines
The issue can be reproduced at will with the following steps:
1. The Branch Plant Availability Definition (P41001) is setup so that the Quantity Soft Committed to SO WO is NOT subtracted from the On-Hand quantity to calculate Quantity Available.
2. The Manufacturing Constants (P3009) are setup so that inventory is HARD committed at the time of inventory creation of the parts list even if there is no inventory quantity available.
3. Enter a sales order (P4210) that is future dated.
4. A manufacturing Work Order for 10 units is entered which creates a hard commitment of 10 units with 0 inventory on-hand.
The Item Availability Inquiry (P41202) shows the Quantity On-Hand = 0, Quantity Available = -10.000 (because of the work order hard commitment) and Future Committed Quantity = 50.000.
5. The Recommit Future Committed Orders (R42995) is run, which causes the Quantity Shipped (SOQS) to be changed to 50.000 and the Quantity Backordered (SOBK) to 0.000.
6. Item Availability (P41202) now shows On-Hand = 0.000, SO Soft Commit = 50.000, WO Hard Commit = 10 and Available = -10.00
7. Run the Commitments (R42997) program which resets the Quantity Shipped (SOQS) to 0.000 and the Quantity Backordered to 50.000.
8. Item Availability (P41202) now shows On-Hand = 0.000, SO Soft Commit = 50.000, WO Hard Commit = 10 and Available = -10.00 and Backorder = 50.000.
9. Backorder Release (R42118) processing option “include backorder quantity as available quantity” is set to 1 (add backorder quantity as available quantity)
10. Run Backorder Release (R42118). Even though there is no inventory available to satisfy the order, order the line is split into two lines with 40.000 backordered on one line and 10.000 backordered on the other line. The client does not understand why the line is split.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document