Purchase Invoice Exchange Rate and the Currency Conversion Rate Setting
You can now edit the exchange rate of a purchase invoice’s currency from the invoice itself, just as you can in sales invoices and journal entries, instead of relying only on the system rate. A new setting in Purchases Settings controls this, and the edited rate applies only to that invoice unless you choose to save it as the system rate.
In this article
Configuration
Control how the system handles currency rates when you use currencies other than the default currency in invoices.
| Option | On-screen description | Effect |
|---|---|---|
| View | Show the currency conversion rate field, where the user can edit the currency rate manually, with an option to update the system rates with the entered value. | The rate field appears in the currency window of the purchase invoice, and the rate fields appear when you pay a purchase invoice in a different currency. |
| Hide (default) | Hide the currency rate field and apply the automatic conversion rates set in the system. | The system rate is used automatically. |
The rate field in the purchase invoice
- Click the currency in the invoice header to open the currency window, then click Update after you make your changes.
- Item prices are recalculated immediately after you change the rate, both when adding and when editing.
| Field | Mandatory? | Default | What it does |
|---|---|---|---|
| Currency | Mandatory | Default Currency | The invoice currency |
| 1 [Currency] = [Rate] [Account Currency] | Appears when you select a currency other than the account currency | The system rate or the live rate on the invoice date | The invoice rate; it applies to this invoice only |
| Update System Rate | Optional | Disabled | Saves the rate as a new record in Currency Rates with the invoice date |
Where does the field appear?
- Only in Purchase Invoices (when adding and editing).
- It does not appear in Purchase Refund, Purchase Debit Note, or Purchase Credit Note, even though they use the same form.
- It does not appear if the invoice currency is the account’s base currency.
What happens after you save?
- The invoice entry is posted at the entered rate.
- This rate is used later when calculating the currency difference in purchase invoice payments made in a different currency.
- If you enable Update System Rate, a new rate record from the invoice currency to the account currency is added, starting from the invoice date.
Where does the suggested rate come from?
- The latest rate in Currency Rates that starts on or before the invoice date.
- If there is no local rate, the currency’s live rate is used.
- When you change the invoice date or the currency, the rate is suggested again.
Why doesn’t it work as I expect?
| Problem | Reason | Solution |
|---|---|---|
| The rate field does not appear | The setting is Hide, the document is not a purchase invoice, or the currency is the account currency | Review the conditions |
| The rate was not added to Currency Rates | You did not enable Update System Rate, or the currency is the account currency | Enable the option before saving |
| Item prices changed after editing the rate | Recalculation happens immediately | Expected behavior; review the items |
| The refund has a different rate | The refund has no rate field and is settled at the original invoice’s rate in payments | Expected behavior |
Related settings
| Setting | Effect |
|---|---|
| Currency Conversion Rate in Sales Settings | The same field for sales invoices |
| Update Journal Entries Currency Rates | Edit the rate in manual journal entries |
| Currency Rates | The source of the suggested rate |
FAQs
Why doesn’t the rate field appear in the refund?
The field is available in purchase invoices only.
Does editing the rate change the system rates?
No, unless you enable Update System Rate.
Does this setting affect Purchase Invoice payments?
Yes, the same setting shows the rate fields when you pay a purchase invoice in a different currency.
What is the default value of the setting?
Hide.
Can you edit the rate after saving?
Yes, from Edit Invoice, and the system recalculates the accounting and the journal entry.
Is the rate recorded in the Activity Log?
The change to the invoice appears in its Activity Log.
Can you use a rate with more than 4 decimal places?
Yes, the field is numeric and accepts decimals.