My Oracle Support Banner

E1: 42: P4210 Sales Order displays Incorrect Back Order Quantity For More Lines With the Same Item (Doc ID 2512898.1)

Last updated on OCTOBER 30, 2019

Applies to:

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

Symptoms

Bug 27474027 - INCORRECT BACK ORDER QUANTITY only fixed the issue with the single line. When trying to change the quantity ordered into more sales order lines, that containing same item, the system incorrectly calculates the backordered quantity.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.There is an Item that has Qty on Hand =5 and QTY Available =5 .
2.Create a Sales Order with Activate Availability Checking = 1(Activate,notify, and backorder or cancel) under commitment tab, in the processing options P4210. Enter two lines for the same item for qty of 3 and 2 respectively and save the order .
3.Item availability(P41202) displays now the Qty on Hand =5, Committed =5 and Backorder = blank
4.Inquire on the above order and change the quantity in both line as follow :
  -Change qty of the line 1, from 3 to 10, then drop of the line:
  Qty Backordered = 7, Qty Available = -7, Last Status=520, Next Status = 540
  -Change qty of the line 2 , from 2 to qty 3 then drop of the line:
  Qty Backordered = 3, Qty Available = -8, Last Status=900, Next Status = 540
Save the order.
Notice that for both lines in the sales order , the Qty Backordered is incorrect.
5.Item availability(P41202) has now the Qty on Hand = 5, Committed = 13, and Backorder = 10. The backordered qty is incorrect and must be 8.
There is a total qty of 13 on the order and qty= 5 on hand, so expected only to have 8 on backordered. Instead of this there is 10 qty backordered.


The system must to calculate correctly the backordered qty in the sales order lines and Item availability .

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.