General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Kim Berry
    Default Balancing Segment Value in account code distribution...
    Topic posted April 11, 2019 by Kim Berry, tagged Configuration, Financials, General Ledger, Intercompany, Payables, Receivables, Security, Setup / Administration, Subledger Accounting 
    222 Views, 2 Comments
    Title:
    Default Balancing Segment Value in account code distribution based up Legal Entity / Business Unit in which the transaction is entered
    Summary:
    Balancing segment value to default into Transaction Account Code Combination in AP & AR workbench
    Content:

    We have a single Ledger with four Legal Entities (LE). Each Legal Entity has a Balancing Segment Value (BSV) assigned and each LE has a Business Unit (BU). There is an intercompany relationship between 2 of the Legal Entities and the other 2 legal entities do not.

    The AP and AR Users operate in a 'Shared Service' environment and will have access to multiple BU's for transactional entry purposes

    As there are 4 LE's there are 4 BSV's and we want to restrict the BSV's available to the Users for transaction entry purposes (Charge Accounts and Revenue Accounts).

    Goal - To Default the BSV in the Charge Accounts and Revenue Accounts based upon the LE / BU in which the transaction is entered. To further restrict the selection of the BSV and display BSV values where an inter company relationship exists

    e.g. Four LE BSV Values

    ABC1

    ABC2

    ABC3

    ABC4

    Intercompany Relationship defined  between ABC1 and ABC2

    User transacting  in ABC1 BU the Charge Account BSV defaults ABC1. The User can select/update to ABC2

    User transacting in ABC2 BU the Charge Account BSV defaults ABC2. The User can select/update to ABC1

    User transacting  in ABC3 BU the Charge Account BSV defaults ABC3. The User can select/update to ABC3 only

    User transacting  in ABC4 BU the Charge Account BSV defaults ABC4. The User can select/update to ABC4 only 

    The ability for Users to select an incorrect BSV values prevents SLA transfer where intercompany relationships are not defined

     Any ideas how this goal can be achieved

    Version:
    Cloud R13

    Comment

     

    • Sean Chen

      Seems like it's ER 29503272 mentioned in Default Company Segment Value (Doc ID 2519487.1)

    • Prithis Das

      You may be able to achieve this using additional Data Access Sets with the Access Set Type set to Primary Balancing Segment Value instead of Full Ledger. Using your example, you would need 3 additional DAS:

      1. Data Access Set "ABC1-ABC2" would be setup with both the BSVs ABC1 and ABC2.
      2. Data Access Set "ABC3" would be setup with BSV ABC3 only.
      3. Data Access Set "ABC4" would be setup with BSV ABC4 only.

      You would then assign the three Data Access Sets to individual users.they should be restricted to the single BSV or two BSVs as the case may be.

      Also, in AR you can assign AutoAccounting to derive the Balancing segment from the AR Transaction Type, and assign the appropriate LE as well as the Receivables and Revenue accounts with the correct BSV to the Transaction Type. The user would select the appropriate Transaction Type (which again can be controlled through Reference Data Sets assigned to the BU. The Transaction Type would then default the correct LE as well as the BSV for the invoice distributions.

      Please let me know your thoughts!

      Thanks