Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Changing Exchange Rate Table ID

Posted on by 250

Hi all,

i have a customer that has 2 GP server (GP 8 & GP 2010), these server is going to be merged in to 1 (the GP 8 companies will be upgraded to GP 2010).

I'm thinking of the following:

1. Create new companies in the GP 2010 server (using GP 8 company ids)

2. Upgrade the GP 8 companies to GP 2010

3. make backup of step 2 and restore to the new companies created in step 1

But there are 2 more complications in this 2 server...

1. The Currency index changed (eg. in GP 8 for SGD index = 1008 but in GP 2010 for SGD its 1010)

2. They are using different Exchange Table IDs. (eg. in GP 8 Exchange table id = EUR but the same exchange table in GP 2010 the id is EUR-SGD)

Can anyone advise a script to update the GP 8 companies and change all Exchange Table values  and Currency Index to use the ones from GP 2010?

or

Can anyone advise which tables should i be updating?

The user is using GL, AR, AP, FA, BR, SOP, POP, Inventory

Thanks.

Ben

*This post is locked for comments

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans