How to change base currency if GL transaction existed

Q

quocthai1

New Member
Hello Everbody!
I need to change my MFG/Pro base currency after go alive, but I have some problems with account's currency. The menu 25.3.13 doesn't allow me to change Currency if some posted GL transactions existed. I have tried to export all transactions by menu 25.19.14 successfully but can not find any menu to delete them, it seems that the menu 36.23 doesn't work with posted transactions.
Do you know how to delete them? If I can do it, I think I can change base currency then import the transactions back.
 
Hi
Unfortunately, the quick answer to both of your questions is "No". You can not delete posted transactions and you can not change the account currency.
Here is what you can do:
- Reverse the existing GL transactions (to offset the balances)
- Inactivate the old account
- Create a new account with the correct currency
- Post transactions with the new account

Hope it helps

____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need GL Report Writer reports on the Web/Excel?
Check 32WebReport at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9[FONT=&quot][/FONT]
 
It does not stop there...

I do not know how much has been implemented and whether transactions already exist in the other modules. I also do not know whether you just want to change the code or actually switching the currencies (e.g. USD to JPN).

All transactions already created (AR, AP, SO, etc) assume the base currency is the one you have defined and the exchange rates and the like (for non base currency) have been set in the tables already.

I developed a tool to convert a client from CRC to USD and another from SWE to USD on EB and EB2 respectively. Conversions were succesful and modified all the underlying tables and rates to the new currency (including the ex_ tables). GL had to be restated and special handling was required for triangulation of currencies). What I want you to understand is that this is not an easy thing to do.

Most likely, depending on how much data has already been loaded, you may have to consider starting with a new DB and reload.
 
Hi Luis,
We are also implmenting a change of currency but sad to say, since this is the first time for us, we don't have any clues on what tables to change and what procedure to adapt. Can you able to share your codes with us? It may not be perfect for our environment but atleast we will have a clue. were using SCO 5 with MFGPRO 7.3 and Progress 8.3D. tks

LuisGdelC said:
It does not stop there...

I do not know how much has been implemented and whether transactions already exist in the other modules. I also do not know whether you just want to change the code or actually switching the currencies (e.g. USD to JPN).

All transactions already created (AR, AP, SO, etc) assume the base currency is the one you have defined and the exchange rates and the like (for non base currency) have been set in the tables already.

I developed a tool to convert a client from CRC to USD and another from SWE to USD on EB and EB2 respectively. Conversions were succesful and modified all the underlying tables and rates to the new currency (including the ex_ tables). GL had to be restated and special handling was required for triangulation of currencies). What I want you to understand is that this is not an easy thing to do.

Most likely, depending on how much data has already been loaded, you may have to consider starting with a new DB and reload.
Click to expand...
 
You must log in or register to reply here.
Back
Top