September 2009 USASSAAS Release Highlights September Release Highlights

September 2009 USAS/SAAS Release Highlights

September Release Highlights – New Funds • 532 School Fiscal Stabilization Fund • 533 Stimulus Title II Technology Grants • 536 Title I School Improvement Stimulus A • 537 Stimulus School Improvement Subsidy G

September Release Highlights – Five Year Forecast • New lines added for fund 532 amounts: ▫ ▫ ▫ ▫ 01. 045 Restricted Federal Grants-in-Aid - SFSF 09. 045 Fiscal Stabilization (reserv. of fund bal. ) 21. 010 Personal Services SFSF 21. 020 Employees Retirement/Insurance Benefits SFSF 21. 030 Purchased Services SFSF 21. 040 Supplies and Materials SFSF 21. 050 Capital Outlay SFSF 21. 060 Total expenditures - SFSF

September Release Highlights – Five Year Forecast • ADM lines removed from forecast: ▫ 20. 020 Kindergarten – February Count ▫ 20. 025 Grades 1 -12 – February Count

September Release Highlights – Changes to USASFF • 532 fund will now be included • Revenues to appear in new line: ▫ 01. 045 Restricted Federal Grants-in-Aid – SFSF • Expenditures ▫ Reported on normal 03. * lines ▫ Categorized per normal formula • PLUS – reported in new disclosure lines ▫ 21. 010 -21. 050 correspond to 03. 010 thru 03. 050 ▫ But contain just the 532 amounts

September Release Highlights – Changes to USASFF • If using USASFF in conjunction with SSDT spreadsheets – ▫ MUST use new spreadsheets from SSDT website: http: //ssdt. oecn. k 12. oh. us/projects/usas Click on “five year forecast spreadsheets” under Downloads section • All related programs also updated to use new formula

FIVE-YEAR FORECAST 1. 045 Restricted Federal Grants-in-Aid SFSF

9. 045 Fiscal Stabilization

State Fiscal Stabilization Funds 21. 010 Personal Services SFSF 21. 020 Employees’ Retirement/Insurance Benefits SFSF 21. 030 Purchased Services SFSF 21. 040 Supplies and Materials SFSF 21. 050 Capital Outlay SFSF 21. 060 Total Expenditures - SFSF

September Release Highlights – SM 1/SM 2 • New line added ▫ 01. 045 Restricted Federal Grants-in-Aid – SFSF ▫ Will include all revenue for fund 532 ▫ Affects all SM 1/SM 2 related programs & reports • Fix program provided for ITC to run ▫ Will recalculate SM 2 amounts for months already closed • Use SM 1 MNT to manually update estimates if desired

September Release Highlights – Converting Template Requisitions • Requisitions coded as “Template” can no longer be converted to purchase order ▫ Type = “T” in requisition header ▫ Clone to non-template requisition, then convert • Affects REQSCN, POSCN, MASCNV • Will not affect USASWeb until v 2. 6 is released

September Release Highlights – AUTOREC/Extract • Export file will be created in output directory ▫ “Positive Pay” files ▫ Easier for subsequent ftp process ▫ Makes AUTOREC consistent with PAYREC v. ITC custom procedures may need updated

September Release Highlights – POFORM • Add question for “Transmission Status” ▫ Do you wish to re-print POs already transmitted? ▫ Will only see if “Using Requisition Approvals” district configuration flag set to Yes ▫ 3 rd party system can update “Transmission Status” to indicate p. o. already sent by their software allows bypassing of po’s already transmitted when creating the file of po’s to print. v. POFORM can only exclude po’s if 3 rd party system is updating “Transmission Status” field

September Release Highlights – USALOAD/VENLOAD • Update highest vendor number • And highest memo vendor number ▫ If vendor number created higher than current “highest number”

September Release Highlights – USASWeb/Invoices • Added item number to error message: ▫ Invoice error, item # xx, cancelled amt exceeds remaining encumbered amt

September Release Highlights – VALACT • Added warning for funds to be removed after fiscal year 2010 ▫ As listed in the AOS manual: ▫ 420, 429, 438, 447, 458, 462, 495, 497, 556

September Release Highlights – Problems Corrected • ARF ▫ Fixed zip code format on non-district remit-to • ARRPT ▫ Fixed access violation if > 400 ledger codes ▫ Now allows 600 and gives friendly error message • AUTOPOST/Other ▫ Added validation to fix posting error ▫ Trying to post payroll clearance check with no #

September Release Highlights – Problems Corrected • STUFEES ▫ Exclude. posted files from list of files to post • USAEMSEDT ▫ Fixed reports to work correctly in FISCALCD • USASCN/MASCNV ▫ Fixed bug creating purchase order with blank date ▫ Requisition must have date if using option to use requisition date for p. o. date

September Release Highlights – Problems Corrected • USASWeb/Receipts ▫ Fixed ability to update blank ‘received from’ or header description fields • USASWeb/Requisitions ▫ Fixed requisition total at top of query ▫ Was incorrect if any items had negative amounts

SAAS/EIS Release Highlights – EISEMS • Extracts capital assets data for EMIS • Creates ▫ EISEMS. SEQ file to load into EMIS ▫ EISEMS. TXT summary report ▫ EISEMSE. TXT error report if any errors/warnings • Based on EIS 103 and EIS 104 calculations

SAAS/EIS Release Highlights – Problems Corrected • EISEMS ▫ Fatal error changed to warning ▫ Blank or invalid asset class • EISRPT/EIS 104 ▫ Beginning and Continuing grand totals reversed

September Release Highlights Technical Changes

September Technical Changes – AUTOREC/Extract • Extract option now creates “positive pay” file in OECN$OUT instead of OECN$DTA • Consistent with PAYREC functionality • Any local procedures which may manipulate or look for these files may need to be updated to locate the file in OECN$OUT instead of OECN$DTA

September Technical Changes – USAS 0909 • Fix program to recalculate SM 2 amounts ▫ ▫ Recalculates months already closed in fy 2010 Amounts pulled from USAHIST monthly amounts Run only in live files Can be run multiple times without harming files • USAS 0909. COM can be used $ SUBMIT/NOPRINT/KEEP/USER=district_username OECN$BUD_61: USAS 0909. COM

September Technical Changes – USAS_CONFIG_REC • USAS_CONFIG_REC. DTR_REC ▫ Fixed typo in datatrieve record layout ▫ Caused installation to fail and reports not to run

END