General Ledger & Intercompany

Get Involved. Join the Conversation.

Posts

  • Sirisha
    GL Description is restricting to 240 character limitation,...3
    Topic last edited 1:52 AM by SirishaBlue Ribbon: 750+ Points, tagged General Ledger, Subledger Accounting 
    Title:
    GL Description is restricting to 240 character limitation, the key information which is at the end of the SLA rule, is being cut-off
    Summary:
    GL Description is restricting to 240 character limitation the key information which is at the end of the SLA rule, is being cut-off
    Content:

    GL Description is restricting to 240 character limitation the key information which is at the end of the SLA rule, is being cut-off.

    Where can we check the GL Description character length?

  • Anjali Bisht
    19C: ALLOCATION RULE NAME AS RECONCILIATION REFERENCE3
    Topic posted December 5, 2019 by Anjali BishtBlue Ribbon: 750+ Points, tagged Allocations, Financials, General Ledger 
    Title:
    19C: ALLOCATION RULE NAME AS RECONCILIATION REFERENCE
    Summary:
    19C: ALLOCATION RULE NAME AS RECONCILIATION REFERENCE
    Content:

    Hi All,

    There is a opt in feature of 19C namely "Allocation Rule Name as Reconciliation reference, we have enabled this feature however still not able to see any information/data under reconciliation reference. Is there any other configuration that we need to perform for this feature to work and where can we view this?

    Thanks

    Anjali 

  • Federica Colosimo
    Intercompany Transaction Provider1
    Topic posted Yesterday by Federica ColosimoRed Ribbon: 250+ Points, tagged Assets, Financials, General Ledger, Intercompany 
    Title:
    Intercompany Transaction Provider
    Summary:
    Intercompany Transaction Provider (Empty Field)
    Content:

    Hi, 

    I'm trying to create a intercompany transaction, but when I've started to create it, the field "Provider" doesn't show any options. 

    Can you help me to solve this issue? 

    Thankss  

  • Vikash Sethi
    19D Upgrade - UI Change for Outstanding Subledger...35.0
    Topic posted December 11, 2019 by Vikash SethiSilver Medal: 2,000+ Points, tagged General Ledger, Period Close / Reconciliation, User Interface 
    Title:
    19D Upgrade - UI Change for Outstanding Subledger Transactions
    Content:

    Upgraded to 19D on DEV instance. Navigation Path --> General Accounting --> Period Close --> "Outstanding Subledger Transactions", the screen has changed. Earlier, we used to get details of all modules together in a tabular fashion. Now, the details are per module, along with ability to run Subledger Period Close Exception Report. Per users, this is a step backwards, as it just shows information for a single module. There is no parameter or option available to see data for all the modules. Is there any way, we can go back to old view? Or how can we see all the modules together in a single view?

    Version:
    19D
    Image:
  • Remi Degrelle
    Is there a way to restrict the list of account values by...9
    Topic last edited November 28, 2019 by Remi DegrelleRed Ribbon: 250+ Points, tagged General Ledger, Security, Setup / Administration 
    Title:
    Is there a way to restrict the list of account values by modules ?
    Summary:
    Need to have different list of values for accounts depending on the module
    Content:

    Hi everyone,

    I would like to see if there a way to restrict the list of account values depending on the module selected for a particular transaction?

    By using the standard functionnalities,

    1) We can restrict access to subledger accounts using Third-party control accounts (to avoid GL manual entries on pure subledger accounts)

    2) We can restrict access in a given subledger module to a pre-defined list of accounts using segment value security rules. But when we applied this security rule on a custom role (that we call for example SUBLEDGER_AP_SECURITY_RULE), and apply it to the user, then the user is not able to see those values whatever the module he's selecting

    (I see that there is a LOV for module in the SR General Information page but it seems to be inefficient. See below screenshot)

    On this second point, part of this problem can be solved by implementing a proper SOD. But we still have some cases of users having access to multiple subledgers or subledgers and GL for which we need to secure the list of available accounts depending on the module. In addition to that, we are using pure GL accounts (GL mirror accounts or GL intercompany reclassification accounts) for fast correction during month-end that we reverse on the next period (and make correction in the appropriate module). These particular accounts must be used in GL only and in no other subledger module.

    Regards,

    Rémi

     

     

    Version:
    19D
    Image:
  • Kim Puls
    Year-End Close9
    Topic last edited January 30, 2019 by Kim PulsSilver Medal: 2,000+ Points, tagged Allocations, Assets, Budgetary control, Cash Management, Expenses, Financials, General Ledger, Payables, Period Close / Reconciliation, Receivables, Reports, Subledger Accounting 
    Title:
    Year-End Close
    Summary:
    How is year-end close different from month-end close?
    Content:

    Our institution is new to R12 (went live 7/1/17) which means we haven't done a year-end close yet. We've been told that year-end is similar to month-end. We know we'll have to build new calendars...but our functional leads are questioning how balances roll forward and what they look like in the new year. Is the carryforward a separate line or is it lumped into the new year funding? What happens with unaccounted/POs that need to roll forward? And to top that all off we are upgrading to R13 in the next 6wks.

    Thanks - Kim

  • Rajesh Dixit
    Not finding chart of account listing report65.0
    Topic posted December 9, 2019 by Rajesh DixitGreen Ribbon: 100+ Points, tagged Financials, General Ledger, Reports 
    Title:
    Not finding chart of account listing report
    Summary:
    I am looking for a simple chart of account listing report showing values in different segments, descriptions and enabled/disabled
    Content:

    I am looking for a simple chart of account listing report showing values in different segments, descriptions and enabled/disabled.

    I had thought there was a chart of account listing report in OTBI under GL but not finding that.

    Any insights ?

  • Vikash Sethi
    BI Report does not show data after Journal PostingAnswered4
    Topic posted December 10, 2019 by Vikash SethiSilver Medal: 2,000+ Points, tagged Financials, General Ledger, Reports 
    Title:
    BI Report does not show data after Journal Posting
    Content:

    We created a custom BI Report - General Ledger Transactions Report. The report works fine but only issue is if I create a new journal and post it, the report does not show the latest journal in the report. It takes at least 10 minutes for this data to appear on the report. If I run the report before waiting for 10 minutes, it does not show the latest journal.

    Does this happen for all BI reports? Is this server issue? 

  • 3262537
    Cannot manage rule in Journal Approval2
    Topic posted December 11, 2019 by 3262537Red Ribbon: 250+ Points 
    Title:
    Cannot manage rule in Journal Approval
    Content:

    Hi All

     

    Do you know where do I need to setup if I can't manage the rule in Journal Approval. The button seems to be disappeared.

     

    Regards

     

    Image:
  • 3262537
    Set rule for journal approval3
    Topic posted November 28, 2019 by 3262537Red Ribbon: 250+ Points, tagged General Ledger 
    Title:
    Set rule for journal approval
    Content:

    Hello

    I'm trying to config the journal approval  for journals that a notification goes to all members of the group - and if any one of the group approves the request, the journal is approved. I have attached the screenshot on this post. Could you advise below please?

    (1) I use the rule SingleTypePaticipantOneInParallelModeRuleSet but I'm not sure what condition to put on the IF condition as I don't have condition just want any approval in the list review and approve the journal. Is 'Journal Batch Ledger' ok to use?

    (2) Where do I set the approval group and add all the managers to this group?

    (3) Is there anything else apart from the rule that I need to config?

    Thank you very much.

     

    Regards

     

     

     

    Image: