Accounting Hub

Get Involved. Join the Conversation.

Topic

    Saichand Reddy Danda
    How to create GL journal batch by transaction currency from...
    Topic posted August 20, 2019 by Saichand Reddy DandaGreen Ribbon: 100+ Points, last edited August 20, 2019, tagged Accounting Hub Cloud Service, Financials, General Ledger, Subledger Accounting 
    41 Views, 7 Comments
    Title:
    How to create GL journal batch by transaction currency from FAH
    Summary:
    We get different transaction currencies (other than ledger currency) in the source file for accouning transformation. How to create GL journal batch by transaction currency in GL
    Content:

    From the source system we get transactions with a currency different from ledger currency, with the summarization option enabled at Date level (in GL), we get to see different GL batches based on transaction date but not based currecy. we are using pass through approach, only deriving few segments in accounting flexfield.

    Our requirement is to get GL batch based on transaction currency and transaction date.

    For Example, following source data

    Expectation is to create 3 batches one with 100 MXN with 7/16/2019, second one with 200 USD 7/17/2019 and third one with 300 MXN with 7/17/2019

    Actual: Created 2 batches based on date one with 100 MXN with GL accounting date 7/16/2019 and another one with 4277.27 MXN (with 1 USD=19.89MXN) GL accounting date 7/17/2019

    TRANSACTION_NUMBER DEFAULT_AMOUNT DEFAULT_CURRENCY DR_CR CONVERSION_TYPE TRANSACTION_DATE CONVERSION_DATE
    19081900008 100 MXN Dr User 7/16/2019 7/16/2019
    19081900008 100 MXN Cr User 7/16/2019 7/16/2019
    19081900009 200 USD Dr Corporate 7/17/2019 7/17/2019
    19081900009 200 USD Cr Corporate 7/17/2019 7/17/2019
    19081900010 300 MXN Dr User 7/17/2019 7/17/2019
    19081900010 300 MXN Cr User 7/17/2019 7/17/2019
    Version:
    19C (11.13.19.07.0)

    Comment

     

    • Gergana Radoutcheva

      Currency is not really a batch level component, see Journal Entry Components. You could perhaps split the transaction data in different files by currency and process sequentially if that's what you need.

      What's the rationale behind the requirement to batch journals by currency, can you please elaborate?

      • Saichand Reddy Danda

        Thanks for your reply Gergena.

        Is it possible to create a different journal header (with currency) in the same batch when the transaction date is same? Reason being single journal header showing both ledger and entered currency journal lines with conversion date as '1' and type as 'User' .

        • Gergana Radoutcheva

          Accounting Hub journal entries are summarized when transferred to GL. Since journal lines with different rates and rate types could be summarized the GL journal would show rate as 1 and type as User. You can get original conversion details from the subledger journals.

          • Saichand Reddy Danda

            Thanks Gergana for your reply.

            We would like to check the possibility of separate journal headers for each entered currency of a file.

            From the source we are getting the transaction lines balanced by currency in a separate transaction number in header. At present, we only see one batch created with single header consisting of multi currency journal lines. 

            • Gergana Radoutcheva

              I can't think of any way other than splitting the transaction data in different files by currency. Why is that so important?

            • Veerendra Chava

              You can see the same information in Subledger journals.

              Generally FAH Sources transaction volume is more, So Oracle is grouping based on the transaction Date or Period.

               

    • Veerendra Chava

      Hi ,

      GL Journal Batches grouping for the FAH Sources will have only two options i.e Date and Period.

      FAH Supports mutliple currencies for Single FAH transaction. As currency information is capturing at Line Level.

      If you want to have the separate batch for each currency, then you have to split the FAH files based on the currency and import.