Setting up a Reporting Hierarchy
The process of setting up a reporting hierarchy uses the field customization features of the underlying Salesforce platform. See the Salesforce Help for more information.
In outline, to set up a reporting hierarchy, you must carry out the following steps.
Step 1: Create a custom field on the General Ledger Account object for each level of the hierarchy
The data type for these fields is "Picklist". When you create the fields, you also define the contents of the picklist. For example, you might create the following three custom fields to represent sections of your balance sheet.
Picklist Contents
Picklist |
||
---|---|---|
Balance Sheet 1 | Balance Sheet 2 | Balance Sheet 3 |
Balance Sheet | Current Assets | Bank and Cash |
Accounts Receivable | ||
Provisions | ||
Inventory | ||
Prepayments and Accrued Income | ||
Fixed Assets | Fixtures Fittings and Equipment | |
Land and Buildings | ||
Intangible Assets | Intangible Assets | |
Current Liabilities | Accounts Payable | |
Accruals and Deferred Income | ||
Employment Payables | ||
Tax Liability | ||
Long Term Liabilities | Payables After 1 Year | |
Shareholders Funds | Capital and Reserves |
See the Salesforce Help topic "Adding Fields" for further guidance on adding custom fields to objects.
Step 2: Create dependent relationships between fields
These relationships dynamically filter the available values in a picklist based on the value selected in the controlling field.
See the Salesforce Help topic "Defining Field Dependencies" for more information.
Step 3: Select the appropriate picklist values when you create each new general ledger account
For a general ledger account called:
- "Bank Account – Current", you might select "Balance Sheet", then "Current Assets", and then "Bank and Cash".
- "Accounts Payable Control", you might select "Balance Sheet", then "Current Liabilities", and then "Accounts Payable".
- "Bank Loan", you might select "Balance Sheet", then "Long Term Liabilities", and then "Payable After 1 Year".
- "Share Capital", you might select "Balance Sheet", then "Shareholders Funds", and then "Capital and Reserves".
Certinia applications have sample reporting hierarchies already set up. These are examples on which you can base your own customized reporting hierarchies to reflect your own business environment.