FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG012M
Monthly General Ledger Reporting

This job group extracts records for the monthly accounting process. Optionally it will archive the extracted month and/or provide 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 GA1302J
Update Last Month Closed
  Open Account Detail Report (GA1302)
R 02 01 GA1303J
Recompute Balances From Accounting Detail
  Acct Detail/Acct Summary Discrepancies (GA1303)
R 03 02 GA1301J
GL Detail Report Extract
R 04 03 GA1300J
Accounting Summary Report Extract
R 05 04 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)
O 06 05 GA1330J
Monthly Transaction Register
  Monthly Transaction Register (GA1330)
R 07 06 GA3200J
Record Vpa Reimbursement In Next Month
O 08 06 GA3231J
Vendor Payment Advance Reimbursement Report
  Vendor Payment Advance Reimbursement Report (GA3231)
O 09 06 FG010M
Monthly Oper. Report, Subgroup of FG012M
    GA3237J
Encumbrance Extract For Monthly Operations
    GA3230J
Monthly Operations Expenditure Report
  Monthly Operations Expenditure Report (GA3230)
O 10 06 GA2103J
Detail Revenue Report
  Detail Revenue Report (GA2103)
O 11 06 BM3230J
Check Register
  Check Register (BM3230)
O 12 04 GA1331J
General Ledger
  General Ledger (GA1331)
O 13 04 GA1332J
Fund Ledger
  Fund Ledger (GA1332)
O 14 06 GA1333J
Monthly Reconciliation by Batch of Cash Ledgers
  Monthly Reconciliation by Batch of Cash Ledgers (GA1333)
O 15 04 GA1334J
Balance Sheet
  Balance Sheet (GA1334)
O 16 04 GA1335J
Program/Organization Trial Balance
  Program/Organization Trial Balance (GA1335)
O 17 04 GA3232J
Cumulative Operations Expenditure Report
  Cumulative Operations Expenditure Report (GA3232)
O 18 04 GA3233J
GL Allotment Balances by Fund/Appr
  GL Allotment Balances by Fund/Appr (GA3233)
O 19 04 GA3234J
Program/Object Expenditure Summary
  Program/Object Expenditure Summary (GA3234)
O 20 04 GA3235J
GL Allotment Balances by Program/Fund/Appr
  GL Allotment Balances by Program/Fund/Appr (GA3235)
O 21 04 GA2104J
Summary of Receipts, Transfers and Fund Balances
  Summary of Receipts, Transfers and Fund Balances (GA2104)
O 22 04 GA2108J
Revenue Summary Report
  Revenue Summary Report (GA2108)
O 23 02 GA3236J
Reimbursable Expenditure Detail Report
  Reimbursable Expenditure Detail Report (GA3236)
O 24 02 GA2109J
Revenue Subledger Report
  Revenue Subledger Report (GA2109)
O 25 06 MM2205J
1099 Summarization Process
  1099 - Misc Detail Report (MM2205A)
  1099 - Misc Detail Summary Report (MM2205B)
  1099 - Misc Error Report (MM2205C)
O 26 25 MM2206J
1099 Misc Summary (by Month) Report
  1099 Misc Summary (by Month) Report (MM2206)
O 27 26 GA1318J
Online GL Archival Batch Process
R 28 05 CR2701J
Smartbuy Extract - SBCTC
R 29 28 GA1309J
Copy Account Detail For Archival
R 30 29 BM1768J
Purge Credit Card Data - CA
  Purged Credit Card Report (BM1768)


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
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.
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, JUL 31, 2015, 03:08 PM