Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

New Company with different base currency

Posted on by Microsoft Employee

Dear experts, I'm pretty new to Navision 2013 so I need someone to shine some light on this. My Nav is setup with USD as the base currency for all the companies. Normally I do a copy of a company (template) with USD as the LCY. I need the new company to have another currency as the LCY. What do I need to change? Is it just the currency settings and general ledger setup? Thanks in advance.

*This post is locked for comments

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: New Company with different base currency

    You need brute force to get it clean again, no other way possible. Since the currency code will be the LCY, and you've already posted with it, the exchange rate should be 1:1. As long as nobody enters a different exchange rate, and the posting routine always finds an exchange rate (in the allowed date range to be posted), then you're sort of fine. The only additional restriction is that you can only post in LCY with explicit currency code to these bank accounts. Others are not really an issue, except from "cleanliness".

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: New Company with different base currency

    In the case that you already have transactions done on that currency what steps should you take to ensure you get back to your setup explained above since you can't delete the currency then directly.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: New Company with different base currency

    No. It does not mean field is empty.

    It is may be because your NAV partner has removed the field from the master card. You should contact your NAV partner and asked them to add the field.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: New Company with different base currency

    Hi,

    As a standard NAV, "Currency Code" field is available on the "Foreign Trade" tab.  Do you mean that the "Currency Code" field is missing from the Customer / Vendor page?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: New Company with different base currency

    Hi Tharanga, the field is not there. I suppose if it's not there the field is basically empty?

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: New Company with different base currency

    About your second question,

    It seems it is a modification done to Dynamics NAV and will not be able to provide a solution for that without knowing the modification. Best thing is to contact your partner and discuss about the modification.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: New Company with different base currency

    In the "Invoicing Tab" under "Foreign Trade" you will be able to see the Currency Code assign for the vendor, customer.  

    If the field is not there you might have to contact your partner and ask him to add the field to your page.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: New Company with different base currency

    Thanks Jens and Tharanga. I've checked those places you've mentioned and the only input I find is foreign currency. There's no LCY options in Customers, Vendors or Banks. Am I missing something? Also due to we having multiple companies, my vendor setup a sync feature whereby all COA, Vendors, Customers, Exchange rates can be sync across all companies from the "main" company. Is there a way I can block the sync of currencies to this new company so that the usual base currency won't overwrite the new currency of this new company?

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: New Company with different base currency

    What Jens mention was if your new currency is GBP and if you have define "GBP" in the Bank, Customer, Vendor accounts as currency then you will have a issue. Because NAV always get "" as the default currency code.

    Therefore make sure you have not define your new local currency code in any other sub ledgers. If you have define, then NAV will start on looking for a exchange rate for GBP in the exchange rate table.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: New Company with different base currency

    Hi Patrick,

    yes. Local Currency has code '' in a company. If you copy your master data into the new company, you need to make sure that the new local currency code (only present in G/L setup) is nowhere set in the bank, customer, vendor records, because it's LCY and should be empty.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans