Debasing Currency or Change in LCY

gerrykistler

Does anyone have a tool they have written which will do either of the following:

1) Debase the LCY - divide all LCY amounts everywhere by a set amount
2) Change the LCY from one currency to another - multiply or divide all LCY amounts everywhere based on the currency exchange rate table

If you have something please post a brief description here and if it sounds like something I can use then we can discuss it privately in more detail including compensation.

Chinmoy

Hi Gerry,

Just a very rough and first level thought on this. We have a an table object called "Object Tracking" from where we can get the Ids of all the tables (records with Object Type = Table). Then looping through the fields of each table we should be able to find out the field names which contain the word LCY. We can generate a list of these tables and fields. Then we can write a code which will update all these LCY fields with whatever we intend to.

I do not have any readymade code for this, however, you can do something like this to write a code of your own.

See if this helps..

Chn