E1: 42: Direct Ship Credit Order from History (P4210) Prevents Cost Override During Entry (Doc ID 3071457.1)

Last updated on FEBRUARY 24, 2025

Applies to:

Symptoms

After upgrading the Tools Release from 9.2.3.3 to 9.2.8.2 and Upgrading the Applications Release to UN8, when creating a Credit Order from History (CO) that creates a Related Direct Ship Purchase Order (OC), and manually overriding the Extended Price and Extended Cost on the Credit Order (CO), the Overridden Extended Cost is not retained, and is recalculated based on the item unit of measure conversion.

Steps to Reproduce:

1. Item is a hamburger bun and has the following setup in the Item Master (P4101)

• Primary UOM is EA
• Pricing UOM is CS
• Purchasing UOM is CS
• d. Conversions:
  • 1 BG = 8 EA
  • 1 CA = 12 BG
  • 1 CA = 96 EA
• Unit Cost = 0.1932 per EA
• Unit Price = 21.18 per CA

2. Create a Sales Ledger Inquiry (P42025) version as follows:

• Version Name SD
• Defaults Tab
  • Order Type SD
• Credit Memo Tab
  • Status for Credit Orders 620

3. Create a version of Direct Ship Credit PO Entry (P4310) as follows:

• Version Name = OC
• Defaults Tab
  • Order Type = OC
  • Line Type – DC

4. Create a version of Direct Ship Credit SO Entry (P4210) as follows:

• Version Name CODC
• Defaults Tab
  • Order Type CO
  • Line Type DC
• Version Tab
  • PO Entry (P4310) Version Called OC
  • Sales Ledger (P42025) Version Called SD

5. Start Direct Ship Credit Order (P4210 Version CODC) click Add (+) to add a Credit Order from History

6. Take Form Exit to Credit Memo

7. Find the Direct Ship Order for the return (619 SD)

• Quantity Ordered = 1,120 Cases (CA)
• Amount Ordered = 23,721,86
• Extended Cost = 20,772.86

8. Take Row Exit to Credit Memo > Select Line and click the Close (X) button

9. On the Credit Order screen the historical sales order data comes in as follows:

• Quantity = -1,120 CA
• Secondary Quantity = -107,520.00 EA
• Unit Price = 21.18 per CA
• Extended Price = -23,721.60
• Unit Cost = 0.1932 per EA
• Credit Order (CO) Extended Cost is -20,772,86 (-107,520 EA x 0.19032 Unit Cost per EA)
• Purchase Order Extended Cost is also -20,772,86 (-1,120 CA x 18.5472 per CA)

10. For this return the customer wants the Quantity Returned to be -1 CA and Extended Price and Extended Cost to be the same (-4.05). Customer Manually overrides the following fields:

• Quantity Ordered = 1 CA
• Secondary Quantity Ordered = 1 CA
• Unit Price = 4.05
• Unit Cost = 4.05
• Purchase Order Unit Cost = 4.05
• Edit the line

11. When the line is edited some of the manually overridden values are recalculated.

• Secondary Quantity was changed from -1 CA to -96 EA
• Extended Cost was changed from -4.05 to -388.80 (-96 EA x 4.05 per EA)
• The client expects the manually entered values to be retained.
• The recalculation causes the customer to be credited for -4.05 but the supplier is credited -388.80.

Cause

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