Results 1 to 7 of 7

Thread: Activating Multi Currency in a Non Currency environment - E1 9.1

  1. #1

    Activating Multi Currency in a Non Currency environment - E1 9.1

    Hi - I am interested to speak with anyone who has activated multi currency from non multi currency settings. We are planning to do this 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
    amarmero@yahoo.com
    Al Marmero
    E1 9.1 update 2 | TR 9.1.5.5

  2. #2
    Member
    Join Date
    Feb 2002
    Location
    Florida, USA
    Posts
    172
    It's been a number of years since I've done this. I think it was OW B7333, that's how long! I distinctly remember one issue we had to fix via SQL: All records must have a blank currency code prior to running the Load Domestic Currency code program. I did a quick query on this forum and someone said the same thing. Otherwise, just get the latest whitepapers, and the Multi-currency manual and follow the instructions to the "T". And of course, test, test, test. Give yourself plenty of time to do this project.
    JD Edwards E1 and World
    Blasenheim Solutions, LLC
    Technical and functional consultant specializing in Financials

  3. #3
    Thank you Alex very much. My research has shown exactly as you stated.......all records pre-conversion MUST have a *blank currency code. If you or anyone else recalls anything else, please feel free to reach out, I appreciate it.

    Thanks again. Al
    Al Marmero
    E1 9.1 update 2 | TR 9.1.5.5

  4. #4
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,221
    If you have a JDEtips subscription, you may want to search their library. They have several articles on multi-currency that might be of interest.
    Don Sauve
    Wagstaff, Inc.
    E1 9.1, Win2012 R2, Oracle 11.2.0.4, TR 9.1.5.3, WebLogic 12.1.3, BI Publisher
    Moving to: E1 9.2, Win2016, SQL Server 2016, TR 9.2.2.6, WebLogic 12.2.1, BI Publisher

  5. #5
    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.
    Al Marmero
    E1 9.1 update 2 | TR 9.1.5.5

  6. #6
    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
    Al Marmero
    E1 9.1 update 2 | TR 9.1.5.5

  7. #7
    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
    E1 9.1 update 2 | TR 9.1.5.5

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.