My Oracle Support Banner

E1: 45: Sales Order Entry (P42101) Calculates the Gross Margin Price Adjustment (Basis Code = 9) Incorrectly (Doc ID 3013234.1)

Last updated on MARCH 28, 2024

Applies to:

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

Symptoms

Sales Order Entry (P42101) is calculating the Gross Margin Price Adjustment (Basis Code = 9) incorrectly. The 45% margin should result in a price of 1,013.073 but instead the price is calculated as 20.22.

Note: No Customer or Personal Data is revealed below. Fictitious names are used for Adjustment and Group Names and Category Code Values

Steps to Reproduce:

  1. Item Price Group (P4092 Version ZJDE0001) is setup based on Item Category Code SRP3
  2. Customer Price Group (P4092 Version ZJDE0002) is setup based on Customer Category Code AC21
  3. Price Adjustment Definition (P4071) has the following setup:
    1. Line Level Adjustment
    2. Print on Document
    3. Item Price Group = XXSRP3
    4. Customer Price Group = XXC21
    5. Override Price Checkbox is checked
    6. Manual Add/Change checkbox is checked
    7. Quantity Level Break
  4. Price Adjustment Detail (P4072) has the following setup:
    1. Basis Code = 9 (Gross Profit %)
    2. Factor Value = 45.000 (45%)
  5. Price Adjustment Schedule (P4070) has 6 adjustments in the schedule
    1. Gross Profit Adjustment is the 5th of 6 adjustments in the schedule
  6. Customer Billing Instructions (P03013) has Price Adjustment Schedule populated.
  7. Customer Category Codes (P03013) has Category Code X1 (AC21) = H51
  8. Item Branch Category Codes (P41026) has Sales Category Code 3 (SRP3) = X9
  9. Item Cost Ledger (P4105) has the following setup
    1. Sales/Inventory Cost Method = 07 (Standard Cost)
    2. 07 Cost Amount = 557.19
  10. Enter Sales Order (P42101) for customer, item and branch plant with Gross Margin Adjustment
    1. Unit Price is defaults as 20.22
    2. It should be 1,013.073 based on the formula 45% = (1013.013 – 557.19) / 1013.013
  11. Check Price History (P4074)
    1. Gross Margin Price Adjustment was retrieved and applied but the Amount calculated is 20.22 and it should be 1,013.073 based on 45% gross margin over a cost of 557.19.

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
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.