How to set Currency divide by the exchange rate?

(0) Share

Report

Posted on by Patricia Oh

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.

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Patricia Oh 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

If you go to the Currency page you will the exchange rate amount there, you can use that to manipulate your data.

Was this reply helpful? Yes No
Patricia Oh 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nitin,

Aside manipulate the exchange rate, can it be done for a currency divide by the exchange rate?

Thank you

Was this reply helpful? Yes No
Verified answer

Gavin 2,510 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

thedynamicsexplorer.com/.../

Hope this helps.

Thanks

Gavin

Was this reply helpful? Yes No
Patricia Oh 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Gavin,

Thanks for your helps! It resolved my concern.

Patricia

Was this reply helpful? Yes No