Prospero supports organizations which use multiple general ledgers or have multiple companies comprising their organization through consolidations. Prospero provides features allowing users to summarize data from different sources in to a common set of reports by “linking” those sources within a single entity.
When establishing your consolidated entity, the following rules and structures apply:
•Entities are created and managed in the Entity Management workspace of the Prospero Master entity. You must log in to the Master entity as a Prospero Systems Administrator.
•All source entities which are consolidated must use the same structure for their chart of accounts.
•All organizations involved in a consolidation must be defined in the same Prospero database via the Entity Management workspace.
•The Consolidation Entity will contain all consolidated report definitions to allow for reports to run across the various source entities. Report definitions specific to a single company should only be defined in that company’s specific entity.
User access to a Prospero entity which is involved in a consolidation can be assigned and managed via Security and the User Definitions for that entity. In a consolidation organization where specific users should only view or manage reports for a single company or entity, they should be assigned only to that company’s specific Prospero entity. Following standard Prospero Security paradigms, these users will be unable to log into the consolidated entity or other entities to which they have no access.
For more information, see Security.
To establish a consolidated access, the Master Entity Management screen:
1. Log in to the Master Entity using your system administrator account. For more information, contact Prospero Support.
2. Click on the Configuration bar in the Prospero Navigation Pane.
3. Click on the Entity icon to open the Entity Management workspace.
4. For the entity to be involved in the consolidation, enter or select the following:
•Entity Code – A code, or ID, which you assign to your Entity.
•Entity Name – The descriptive name which you assign to your Entity
•Administrator Role – The role in Prospero Security which you have designated can create, maintain or remove Entities in Prospero. The Administrator Role value will default to the user/role creating the Entity.
•GL Linked – Check this option to indicate that the Entity and its’ associated data is linked to a General Ledger.
•Default Currency – Select the default currency for Prospero reporting. The default currency will be indicated on the Currency Definition workspace and will not be editable on that workspace.
5. Select the GL Linked Name ellipsis in the Entity Management worksheet to open the Integrations screen.
6. Select the Insert button to add a new entry and open the Select dialog.
7. Choose a GL Link for the entry from the dialog.
8. Select OK to populate the Integrations screen with the entry’s information. Repeat this process in the Integrations dialog for each desired entry.
9. For each line in the Integrations dialog, select the GL Company ID ellipsis.
The GL Company Name and Company Code will populate the Integrations screen with the information selected.
10. Select the OK button so save your information.
Note: To add or delete entities using Entity Management, you must log in to the Master entity using an ID with permission to maintain entities. This is an Administrative-level permission. For more information, see the section on Prospero Security Permissions in Security
For information or assistance on establishing your entity GL structures, contact the MSX Group.