Skip to Content
author's profile photo Former Member
Former Member

Transaction Currency

Hi Experts,

Has anyone had the requirement to inclde the transaction currency as part of eliminations and reporting?

This is a dimension used in BCS and would expect to have a similar dimension here in BPC. For clarity, this amount is not translated by system, merely supports the local currency amount.

2 possibiliies for setup -

1) Setup 2 separate dimensions within the application TC Key and TC and track the info as dimensions? The requirement is to support intercompany eliminations and see the original TC amount to support the booking, and to support reporting in group currency with a linkage/exposure to the original transaction currency.

I would want to be able to total the currency amount together by currency, e.g. 1000 EUR local currency based on amounts summing to $200 USD and 400 GBP as transaction currency?

Another option would be to setup a separate application similar to the intercompany matching and somehow link to the local currency/reporting currency balance by company by account.

Any thoughts or ideas?

Thanks in advance.

Eyal

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 10:22 PM

    Hi,

    TC-s can be handled several ways, the correct answer here is typical "it depends on the requirement".

    Whilst it is difficult to suggest the optimal solution without knowing your other requirements and considerations, I'd suggest adding T_USD and T_GBP to your CurrencyDim and use custom logic to convert them into LC. In this way each currency can be matched separately and any differences can be tracked per TC and reconciled as required.

    The IC reporting process would involve then entering transaction currency amounts, matching, running FX to convert them to LC and whatnot.

    In this way each account where this method is used can be analysed by currency as well.

    Hope this helps,

    Madis

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 01:34 PM

    Thanks for your feedback Madis

    If I understood you correctly, option a) add additional properties to the currency dimension?

    To clarify the requirement, there may be 4 rows of data as below:

    LC Key u2013 EUR

    Amount TC key TC Amount

    70 USD 125

    30 USD 75

    10 GBP 8

    8 GBP 6

    The goal would be that in the summarized reporting, I could see the following results

    100 EUR linked to 200 USD

    18 EUR linked to 14 GBP

    Note there's no translation between LC and TC but TC is summarized.

    Now this supports intercompany clearing (since I know the original TC amount) or the ability to report on the underlying TC amount.

    By creating a another property would that allow me to summarize as above? I didn't fully understand how so.

    Thank you again.

    Eyal

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eyal,

      Sorry - my previous post was a bit unclear.

      First, let me clarify the requirement further: do you need to report on consolidated (i.e. any eliminations to consider in order to analyse the net exposure at the group level) TC figures? In this case you will need a separate dimension (similar to product or any other extended dim). You may need to have some kind of logic to handle TC-LC rates in that extended dimension because if you need to consolidate

      If you do not need to consolidate then you can use the currency dimension (EUR is LC):

      ENTITYA,T_USD,125
      ENTITYA,LC,70
      ENTITYB,T_USD,75
      ENTITYB,LC,30
      

      Then you can report at the group level:

      ENTITY.........LC.........T_USD
      TOTAL..........100.......200
      A...............70.......125
      B...............30........75
      

      Note that you can also develop custom elimination to calculate the net exposure. The result would then not be part of the general financial reports but can complement however.

      Hope this helps,

      Madis

      Edited by: Madis Udam on Dec 14, 2011 8:47 AM

      Edited by: Madis Udam on Dec 14, 2011 8:48 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.