Wednesday, October 3, 2012

Setting up Reporting Currency Ledger and Secondary Ledger in General Ledger.


Setting up Reporting Currency Ledger:
  1. Responsibility : General Ledger Vision Operations(USA), Setup -> Financials -> Accounting Setup Manager and Search for Primary Ledger "Vision Operations (USA)" and Click on Update Accounting Options.
  2. In Primary Ledger: Vision Operations (USA) section, Click on Update Icon for Reporting Currencies.
  3. Add New Reporting Currency with the following info and Apply.
    • Reporting Currency Name - Indian Rupee
    • Short Name - INR
    • Currency Conversion Level -  Journal 
    • Default Rate Type   - Corporate
  4.  Go to Setup -Open/Close Periods, Query for Ledger : Indian Rupee and Open the Period
  
Setting up Secondary Ledger:
  1. Responsibility : General Ledger Vision Operations(USA), Setup -> Financials -> Accounting Setup Manager and Search for Primary Ledger "Vision Operations (USA)" and Click on Update Accounting Options.
  2. Go to Secondary ledger and check the Secondary Ledger Name .It may be IAS Reporting Vision Ops. If not available , create new with the same name.
  3. Switch to System Administrator Responsibility, Create new Responsibility in the name of IAS Reporting Vision Ops. Set the details as the same as Responsibility: General Ledger Vision Operations (USA) and add this responsibility to the respective User
  4.  Switch to Responsibility Oracle Trade Management Administrator, ->Profile ->  Query for the Profile GL: Data Access Set for Responsibility IAS Reporting Vision Ops, and set it as IAS Reporting Vision Ops
  5. Switch to Responsibility: IAS Reporting Vision Ops. Open the GL Periods for the Ledger as IAS Reporting Vision Ops.

Testing the setup:
  1. Create a new Journal entry in GL,(By creating accruals from Trade Management and Executing CC job " Transfer to General Ledger" from  Responsibility Oracle Trade Management Administrator)
  2. Post the details to GL, this will create a new journal entry in Reporting currency with Journal name INR: Fixed Budgets USD . Click on Review Journal to View the details in Reporting Currency.
  3. Switch to Responsibility: IAS Reporting Vision Ops and query for the same information by navigating to Journals --> Enter -->Query for the Period, this will retrieve the details for the Secondary Ledger : IAS Reporting Vision Ops.       

2 comments:

  1. thanks dude its working...i just opened the secondary ledger periods and posted the journal

    ReplyDelete
  2. Wonderful illustrated information. I thank you about that. No doubt it will be very useful for my future projects.currency converter Would like to see some other posts on the same subject!

    ReplyDelete