Share
ReportHi,
i created a company but the functional currency is became default as euro. i need to change to SAR. Please advice
*This post is locked for comments
You’re offline. This is a read only version of the page.
5,195
Hi,
i created a company but the functional currency is became default as euro. i need to change to SAR. Please advice
*This post is locked for comments
Thank you Refeesh. Have a great day.
Hi Derek Albaugh,
created new company and updated as advised.thanks for valuable information
Hello Refeesh, I wanted to respond to this, as we do not support manually changing anything for Dynamics GP directly through the SQL tables such as this script.
To answer your question, Microsoft Dynamics GP will not allow a change to the functional currency of a company on the Multicurrency Setup Window, once transaction activity or transaction balances already exist for it. This is because the information that is assigned to all transactions and exchange rates, gains, losses, and other Multicurrency information are all based on that defined functional currency. The number of records and manual calculations that we will need to accomplish for this will be more costly than it looks.
As a recommendation, you can create a new company database with the new functional currency and then just bring over the beginning balances into that new company's account using the new currency. The old company will then serve as an archive.
This would allow you to move forward in the new company and still have the correct historical data in the other company if needed.
Knowledge Base 872709 (How to copy setup tables from one company to another in Great Plains) may prove to be of help to you on this task. Here is the link that you can use to access this article:
mbs.microsoft.com/.../KBDisplay.aspx;EN-US;872709
Another way to change it would be to restore the company database prior to setting the functional currency but they will have to re-enter all transactions that was created after it back into the database.
Hopefully this better answers your question,
Thank you
hi all,
i found the solution by updating the table
update <COMPANYID>..MC40000 SET funlcurr = 'Z-US$', FUNCRIDX = '1032', RPTGCURR = 'Z-US$', RPTCRIDX = '1032'
thanks,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (