1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Fixed Asset can work with multicurrency?

Discussion in 'Oracle Financials' started by tomloera, Apr 18, 2012.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi friends;

    Can help me in know if the Fixed Asset module can work with Multi Currency?

    My functional currency is PESOS and I have some projects with PESOS y DOLLARS but when I run the process of CAPITALIZATION only transfer the costs in PESOS.

    I want create a new book in Fixed Assets in DOLLARS, but when assign the GL SET OF BOOKS If I select one different book of the organization (book in dollars) can't see this book in the Project module.

    When I review the problem is because all the books in Asset should have in the GL SET OF BOOKS, the name of the principal book of the organization (in my case the currency code is PESOS)

    In summary I believe can not work with the Fixed Asset in multicurrency

    ┬┐This is correct?

    Best Regards
    Tomas
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Tomas,

    I told you that it is possible. Here is some notes I had from 11i. I shall send you the steps for R12. But I can do it next week. Will look into it when I get some time .

    As far as MRC is concerned, you can also use it for FA Tax Books, found this old note on how to setup FA and MRC:
    "Fixed Assets Setup
    ---------------------
    1) Create a Corporate book
    Fixed Assets Manager: / Setup Asset System / Book Controls
    2) Create as many tax books for this CORP book as you wish
    Fixed Assets Manager: / Setup Asset System / Book Controls
    3) Assign FA Reporting Books through GL
    GL SuperUser: /setup/financials/books/assign
    Select your Primary book, then select the reporting book and click 'Conversion Options'
    Fill in "Oracle Assets", the FA Book Name, the conversion type (Reporting/Conversion/etc)
    for each book you are using.
    4) create 1 FA responsibilities for each Primary / Reporting GL SOB (i.e. not FA BOOK!!!)
    System Administrator: /security/responsibility/define
    FIELD PRIMARY RESPONSIBILITY Value MRC RESPONSIBILITY Value
    Menu: FA_MAIN FA_MRC_NAVIGATOR_GUI
    DataGroup:Name: Standard Multiple Reporting Currencies
    DataGroup:Application: Oracle Assets Oracle Assets
    RequestGroup:Name: All Reports MRC Programs FA
    RequestGroup:Application: Oracle Assets Oracle Assets
    5) Set SOB and MRC SOB system profile options for each responsibility
    System Administrator: /Security/Responsibility/Define
    Profile Option PRIMARY RESPONSIBILITY Value MRC RESPONSIBILITY Value
    GL Set of Books Name <primary SOB name> <reporting SOB name>
    MRC Reporting Set of Books <null> <reporting SOB name>
    6) get your Reporting Book's SOB id's:
    select set_of_books_id, book_type_code, currency_code
    from fa_mc_book_controls
    where book_type_code = '&corpbook';
    6) Continue as normal: set up categories for each corp/tax book
    Then you're good to go..."
    I only used this once, i already review my setup doc and we only defined corp and tax books on the functional currency and then all books were assigned to convertion options on GL (point 3 on the note)
    Of course, with MRC all transactions o tax book will be converted.
    cheers
    Ramji
     
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Excellent information, if their notes are for R11 are excellent as is the version I'm working on. Do not worry about R12 notes helps me a lot.

    I will work on doing a test and you will share the results of it.

    Once again thank you very much for your support.

    Best Regards
    Tomas
     
  4. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Dear Friend;

    Question?

    You can run the capitalization process twice for the same project?

    That is, run it once to capitalize on PESOS and run again to capitalize on DOLLARS?

    Best Regards
    Tom
     
  5. soumya.parhi

    soumya.parhi Premium Member

    Messages:
    33
    Likes Received:
    2
    Trophy Points:
    185
    Location:
    India
    Hi Ramji,

    Can you tell me how to proceed in R12 ?

    Thank you !!

    Soumya
     
  6. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Hello,

    Have sent the R12 process doc to Tomas. I saw your reply in email and request Tomas to keep you posted.
    cheers
    Ramji
     
  7. soumya.parhi

    soumya.parhi Premium Member

    Messages:
    33
    Likes Received:
    2
    Trophy Points:
    185
    Location:
    India
    Tomas,

    Wish you a great time, could you please send me the document in soumya.parhi@gmail.com for FA multicurrency functionality in R12 ?

    Regards,
    Soumya
     
  8. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi Soumya;

    Let me search the document because I make the document some months a go and need search in my backups

    Regards
    Tom
     
    soumya.parhi likes this.
  9. pronaldo

    pronaldo Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi Ramji
    Excelent information
    Could you please send the process for release r12 ?
    Thanks a lot
    Paulo Ronaldo Martins
     
  10. pronaldo

    pronaldo Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
  11. marcospineda

    marcospineda Guest

    Hi Ramji
    Could you please send the process for release r12 ?
    Thanks in advance

    Marcos Pineda

    marcos@marcospineda.com
     
  12. Smora

    Smora Premium Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    CA
    We are starting to implement Oracle Assets in Asia and need to have assets in CNY and ones ordered and paid in USD, to be in USD.

    Can you please send me the process for R12?

    Thanks,
    Sandy Mora

    sandymora@cox.net
     
  13. ABHISEKH

    ABHISEKH Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    India
  14. apps2fusion9

    apps2fusion9 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Hyderabad
  15. Kasi Reddy

    Kasi Reddy Active Member

    Messages:
    10
    Likes Received:
    2
    Trophy Points:
    110
    Location:
    hyd
    Hi Ramnji,

    Great job, Can you please provide the doc?