Change of Currency on Sales Order Header Error: 'Price List Currency(USD) Must Match Order Currency (CAD). Please Also Verify If Pricing Date Falls in between Start Date Active and End Date Active of Your Price List Setup' (Doc ID 1953342.1)

Last updated on APRIL 03, 2024

Applies to:

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

When attempting to enter an order in a currency (CAD) other than the defaulted currency (USD) on the sales order header record,
the following error occurs.

ERROR
-----------------------
 Price list currency(USD) must match order currency (CAD). Please also verify if pricing date falls in between start date active and end date active of your price list setup.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Set the QP: Multi Currency Installed profile option to Yes.
    Responsibility: System Administrator
    Navigate to: Profiles > System
2) From Oracle Pricing Manager > Reports > Run the program 'Update Price Lists with Multi-Currency Conversion Criteria’.
3) The price lists were all updated automatically to use the "Generated Currency Conversion For USD 3"
     Responsibility: Oracle Pricing Manager
     Navigate to: Price Lists > Price List Setup
     Query price list name = Corporate Price List
      Currency = USD
      Multi-Currency Conversion = Currency Conversion For USD 3
4) Responsibility: Oracle Pricing Manager
    Navigate to: Price Lists > Multi-Currency Conversion Setup
    Query Name = Currency Conversion For USD 3
    Shows one record:
    To currency code: CAD
    Conversion type : Corporate
    Conversion date type: PRICING_EFFECTIVE_DATE
5)  Enter Daily Rate
     Responsibility: General Ledger Super User
     Navigate to: Setup > Currencies > Rates > Daily
     Add a conversion rate for today (the pricing date on the order).
     For example, "Daily Rates"
        From: USD To:CAD Date: 13-NOV-2014, Type: Corporate
                 USD to CAD: 1.088565705 and CAD to USD: .91864

6)   Responsibility: Order Management Super User (or equivalent)
7)   Navigate to: Orders, Returns > Sales Orders
8)   Enter Customer
9)   Price List: Corporate Price List
10) Currency: CAD
11) Conversion type: Corporate

Changes

Enabled multi-currency feature in Advanced Pricing.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.