My Oracle Support Banner

E1: 45: Check Price and Availability (P4074) Calculates a Non-Zero Amount for a Zero Amount Foreign Adjustment (Doc ID 3002280.1)

Last updated on MARCH 25, 2024

Applies to:

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

Symptoms

Check Price and Availability (P4074) calculates a Non-Zero amount for a Multicurrency Mandatory Price Adjustment with Basis Code 2 (Percent of Current Net Price) or 8 (Add On User Program Amount) and a Factor Value of Zero.

This is similar to the issue fixed in Bug 27509985 - CURRENCY-ZERO VALUE ADJUSTMENT INCORRECTLY CALCULATED AS .0001 CAUSES OOB IB, which only corrected the issue for Adjustments with Basis Code 5.

Steps to Reproduce:

All Data Referenced Below is JD Edwards Demo Data. No Customer or Personal Data is Used.
  1. Setup a Price Adjustment Definition with the following setup
    1. Line Level Adjustment
    1. Adjustment Control Code 1 (Do Not Print on Document.
    2. Mandatory Adjustment Checkbox checked
    3. Apply Absolute Value Checkbox checked
    4. Quantity Level Break Selected
  2. Create an Adjustment Schedule (P4070) with just the one adjustment on it.
  3. Customer 5255 has Mexican Peso (MXN) Currency.
    1. On Customer Billing Instructions, for Mexican Customer 5255 populate schedule.
  4. Price Adjustment Detail (P4072) has the following setup:
    1. Customer Number = 5255
    2. Item = 230
    3. From Level = 1
    4. UOM = EA
    5. Basis Code = 2 (Percent of Current Net Price)
    6. Factor Value = Zero
    7. Currency Code = USD
  5. Price Adjustment Schedule (P4070) includes the Mandatory Adjustment name.
  6. Run Check Price and Availability (P4074)
    1. Enter Sold To and Ship To Customer Address = 5255
    2. Enter Branch Plant with USD Currency = 30
    3. Enter Adjustment Schedule Name = PESCH
    4. Enter Item Number = 230
    5. Quantity From = 1
    6. Click Find
    7. Exchange Rate Defaults as 17.45000 MXP per USD
    8. Mandatory Price Adjustment is returned with a Foreign Unit Price of .0004 MXP when it should return a Foreign Unit Price of .0000 MXP

Adjustment has Factor Value Numeric = Zero

Adjustment Calculates Non-Zero Amount of .0004 MXN

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.