Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

New Company with different base currency

(0) ShareShare
ReportReport
Posted on by

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".

  • 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
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 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,467 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?

  • 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
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 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
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 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.

  • 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
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans