In NetSuite, the exchange rate applied to an Expense Report is determined by the transaction date and the corresponding currency exchange rate available in the Currency Exchange Rates list. Once an Expense Report is created and saved, the exchange rate becomes fixed and cannot be modified. Any attempt to update the transaction in a way that causes the system to detect a different effective exchange rate may result in the error:
“Exchange rate cannot be changed on an existing Expense Report.”
This article explains the scenarios in which this behavior occurs, the reason behind the restriction, and the recommended workaround.
Scenario 1:
Review Existing Expense Report
- Navigate to Transactions > Employees > Enter Expense Reports > List
- Click View on Expense Report 1234 – Test Employee 1
Existing transaction details:
- Currency: British Pound
- Exchange Rate: 1.33048913
Create or Edit Expense Report
- Navigate to Transactions > Employees > Enter Expense Reports
- Select Employee: Test Employee 1
- Set the Date to 5/8/2025
System displays the following:
- Currency: British Pound
- Exchange Rate: 1.32757
Verify Currency Exchange Rate
- Navigate to Lists > Accounting > Currency Exchange Rates
- Set filter:
Results:
- Base Currency: USA
- Source Currency: British Pound
- Exchange Rate: 1.32757
- Effective Date: 5/8/2025
Findings and Explanation:
When the user attempts to update the existing Expense Report, NetSuite compares the original exchange rate stored on the transaction against the current effective exchange rate based on the transaction date.
In this scenario:
- Existing Expense Report Exchange Rate: 1.33048913
- Effective Exchange Rate for 5/8/2025: 1.32757
Since the rates are different, the system prevents the update and displays the error:
“Exchange rate cannot be changed on an existing Expense Report.”
Even if the user is only attempting to modify non-currency related fields such as Class or Segment, the update is still considered a General Ledger (GL) impacting change because the exchange rate on the existing Expense Report is locked and cannot be recalculated or overridden.
NetSuite restricts exchange rate overrides to prevent inadvertent or unauthorized financial changes. The system expects the correct transaction date to be entered during the initial creation of the Expense Report, as this date determines the exchange rate that will be applied.
Recommended Workaround
The recommended workaround is to:
- Unapply the Expense Report from the related Bill Payment
- Create a new Expense Report with the correct:
- Class
- Segment
- Date (if applicable)
Before proceeding, users should confirm the process with their Accounting Team to ensure compliance with internal accounting procedures.