Report Analysis of Account Activity

Use this routine to report account activity for specified accounts for a range of dates, for both open and closed fiscal periods. Once the report criteria have been selected, click Run to produce the report.

In order to access this screen, individual users must have permission via the No Inquiry Allowed field in General Ledger User Permissions. This field must be unchecked or users receive warning that they do not have clearance to use this process.

If you choose Excel® as your output option at the Send Output To field, the report includes the following columns:

If you run the report for sources APVE and APVM only, the Reference Number and Reference Name columns contain display-only vendor numbers and vendor names, respectively.

Selection

Enter the root accounts for which you want to run this report. If you leave this field blank, you choose all root accounts. If you click on the Arrow, a list of root accounts appears from which you can choose. If you click on the Action button, you access the Multiple GL Account Selection screen, from which you can choose one or more root accounts.

For each root account you select, the report includes all associated sub-accounts and cost centers. If you specify a root account, you clear and inactivate the following fields:

Account Group
Account Sub-Class
Account Class

The lists of accounts that appear at this field are restricted by the General Ledger User Permissions routine.

Enter the sub-accounts for which you want to run this report. This field is active only if you use sub-accounts. If you leave this field blank, you choose all sub-accounts. If you click on the Arrow, a list of sub-accounts appears from which you can choose. If you click on the Action button, you access the Multiple GL Sub-Account Selection screen, from which you can choose one or more sub-accounts.

For each sub-account you select, the report includes all associated cost centers. If you specify no root accounts, the report includes all root accounts associated with the specified sub-accounts.

The lists of sub-accounts that appear at this field are restricted by the General Ledger User Permissions routine.

Enter the cost centers for which you want to run this report. If you leave this field blank, you choose all cost centers. If you click on the Arrow, a list of cost centers appears from which you can choose. If you click on the Action button, you access the Multiple GL Cost Center Selection screen, from which you can choose one or more cost center.

If you specify no root accounts, the report includes all root accounts associated with the specified cost centers. If you specify no sub-accounts, the report includes all sub-accounts (if any) associated with the specified cost centers.

The lists of cost centers that appear at this field are restricted by the General Ledger User Permissions routine.

Sorting

Use these fields to specify your sort sequence and to insert page breaks (if any) between sorts. You can select any combination of the following:

Class
Sub-Class
Group
Account
Account
Sub-Account
Cost Center
Date
Source

If you select the Account option, you cannot select any of the account element options at subsequent Sort fields. The Account option sorts by root account, sub-account, and cost center. |

If you select the Date or Source options, the report includes columns for Post Date and Time. If you do not select one of these as a sort option, the report displays starting and ending balances.