Subsidiary detail

The Subsidiary Detail folder provides access to journal detail expanded to include detailed information from subsidiary packages (Accounts Payable, Accounts Receivable, Bank Reconciliation, Fixed Assets, Payroll). The Subsidiary Detail resource inherits its permissions from the Journal Detail resource.

Tip

The Subsidiary Detail HD view has a special System Source filter that allows you to filter the subsidiary detail records by subsidiary package. This filter performs better than alternative means of filtering on this folder by subsidiary package.

Subsidiary detail security

Common accesses available on subsidiary detail

Access A user with this access can...
Data Have read-only access to subsidiary detail from anywhere in the software (e.g., field validations, filters, date expressions).
Report Run reports with subsidiary detail information.
Report Designs Create and edit report designs with subsidiary detail information. This access enables the Report Designs button on the Output tab of report dialogs.
Shared Answers Create and edit saved answers related to subsidiary detail.
Shared Filters Create and edit shared filters on subsidiary detail.
Visible View the Subsidiary Detail folder in the Navigation pane.

Subsidiary Detail filters

The following built-in filters are available for subsidiary detail:

Filter Name Effect
? Account Prompts for an account number or mask and lists the subsidiary detail entries assigned to matching accounts.
? Amount (Debit or Credit) Prompts for a range of amounts and lists the subsidiary detail entries with a debit or credit amount in that range.
? Post Date Range Prompts for a range of posting dates and lists the subsidiary detail entries with a posting date in that date range.
? [Segment Name] (active segments only) Prompts for a segment item for the named segment (wildcards allowed) and returns subsidiary detail entries for accounts with the specified segment value.
? [Segment Name] Range (active segments only) Prompts for a range of segment items for the named segment (wildcards allowed) and returns subsidiary detail entries for accounts with a segment item in the range.
? Source Description/Memo Prompts for a full or partial source description and/or source memo and lists subsidiary detail entries with matching source descriptions and/or source memos.
? Source Detail Description/Memo Prompts for a full or partial source detail description and/or source detail memo and lists subsidiary detail entries with matching source detail descriptions and/or source detail memos.
? Source Name Prompts for a full or partial source name and lists subsidiary detail entries with matching source names.
? SourceReference/ Reference (2) Prompts for up to two source reference values and lists subsidiary detail entries which match one or both references.
Merged Entries Lists merged subsidiary detail entries only.
New Entries Lists unmerged subsidiary detail entries only.
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 ActivityHD 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, rollup, or attribute to define a range or mask on.
Mask
Enter a mask for the account number, segment item, rollup item, or attribute 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, rollup item, or attribute 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, rollup item, or attribute 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.