General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    gabriel kinovisques
    R13 Primary and Secondary LedgerAnswered
    Topic posted October 14, 2019 by gabriel kinovisquesRed Ribbon: 250+ Points, tagged General Ledger, Reports, Tip 
    45 Views, 4 Comments
    Title:
    R13 Primary and Secondary Ledger
    Summary:
    Description in English in Primary while Secondary in Spanish
    Content:

    Hello 

    I have setup the primary ledger and secondary ledger in MXN, however I need the description on the primary in English while in the Secondary Ledger in Spanish.

    Example :

    Primary 

    1101 -Cash

    Secondary

    1101 -Efectivo

    Thanks for your comments

    Regards

     

     

    Version:
    r13
    Code Snippet:

    Best Comment

    Julien Dubouis

    Hi Gabriel,

    From your post, I understand that you want the values of your Chart of Accounts to be displayed in two different languages while logged in a specific language. Is that so ? 

    When creating values for your CoA in the UI (Manage Chart of Accounts Value Set Values), you will create them with a description in a base language that is the one you are currently logged in (I assume English). This description is copied over to the other languages installed on your environment (I assume Spanish is and maybe a few others). By clicking on the little globe icon, you can adjust the translations in other languages.

    With the FBDI to load values (https://docs.oracle.com/en/cloud/saas/financials/19c/oefbf/general-ledger.html#importsegmentvaluesandhierarchies-3019) you have a column for each language, so you can load all the translations at once.

    That being said, if you want the account 1101 to be seen as Cash in the Primary and Efectivo in the Secondary, for the same user, without changing the language preferences, you should setup 1101 description in English to be Efectivo for your secondary, therefore, that means you should have two distinct value sets in the CoA instance of the Primary and Secondary Ledgers. Very honestly, if you use the same accounts, I would not do that as it incurs maintenance and I don't see the added value. If you need to produce some reports where you want to see the spanish description of the account, just set the report language output as Spanish. 

    Does that answer your question ?
    Thanks

    Comment

     

    • gabriel kinovisques

      Hello 

      What I have done so far it to setup the description manually in English and Spanish.

      Primary Value Set

      USGAAP 

      Here I setup the description in English

      Secondary Value Set

      Here I setup the description in Spanish

      Please Advise

       

       

      • Julien Dubouis

        Hi Gabriel,

        From your post, I understand that you want the values of your Chart of Accounts to be displayed in two different languages while logged in a specific language. Is that so ? 

        When creating values for your CoA in the UI (Manage Chart of Accounts Value Set Values), you will create them with a description in a base language that is the one you are currently logged in (I assume English). This description is copied over to the other languages installed on your environment (I assume Spanish is and maybe a few others). By clicking on the little globe icon, you can adjust the translations in other languages.

        With the FBDI to load values (https://docs.oracle.com/en/cloud/saas/financials/19c/oefbf/general-ledger.html#importsegmentvaluesandhierarchies-3019) you have a column for each language, so you can load all the translations at once.

        That being said, if you want the account 1101 to be seen as Cash in the Primary and Efectivo in the Secondary, for the same user, without changing the language preferences, you should setup 1101 description in English to be Efectivo for your secondary, therefore, that means you should have two distinct value sets in the CoA instance of the Primary and Secondary Ledgers. Very honestly, if you use the same accounts, I would not do that as it incurs maintenance and I don't see the added value. If you need to produce some reports where you want to see the spanish description of the account, just set the report language output as Spanish. 

        Does that answer your question ?
        Thanks

    • gabriel kinovisques

      Hello Julien

      Actually I need to run a Localization report for Mexico called COA for Mexico and I need to have the description in Spanish instead of English.

      I am going to update the description on the Primary Value set and I am going to run the report to see if the descriptions will be display in English.

       

      Thanks for your help

       

       

       

    • gabriel kinovisques

      Hello Julien

      According to your comments , the report is working now with the descriptions in Spanish.

      Thanks for your help

      Regards