Selecting data for balance inquiries

Select the activities to analyze amounts. You can select one of these options:

• An activity group list to analyze information for all activities defined for the activity groups you include in the list.
• An activity group to analyze information for all the activities included in the group.
• Up to six different activities to analyze information for a select set of activities.
• An activity list to analyze information for all the activities included in the list.

Select at which activity level amounts you intend to display:

• The default setting is - All, which displays amounts for posting, summary, and contract level activities.
• Select P - Posting to display amounts for all posting level activities.
• Select S - Summary to display summarized amounts at the summary and contract activity level.

Select the amounts to display for a specific activity level. The default setting is 0 - All Activities, which shows amounts at all levels. You can also set the levels from 1 to 5.

Select the account categories to analyze amounts. You can select one of these options:

• Account Category Group: Analyze information for all the account categories included in the group.
• Account Cat Type: Analyze activity information for all R - Revenue, C - Cost, or A - accrual account categories. Pass Thru amounts are included when you select A - accrual.
• Account category: Analyze activity information for an account category.
  Note: To include all account categories, create an account category group using Account Category Group (AC05.2), where the All flag is set to Y - Yes.

On Activity Accounting Unit Analysis (AC94.1) only.

You can analyze information within a specific company range. Specify the beginning company in this field.

You must associate the companies with the activity group list, activity group, activity, or activity list.

To analyze amounts for a specific company, specify that company in this field and leave the Through Company field blank.

You can analyze information within a specific accounting unit range. Specify the beginning accounting unit in this field.

To analyze amounts for a specific accounting unit, specify that accounting unit in this field and leave the Through Accounting Unit field blank.

On Resource Analysis (AC92.1) only, select a specific resource type to analyze amounts:

• E - HR Employee

• V - AP Vendor

• A - AM Asset

• P - AC Person

• Q - AC Equipment

  Select a GL company, HR Company, or AP company to go with the resource type selected. For example, if you select E - HR Employee as the resource type, select an E - HR Company in the company field.

  See Define resources.

On Resource Analysis (AC92.1) only, select up to six specific resources to analyze amounts.

See Define resources.

Specify at least a From Period and a From Year to indicate the time period to analyze information. To analyze amounts for a specific period, specify that date in the Beginning Period field and leave the Through Period field blank.

Select whether to display amounts for the L - Life-to-date, Y - Year-to-date, P - Period-to-date, or for a R - Range of periods.

You can only select L - Life-to-date if the Through Period and Year fields are blank. Life-to-date is the sum of balances from the beginning of the life of the activity through the specified period and year.

You can only select Y - Year-to-date if the Through Period and Year fields are blank. The Y - Year-to-date value is the sum of balances from period 1 through the specified period for the specified year.

You can only select P - Period-to-date if the Through Period and Year fields are blank. The P - Period-to-date value is the balance for the specified period and year.

You can only select R - Range of periods if you select a From and Through Period and a From and Through Year.

Select a budget number to analyze activity amounts. If you leave this field blank, then the active budget associated with each posting activity is included. You must specify a budget number for summary activities.

Select a specific currency code. If you leave this field blank, then the activity group base currency for each activity included in the inquiry is used.

If you are analyzing information for activities that use multiple currencies, then you must select a currency code.

Select whether you view amounts or units.

If you leave this field blank, then information in amounts are displayed.

Select whether activities with zero amounts are included. The default setting is No.

Select the decimal places to which amounts or units are rounded. The default setting is W - Whole, which means no rounding. You can select decimals for Two places, Thousand, or Million.

Select whether to display as a percent of the budget or the remaining budget.

Select how account category amounts display. The default setting is Activity-Grp/Activity, which displays account category amounts in the activity group/activity structure.

You can select to analyze account category amounts by the Activity-Grp/Var-Levels.