What are the tables to change when changing base currency

[ardydim]

Hi everybody,
We are planning to change the base currency of our MFGPRO. I wonder if anybody has the list of the tables to be updated or much better if you can share your procedure or codings. We will be using new database. We are using MFGPRO 7.3 and Progress 8.3D in SCO 5.
Appreciate any comment. Tks

 

[oldemanw]

Here is a snippet that will provide you with most tables and fields that refer to currency.

output to currency_fields.prn.
select _file-name format "X(12)", _field-name format "X(20)"
from _field, _file
where _file-recid = recid(_file)
and _field-name like "%_curr"
and _format = "x(3)"
order by 1, 2
with width 160.
output close.

Hope this helps,
Willem

 

[ardydim]

Thanks for the answer. its really a great help.

Here is a snippet that will provide you with most tables and fields that refer to currency.

output to currency_fields.prn.
select _file-name format "X(12)", _field-name format "X(20)"
from _field, _file
where _file-recid = recid(_file)
and _field-name like "%_curr"
and _format = "x(3)"
order by 1, 2
with width 160.
output close.

Hope this helps,
Willem