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!

Error in GL Posting

Discussion in 'Oracle Financials' started by tomloera, Jan 10, 2013.

  1. tomloera

    tomloera Forum Expert

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

    I have the next error in the GL Posting Process:

    Error21 - Unable to convert amounts into reporting currency

    Anyone know what could be the reason for this error?

    Best Regards
    Tom
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Tom,

    Can you please provide some more details like, from where you are trying to post this and provide screenshots of them. By that we can analyze the issue
     
    tomloera likes this.
  3. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Can you check if this document id (377623.1) can help?

    GLPPOS Journal Posting Gives Error21 Unable To Convert Amounts To Reporting Currency [ID 377623.1]

    Cause
    The GL Conversion Rules were not defined properly for the Journal Source and Category.

    Solution
    To implement the solution, please execute the following steps:

    Responsibility = General Ledger Super User for the primary set of books
    Navigation = Setup/Financials/Books/Assign
    Form Name = Assign Reporting Sets of Books

    1. Navigate to the Assign Reporting Set of Books form.

    2. Click the [Conversion Options] button.

    3. From the Conversion Options window, select the Oracle General Ledger entry from the region below the poplist, then click the [GL Conversion Rules] button.

    4. Enter the Journal Source and Category for which you want to set a conversion rule.
    Note: You can enter a specific journal source or category or enter Other to select a source or category other than those you
    have specifically defined. Select the Reporting Conversion Type and No Rate Action to use when converting journals with the specified journal source and category.

    5. The setting of the Inherit checkbox will determine the rate that will be used to convert the transaction currency amount to your reporting functional currency:

    a. To use the conversion rate type specified in the primary journal, check the "Inherit" checkbox in the GL Conversion Rules window for this particular GL journal source/category combination.

    If you want to use the conversion rate type in the primary journal as a default for any source/category not defined in the GL Conversion Rules window, check the "Inherit" checkbox for the equivalent of Other/Other source and category.

    Note that if you check the "Inherit" checkbox for a particular source/category combination, the Posting program will ALWAYS use the conversion rate type specified in the primary journal for that source and category.

    OR

    b. To use the Default Reporting Conversion Type you specify on this form, leave the "Inherit" checkbox unchecked.

    6. Define Daily Rates for all currency relationships that could exist in your Primary as well as Reporting Sets of Books.
     
    tomloera likes this.
  4. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Thanks Yingsras, Bharat;

    We fixed the problem which was as follows:

    The user was capturing the exchange rates at the option of Manager-Currency-Daily Rates and for some reason the posting journals do not take these types of change

    It was the entrance to the exchange rates at the option of Currency - Daily Rates and posting the journals correctly.

    Thank you very much for your answers

    Regards
    Tom
     
    yingsras and Bharat like this.