My Oracle Support Banner

E1: 42: Sales Repost (R42995) Does Not Repost Sales Header Amount Total Cost (F4201.TOTC) (Doc ID 2891157.1)

Last updated on OCTOBER 27, 2023

Applies to:

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

Symptoms

Repost Active Sales Orders (R42995) does not repost the Sales Order Header Total Cost Amount (F4201.TOTC).

Steps to Duplicate:

  1. In the Order Hold Constants (P42090) setup an Order Margin Hold (M1) as follows:
    1. Upper limit is blank. A high profit margin on the order is fine
    2. Lower Limit is 10%. The sales margin for the entire order (sum of all lines) mist be at least 10%
  2. Setup a version of SO Entry (P4210) with Order Holds Tab Option #2 (order Margin Check) set to M1.
  3. Create a three-line sales order:
    1. Line 1, Extended Price=300.00, Extended Cost = 290.00, % Margin +3.33%
    2. Line 2, Extended Price=125.00, Extended Cost = 150.00, % Margin -20%
    3. Line 3, Extended Price=200.00, Extended Cost = 150.00, % Margin +25%
    4. Order Total, Extended Price=625.00, Extended Cost = 590.00, % Margin +5.6%
    5. Order should go on M1 Hold
    6. Save the order
  4. Order goes on M1 Hold as expected.
  5. Check the Sales Order Header Open Amounts
    1. Order Amount (F4201.OTOT) = 625.00
    2. Total Cost (F4201.TOTC) = 590.00
    3. Order Profit Margin = 35.00
  6. Using Release Held Orders (P43070) Release the M1 Hold
  7. Process Lines 1 and 2 through Sales Update (R42800) but leave Line 3 open.
  8. Check the Sales Order Header Open Amounts and they are unchanged
    1. Order Amount (F4201.OTOT) = 625.00 – should be 200.00
    2. Total Cost (F4201.TOTC) = 590.00 – should be 150.00
    3. Order Profit Margin = 35.00 – should be 50.00 (200.00-150.00)
  9. Setup a version of Sales Repost (R42995)
    1. Set Repost Tab Option #1, #2 and #4 = 1 (Bypass update)
    2. Set Repost Tab Option #3 = Blank (Update order header total)
  10. Run Sales Repost (R42995) version
  11. Check the Sales Order Header Open Amounts and they are unchanged
    1. Order Amount (F4201.OTOT) = 200.00 – CORRECT!
    2. Total Cost (F4201.TOTC) = 590.00 – INCORRECT should be 150.00
    3. Order Profit Margin = -390.00 – should be +50.00 (200.00-150.00)

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.