FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG141M
SBCTC - Month End Reports

This job group extracts records for the monthly accounting process, and optionally provides month end reports.
Special Instructions All FMS Daily Processing must be completed before this job group begins. The parameters that appear will depend on the jobs that are selected.
Operator Instructions GA1301J : N


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 GA1501J
Close GL Posting
R 02 01 GA1502J
GL Posting Phase I
R 03 01 GA1503J
GL Posting Phase II
R 04 01 GA1211J
Audit Account Structure
R 05 04 GA1212J
GL Transaction Cleanup Report
  GL Transaction Cleanup Report (GA1212)
R 06 05 GA1206J
Reprocess Posting Error File
R 07 06 GA1205J
Daily Batch Processing
R 08 07 GA1204J
Process Pooled Cash
R 09 08 GA1205J
Daily Batch Processing
R 10 09 GA1501J
Close GL Posting
R 11 10 GA1200J
Daily Batch Report
  Daily Batch Summary (GA1201)
  Daily Batch List (GA1202)
R 12 11 GA1207J
Posting Error File List
  Posting Error File List (GA1207)
R 13 12 GA1302J
Update Last Month Closed
  Open Account Detail Report (GA1302)
R 14 13 GA1301J
GL Detail Report Extract
R 15 14 GA1330J
Monthly Transaction Register
  Monthly Transaction Register (GA1330)
R 16 15 FG010M
Monthly Oper. Report, Subgroup of FG012M
    GA3237J
Encumbrance Extract For Monthly Operations
    GA3230J
Monthly Operations Expenditure Report
  Monthly Operations Expenditure Report (GA3230)
R 17 16 GA2103J
Detail Revenue Report
  Detail Revenue Report (GA2103)
R 18 17 GA1333J
Monthly Reconciliation by Batch of Cash Ledgers
  Monthly Reconciliation by Batch of Cash Ledgers (GA1333)
R 19 18 GA1300J
Accounting Summary Report Extract
R 20 19 GA1331J
General Ledger
  General Ledger (GA1331)
R 21 20 GA1332J
Fund Ledger
  Fund Ledger (GA1332)
R 22 21 GA1334J
Balance Sheet
  Balance Sheet (GA1334)
R 23 22 GA1335J
Program/Organization Trial Balance
  Program/Organization Trial Balance (GA1335)
R 24 23 GA3232J
Cumulative Operations Expenditure Report
  Cumulative Operations Expenditure Report (GA3232)
R 25 24 GA3234J
Program/Object Expenditure Summary
  Program/Object Expenditure Summary (GA3234)
R 26 25 FG029M
AFRS Reporting
    CR2351J
Extract AFRS Report File
    CR2352J
AFRS Accounting Transactions Report
  AFRS Accounting Transactions Report (CR2352)
    CR2353J
AFRS Not Reported
  AFRS Not Reported (CR2353)
    CR2354J
AFRS/FMS Cross Reference
  AFRS/FMS Cross Reference (CR2354)
    CR2355J
AFRS Extract Error List
  AFRS Extract Error List (CR2355)
    CR2356J
AFRS IN-PROCESS Transactions
  AFRS IN-PROCESS Transactions (CR2356)
    CR2359J
Transport AFRS Report File
    CR2101J
Accounting/Budget Rollup For SBCCE Reporting
    CR2132J
Create FAE Transfer File
  FAE Extract For SBCCE Reporting (CR2132)
    CR2141J
Facilities Extract For OFM
  OFM Facilities Extract (CR2141)
    CR2321J
MWBE - Extract MWBE Data
  MWBE Expend/Accrual Report (CR2321)
R 27 26 GA1309J
Copy Account Detail For Archival


Parameters

FND-ARRAY Enter 'ALL' to include every fund. Or, enter up to 15 funds, separated by commas.
GA1200-BEG-DATE Defaults to the scheduled run date. When reprinting batches from prior dates, enter the beginning date in YYMMDD format to be used as selective criteria.
GA1200-END-DATE Defaults to scheduled run date. When reprinting batches from prior dates, enter the ending date in YYMMDD format to be used as selection criteria.
GA1200-SRT-OPT 1 = GA1202 (PROCESSED BATCH) (DEFAULT) BTCH-ID/BTCH-DATE/SUB-BATCH GA1201 (BATCH SUMMARY) (DEFAULT) BTCH-DATE/BTCH-ID/SUB-BATCH
2 = GA1202 (PROCESSED BATCH) BTCH-DATE/BTCH-ID/SUB-BATCH GA1201 (BATCH SUMMARY) BTCH-DATE/BTCH-ID/SUB-BATCH
GA1204-DATE The current scheduled date (YYMMDD).
GA1211-DATE The date of the report (YYMMDD). If no date is entered, the current date is used (default).
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 P900
Created: FRI, JUL 31, 2015, 03:08 PM