E1: 45: Canceled Split Line Does Not Cancel Associated Free Good Line (Doc ID 2201932.1)

Last updated on NOVEMBER 08, 2016

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

EntepriseOne 9.1
With a sales order line with a quantity greater than 1.000, and a Free Good line associated to it, the Pick Slip Print UBE (R42520) splits the line as the item is hard-committed and lot-controlled. When lines are split, which associated lines are associated to which free good lines?

With a sales order line with a quantity greater than 1.000, and a Free Good line associated to it, the Pick Slip Print UBE (R42520) splits the line as the item is hard-committed.

With a quantity of 2 and an associated Free Good line with a quantity of 2, location quantities of 1 at each location, the sales order details is defined as follows after R42520 hard commits the detail lines:
Line Number 1.000 - Sellable End Item with a Quantity of 1.
Line Number 1.001 - Sellable End Item with a Quantity of 1.
Line Number 1.010 - Free Good Item with a Quantity of 1.
Line Number 1.011 - Free Good Item with a Quantity of 1.

When canceling Line Number 1.001, the system does not cancel the associated Free Good Line which would seem to be Line Number 1.011.

STEPS TO DUPLICATE

1. Create Price Adjustment Definition - P4071

2. Create an Adjustment Schedule - P4070

3. Create Adjustment Schedule Details - P4072

4. From the Schedule Details, define the Free Goods Revisions (P4073). In this example, every time you order Item A, you get an Item A free.

5. In the Summary Availability (P41202), for purposes of this test, ensure that availability is at different locations with a quantity of 1. In this example, we’ll need four different locations each with quantity available of 1.

6. Create sales order via P4210 for a quantity of 2. Not the Free Good Line.

7. Run Pick Slip Print (R42520). Note that the Processing Option 1 of the Process tab of R42520 must be defined as ‘1’ to hard commit the inventory.

8. In P4210, notice that the ales order detail lines split to reflect the on hand inventory. Lines 1.000 and 1.001 are the items to be sold, with 1.100 and 1.011 being associated with the free goods items.

9. Customer Service Inquiry shows the Original Order Number on the Free Goods Lines.

10. Cancel the second line in the sales order, Line 1.001. Note that what would seem to be the Free Good line associated to it, Line 1.011, is not canceled.

11. In the Data Browser, the F4211 reveals that the Original Line Number is 1.000 for both Free Good lines which doesn’t seem to be correct. THIS is the reported issue.

12. To take the issue further, cancel Line Number 1.000.

13. Notice that Free Good Line 1.011 is still not canceled.

14. In the Data Browser, it is confirmed that Line Number 1.011 is not canceled.

15. Now run another test with a new sales order with a quantity of 1 with the free good line coming in as well.

16. Cancel Line Number 1.000.

17. Notice that both Line Number 1.000 and Line Number 1.100 are correctly canceled.

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