College Unique Job Scheduling
UFxxxxJ UPxxxxJ UUxxxxJ UGxxxx Other

UG102M
Monthly GL - P300

This job group extracts data necessary for the monthly accounting process.
Special Instructions All FMS Daily Processing must be completed before this job group begins. This job group is restricted to SBCCE.
Operator Instructions GA1301J : N


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 GA1302J
Update Last Month Closed
  Open Account Detail Report (GA1302)
R 02 01 GA1301J
GL Detail Report Extract
R 03 02 GA1330J
Monthly Transaction Register
  Monthly Transaction Register (GA1330)
R 04 03 GA3237J
Encumbrance Extract For Monthly Operations
R 05 04 GA3230J
Monthly Operations Expenditure Report
  Monthly Operations Expenditure Report (GA3230)
R 06 03 GA2103J
Detail Revenue Report
  Detail Revenue Report (GA2103)
R 07 03 GA1333J
Monthly Reconciliation by Batch of Cash Ledgers
  Monthly Reconciliation by Batch of Cash Ledgers (GA1333)
R 08 01 GA1300J
Accounting Summary Report Extract
R 09 08 GA1331J
General Ledger
  General Ledger (GA1331)
R 10 08 GA1332J
Fund Ledger
  Fund Ledger (GA1332)
R 11 08 GA1334J
Balance Sheet
  Balance Sheet (GA1334)
R 12 08 GA1335J
Program/Organization Trial Balance
  Program/Organization Trial Balance (GA1335)
R 13 08 GA3232J
Cumulative Operations Expenditure Report
  Cumulative Operations Expenditure Report (GA3232)
R 14 08 GA3234J
Program/Object Expenditure Summary
  Program/Object Expenditure Summary (GA3234)
R 15 03 FG029M
AFRS Reporting


Parameters

FND-ARRAY Enter 'ALL' to include every fund. Or, enter up to 15 funds, separated by commas.
GA1300-RPT-TYP M = as of month end
D = as of current date
GA1330-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA1331-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA1332-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA1334-CODES Y = Yes, print both codes and titles
N = No, do not print both codes and titles, print only titles for GL, GL Group, GL Class and GL subclasses
GA1334-FND-SEL 1 = By Fund
2 = GAAFR
3 = NACUBO
4 = All Funds
GA1334-OTHER Y = Yes, include GL groups that are not specified in the GA1334-SECTION parameter in an "OTHER" section
N = No, do not include GL groups that are not specified in the GA1334-SECTION parameter in an OTHER section.
GA1334-PER M = Month to date
F = Fiscal to date
GA1334-SECTION Identifies the GL groups that are to appear in each section of the balance sheet. The GL groups should be specified with a slash (/) between each
group. eg: 1/23
GA1334-SUM-LVL 0 or 1 = Do not summarize
2 = Summarize to GL Subclass level
3 = Summarize to GL Class level
GA1335-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA2103-ALPHA-SRT Y = Yes, sort on trns-desc within subsource
N = No, do not sort on trns-desc within subsource
GA2103-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
. ALPHA CMP SORT SORT
. N Y Campus, Program, Organization Appropriation, General Ledger Source Revenue, Sub Source, Transaction Code, Trans Reversal Code, Batch Number, Document Number Transaction Description
. Y N Campus, Program, Organization Appropriation, General Ledger Source Revenue, Sub Source Revenue, Transaction Description
. N N Program, Organization, General Ledger, Source Revenue, Sub-source Revenue, Transaction Code, Trans Reversal Code, Batch Number, Document Number, Transaction Description
. Y Y Program, Organization, Appropriation, General Ledger Source Revenue, Sub-source Reveneue, Transaction Description
GA3230-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA3230-GRP-OPT Y = Yes, sort by program/organization group
N = No, do not sort by program/organization group
GA3230-RPT-OPT Y = Yes, summarize transactions through REF-DOC-NUM (Order Num)
N = No, do not summarize transactions through REF-DOC-NUM; summarize through DOC-NUM
MO13-RPT-IND 0 = Normal month end reporting
1 = 13th/25th month. Exclude 12th month.
YR-MO The year-month to be processed (YYMM).

Distribution: FMS P060
Created: FRI, JUL 31, 2015, 03:08 PM