Financial Consolidation and Close

Get Involved. Join the Conversation.

Comments

  • Ganesh Nellayappan

    Hi Bernardo,

    Thanks for detailing it out.

    You are right.

    When I create translation rules for specific account, it override the regular values. So If I write translation rule, it overrides the regular consolidation process of using Override rate.

    Custom rules are coming up in 17.11. Probably by this Friday's update.

    I will test the same and let you know.

     

    Regards,
    Ganesh Nellayappan

     

  • Laura Ferris

    Here are two links to the documentation about using teams:

    FCCS Administrator's guide, Managing Teams for Close Manager chapter

    FCCS User's guide, Updating Tasks chapter

    I'm hoping someone from Development can speak to your questions about the bugs and security items.

    Thanks,

    Laura

  • Ganesh Nellayappan

    Ok . Thanks for the update.

    I have also not heard about this so far. Probably next we should try re-importing the files using SmartView or load metadata.

    Regards,
    Ganesh Nellayappan

     

  • Bernardo Andres Neira

    Hi, after a frustrating week I deleted all my troublesome accounts and re-created them again using some working "template" accounts.

    Now the roll up works just fine, I'm not sure what the problem was (or is ??) but I think there are a certain kind or attributes (or at least one) that cannot be modified from the GUI and is generating this issue

  • Bernardo Andres Neira

    Thanks a lot Ganesh, however I'm not sure the solution you provided works for my requirement. I'll explain with numbers

    Let's say I have an account FCCS_IssuesOfStock from the equity, the rate I used for this account is Rate Override. The Entity Currency is COP and the Parent Currency is USD

    Now this account only has one movement which could be any movement from the dimension, so for the example lets say FCCS_CapitalExpenditures

    [A:]FCCS_IssuesOfStock;[M:]FCCS_CapitalExpenditures --- 50.000 COP

    Let's pretend the average rate from COP to USD is 0.05 and the ending rate is 0.04 the Historical rate for that movement is 0.06

    So in normal conditions (the historical rate has been input)

    [A:]FCCS_IssuesOfStock;[M:]FCCS_CapitalExpenditures --- 3.000 USD (using 0.06 as the rate)

    However if no historical rate (rate override) was input then FCCS uses average rate as the default rate so

    [A:]FCCS_IssuesOfStock;[M:]FCCS_CapitalExpenditures --- 2.500 USD (using 0.05 as the rate because no rate override was input)

    But the value I need in case no rate override is input should be [A:]FCCS_IssuesOfStock;[M:]FCCS_CapitalExpenditures --- 2.000 USD (using 0.04)

    Since my requirement is to originally use the rate override, but in case no rate is input then FCCS should use the ending rate, I dont get how using an advanced translation rule could work for me.

    If I create an advanced rule to use ending rate (0.04) it wil either replace the value, which in case the rate override (0.06) had been input, would be wrong or add to the original translation which in any of the above cases would also be wrong.

    Does this make any sense ??

    Thanks a lot for your interest and help so far

     

  • Ganesh Nellayappan

    Screen Shot Attached

  • Ganesh Nellayappan

    You are right.
    Historical account can have these types.
    -Historical
    -Historical Amount Override
    -Historical Rate Override

    Default Exchange Rates for all there Accounts are "Average Rate"
    In case of Historical Amount Override, if you have override amount using the Override Forms then FCCS will take that amount instead of default rate.
    In case of Historical Rate Override, if you have override rates using the Override Forms then FCCS will take that rate instead of default rate.

    Historical Accounts
    —If an amount override or rate override is specified for the historical account, the system uses the applicable override for the account.
    Otherwise, the historical account is translated using the Average Rate

    https://docs.oracle.com/cloud/latest/financial-consol-cloud/AGFCC/AGFCC.pdf => Page 108

    You can override translation rule for a account by using Calculations.

    Specifying Default Translation Settings
    https://docs.oracle.com/cloud/latest/financial-consol-cloud/AGFCC/AGFCC.pdf -> Page 209.

    1. Select Application -> Calculations
    2. Select Create (+ Icon)
    3. In Translation Rule Name : Provide Rule Name
    4. Select Translation Method (Periodic or YTD)
    5. Select Rate Information. (as per your requirement)
    6. Click on Advanced Button to Select Year , Period and Scenario (if you want it from/for specific Period)
    7. Click on + icon to select (or exclude members) for this rule
    8. Select the Account Dimension and Select the Account Member (in your case Historical Account)

    9. Select Deploy


    Hope this helps.

    Regards,
    Ganesh Nellayappan

  • Bernardo Andres Neira

    Hi Ganesh,

    Maybe I didn't explain myself. For equity accounts usually one should select rate override in order to input a historical rate for the movements with values, however if the account has rate override but there is no rate for that combination, FCCS automatically translates using the average rate.

    My main question was if there is any option or configuration to change the default rate for equity accounts as ending in case no historical rate is given, instead of the average rate

  • Bernardo Andres Neira

    Hi Ganesh, thanks for your time

    I did check my settings again which I'm attaching but I'm still facing the same issue

  • Elina Heinonen

    Hi and lot of thanks for the answer, I have looked at sample application and watched videos, but unfortunately I cannot find the answer to my question - how to adjust cash flow manually.

  • Elina Heinonen

    Hi and lot of thanks for the answer, I have looked at sample application and watched videos, but unfortunately I cannot find the answer to my question - how to adjust cash flow manually.

  • Rich Wilkie

    Have you looked at the sample application?  We have cash flow data there so you could get some examples directly from that.    Also some cash flow videos can be found in the doc library (https://docs.oracle.com/cloud/latest/financial-consol-cloud/financial-consol-cloud_videos.htm).  Finally the movement dimension section in the doc is pretty good for this (https://docs.oracle.com/cloud/latest/financial-consol-cloud/AGFCC/dim_movement.htm#AGFCC-admin_dimensions_25)

     

    The new dimension editor released in 17.10 will also help you validate your metadata to make sure you have the correct settings for your members.  

     

    https://docs.oracle.com/cloud/latest/financial-consol-cloud/AGFCC/accessing_the_dimension_editor_sui.htm#AGFCC-GUID-041CBCCC-D1E5-4FFB-B221-6E2A4584FB17

     

     

  • Elina Heinonen

    Is it possible to get real example - which kind of account (metadata properties) and which kind of movement (metadata properties) is needed to be able to input manual adjustments to cash flow?

    In addition I would be very thankful if I could receive a real example of cash flow.

    Sorry, now I noticed that I am overdue!!

  • Ganesh Nellayappan

    Hi Bernardo,

    You should be able to choose the Exchange Rate Type as per your accounting requirement.

    As per your business requirement only for Historical Account you can choose Historical as "Exhange Rate type" , for other you can choose "Average" or "Ending" as per

    I am not able to understand this question

    will a new release restore all the rates to historical ??

    Are you saying that once the pod gets upgraded, the default rate if selected as Average or ending gets back to Historical. ?

    If so let me know from which version to which version, I can test. If it reverts then we can file a bug.

    if you are talking about PL accounts under retained earning, I could see a enhancement in 17.09 where PL Accounts will have exchange rate as "No Rate" as it cannot be Historical. So if PL account is made as Historical then after 17.09 upgrade it will be "No Rate" instead of Historical.

     

    Regards,

    Ganesh Nellayappan

  • Ganesh Nellayappan

    Tested it works.

    How I set it up, I have provided. Please check once.