425
Can I change the functional currency of a firm that has NO transactions posted to it ?
I beleivethat i can chagne the currency in the SQL table but need to know which tables i need to change. I understand that this may not be supported but sincewe have not posted any thing we should be ok to change correct
*This post is locked for comments
I have not done this through SQL, and frankly, I would be hesitant to try. Besides changing the MC setup, I would think you'd need to go through every single table that has a currency ID and might have data and possibly change all the records. Maybe not, but I would at the very least want to check that.
Thats what i thought as well but got the message telling me there was activity on the currency. After this message i checked and there were some batches entered ( unposted). We are going to remove and tattempt again. If not do you know the tables to change this SQL?
Thanks
Don,
Not sure if you have tried this, but if there are no transactions posted, I think you should be able to change the functional currency in the GP UI, without having to do it in SQL.
Found a similar post in the forum
I recommended you to create a new company and setup functional currency you want. If you need to change the functional currency for your current company you may need to update the functional currency index (FUNCRIDX) and currency id(FUNLCURR) in MC40000 for your company in the database and run checklinks for Multicurrency setup table. But do this after taking a backup of your System and Company databases.
Please note that the FUNCRIDX and FUNLCURR points to CURRNIDX,CURNCYID of MC40200 of System database. So you need to update all fields in MC40000 based on MC40200.
Hope this helps.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
