FG012M Monthly General Ledger Reporting

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

Job listings

Job ID

Description

GA1302J

Update Last Month Closed

Open Account Detail Report (GA1302)

GA1303J

Recompute Balances From Accounting Detail

Acct Detail/Acct Summary Discrepancies (GA1303)

GA1301J

GL Detail Report Extract

GA1300J

Accounting Summary Report Extract

FG029M

AFRS Reporting

AFRS Accounting Transactions Report (CR2352)

AFRS Not Reported (CR2353)

AFRS/FMS Cross Reference (CR2354)

AFRS Extract Error List (CR2355)

AFRS IN-PROCESS Transactions (CR2356)

FAE Extract For SBCCE Reporting (CR2132)

OFM Facilities Extract (CR2141)

MWBE Expend/Accrual Report (CR2321)

GA1330J

Monthly Transaction Register

Monthly Transaction Register (GA1330)

GA3200J

Record Vpa Reimbursement In Next Month

GA3231J

Vendor Payment Advance Reimbursement Report

Vendor Payment Advance Reimbursement Report (GA3231)

FG010M

Monthly Oper. Report, Subgroup of FG012M

Monthly Operations Expenditure Report (GA3230)

GA2103J

Detail Revenue Report

Detail Revenue Report (GA2103)

BM3230J

Check Register

Check Register (BM3230)

GA1331J

General Ledger

General Ledger (GA1331)

GA1332J

Fund Ledger

Fund Ledger (GA1332)

GA1333J

Monthly Reconciliation by Batch of Cash Ledgers

Monthly Reconciliation by Batch of Cash Ledgers (GA1333)

GA1334J

Balance Sheet

Balance Sheet (GA1334)

GA1335J

Program/Organization Trial Balance

Program/Organization Trial Balance (GA1335)

GA3232J

Cumulative Operations Expenditure Report

Cumulative Operations Expenditure Report (GA3232)

GA3233J

GL Allotment Balances by Fund/Appr

GL Allotment Balances by Fund/Appr (GA3233)

GA3234J

Program/Object Expenditure Summary

Program/Object Expenditure Summary (GA3234)

GA3235J

GL Allotment Balances by Program/Fund/Appr

GL Allotment Balances by Program/Fund/Appr (GA3235)

GA2104J

Summary of Receipts, Transfers and Fund Balances

Summary of Receipts, Transfers and Fund Balances (GA2104)

GA2108J

Revenue Summary Report

Revenue Summary Report (GA2108)

GA3236J

Reimbursable Expenditure Detail Report

Reimbursable Expenditure Detail Report (GA3236)

GA2109J

Revenue Subledger Report

Revenue Subledger Report (GA2109)

MM2205J

1099 Summarization Process

1099 - Misc Detail Report (MM2205A)

1099 - Misc Detail Summary Report (MM2205B)

1099 - Misc Error Report (MM2205C)

MM2206J

1099 Misc Summary (by Month) Report

1099 Misc Summary (by Month) Report (MM2206)

GA1318J

Online GL Archival Batch Process

CR2701J

Smartbuy Extract - SBCTC

GA1309J

Copy Account Detail For Archival

BM1768J

Purge Credit Card Data - CA

Purged Credit Card Report (BM1768)

Parameters

Job parameters
Parameter	Values
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
GA2108-CMP-SRT	Y = Yes, sort by campus N = No, do not sort by campus
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
GA3233-RPT-PER	M = Month to date F = Fiscal to date B = Biennium to date
GA3235-RPT-PER	M = Month to date F = Fiscal to date B = Biennium to date
GA3236-CMP-SRT	Y = Yes, sort by campus N = No, do not sort by campus
GA3236-CURR-OPT	Y = Yes, print report as of current date N = No, do not print report as of current date; print report as of last month end
GA3236-SRT-OPT	Reimbursable Code Sort Option 1 = sort on 1st digit of reim-cd 2 = sort on 2nd digit of reim-cd 3 = sort on both digits of reim-cd
JV-NUM	The REF-DOC-NUM to be used for Vendor Payment advance reversal.
MM2205-SORT-OPT	V = Sort by Vendor Number N = Sort by Vendor Name S = Sort by Tax identification number (SSN)
MM2206-CLAS-OPT	Refers to the 1099 classification. Valid entries are: MO - Other M1 - Rents M2 - Royalties M3 - Prizes and Awards M4 - Federal Income Tax Withheld M5 - Boat Proceeds M6 - Medical and Health M7 - Non-Employee Compensation M8 - Substitute Payments in Lieu of Dividends or Interest M9 - Direct Sales MA - Crop Insurance Proceeds MB - Excess Golden Parachute Payments EXAMPLES: Enter two characters (M7) for a report on 1099 Class M7. Enter M1,M2,M7 for a multiple 1099 Class report on classes M1, M2, and M7.
MM2206-MO-OPT	Indicates which month(s) will be printed. To report one month type in 01 (e.g., JAN). To report more than one month, separate by commas (e.g., 01,02,03....12). To report all twelve months, type in ALL.
MM2206-RPT-YR	The last two digits of the calendar year (YY).
MM2206-SORT-OPT	V = Sort by Vendor Number N = Sort by Vendor Name S = Sort by Tax identification number (SSN)
MO13-RPT-IND	0 = Normal month end reporting 1 = 13th/25th month. Exclude 12th month. 2 = 13th/25th month. Include 12th month.
REPROCESS-OPT	Y = Yes, reprocess 1099 Summarization N = No, do not reprocess; run the normal 1099 Summarization Process (Default)
RPT-ONLY-SWITCH	Y = Yes, print report only, do not update summary file. N = No, do not print report only. Print report and update summary file with detail totals.
YR-MO	The year-month to be processed (YYMM).

_{Distribution:
FMS

Created: FRI, APR 06, 2012, 12:15 PM}