Hi,
Can someone please tell me what is the technical table name for the Exchange Rate Table in GP 2013?
I want to be able to query the table via SQL.
Thanks
*This post is locked for comments
MC00100
Multicurrency Exchange Rate Maintenance - System (Dynamics database, not company)
MC_Exchange_Rate_MSTR
Hi Harry,
Thanks for you reply.
When I query against this table name in my database; there is an error.
The table name is not in the database.
Error: Invalid object name 'MC00100'
Please advise.
You are likely querying the company database, and not the Dynamics (system) database. I was just clearing that up in my post.
Yes you are correct I was running a query against the company database.
Thank you for the Answer.
Do you think it is wise to insert new records of exchange rates on a daily basis? Or is this something for Integration Manager
Most importantly, humans are error-prone, and mistakes in this table will have far-reaching ripple effects. Depending on the frequency with which your finance team feels they need updates to this table, I think it is practical to update this table automatically instead of having humans do it.
Thank you for all your help.
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.
