Scenario 2:
User cannot update or change the date on an existing expense report and encounters the error:
“Exchange rate cannot be changed on an existing Expense Report.”
Findings and Explanation
When the user updates the Date field on an existing Expense Report, NetSuite automatically evaluates the exchange rate associated with the new transaction date.
Because exchange rates are date-dependent, changing the transaction date may result in a different effective exchange rate. If the newly calculated rate differs from the original rate stored on the transaction, NetSuite prevents the update and displays the error:
“Exchange rate cannot be changed on an existing Expense Report.”
The exchange rates used by NetSuite are maintained in the Currency Exchange Rates list:
- Navigate to Lists > Accounting > Currency Exchange Rates
The Exchange Rate field displayed on the Expense Report always reflects the effective rate associated with the transaction date.
As a result, changing the transaction date is not considered a simple date modification. It is treated as a change that impacts the financial or GL impact of the transaction because the exchange rate is also affected.
Users may only change the transaction date if both dates share the same exchange rate. If the exchange rate differs between the original and updated dates, the transaction cannot be saved.
Similar to the first scenario, NetSuite does not generally allow exchange rate overrides in order to maintain financial integrity and prevent unauthorized modifications.
Recommendation
The recommended solution is to create a new Expense Report using the desired transaction date.
Moving forward, users are advised to verify the transaction date before saving Expense Reports to ensure the correct exchange rate is applied and to avoid future editing restrictions.
Related SuiteAnswer: 92548 | Resolve Currency Field on Mainline of Saved Expense Report Cannot be Edited