General Ledger & Intercompany

Get Involved. Join the Conversation.

Comments

  • Baskar Chakravarthi

    As of now, there is no such functionality is available in the General ledger module. You have to do manually for end dating the currency or disabling the currency.

  • Krishnan Venkatachalam

    Hi David,

    Thanks for the response. Unfortunately thy want it at the Journal level (vs balance). If it was just Balance I could have pushed them to our consol systems for translations :(.

    Another aspect I am trying to avoid is unnecessary performance impacts. The US ledger has multiple entities and I dont want them in GBP.

    That would be a load. From a security standpoint, wont it be easier for me to control the ledger level access vs entity level?

    At this point I have a workaround (ie create another Primary Ledger with the new currency, assign the BSV to that ledger then do a with a BIP -> FBDI feed into the new PL). I am just surprised that Oracle does not let you to control the entities for which data flows through considering Primary -> Secondary is a one way street.
    I am sure there other issues to consider like auto posting the journals etc. But should be able to figure those out.

    Regards,

  • david zachar

    Hi Krishnan..

    It depends on the manner you have setup the conversion to the RC..

    If you have selected "Balance", then you can select this as part of the Translation program (last parameter)

    If you are transferring at "Subledger" or "Journal", there is no straight forward way to do this.. If there is a strong business requirement, you could hide these values in the RC using segment security rules (though they would still transfer - just not be visible to the end users)

    David

     

     

  • Baskar Chakravarthi

    Yes, Setup & Maintenance area.

    You can search directly for the task Manage Chart of Accounts Value Set Values or navigate there by selecting Financials on the top left, scrolling down to Financial Reporting Structures, then selecting it from the list on the right.

    Create a Structure Instance and Finally deploy it.

     

  • Baskar Chakravarthi

    Hi Bala,

    Before you create a manual JV, take a backup of trial balance and then ask business users to pass the manual JV to clear the balances.

     

  • Baskar Chakravarthi

    Thanks.

    In general, increasing the maximum size of an existing value set (or replacing your value set with a bigger one instead) does not cause any problem with your existing flexfields data so long as your new maximum size is still small enough to fit in the underlying flexfield table's segment columns. However, you should never change to a value set with a larger (or smaller) maximum size if your value set is Right-justify Zero-fill, since 001 is not the same as 0000001, and all of your existing values would become invalid.

  • Balakrishna sivappagari

    Hi Cezar,

    Thanks for the response, but i am not asking how to delete the intercompany transaction from dashboard.

    I am asking how to delete the approved intercompany transactions while doing the consolidation. 

    Please provide me steps for the same.

    Thanks in advance

    Regards,

    Bala

     

  • Cezar Enache

    Hi Bala,

    Please check the below doc: How to Remove Rejected Intercompany Transaction from Dashboard? (Doc ID 2174525.1)

    Sincerely,
    Cezar

  • Cezar Enache

    Hi Baskar,

    Please be informed that this questions is answer by the MOS document: Can We Increase The Size Of Segment In The Chart Of Accounts And What Is The Impact (Doc ID 2181168.1)

    Sincerely,
    Cezar

     

  • Balakrishna sivappagari

    Thank you so much Anjali.

  • Anjali Bisht

    Hi Fernan,

     

    The Performance enhancements in period close work area was a opt in feature in 19C however it has become opt in expiry(mandatory) feature in 19D which means there is no way of going back .

    Thanks

    Anjali Bisht

  • Anjali Bisht

    Hi Bala,

    Business will have to pass journal entries in GL to have the balances cleared .

    Thanks

    Anjali Bisht

  • Balakrishna sivappagari

    Hi Anjali,

    Thanks for the quick response.

    Can you please let me know how to clear the balances?

    Thanks in advance

    Regards,

    Bala

  • Anjali Bisht

    Hi Bala,

    For the CVR to be effective, you will have to disable the existing code combination that's violating the CVR  in Fusion. Please ensure that the business clears the balances and post that you can disable the code combination.

    Once you have cleared the balances, you can run "Manage Cross Validation Rule Violations" and choose the following:

    Chart of accounts-  Here select your chart of accounts

    Cross Validation Rule- Select the rule name that you want to disable the code combination for.

    Disable Accounts- This will help you in disabling the CVR Violations code combination in one go.

    Thanks

    Anjali Bisht

     

  • Kim Flannagan

    Hello - 

    I am trying to figure out how to create a new label.... can you provide guidance? 

    Thanks!