The Financial View Item window provides journal detail drilldown for financial amount columns, giving you an easy way to investigate the postings behind a summarized total in a financial view.
View journal detail from a financial view
You can drill down on items in a financial view to see journal entry details.
- In the HD view, with the financial view loaded and the accounting period details selected, locate the row you want to view detail for.
- Double-click anywhere in the row. Detail for the selected item displays in the Financial View Item window.
Notice that the left pane shows the columns from the financial view and the corresponding values for the selected item.
- In the left pane, click on a row that represents a total in order to see the journal entries that make up the total in the right pane.
- Browse the detail as desired.
Investigate a summarized total
- View the journal detail
-
Put focus in the Journal Detail pane and press Ctrl+A to select all rows in the view. Notice that the net activity reported in the status bar matches the total you selected in the Value column.
- Use one or more of the following suggestions to investigate the summarized total:
Show the "Entry Merged By" and "Entry Merged (Date)" columns to see when the journal entry was merged and by whom.
Show the "Entry System-Journal Source" column to ensure that postings for a subsidiary control account such as "Accounts Payable" actually came from the subsidiary package.
Show the "Entry Void Status (Voided/Reversal)" column to see which entries have been reversed.
Show the "Account" column to ensure that your rollup structure is including the correct accounts.
If you're including unmerged entries, show the "Entry Merge #" column to see which entries are unmerged.
If the total was correct a few days prior, sort by the Merge # column to view the most recent postings (since they are the likeliest cause of the problem).
Investigate an individual journal detail line
- View the journal detail
-
Locate the detail line to investigate in the Journal Detail pane and double-click it. The detail record opens in the Journal Detail window.
- Use the following suggestions to investigate the detail line further:
If the journal detail is a summarized posting from a subsidiary package such as Accounts Receivable, an additional tab sheet will be visible so that you can see subsidiary detail. Select the tab to see the transactions which were summarized into the detail posting. You can also drill down on individual transactions to continue your investigation, including viewing any attachments to the originating transaction.
Click
to drill down to the associated journal entry in the Journal Entry window to see what else was posted with the detail line.
Note
Since version 6.16 of ActivityHD, new General Ledger installations have been provided a pre-installed Trial Balance financial view. In version 6.21, a corresponding pre-installed report design for the Trial Balance financial view was introduced.
Purpose
The Financial View Report allows you to produce dynamic financial statements for analysis.
Content
The output of a Financial View Report depends on the particular financial view and your report design.
Print the report
- In the Navigation pane, highlight the General Ledger > Financial Views folder and then highlight a financial view subfolder.
- Start the report set-up wizard.
- To report on all or a filtered subset of financial view items:
- Right-click the financial view subfolder and select Select and Report > Financial View Report from the shortcut menu.
- On the Selection tab, define any filters to apply to the data.
- To report on specifically selected financial view items:
- In the HD view, select the financial view items to include on the report. You can use Ctrl and/or Shift selection to select multiple records.
- Click
.
- To report on a particular financial view item from the Financial View Item window:
- In the HD view, locate and double-click the financial view item to report on. The Financial View Item window opens with the financial view item loaded.
- Click .
- To report on all or a filtered subset of financial view items:
- Select the Options tab.
- From the Calendar drop-down list, select the GL calendar to base the report on.
-
To define the reporting period using a relative expression, select or enter the period expression in the Expression field. If you prefer to explicitly enter the year and period, skip to step 6.
You can select from the following common period expressions:
- Current
- Current - 1 period
- Current - 1 year
Alternatively, you can type a valid period expression in the field. For help on period expression syntax, click the help button to the right of the field.
If you select or enter a period expression, ActivityHD adjusts the values in the Year and Period fields accordingly.
If you enter a period expression, skip to step 8.
- From the Year drop-down list, select the year of the period to report on.
- From the Period drop-down list, select the financial period to report on.
- If you only want the report to reflect postings through a particular date, enter the date in the As of field. All postings after the as of date are ignored. The as of date must fall between the current period begin and end dates.
- To include unmerged entries that are not on hold in the report results, mark the Include Unmerged Entries Not on Hold checkbox.
- To include a section at the end of the report with the report settings used to produce the report, leave the Include Report Options checkbox marked. To produce the report without this information, clear the checkbox.
- Select the Sorting tab.
- In the Available Sort Options list box, highlight the field(s) to sort by, then click
to move your selection(s) to the Assigned Sort Options list box. - If you selected multiple sort fields, use
and 
to arrange the sort fields in the order you want them applied. - To start a new page for each change in one of the sorting options you specified, select the sorting option to break on from the Page Break Level drop-down list. If you do not want to insert page breaks, accept "(none)".
- To subtotal based on one of the sorting options you specified, select the sorting option to subtotal on from the Subtotal Level drop-down list. If you do not want to show subtotals, accept "(none)".
- Select the Output tab.
- In the Design field, look up and select the report design to use.
- In the toolbar, click the icon for the type of output you want:
- Provides access to two preview options.- Preview - Click the icon or click the drop-down arrow and select Preview from the drop-down menu to view the report in the Crystal Reports viewer.
- Preview to PDF - Click the drop-down arrow next to the icon and select Preview to PDF to view the report in the PDF reader.
- Opens the Print dialog so that you can select and configure a printer and then print a paper copy of the report.
- Opens the Report Email dialog so that you can address and compose an email that the report will be attached to. For best results, ensure your email client is running before you attempt to send a report via email.
- Opens the Export Report dialog so that you can save the report to a file. File types include Crystal Reports (.rpt), PDF (.pdf), Microsoft Excel (.xls), Microsoft Word (.doc), rich text (.rtf), and XML (.xml).
Data extensions
The following data extension is available for the report:
- Financial view items
Financial View Item Record ID
[Financial View Name] tab
This pane shows the Journal Detail HD view filtered to show all journal detail lines associated with the current financial view item.
Double-click a row in the pane to drill down to its record in the Journal Detail window.
Related Financial Views tabs
If you are viewing a financial view item for a financial view based on one or more designated segments or rollups, one tab displays for each compatible account-based financial view. The tab label corresponds to the name of the financial view.
The Financial View Items pane shows the Financial View Items HD view for the indicated financial view filtered to show the related detail lines in the indicated financial view. This allows you to drill down to even further detail and to perform in-depth investigation and analysis of your data.
Financial view items security
Common accesses available on financial view items
| Access | A user with this access can... |
|---|---|
| Data | Have read-only access to financial view items from anywhere in the software (e.g., field validations, filters, date expressions). |
| Read | Have read-only access to financial view item records. |
| Report | Run reports with financial view item information. |
| Report Designs | Create and edit report designs with financial view item information. This access enables the Report Designs button on the Output tab of report dialogs. |
| Shared Answers | Create and edit action profiles and report profiles related to financial view items. |
| Shared Filters | Create and edit shared filters on financial view items. |
| Visible | View the [Financial View Items] folder in the Navigation pane. |
Calendar Period
A period expression which defines a relative reporting period for the financial view. You can select a period expression from the drop-down list or enter a period expression directly in the field. To explicitly specify a reporting period for the selected calendar, use the Year and Period fields instead.
The dropdown contains the following common period expressions:
- Current
- Current - 1 period
- Current - 1 year
For help with proper period expression syntax, click the help button to the right of the field.
Report Email dialog
- Windows user default account. Sends email using the user's Windows default email account. For most users, this is the account configured in Outlook or another email client application.
- Server personal. Sends email using the email configuration for the system or company server and the email address on the current user's authorized user record. The authorized user record must have a confirmed email address.
- Server generic. Sends email using the email configuration and "from" address for the system or company server. This option requires "Send generic" access to the Server Email resource.
|
5225 S Loop 289, #207 Lubbock, TX 79424 806.687.8500 | 800.354.7152 |
© 2025 AccountingWare, LLC All rights reserved. |