Options tab
Current Period
The current period to use for calculations in the financial design.
Calendar
The GL calendar to use for the financial design. If the selected calendar contains today's date, the Year and Period fields default to the calendar period which contains today's date. Otherwise, if the calendar does not contain today's date, the fields default to the last valid period before the current date.
Expression
A period expression which defines a relative reporting period for the financial statement. 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 use for the financial design. If a period expression is entered in the Expression field, ActivityHD automatically updates this field for you.
Period
The period from the selected year to use for the financial design. If a period expression is entered in the Expression field, ActivityHD automatically updates this field for you.
As of
The date through which to include postings on the financial report. All postings after the as of date are ignored. The as of date must fall between the current period begin and end dates. Leave the field blank to include all postings for the specified period.
Currency Unit
The currency unit to report amounts in if different than the unit(s) specified on the affected accounts. If blank, the units specified on affected accounts are used. For optimal performance, only enter a unit if translation needs to be performed from one unit to another.
Note
If you are generating a report from a layout template and want the currency unit to display below the main heading, specify the reporting unit to use and ensure that the unit record includes a description.
Use Live Data
Mark this checkbox if you want to show actual data in your financial design as you work. Otherwise, the design will show zeros for amounts.
Include Unmerged Entries not on Hold
This checkbox is enabled if the Use Live Data checkbox is marked. Mark this checkbox to include unmerged entries which are not on hold in your live data.
Iteration Limits table
Use the table to restrict the data which is reported by the financial design.
Type
The account, segment, rollup, or attribute to limit by.
Item(s)
The mask or value(s) for the account number, segment item, rollup item, or attribute item to limit by.
Note
The Find dialog on the Item(s) field supports multi-select. For example, if you choose "Department" in the Type field, you could use Ctrl and/or Shift selection in the Find dialog on the Item(s) field to select multiple departments for iteration. This feature allows you to create a consolidated financial for a set of items.