CenterPoint Fund Accounting - Smart Summarization in Reports

 

Document #: 3189 Product: CenterPoint®

 

A “smart summarization” feature allows the following reports to improve your reporting needs:

  • General Ledger
  • General Ledger Account Activity
  • General Journal Activity by Account
  • Purchases by Vendor and Account

The smart summarization automatically displays different data based on the columns included in the report.

  • If you preview the report with no department/profit center or location/production detail columns included, the data is summarized by the account for each transaction. For example, if you had multiple lines in the same transaction that used the same account but different department/profit center or location/production details on each line, the account will be summarized into one line. Using account distributions is an example of posting multiple lines to one account.
  • If you add the department/profit center or location column to the default report, each account will be summarized by department/profit center or location.
  • If you add the columns for profit center, production center, and location/production year, each account will be summarized by profit center, production center, and location/production year.

Each variation of the report can be saved in your favorites and ready for you needs, whether it be details or a summary.

The following example shows how a repair transaction assigned to multiple departments would look based on the columns included in the report.

Example 1: No Extra Columns Included - Summarized Report

  1. Select Reports > Reports > Transaction Reports > and one of the reports mentioned above. In our examples, we'll be using the General Ledger Account Activity report.
  2. In this example the default report was used (no extra columns were added to the report) so the transaction data is automatically summarized by the account.

Example 2: Data Summarized by Department (within each account)

  1. Select Reports > Reports > Transaction Reports > and one of the reports mentioned above.
  2. Click Preview and then select the Columns tab. Include the Department column.
  1. Click the Refresh button and the modified report will be displayed. Because the Department column was included, the $100 transaction is summarized by Department instead of by account as shown in the first example.

Concept Link IconSee Also