Multi-Company Setup

Body
Title
Multi-Company Setup
URL Name
1069762703
Skip Feed
  1. Hi Rebecca,

    Thank you once again for your message.  We've updated this article regarding limiting a user to a particular ledger.

    User Set Up:

    If you need to limit a user to only enter data in a specific Ledger, versus any or all Ledger(s) then you will want to leverage Salesforce’s Sharing Permissions and Role Hierarchy-based Sharing functionality.

    For example, setting the Ledger to Private will allow you to use the Role Hierarchy to extend permission to anyone in the hierarchy above the record owner.

    Example:

    • Ledger sharing permissions set to Private
    • Accountant for Company A would need to own the Ledger Record for Company A
    • Accountant for Company B would need to own the Ledger record for Company B
    • CFO for the Parent company would need to be set up in a Role hierarchy where both Accountants report to the CFO
    • The two Accountants would then need to have their role hierarchy access set to No Access (limiting them to only see records where the Ledger was set to the one they own)
    • The CFO would need to have his or her role hierarchy access set to View & Edit (allowing them to view and edit records regardless of the Ledger owner)

    Please refer to the Salesforce Roles Hierarchy article for additional information on how to use this functionality.

     

    Thank you!

    Expand Post

  2. Can you add a little clarity around "User Setup - If you need to limit a user to only enter data in a particular ledger."

    The instructions say: For example, setting up record types on the Ledger object and assigning those record types to the appropriate users’ permission set, will limit a user to only being able to enter records for the Ledger they have permission for.

    Would each ledger then have a separate record type, and then would you create separate permission sets to grant access to each ledger, and then apply those permission sets to users as necessary to grant access? 

    Do you need to set the sharing of the ledger to Private to make that work?

    Does this override the "view all" setting for various objects in the Accounting Seed Permission sets?

    Thanks!

    Expand Post

  3. Hi Rebecca,

    It would be best practice to use the ledger field for each company instead of the GLAV and then creating the consolidated report using either the custom reporting tool or a salesforce report where the ledger is filtered for all companies. 

    While consolidating financials, most companies will have a need for elimination entries so it's not as simple as leaving the GLAV blank while running a report. 

    Thank you,

    Ryan


  4. So ... if a company does MOST of their reporting on consolidated financials - does it still make sense to move to using ledgers instead of just GLAV? 

    We're currently working with a company with 6 distinct entities, but 95% of their activity is booked to 1 of them.  They have a site license, so I had been thinking we'd use separate ledgers for the separate entities, but maybe for this company - keeping them in GLAV makes more sense?  6 columns * multiple period and/or budget vectors is a LOT of columns to maintain in the custom reporting tool.  

    Feature request: Consolidated financials in the OOTB AS financial reports.


  5. Hi Katie,

    Yes, they can do this a couple of ways: 

    1. Using the custom reporting tool, adding a column for each ledger. They can then total these up and either leave each column as visible or suppress each ledger column to only show the total. 

    2. Using the SF reporting tool to run a P&L and Balance Sheet with the filter for all ledgers. 

    Thank you,

    Ryan


End of Feed
8 Chatter Feed Items