710 likes | 834 Views
USAS/SAAS Updates. TCCSA Fall 2004. New Vendor Fields. New Hire SSN field added Child Support flag added. New Hire SSN field. Displayed in VENSCN & EIEIO Added to VENDOR1 report VENHIRE will print this SSN on report if non-blank, otherwise will print 1099 ID. Child Support Flag.
E N D
USAS/SAAS Updates TCCSA Fall 2004
New Vendor Fields • New Hire SSN field added • Child Support flag added
New Hire SSN field • Displayed in VENSCN & EIEIO • Added to VENDOR1 report • VENHIRE will print this SSN on report if non-blank, otherwise will print 1099 ID
Child Support Flag • Displayed in VENSCN & EIEIO • Added to VENDOR1 report • POSCN & APE will check and display warning if set to “Y”
4502 • Federal Assistance Summary changed from $300,000 to $500,000
ACTMOD • Must now use memo vendor number for Expense/Supplies Distribution option • To prevent problems with YTD amounts for 1099 purposes • Distribution is NOT an additional payment to the vendor
AUTOPOST/Payroll • Can now use payroll date from batch file or enter a posting date
CHEKPY • Optional heading line prompt added
EIEIO/OINQ/BLDOINQ • Invoice Description will now display if entered; otherwise po item description will print as before
EXPROC • Will now update and default to the highest po number on file
FUNDSUMM • Will now exclude funds with all zero amounts from the report
PODETL • Now looks at account filters from USASDAT/USASEC and will exclude purchase order items for accounts for which the user does not have read access
USACERT • The word “fiscal” has been removed from the prompt and help messages for the year in AMDCERT and CERTBAL
USAEMS • Extraction for new EMIS fund category field (QC185) changed • If USAS EMIS fund category field is blank, an “*” will be placed on USAEMS.SEQ for importing into EMIS • Necessary to fulfill EMIS reporting requirements
USASCN/ACTSCN • Added “*” as valid EMIS fund category for each fund which requires a code be entered • Use “*” if none of the codes is applicable to your grant • New codes added for FY 2005
USASCN/BRDRET • Change default to always be “Validate”
USASCN/POSCN • Added grand total to overflow page
USASDAT/USASEC • Added PODETL to list of reports using account filters
Requisition Amounts • Corrected the calculation of the open requisition amounts on the account records • USASDAT/USACON (when changing the requisition tracking flag) • FIXENC
Blank Month-to-Close-FY • Fixed problems with USAS programs when Month to Close Fiscal Year on USASDAT/USACON is left blank • Programs will now all default to 06 if the Month to Close Fiscal Year is blank in USASDAT/USACON
ACTCHG • Corrected problem causing AUDITS file and report to show the original account instead of the new account after collapsing accounts
BALMON • When running BALMON for specific fund and all years the report only included the current fiscal year
CHEKPY • Report heading listing check types selected did not include “Warrant”
FINDET • Incorrect description printing on SCC subtotal line when sorting and subtotaling by FS,SC • No description will be printed for the SCC subtotal line
INVEST • Program was ending abruptly if a blank fund number was entered • An error message will now be displayed and the user given another chance to enter the fund number
RCPROC • The creation date for the vendor was being incorrectly updated with the current date when a refund was posted
USASCN/REQSCN • Account balances not checked correctly when modifying a requisition and “Track Requisition Amounts” flag set to “Y”
USASCN/VENSCN • Phone number display corrected when the number ends in all zeroes
EISRPT/EIS203 • Added sort and subtotal options for: • Fund Type • Function
EISRPT/EIS203 • Corrected problem causing program to abort when choosing to use a date range and leaving the date blank.
EISRPT/EIS104 • Problem with items capitalized at the beginning of the fiscal year, but are not capitalized at the end of the year and have had transfers posted • Negative adjustment was shown in both the original and the new fund/function/class • Now the negative adjustment will be shown in only the new fund/function/class
Programs to be made obsolete • It is our intention to remove the following programs from the USAS package after the May 2005 release: • PORQ • INPROC • OHUSAS • ACCEDT • SETBAL • GAAP Subsystem (old)
Programs to be made obsolete • The following programs will be removed from the software for the December, 2004 release: • HB412EXP (udms export) • EISAPR (EIS package-old EIS specifications)
USAS/SAAS Updates Selected updates from the May Release
Requisition Amount Tracking • Optional tracking of total requisitioned amounts has been added NOTE: PORQ WILL NOT RUN IF REQUISITION AMOUNTS ARE BEING TRACKED! • Must set new flag in USASDAT/USACON to begin using this enhancement. If not set, no changes in functionality will be seen. • Can also determine whether you want the amounts considered when checking balances during requisition or encumbrance posting
Requisition Amount Tracking (continued) • If “Track Requisition Amounts” set to “Y” • Requisition amounts will appear with accounts in ACTSCN, EIEIO, OHUSAS • APPSUM/BUDSUM can optionally include these amounts with encumbrances and subtracted out of the remaining balance
Requisition Amount Tracking (continued) • Transaction programs will subtract the requisitioned amounts out when determining the remaining balance to use for balance checking • REQSCN, POSCN, AUTOPOST, BRDRET, APE, EXPROC, INPROC
Requisition Amount Tracking (continued) • ADJUST will move the requisition amounts from future year to current year during fiscal year-end close process • FIXENC will recalculate the requisitioned amounts from the open requisitions on file • DELACT, ACTCHG, BUDLNK modified to use requisitioned amount fields
Status and Start/Stop Dates • Status and Start/Stop Dates were added to the UDMS views • Four new reports list accounts with Status = “I”, or start or stop date not blank • STAT_APP • STAT_REV • STAT_CASH • STAT_BUD
Invoice Description on Reports • Several reports modified to print optional invoice description if entered in APE, otherwise will print po item description • ACCSTS • ACTRPT • APPLED • BUDLED • CHEKPY • PAYABL • USASAUD
APPROP • Two new options added to replace old ACCLOAD functionality: • APPROP/NYPLOAD – Loads Next Year Proposed amounts from CSV/Tab file • APPROP/IABLOAD – Loads Initial Budget/Revenue amounts from CSV/TAB file • Runs ACCLOAD with “parameters file” to control fields that are updated.
APPROP • Spreadsheet must contain the following headings in the first row: • TI, FUND, FUNCTION, OBJECT, SCC, SUBJECT, OPU, IL, JOB, RECEIPT, PROPOSED, INITIAL_BUDGET, INITIAL_ESTIMATE • Exact columns needed depends on whether you are loading budget or revenue accounts and which option you are using • Spreadsheet may contain additional columns which will be ignored. • BUDLNK will be automatically run to update the appropriations from the budgets