Journal detail

The Journal Entry Detail folder provides access to the journal detail lines which constitute your journal entries. From this folder, you can view detail lines, run bots, and access the drilldown tool.

Run the Journal Entry Inquiry bot

You can drill back from a journal detail record in ActivReporter to the Journal Entry Inquiry window in Dynamics-GP.

  1. In the Journal Detail HD view, highlight the journal detail record you want to research.
  2. In the toolbar, click and select Journal Entry Inquiry from the drop-down menu, or press Ctrl+J. The inquiry window opens with the requested journal entry record.

    Tip

    You can also access the Journal Entry Inquiry bot from the Journal Entry and Journal Detail windows as well as the Journal Entries HD view.

Drill down on journal detail

The Drilldown Explorer lets you execute a financial function and view the result as well as the detail behind the calculation.

  1. In the Navigation pane, highlight the ActivReporter > Journal Entries > Journal Detail folder.
  2. Right-click the folder and select Drilldown Explorer from the shortcut menu.

  3. From the Function drop-down list, select the financial function to view details for. Select from among the following functions:
    • Activity
    • Balance
    • Begin Balance
    • Year to Date
    • Credit Activity
    • Credit Balance
    • Credit Year to Date
    • Debit Activity
    • Debit Balance
    • Debit Year to Date
  4. In the Calendar Period field, click the field to select the accounting period for which to view journal detail. The popup opens where you can specify an explicit calendar period to view detail for or you can enter or select a relative period expression. An asterisk (*) after the period name indicates a relative period expression is applied.
  5. If you need to specify a date in the period to view journal detail for other than the last day of the selected calendar period, enter the date in the As Of field. Otherwise, the date defaults to the last day of the selected period.
  6. If you want to include unmerged transactions in the results, mark the Include Unmerged checkbox.
  7. If you want to limit the detail based on an items expression, click to open the dialog box where you can build an expression by selecting items and specifying constraints.
  8. Click Calculate. The journal detail records which match your criteria load in the view.

View the journal entry associated with a detail record

You can view the journal entry associated with a detail record from the Journal Detail window.

  1. Open the journal detail record.
  2. In the toolbar, click . The associated journal entry opens.

Filter journal detail by journal type

You can filter the Journal Detail HD view by journal type. To do so, select a journal type from the Filters drop-down list. Valid journal types are:

  • Financials Journal
  • Inventory Journal
  • Payroll Journal
  • Project Journal
  • Purchasing Journal
  • Sales Journal

Each journal type is identified by the value in the custom Series field on the related journal entry. The values and the associated journal types are:

  • 2 = Financials Journal
  • 3 = Sales Journal
  • 4 = Purchasing Journal
  • 5 = Inventory Journal
  • 6 = Payroll Journal
  • 7 = Project Journal

A "Budget Entries" filter is also available to show journal detail entries with a System-Journal Source of "GP-Budget".

x

Account Conditions

Condition Expression

If the account mask you specified in the field that accompanies the Condition field is too broad or too narrow to capture the accounts you need, enter a SQL condition statement here to exclude or include accounts. Accounts are included which satisfy both the condition and the account mask.

If you entered a condition in the underlying field, it is carried over into this text box.

Alternatively, you can use the table below to describe the conditions you need and ActivReporter will build and add the conditions to this text box.

Conditions table
Use this table to construct the conditions you need in order to accurately select accounts.
Item
From the drop-down list, select the account, segment, or rollup to define a range or mask on.
Mask
Enter a mask for the account number, segment item, or rollup item when the items you need to select have common characters but are not in a particular order.
Begin
Enter the first account number, segment item, or rollup item in the range of items you need to select. Use a range when the items are in a defined order.
End
Enter the last account number, segment item, or rollup item in the range of items you need to select. Use a range when the items are in a defined order.
Check Conditions button
Click this button to check for SQL errors in the condition statement.

 

x

Calendar Period

Calendar
The GL calendar to use to view journal detail.
Expression

A period expression which defines a relative reporting period to view journal detail for. 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.

Year
The year from the GL calendar to view journal detail for. If a period expression is entered in the Expression field, ActivReporter automatically updates this field for you.
Period
The period from the selected year to view journal detail for. If a period expression is entered in the Expression field, ActivReporter automatically updates this field for you.