Tuesday, March 19, 2019

Opportunity Saved Search > Set Date Range and Preview > The Exchange Rate being used is wrong

The exchange rate in an Opportunity record is based on the last value (from "As of " field) in List > Accounting > Currency Exchange Rates

* The last effective date within the chosen "As of" will be considered.

If there are inconsistencies in the exchange rates when viewing the Opportunity list, check what date filter is being used in the saved search.

In an Opportunity record, there are many date fields. Samples are Date Create, Expected Closed Date, Date, etc.

Since the exchange rates are computing based on the transaction date, then the "Date" field should be the field to be added under the Available filters of the saved search.

Steps to Resolve:

1. Navigate to Reports > Saved searches > All saved searches > New.
2. Click Opportunity.
3. Go to Results tab > Columns sub tab > add the following fields:

- Date
- Number
- Title
- Formula Date.. Formula = {datecreated} .. Custom label = Date created

4. Available filters tab:
 - Date > Show as footer = Yes

5. Save and Run

6. At the foot of the screen, set the date range.

Actual result: The exchange rate used is correct.

No comments:

Post a Comment