Consolidated Exchange Rates on Saved Searches: Current Consolidated Exchange Rate (With Date/Period)

Patricia Rose Ortua-Oracle

Scenario: A Journal Entry was created on September 16, 2025 with the following setup:

• Date = August 22, 2025
• Posting Period = August 2025
• Subsidiary = CANADA New Brunswick
  • Subsidiary's Base Currency = CAD
• Transaction Currency = AUD
• Exchange Rate = 2.00
• Account = 1100 Accounts Receivable
  • General Rate Type per Account record = Current
• Amount = 1,000.00 AUD
  • Amount in GL Impact sub-tab (Base Currency) is 2,000.00 CAD which was calculated as follows:
    • Amount in Transaction Currency multiplied by Effective Currency Exchange Rate
    • 1,000.00 x 2.00
      

Root Parent Subsidiary is Parent Holdings Incorporated with a Base Currency of USD.

To check the Consolidated Exchange Rates between CANADA New Brunswick and Parent Holdings Incorporated, users may follow these steps:

1. Navigate to Lists > Accounting > Consolidated Exchange Rates
2. Set Filters as follows:
   1. From = Transaction Subsidiary (i.e. CANADA New Brunswick)
   2. To = Root Parent Subsidiary (i.e. Parent Holdings Incorporated)
   3. Period = (Select applicable period)

August 2025:

September 2025:

The Transaction Saved Search was set up as follows:

• Criteria:
  • Internal ID = Internal ID of the Journal Entry
  • Account = 1100 Accounts Receivable
  • Posting Period = Aug 2025
    
• Results:
  • Date
  • Period
  • Type
  • Document Number
  • Account
  • Amount
  • Consolidated Exchange Rate = Per-Account
    

The Saved Search returns the following result:

COMPUTATION OF AMOUNT: Amount in GL Impact sub-tab of the transaction (Base Currency) multiplied by the applicable Consolidated Exchange Rate

• Amount in GL Impact = 2,000.00 CAD
• Current Consolidated Exchange Rate for August 2025 = 3.50
  • Which gives us the product of 7,000.00 USD
    

EXPLANATION:

• Applicable Consolidated Exchange Rate = Value set on the Consolidated Exchange Rate field of the Results sub-tab of the Transaction Saved Search.
• Since we have set Per-Account, the system will use the General Rate Type set on the Account record (Current).
• Since there is a posting period filter set on the Criteria of the Transaction Saved Search, the system will use the Current Consolidated Exchange Rate based on the transaction's posting period, which is August 2025.
  • For this specific example, setting Consolidated Exchange Rate field (on the Saved Search's Results sub-tab) to Current will result to the same amount simply because the account's General Rate Type = Current.
  • Setting a Date filter = August 22, 2025 on the Criteria sub-tab of the Saved Search will result to the same amount.