E1: 45: P4210 to Retrieve Prices Defined in Different Currencies from F4072 Table (Doc ID 2253372.1)

Last updated on APRIL 10, 2017

Applies to:

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

Goal

The customer would like for P4210 (SO Entry) to call prices from P4072 (Price Adjustment Details) regardless of the currency in F4072 table.

This will improve Oracle product functionality to meet the market needs. The customer is looking for flexible solutions and it will for sure help if they could maintain the prices in P4072 in one base currency and have P4072 catching and converting back into the order currency in all cases.

Business case:
In Argentina, due to the high inflation they have been facing in the last years, customers are today running all prices offers in USD and no longer ARS.
They are using the P4072 price adjustment detail revisions to store the current price in USD (not in ARS).
However Argentina must legally invoice in ARS. The currencies in the order header is ARS. The orders are thus only domestic (ARS).
The currency functionality of P4210 does not allow for the system to retrieve the prices in USD and convert those in ARS in sales order transactions.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms