My Oracle Support Banner

E1: 42: Line Margin Hold Code Not Removed After Item Price Revision on Sales Order When Using Advanced Preference (19) Profit Margin Hold (Doc ID 2796957.1)

Last updated on APRIL 05, 2022

Applies to:

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

Symptoms

Line Margin hold code not removed from sales order line when price revision is done on Sales Order and margin is inside the hold limits when using Advanced Preference (19) Gross Profit Margin.

Steps:

  1. Setup Gross Profit Margin Advanced Preference (19)
  2. Advanced Preference Definition (P4071)
  3. Advanced Preference Detail (P4072) - Take the Row Exit to 'Pref Details' to input the preference limits: Lower 2.5% and Upper 80%
  4. Advanced Preference Schedule (P4070) - Add the advanced preference to a preference schedule (i.e. PROFIT)
  5. P4210 – Processing Options
  6. Tab 10 - Preference - set #3 to "PROFIT"
  7. Tab 22 - Profit Margin - set #1 to "1", set #2 to "ND" and set #3 to "1"
  8. Limit "blank", as the limits will come to play from Adv. Preference
  9. P4210 – Enter a sales order and use item location where price will cause
  10. Profit be over 80%. See the warning: "Gross Profit Exceeds Not Within Range" and "Line 1.000 will go to the following holds"
  11. Click on "Submit and Close" button to save the order. See that the order went to Margin Line Hold (M2)
  12. P4210 – Inquire order back and change the location which has lower price and so, will recalculated the profit. See, % of profit margin now is 40% within the range. Click on "Submit and Close" button.
  13. No warnings this time, as expected however see that Margin Line Hold code is not cleared from order line.

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.