Dynamics Community Forum Thread Details

Search and Replace Values throughout a database

I have a customer looking to "re-implement" multi-currency. They have multiple companies with transactions in each. They have not actually been using rates or currency translations, so far. The problem is that some companies show a functional currency ID of Z-US$, USD, or Z-USD (for example). Of course, I get the "Activity for this functional currency already exists. The functional currency can't be changed." message. I am thinking I need only update the currency IDs to be on my merry way with the re-implementation.

Companies do not all use the same modules, so a static script won't do. I want to avoid having to re-implement each company. To that end, does anyone have a script which would go through all the tables and replace Z-US$ with USD (for example)?

I found this script which does a nice job of finding the values, but I need a script which could replace the value wherever it is found. I vaguely recall there was a utility years back which could do this, but I do not recall who made it or the product name and The Google seems to have been cluttered with other things since.

http://www.gp-dynamics.com/dynamics-gp-command-details.asp?id=90

Thanks in advance!

Quick Links

Leaderboard