Summation account

The Summation accounts page allows you to create accounts that are derived or calculated based on the values of other accounts or specific formulas. A calculated account is used in user defined reports and online input forms.

On this page, you can do the following:

• Create a summation account in the List View tab.

• Display a hierarchical view of summation accounts in the Tree View tab.

• Change summation account codes in the Change Code tab.

• Run a summation account report in the Summation accounts report tab

To access the Summation account page, click Configuration > System Structures > Accounts > Summation Accounts.

Create a summation account (List view tab)

The List view tab is where you create new summation accounts.

Page layout

The left-side panel displays a list of all available summation accounts. It includes these columns:

• Code — The code for the summation account.

• Description — The description of the summation account.

When you select a summation account, the detail table in the right panel shows the accounts assigned to it. It includes these columns:

• Type — The account type — S for Account Summation or A for Account.

• Code — The account code.

• Description — The account description.

• Sign — Indicates whether the account is added (+) or subtracted (−) in the summation.

The upper-right area of the right panel lets you define a new summation account or edit an existing one. It includes these fields:

• Code — The code for the summation account.

• Description — The description of the summation account.

Create a summation account

1. Click . The fields in the right panel are refreshed and ready for your input.

2. Enter a Code and a Description for the new summation account.

3. Click . The button is activated.

4. Click . The Select an Account dialog is displayed.

5. Choose either Account or Account summation from the drop-down. A list of accounts is displayed. You can filter the list by code or description.

   

6. Optionally, select Only the ones that are not used by any calculated amount to further filter the displayed accounts.

7. From the Sign drop-down, select (+) or (-) to add or subtract the selected accounts or account summations.

8. Click to confirm your selection on the summation account, and bring you back to the main Summation Accounts page.

9. Save your input.

     Note:  To remove any line, select it and then, click . Confirm the deletion when prompted.

Display a hierarchical view of summation accounts (Tree view tab)

The Tree view tab gives you a global (hierarchical) view of summation accounts and shows the relationships between them.

The tree view displays the following columns:

• Code — The code for the summation account.

• Description — The description of the summation account.

• Type — The account type — S for Summation or A for Account.

• Actions — Edit icon to open the account in the List view tab.

View summation accounts

You have these options:

• To filter accounts by type, use the Type column filter. Select A for Account or S for Summation.

• To edit a summation account, click in the Actions column. The account opens in the List view tab where you can make changes and save.

Change account codes (Change codes tab)

The Change codes tab is where you change existing summation account codes to new ones.

The tab displays these columns:

• Code — The current summation account code.

• New — Code The field where you enter the replacement code.

• Description — The current description for the summation account.

• New Description — The field where you enter an updated description.

Change a summation account code

1. Click the Change codes tab.

2. Find the code you want to change. Use the Code, New Code, and Description column filters to search for it.

3. Look for the code you want to change.

4. Click in the New Code field, select the existing code, and type the replacement code.

5. Optionally, update the description in the New Description field.

6. Save your input.

View summation account reports (Summation Accounts Report tab)

The Summation Accounts Report is where you run reports on your summation account configuration.

Generate a report

1. In the Period field, the current consolidation period is shown by default. Click to select a different period.

2. Select a Report type. See Report Types below for details on each option.

3. In the File type field, select the output format.

4. Click . After the report is generated, a download link appears for you to view it in the selected file format.

Report types

The Summation Accounts Report tab includes the following report types:

Accounts by summation accounts

This report lists existing summation accounts along with the following details:

• Accounts directly referenced — accounts and/or summation accounts directly used in the selected summation account.

• Accounts indirectly referenced — accounts linked through other summation accounts that are used in the selected summation account.

• Part of — other summation accounts that use the selected summation account.

• Used in user reports (directly) — codes of the reports that directly use the selected summation account.

• Used in forms (directly) — codes of the input forms that directly use the selected summation account.

• Used in validation rules — codes of the validation rules that directly use the selected summation account.

  Note:  When you select this option, a Filter by summation account field appears. Enter a search term and click to narrow the results to a specific summation account. If you leave the filter blank and click , all summation accounts are returned.

Summation accounts by accounts

This report lists the chart of accounts along with the following details:

• Summation accounts that include this account directly — summation accounts in which the selected account is used directly.

• Summation accounts that include this account indirectly — summation accounts in which the selected account is used through other summation accounts.

• Used in user reports (directly) — codes of the reports in which the selected account is used directly.

• Used in forms (directly) — codes of the input forms in which the selected account is used directly.

Accounts not selected in any summation

This report lists all accounts not included in any summation account. This could indicate a configuration issue that affects report accuracy. This report should generally be empty.

Summation account - tree view

This report lets you drill down through nested summation accounts for easier review of complex structures. When you select this option, a Filter by Summation Account field appears. Enter a search term and click to browse all available summation accounts. Select the account you want — any report you export in PDF, XLS, or XLSX format will include only the data for that account. If you leave the filter blank and click , all available summation accounts are returned.