UMSAccounting

JIRA Reference:   DM-270 - SFA - Reserve for Doubtful Accounts Balances EB Closed

Report Purpose

This report is used by the UMS Accounting staff and returns Year to Date and Project to Date monetary amounts for a specific range of accounts by department and business unit. 

Accounts: ('13003','13109','13015','13001','13106','13002','13100','13107','66201','13000')

Report Location

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

Report Name

UMS_DTS_RES_DOUBT_ACCTS

Report Type

Query

Prompts Required

Accounting Period & Fiscal Year

Accounting Period and Fiscal Year Calculation

Data Fields Generated

PeriodDeptDept DescFundProgramProjectAccountClassYear to DateProject to DateUnit

Tables Used


UM_GLQ_REPRTING - Ledger Data


Criteria Used


Account: in list ('13003','13109','13015','13001','13106','13002','13100','13107','66201','13000')


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!

Round, red help button. Click to email DARTS.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.

Attachments:

Capture.PNG (image/png)