OPTIONS
- O/L-Budget Amounts
- O/L-Actual Amounts
- O/L-Encumbrance Amounts
- O/L-Invoice Documents
- O/L-JV Documents-Actual Amounts
- O/L-All Documents
- O/L-Specific Document
- G/L-Transaction Details
- G/L-Specific Document
DESCRIPTION
The first seven reports provide revenue and expense information for detailed transactions for Budgetary, Actual, Encumbrance, Invoice and JV documents for the operating ledger side. The last two reports provide the balance sheet information for the detailed transactions for the general ledger side.
Columns
Presented by Account, Period, Transaction Date, Document Number, Sequence, Activity Code, Rule Code, Transaction Description, Amount Dr, Amount Cr of all operating accounts within the applicable parameters specified. Page breaks and totals are provided at Fund and Org for O/L and Fund for G/L.
Rows
Are related accounts, subtotals by Account Code for all accounts within the fund.
Summary Totals
Income and Expenses are provided at each break of Fund and Org for O/L and Fund for G/L.
REPORTS & PARAMETERS
Even though the parameter screen is available for all reports, not every report will use all the parameters. In fact, if you input a chart element on the parameter screen and run a report that does not use that parameter, that parameter will be ignored. So in effect, you may think you specified certain criteria when you really didn't. For example, the G/L Transaction Detail may allow you to specify an Index, but will ignore your selection. If no other elements were selected, it will give you a warning message that no qualifications have been selected.Below is a list of all the reports and what parameters they use.
| CATEGORY | REPORT NAME | PARAMETERS USED |
|---|---|---|
| O/L | Budget Amounts | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | Actual Amounts | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | Encumbrance Amounts | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | Invoice Documents | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | JV Documents-Actual Amounts | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | All Documents | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| O/L | Specific Document | Fiscal Year, Fiscal Period, Fund, Org, Account, Program, Activity, Location, Fund Type, Acct Type. Index & Grant |
| G/L | Transaction Details | Fiscal Year, Fiscal Period, Fund, Account, Fund Type, Acct Type & Grant |
| G/L | Specific Document | Fiscal Year, Fiscal Period, Fund, Account, Fund Type, Acct Type & Grant |
Note: Any combination of chart elements can be used for these reports.
EXAMPLE
How many total dollars were spent for Postage for FY08 by the ASUM Administration?
Hint: Search on "ASUM Admin" in the fund lookup and "Postage" in the account lookup.
Parameters Used:
Fiscal Year = 08
Fund = 334001
Account = 62304
Include lower levels? Box
SAMPLE
