RE: Copy database from one site to another
That's one of the things I tell customers is a requirement to verify, before moving a company database over from one Dynamics GP environment to another:
The functional currency being used by the company database(s) being migrated over, must be setup the same as a currency in the DYNAMICS/system database that you're moving the company database under:
>Against the DYNAMICS/system database, you can look at this table:
Select ISOCURRC, * from MC40200
>Against the company database(s) you’re looking to migrate, look at this table:
Select * from MC40000
The FUNLCURR value(s) from the MC40000 table of the archived company database must exist in the MC40200 table of the DYNAMICS/system database you're moving it to, as well as the FUNCRIDX, RPTGCURR, RPTCRIDX values from the MC40000 table must match that for the same currency in the CURRNIDX and CURNCYID column values of the MC40200 system table.
There really isn't a supported option or process for fixing this after the fact, especially when the company database already has transactions in it.
You can try and manually make the changes in SQL, changing the currency index to match what the system database in the new environment shows, but there are a large amount of those tables and we can't verify whether you'll run into issues by doing that.
Is there a way you can leave the pre-existing transactions as is and use the new currency and index in future transactions, without errors or issues? If so, you'd probably want to go that route.
Others in the Community may have some other options for you........
Thanks
