Turning on multi currency in a non multi currency environment

rsvconsulting

rsvconsulting

VIP Member
Hi - I am interested to speak with anyone who has activated multi currency from non multi currency settings. We are running in USD with multi currency "turned off."

We are planning to activate multi currency to add a foreign subsidiary and would like to talk about the order of steps, running of various conversion programs, repost of account balances and just any general issues that might have been encountered, or avoided in early planning / detection. Please feel free to call or write and we can set a time to speak at your convenience. Thank you and looking forward to connecting on this interesting topic. Your advice is greatly appreciated, and the favor will gladly be returned.


Al Marmero
609-313-7530
[email protected]
 
UPDATE: So far the activation of multi currency has been very successful. All of the Load Domestic Currency Code programs have populated the CRCD, etc. as expected. I did find that some of the Load programs are not apparent, such as the R12808 for Fixed Assets. Question: Does anyone have a full list of JDE-provided "load" UBEs? Otherwise I suspect I may have to SQL update CRCD in some of the tables where I cannot find a Load UBE, such as for the 42119 and 42199. Thanks for any info.
 
UPDATE: 3/8/18--I did learn that the CRCD column must be populated with the company domestic currency code in every table that contains records. Since CRCD is present in 304 E1 tables and Oracle only supplies 10 conversions utilities, I am going to write the needed utility and make this process much easier at the outset for the future.

Thanks again to those who contributed input.

Al Marmero
 
UPDATE - 3/12/18 - Just an fyi - Did some further research and found that 9.1 contains CRCD in 594 tables (not 304 as previously reported in Oracle documentation). So the query that I am creating will be very valuable.
 
Al Marmero,

We are thinking of doing the same and any inputs from your experience will help.

Thanks
Venu
 
Back
Top