Created by Miki Yanagi, last modified on Apr 15, 2021

MaineStreet Finance Query

These queries are created for UMS05 and UMS04 only.

Query NameShort Description
UM_GL_SUMMARYGL output which includes budget, revenue, expenses, and the balance for a given accounting period
UM_JOURNAL_ACTIVITYJournal detail for a given dates


These public queries might be helpful.

Query NameShort Description
UMS_DTS_HR_DETAILReconcile accounts for salary

UMS_DTS_UM_FAST_XLAT_VW

look up HR ACCOUNTING ID

Resource

Other Resources available in UM Finance Google Drive


Instruction

Templates (need to download)

PC users

Mac users

Other information

(Link to UM Finance Google Drive -restricted access)