Managing Stale Exchange Rates in ERPNext
ERPNext allows you to fetch currency exchange rates automatically from supported exchange rate providers or use previously saved exchange rates, known as Stale Exchange Rates. This provides flexibility when working with foreign currency transactions, especially in environments where exchange rates do not need to be updated continuously.
If the Exchange Rate field in your Sales or Purchase transactions is read-only, it is typically because the Allow Stale Exchange Rates setting is enabled in Accounts Settings.
Disabling the “Allow Stale Exchange Rates” option makes the Exchange Rate field editable, allowing users to manually enter or modify exchange rates in transactions.
To access this setting:
Accounting > Accounting Masters > Accounts Settings
1. What are Stale Exchange Rates?
A stale exchange rate is a previously saved currency exchange rate stored within ERPNext. Instead of always fetching the latest market rate, ERPNext can reuse these saved rates for foreign currency transactions.
This feature is useful when:
- Your organization follows predefined exchange rates.
- Exchange rates are updated periodically rather than daily.
- You want consistency across multiple accounting transactions.
2. Why is the Exchange Rate Field Read-Only?
If you cannot edit the Exchange Rate field in a Sales Invoice, Purchase Invoice, or other foreign currency transaction, verify whether the Allow Stale Exchange Rates setting is enabled.
When this option is enabled, ERPNext automatically applies the saved exchange rate according to your currency exchange configuration, making the field read-only.
The read-only behavior helps ensure that users consistently use approved exchange rates across financial transactions.
3. How to Make the Exchange Rate Editable
Follow these steps to enable manual editing of exchange rates:
- Navigate to Accounts Settings.
- Locate the Allow Stale Exchange Rates option.
- Uncheck the checkbox.
- Click Save.
- Refresh your ERPNext session.
- Open the Sales or Purchase transaction again.
After refreshing, the Exchange Rate field becomes editable.
4. When Should You Disable Stale Exchange Rates?
You may want to disable this feature when:
- Exchange rates fluctuate frequently.
- Users need to manually enter negotiated exchange rates.
- Specific transactions require custom exchange rates.
- Your organization follows daily market exchange rates.
5. Best Practices
- Use stale exchange rates when standardized rates are required across the organization.
- Disable the feature only for users who need to manually adjust exchange rates.
- Verify exchange rates before submitting foreign currency transactions.
- Regularly review saved currency exchange rates if stale rates are enabled.
6. Benefits of Using Stale Exchange Rates
- Ensures consistent exchange rates across transactions.
- Reduces manual data entry.
- Supports standardized accounting policies.
- Helps maintain uniform financial reporting.
