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
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,
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 Derek Albaugh,
created new company and updated as advised.thanks for valuable information
Thank you Refeesh. Have a great day.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
