How to input additional exchange rate which is different from the reporting currency?

(0) Share

Report

Posted on by Community Member

We have maintained 4 currencies (USD, EUR, JPY and SGD) in our system. As per tax authority requirement, we are required to input the exchange rate as per the supplier's tax invoices (For example, Invoice amount is USD, the input tax should be based on Singapore dollar amount shown in the supplier tax invoice). How can we do this without editing the currency table?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

[quote user="piggyyew"]

We have maintained 4 currencies (USD, EUR, JPY and SGD) in our system. As per tax authority requirement, we are required to input the exchange rate as per the supplier's tax invoices (For example, Invoice amount is USD, the input tax should be based on Singapore dollar amount shown in the supplier tax invoice). How can we do this without editing the currency table?

Thank you.

[/quote]

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Hi piggyyew,

usually you are able to change the exchange rate in the invoice at input time. If it's a complicated case, you also can post a general journal with different exchange rates by line, even different currencies per journal line is possible.

Beware of mixed-currency applications, though. The amounts are always revalued with the exchange rate that is the result of querying the currency table at the posting date (of the application). Which is usually unexpected and undesired, but a possible way to handle it.

If you need more information, please contact me by private message. We have developed AddOns to handle multi-currency reporting.

with best regards

Jens

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

You can change the exchange rate on existing journal lines or sales and purchase documents before posting them. Please refere below blog post on How to: Change Exchange Rates When You Post : https://msdn.microsoft.com/en-us/library/hh168300(v=nav.80).aspx

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi Jens,

I can only edit the exchange rate in the purchase invoice instead of journal lines. May I know the AddOns features you have mentioned? I would like to find out more.

Thanks!

Was this reply helpful? Yes No
Jens Glathe 6,092 on at

Like (0)

Report

Hi piggyyew,

sorry for the delay. You can download a flyer for Plexada Transaction Currency here. And if you need open items on G/L entries with full currency support, a flyer for Plexada Open Items here.

with best regards

Jens

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jens,

Does it mean that the mentioned AddOns features are not from Navision itself? The company has to purchase from Plexada? Thanks.

Was this reply helpful? Yes No
Jens Glathe 6,092 on at

Like (0)

Report

Hi piggyyew,

yes, that's true. Microsoft doesn't maintain AddOns themself. It's even more complicated than that. Like most NAV AddOns, the company has to buy from their NAV partner, and they contact us (plexada) for the AddOn. Not an entirely painless process, but it works most of the time. If you need further information please contact me by private message.

with best regards

Jens

Was this reply helpful? Yes No