JIRA Reference:
REPORT-448
-
Query help
Closed
Report Purpose
This report provides each transaction by business unit, fund, account, department, program, and journal dates.
It is recommended to schedule the query or to limit criteria (eg. very narrow date range) since this report gets very large.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_JOURNAL_ACTIVITY
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt. Leave the prompt blank if you would like to get all data except journal dates.
- Business Unit
- Fund Code
- Account (From / To)
- DEPTID (From / To)
- Journal Date (From / To)
- Program Code
Data Fields Generated
| Account | Account Name | Class | Dept | Fund | Program | Amount | Line Descr | Journal Date | Ref | Journal Source | Posted Date | Ledger Grp | Journal ID | Source | More Info* |
|---|
*More Info is the journal description for AP only.
Tables Used (For DARTS users only)
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a report?
Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustments. Please see Security Questions (PS Query/Discoverer).
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.