DARTS : Revenue & Expense Report

Report Purpose

This report provides Base Budget, Current Budget, Current_month, YTD actual, and Budget Balance for revenue and expenses by department and account.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

• UMS_DTS_REVENUE_EXPENSE
• UMS_DTS_REVENUE_EXPENSE_AUX    (Auxiliary fund (03) only)
• UMS_DTS_GL_SUMMARY  (no restriction on account range)
  

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

For UMS_DTS_REVENUE_EXPENSE & UMS_DTS_GL_SUMMARY:

• Fiscal Year
• Accounting Period 
• DEPTID (range, enter same DEPTID if only one)
• ACCOUNT (range, enter same Account number if only one)
• Fund Code (Leave it blank if you want to include all fund code)
• Program Code (Leave it blank if you want to include all programs)
• Business Unit (Leave it blank if you want to see data from all business unit)
  
  

For UMS_DTS_REVENUE_EXPENSE_AUX:

• Fiscal Year
• Accounting Period 
• Business Unit (Leave it blank if you want to see data from all business unit)

Data Fields Generated

For UMS_DTS_REVENUE_EXPENSE & UMS_DTS_GL_SUMMARY:

For UMS_DTS_REVENUE_EXPENSE_AUX: (same as above except fund code)

Tables Used

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_GLQ_ACCTA - GL reporting account attribute

Criteria Used

For UMS_DTS_REVENUE_EXPENSE:

• A.ACCOUNT between 40000 and 89999
  

For UMS_DTS_REVENUE_EXPENSE_AUX:

• A.FUND_CODE = '03'
• A.ACCOUNT (BETWEEN 40000 AND 89999) and A.ACCOUNT (NOT BETWEEN 65900 AND 65999)