General Ledger & Intercompany

Get Involved. Join the Conversation.

Posts

  • Holly Palmer
    Transfer balances for only one legal entity to a reporting...
    Topic posted 1:32 PM by Holly Palmer, tagged General Ledger 
    Title:
    Transfer balances for only one legal entity to a reporting ledger
    Summary:
    Transfer balances for only one legal entity to a reporting ledger
    Content:

    I have a primary ledger with many legal entities. Is it possible to transfer balances for just a single legal entity from the primary ledger to a reporting ledger with a different currency? We are trying to isolate the balances for just one entity. 

    Version:
    R13 19C
  • Nick Hirsch
    Cost Allocation
    Topic posted 11:35 AM by Nick HirschRed Ribbon: 250+ Points, tagged Allocations, Financials, General Ledger 
    Title:
    Cost Allocation
    Summary:
    Want to automate cost allocation
    Content:

    Hello,

    We have a scenario whereby we have some market data licence costs that we want to allocate across multiple departments, but we only want one department head to sign off / approve the cost. The invoice will initially get posted to department A (say £200), but then we want to allocate £50 to departments B, C and D and leave £50 in A.

    We could post a manual journal but would someone be able to advise the best automated solution for doing this? We have quite a few market data licences like this.

    Many thanks

    Nick

    Version:
    19C
  • Sunil KK
    Sequencing by LE and Interco Balancing Rules
    Topic posted Yesterday by Sunil KKGreen Ribbon: 100+ Points, tagged General Ledger, Intercompany 
    Title:
    Sequencing by LE and Interco Balancing Rules
    Summary:
    Sequencing by LE and Interco Balancing Rules
    Content:

    It appears that if we enable Sequencing  by LE, then we can not use Interco Balancing across LE (if all LEs are within a Ledger), we should only use Interco batch (AGIS).

    Has anyone found a work around to use sequencing by LE and yet use Interco Balancing feature at ledger level for multiple LEs?

  • ERPNewbie
    Canceling Intercompany related transactions
    Topic posted October 21, 2019 by ERPNewbieRed Ribbon: 250+ Points, tagged Accounting Hub Cloud Service, Cash Management, Financials, Help Center, Intercompany, Payables, Period Close / Reconciliation, Receivables, Subledger Accounting 
    Title:
    Canceling Intercompany related transactions
    Summary:
    is it possible to cancel Intercompany invoices/payment without reversing them via intercompany processes?
    Content:

    There's an incorrect intercompany transaction that was wrongly entered into the system. 

    Would it be possible to just cancel the related transactions (AP invoice and payment, AR invoice and payment) and not reverse the intercompany transactions?

    If yes will it have any negative impact on the ledger/reconciliation? Thanks so much

  • Sandeep Kumar
    Audit Trial for GL Code14.0
    Topic posted October 20, 2019 by Sandeep KumarSilver Medal: 2,000+ Points, tagged Financials, Security 
    Title:
    Audit Trial for GL Code
    Content:

    We want to enable Audit Trial for GL Code but did not find attribute in Audit Policy , Do we have this option ?

     

  • Sunil KK
    Allocation based on Account balance (without STAT...3
    Topic posted October 18, 2019 by Sunil KKGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger 
    Title:
    Allocation based on Account balance (without STAT journal)
    Summary:
    Allocation based on Account balance
    Content:

    Hi All,

    I would like to know if anyone has achieved similar allocation as below:

    Scenario:

    Jan-19 PTD Balances are as follows:

    A1) All expenses are recorded in Account    50001 and product 101 , say 100 USD (This is for expenses belong to both product 101 and 102)

    B1) Revenue is correctly recorded against : 40001 and product 101, say 200 USD

    B2) Revenue is correctly recorded against :  40002 and product 102, say 100 USD

    I would like to allocate Expenses from 50001.101 to 50002.102 based on % revenue derived from B1 and B2 ). i.e, Target amount A2 = (B2/B1+B2) * A1 

    Offset Account = A1

    As seen above, the allocation is based on balance instead of STAT journal. Is this possible using either formula or Allocation ? Any thoughts?

     

    Thanks,

    Sunil

    Version:
    19C
  • Raghavender V
    How to assign tasks and trigger mails or start conversations...
    Topic posted October 18, 2019 by Raghavender V, tagged General Ledger, Period Close / Reconciliation 
    Title:
    How to assign tasks and trigger mails or start conversations with users from Close Monitor?
    Summary:
    How to assign tasks and trigger mails or start conversations with users from Period Close Monitor?
    Content:

    Hi

    As part of improving the financials close time frames in our place, we are looking for a functionality of assigning tasks to individuals and tracking their progress. Though i see Close Monitor as a feature in ERP Financials (even in 19D), it just gives the option to check the close statuses of all sub ledgers there but does not

    - look for the exceptions if any in closing the periods

    - allow us to send mails to responsible persons etc.

    Has anyone used this feature to extend further to improvise the same. Any inputs in this regard are very helpful.

     

    On the other hand, i see, some of these features are available in Financials Consolidation and Close Service (FCCS). Has any one used this to automate the close process?

     

    Thanks

    Raghav

  • Nick Hirsch
    New Entity Set Up64.5
    Topic posted October 18, 2019 by Nick HirschRed Ribbon: 250+ Points, tagged Configuration, Financials, General Ledger, Setup / Administration 
    Title:
    New Entity Set Up
    Summary:
    Process for setting up a new entity in GL
    Content:

    Hello,

    How easy is it to set up a new entity in your existing Oracle GL?

    We need to set up some new entities and they need to mirror some existing ones we have - is it possible to duplicate an entity? Similar to how you would duplicate a Chart of Accounts?

    They are very simple entities that only require GL (no AP for example) and we already have similar ones in our structure.

    Any help / process documents would be very much appreciated.

    Many thanks

    Nick

    Version:
    19B
  • Mohamed Shawky
    Disable Transfer from AP to GL3
    Topic posted October 15, 2019 by Mohamed Shawky, tagged Financials, General Ledger, Subledger Accounting 
    Title:
    Disable Transfer from AP to GL
    Content:

    Hi,

    Is there a way to disable transactions Transfer from AP to GL other than selecting no in the create accounting process in Cloud Financials. Like it used to be in EBS.

    Thanks

    Mohamed

  • Rohan Kamat
    Disable summarization by code combinationsi n allocation...
    Topic posted October 15, 2019 by Rohan KamatBronze Trophy: 5,000+ Points, tagged Allocations, General Ledger 
    Title:
    Disable summarization by code combinationsi n allocation rules
    Content:

    Hi team 

    If we have same target accounts ( having same combinations in a formula journal ) ,allocation engine summarizes the account balance , is there a way to avoid the summarization 

    For example 

    Formula journal is written 

    01-000-21200-000 100

    01-000-21200-000  120

    01-000-31000-000                 220

     

    After running allocaiton , we get 

    01-000-21200-000 220

    01-000-31000-000         220 

    but we want seperate lines in journal entries . Any ideas how this can be achieved without writing 2 seperate rules

     

    Thanks

    Rohan

    Version:
    19C