1 / 2

NAMING EXAMPLES (50 characters):

CSE CHART OF ACCOUNTS NAME GAME. Why Name Strings? *Names vs. Numbers : A Picture is Worth 1000 characters… *Easier for Non-Accountants to Decipher : Connect the Dots *Reconciliation : You may now pass GO! *Track & Report ACTIVE vs. INACTIVE chart string activity: Chutes & Ladders

ismael
Download Presentation

NAMING EXAMPLES (50 characters):

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSE CHART OF ACCOUNTS NAME GAME Why Name Strings? *Names vs. Numbers: A Picture is Worth 1000 characters… *Easier for Non-Accountants to Decipher: Connect the Dots *Reconciliation: You may now pass GO! *Track & Report ACTIVE vs. INACTIVE chart string activity: Chutes & Ladders *Budget Prep: YAHTZEE! How Do you Name Strings? JOB AID: CHARTIFELD REPORT MASK: http://www.umn.edu/ohr/prod/groups/ohr/@pub/@ohr/@trainingservices/documents/asset/ohr_asset_175694.pdf NAMING EXAMPLES (50 characters): 1000 (O&M): DEPT GENERAL OPERATIONS 1024 (ICR): AKKIN START UP FUNDS 1026 (OTHER UNRESTRICTED): BME FIXED PRICE CLOSEOUT 1150 (ISO): CHARFAC OPERATIONS COST SHARE: PAUL STRYKOWSKI 1% CS LSAMP UROP: KOTHARI UROP SUM/FALL 09 1701 (FOUNDATION): CSESS K ANDERSON MATH and SCI SCHOL (UGRA--E--MERIT) 1750 (TREASURY): CSESS JAMES KOTTKE MEM SCHOL (P000002060) Who Can Help? Finance Team Do you have an internal naming COA document that could be sent over for Mask entry? Managing the COA? UMREPORTS (group by description), COA query

  2. CHART OF ACCOUNTS NAMING QUERY SELECT DESCR50 AS "CHART STRING NAME", FUND_CODE, DEPTID, PROGRAM_CODE, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 AS "EMPLID", PROJECT_ID, LASTUPDOPRID FROM FS_PS_FGL_CF_MASK WHERE DEPTID = '11055' If you have 1 deptid, clause should be entered like this: A.DEPTID = ‘11107’ If you have more than 1 deptid and they are sequential (i.e. 11101, 11102, 11103, 11104, 11105, 11106), clause can be entered like this: A.DEPTID BETWEEN ‘11101’ AND ‘11106’ If you have more than 1 deptid and they are not sequential (i.e. 11107, 11073), clause can be entered like this: A.DEPTID IN(‘11107’, ‘11073’)

More Related