32
Hi everyone,
I need some help.
I would like to have foreign currency calculate to local currency by divide the exchange rate, instead of multiply by the exchange rate.
I have no idea how it can be done.
Thanks in advance for your help.
Hi Gavin,
Thanks for your helps! It resolved my concern.
Patricia
Hi,
Not sure if this helps but when adding your exchange rates you can either enter the rate in the "Exchange Rate Amount" field or the "Relational Exch. Rate Amount" field.
For example below on the 01/03/23 I've entered my rate in the "Exchange Rate Amount" box. This is effectively saying 1.67 SGD is equal to 1 GBP (my LCY currency). In the 01/04/23 row I've entered the rate into the "Relational Exch. Rate Amount" field. This is effectively saying 0.6 GBP is equal to 1 SGD.
These rates produce similar results on the journal:
I also wrote this article on exchange rates for my blog:
Hope this helps.
Thanks
Gavin
Hi Nitin,
Aside manipulate the exchange rate, can it be done for a currency divide by the exchange rate?
Thank you
If you go to the Currency page you will the exchange rate amount there, you can use that to manipulate your data.
Hi Nitin,
Am referring to divide a currency by the exchange rate
Example:
Local currency is in USD. In the exchange rate table, SGD Currency exchange rate at 1.33
A Purchase Invoice at SGD 1,000. Wish to set the BC to convert SGD 1000 into local currency, by divide the exchange rate 1.33 during the Purchase Invoice entry.
Currently it converts by multiply the exchange rate.
Thank you
If you are talking about to see the what is the total amount in your local currency would be if you are using Sales Invoice or Purchase Invoice so in that case you consider the Amount (LCY) in both the documents, it will show you local currency amount.
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (