SBX - Search With Button

SBX - Forum Post Title

Add new company with different currency to existing system

Microsoft Dynamics SL Forum

Ronald Harper asked a question on 3 Jul 2018 2:49 PM

Question Status

Unanswered

We have an existing system using US base currency. We need to add a Mexican and Canadian company to our environment and they use their native currency. Can we add these companies to our existing database, which would make life a lot easier for our financial team or would we need to create new separate databases for the new companies. Either way can you provide guidance on the best Microsoft recommended solution?

Thanks,

Ronald

Reply
rcboiler responded on 5 Jul 2018 1:38 PM
My Badges

How many system and application databases do you currently have?

Reply
Ronald Harper responded on 6 Jul 2018 8:14 AM

We have 1 system and 1 application database. We are adding two new companies, from Mexico and Canada.

Reply
rcboiler responded on 6 Jul 2018 9:16 AM
My Badges

Separate dbs are typically used when transactions are done in their own currencies.  Do you have the multi-company module?

Reply
Ronald Harper responded on 6 Jul 2018 9:56 AM

we do. We hoping to use one database for all the companies but it looks like if you have multiple base currencies it requires multiple databases.

Reply
rcboiler responded on 11 Jul 2018 11:26 AM
My Badges

I believe you are correct if wanting to use different base currencies.

Reply
Lisa responded on 13 Jul 2018 4:01 PM
My Badges

The rule of thumb if you want to have different base currencies in a multi-company environment for several companies then you will need to have separate databases.   If you want to have several companies in the same database then all companies need to have some things in common and the base currency is just one of them.

Reply

SBX - Two Col Forum

SBX - Migrated JS