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
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
Hi Jens,
Does it mean that the mentioned AddOns features are not from Navision itself? The company has to purchase from Plexada? Thanks.
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!
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
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
[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]
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 (