Budget
Version 1 of the Carry Forward Assistant added...
This new form (Utilities:Carry Forward) facilitates preparation for and creation of new fiscal year projects and the reassociation of recharge types, vendor blankets and distributions from the old fiscal year into the new fiscal year. This provides an alternative method to that provided via Admin Projects form which has been used in the past.
Post Form...
An 'i' button has been added to provide summary information for the project to which you are posting.
Project Status Form...
Stored note length has been increased from 40 to 255 characters. (Stored notes are canned messages you can use to make up project status notes. )
The financial statements generated from this form are now identical to the forms produced by the main Print Reports form.
Account/Fund Status Form...
A new button has been added to the bottom of the form which will print reconciled statements for all projects associated with the account-fund being displayed.
Project Setup Form...
Funding agencies may now be selected by typing their abbreviation or a portion of their name as well as from a pull-down list.
Edit/Reconcile...
Users now receive an alert if a financial record they wish to edit is open elsewhere.
Assisted Reconciliation...
Main form - The account and fund search fields under the GL Entries and GUS Transactions tabs automatically pre-load when you click on an account-fund line in the main display.
Compare Acct/Fund form - GL entries can now be sorted by clicking on the Tr Date column header. An alert has been added to indicate that a GUS Transaction A note has been added at the bottom of the form to remind users of the key combinations available to select data.
Users now receive an alert if a GUS Transaction record they wish to edit is open elsewhere.
Print Reports...
The project summary reports can now be composed of either "all projects for which a person is a PI or co-PI" or by "all reports which are received by a person". This allows printing of summaries for lab managers, etc. who are not actually PIs and allows you to control which reports are included in PI summaries. The option is selected via a preference setting in the Utilities:Preferences:Printed Reports area.
A bug which would cause a run-time error when emailing separate financial statements to PIs when a particular statement was both in the Standard Reports and added as a separate report for that PI has been fixed.
Duplicate Projects...
(button at bottom of main Projects display form)
A new selection option, "Duplicate Subs" has been added. In the past, Subs were always duplicated.
A bug introduced in version 4.5.1 which caused GUS to ignore a new fiscal year entry when manually duplicating a Project has been fixed.
Admin Projects...
A bug which would cause a run-time error when deleting projects has been fixed.
A bug introduced in v4.5.1 which would cause a run-time error in with the "Status -> CF-Hold, Duplicate" option has been fixed.
Purchasing
POs Screen...
When entering a new PO, under some circumstances clicking on the Project 'i' button would cause the PO record to be partially duplicated. This has been fixed.
Recharges
Financial Journal...
The file format for the electronic financial journal has been modified to facilitate ftp transfers to Accounting via FTP on Windows clients.
Contracts and Grants
Financial Agencies...
Funding agencies may now be selected by typing their abbreviation or a portion of their name as well as from a pull-down list in both the Proposal and Award setup forms.
Personnel
- Removed redundant code that stopped monthly transaction creation if the sub and type combination was repeated in a given project. Mainly affected the UPAY screen which was revised last year and provided with an alternative way to handle this problem.
- Fixed a bug that prevented the project summary arrays on the Summary screen from refreshing if the user was on the second (view by month) tab.
- Added a “Ledger” array to the “View by Month” tab of the Summary screen.
- Fixed the Vacation Benefits field of the Post/Reconcile screen so that when the Vac Salary changes, the Vac Benes field changes relative to the new amount (multiplied by the default benefit rate set in the preferences screen, currently .1242)
- Changed the totals fields on the second page of the Summary screen to Megabucks format to fix problem where large values were showing up as “<<<<<<<<<<<<<”
- Created 6 new Personnel training videos and uploaded to website.
- Added color selection to preferences allowing users to choose 1 of 4 different background colors to be applied uniformly to all the screens in the Personnel section.
- Added Benefits Eligibility Hours and Career Eligibility Hours fields to the Employees table, as well as the Employee screen, in preparation for the upcoming PPS Data Download feature, to manage people with limited Appointments.
- Fixed a bug in the UPAY screen that left the Reason Code field and “i” button enabled on load (should have been disabled like the rest of the fields and buttons on that screen).
- Changed name of Merit Cycle field on Appointments screen to “Next Salary Review” to match PPS
- Added “Evaluation Date” and “Evaluation Type” fields to the Appointments table (actually named OtherDate and OtherDateType) to accommodate evaluation tracking in the Hot List
- Revised the Employee screen. Added Appointment related filtering by Appt. type, Supervisor, Bargaining Unit, and Title Code.
- Revised the printed report from the Employee screen to more closely match other new Personnel reports.
- Added Export functionality to the Employee screen. Also fixed existing sorting function so that prints and exports remain sorted as well.
- Changed the Title Code field on the Appointment screen to match the new functionality on the corresponding search field of the newly-revised Employee screen, in that now you can just type in a title code if you know it and GUS will find the description. It used to be that you could only get the actual description by clicking the lookup button.
- Added code to block projections past Visa End Dates.
- Removed the word “other” from the “UPAY” type button description on the “Create New Transactions” screen.
- Removed vestigial rTotalDistPercent field from Distribution screen
- Added Evaluations tab to Hot List to track upcoming Evaluations
- Added popup to UPAY screen alerting users to Dept. Chair approval requirement if UPAY is for transactions over 120 days old.
- Fixed bug in Hotlist screen that caused ending projects to be repeated for all employees, whether they were affected by the ending project or not
- Added a “Project Ending?” array to the Distributions Ending tab of the Hotlist screen to indicate when a project associated with an ending Distribution is also ending.
- Changed Total for Project field on Projection report to iMegabucks format to prevent “<<<<<<<<<<<” problem
- Fixed a bug that allowed the Hot List and UPAY Form menu items to be available even for users without Personnel permissions.
- Added a field to the Employee table for the Alt Email address in preparation for the upcoming data warehouse download functionality. The regular email address field will be filled by the one in the campus directory, which is sometimes wrong, so the users needed the alt. one for their other or “correct” one.
- Added additional field for Academic Salary Review date on the Employee screen.
- Removed the merit and review date fields from the Appointment screen – now managed from the Employee screen to coincide with PPS schema
- Revised tab 7 on the Hot List to accommodate new Employee-centric evaluation/review date handling
- Added an 8th tab to the Hot List for handling Limited Appointments
- Added “PPS End Date” fields to both the Distributions and Appointments tables and screens to accommodate the upcoming PPS data download feature
- Finished writing methods and queries for importing Employee and Appointment data from the data warehouse (tab-delimited files)
- Fixed a problem with the Hot List screen where the Projects Ending tab loaded extremely slowly in large databases. This screen still loads slower than most other screens just because of the sheer volume in some of the larger departments, however it now loads in an acceptable time period (not more than 60 seconds).
- Fixed bug in the Export Employee Roster screen that prevented exporting of records sorted by Employee
- Added a support utility that obscures Employee data by changing recognizable information such as names, email addresses, locations and phone numbers to randomly chosen replacements, for GUS demonstrations, workshops and documentation materials.
- Moved the BELI drop-down to the Employee Information screen from the Appointment screen.
- Worked out most of the details and wrote the code to support the downloading of data from the data warehouse – tab delimited file format
- Created a set of generally accessible variables on the Preferences screen for the 3 and four character dept. codes and tied them to the existing recharge-specific variables. Also wrote code that tests for them and minimizes impact to the users before the new ones have been added specifically.
- Fixed a bug that caused a misrepresentation of the effective salary amount in the Appointment screen
- Added code that updates changed Benefit Rate, Salary Rate, and Percent Time in the Appointment when a user makes a change to a transaction and chooses to update future transactions and the related Distribution with the same new amounts
- Changed the sorting of the Titles selection screen so that it now sorts by Title and not by Title Code
- Added a feature to the Title screen that allows searching by Title without having to add the “@” symbol to incomplete criteria
- Revised look and sorting of the Personnel Outstanding Liens report
- Added functionality to Hot List – Distributions Ending tab so that if the user double-clicks on the Employee name, the Employee Detail screen opens, allowing the user to check and see if there’s another Distribution pending for the Employee before extending the current one
- Changed the default for the Hot List time period to “This Month”. Was “Next 3 Months”.
- Added Hours – Current Month and Hours – Last Month fields to the Post/Reconcile screen in order to keep track of hourly records
- Added an “Hourly Time Reporting End Day” preference field in the UTILITIES > PREFERENCES > PERSONNEL screen to permit the calculation of hourly projections without users having to manually work around a lack of hourly projection functionality
- Changed the Employee screen so that when an Employee record is edited and the user returns back to the list, the Last Name search field is highlighted for quick searching for the next Employee
- Fixed a bug that would prevent the recalculation of Salary and Benefits Overhead when revising future Salary and Benefits amounts for existing transactions from the Post/Reconcile screen
- Finished work on a system that makes projections for hourly employees accurate without having to work around the problem of time reporting ending in the middle of the month. Now hourly Employees are projected to the correct ledger month based on the reporting end date preference set by the user.
- Added validation code to the Hourly Reporting End Day field on the Preferences screen, so that a day less than 1 or greater than 28 (the shortest possible month) cannot be entered.
- Re-formatted the code that calculates projections for hourly Employees so that instead of assigning Salary and Benefits amounts based on their percentage of time for an average month of 174 total work hours, now they are calculated based on the actual hours projected.
- Added the Employee First Name to the Distribution screen.
- Finished the Personnel > Carry Forward screen/code. Users can now just double-click on Distributions shown in the list of affected Distributions, and it automatically copies it and opens the Distribution screen so they can add the new project code and Salary sub/type/and object code and project the Dist into the new FY.
- The old Distribution is updated to show that it has been carried forward, and it removed from the Carry Forward list automatically.
- Revised the Post/Reconcile screen help form so that the picture shown accurately represents the latest version of the screen.
- Fixed a bug that caused Employee Types and Statuses to intermittently show up wrong on the Employee Detail screen, even though the correct data was in the underlying table
- Fixed a bug that caused the default Employee list Status display drop-down to show the wrong list item
- Finished work on a “Personnel Projection Formulas and Methods” document to assist users as well as the GUS Personnel Committee
- Fixed a few bugs with the Appointments and Distributions report
- Revised the Employee Detail screen so that the Print button at the bottom of the Appts and Dists tab prints the Appointments and Distributions for the selected Employee only
- Fixed a bug on the Post/Reconcile screen that caused the Salary amount to recalculate inaccurately if the Percent Time field was changed. Now it calculates accurately based on the Salary amount in the Distribution
- Fixed another bug on the Post/Reconcile screen that prevented the Vacation Benefits from automatically recalculating when the Vacation Salary was changed.
- Fixed a bug that prevented the updating of the Main SP Liens when a new Type or Object Code was chosen for any of the categories (Salary, GSF, GSHIP, Vac Sal, Vac Bene, Gen Bene) on the Post/Reconcile screen.
- Fixed a bug in the Employee Roster report that would print extra lines for an Employee if there were unused Monthly Personnel Transactions in the database
- Fixed a bug in the Hotlist that caused manually entered Distributions to show up in the list just because the PPS End Date was 00/00/00. (the PPS End Date is not directly editable). For manually entered Distributions without valid PPS End Dates, only the GUS End Date is used now to determine if it will end within the Hotlist time period.
- Added a “Helpful Resources” link to the GUS Info menu that takes users directly to the resources.shtml page on the website. The page will ultimately contain links to helpful UC and UCSB pages, helpful user forms, external apps and formulas that assist GUS users during the course of their work, as well as the GUS Mentors list.
- Met with GUS Personnel committee to continue work on future development strategies and goals
- Added code to prevent the projecting of Distributions with a Start Date before 1/1/1998 (the year the GUS project began)
- Added a warning to the Limited Appointments tab of the Hot List screen indicating that Benefit and Career Eligibility Hours must be maintained in order for the list to show ending Limited Appointments.
- Fixed the Employee Status drop-down on the Print Employee Roster screen so it reliably chooses the “Active” choice by default.
- Finished updating and revision the Personnel Module documentation (PDF format) to go with the next release of GUS (GUS 5).
- Finished creation of a new online documentation system which can be called up by clicking the “?” button on any of the major screens. Currently fully implemented for the Personnel module, other modules to follow.
- Added HR and Accounting links to the website’s resources page, so that in GUS, users can just click GUS Info > Helpful Resources to get useful forms, charts and relevant information without having to leave GUS or wade search through many pages and links on the HR site.
- Fixed a bug that caused some records to wrap to another line in the Employee Roster export process, if the comments field contained a manually typed carriage return.
- Finished adding Email functionality to the Post/Reconcile, Summary, Employee Info, UPAY Log, and Hot List screens.
- Resized the totals fields of the printable report from the Summary screen so that the numbers could be shown completely
- Fixed a bug that prevented the GSF and GSHIP from filling in automatically from the Appointment when creating a new Distribution
- Removed an extra “OK” button from the Pick MPT screen (for selecting transactions to use from the UPAY screen.)
- Fixed a bug on the Employee Information screen, Appts/Dists tab, that intermittently prevented Distributions from being set to “Inactive”, and often set them to “Historic” or back to “Active”.
- Fixed a bug that caused the first selected field of the Employee Information detail screen to be the DOB. Changed it to go to the Last Name instead.
- Fixed a bug that prevents the Distribution status from updating in the Dists list after a status change – now the list is automatically removed to avoid confusion and the user must click on an Appointment (as normal) to refresh the Dist list showing the new statuses
- Added a developer’s utility that removes inactive MPTs and their related SUBs.
- Added a utility that finds the date associated with a timestamp.
- Fixed a bug that would prevent the expected reduction of an erroneous Budget transaction when the user changed the PPP Date and THEN unreconciled a Monthly Personnel Transaction from the Post/Reconcile screen.
- Changed a behavior on the Post/Reconcile screen, where, after saving a transaction, the screen would refresh and the transaction selection would jump to the first matching transaction for the selected Employee, even if the “Advance to Next Employee” preference was switched off. Now, if that preference is turned off, when a transaction is saved, that transaction remains selected.
- Revised label on Distribution screen for the Salary Sub/Type/Object Code section to ensure that users understand that this is ONLY for those things related to Salary, and that the Subs/Types/and Object Codes for Benefits is selected during the Projection process.
- Fixed problem with the Staff Review tab of the Hot List screen that would cause it to show records for Employees whose upcoming review dates were outside the scope of the Hot List period chosen.
- Added additional filtering to the Hot List screen to prevent Appointments and Distributions assigned to other departments from showing up in the lists.
- Added additional information to GUS 5 documentation Word Doc, PDF and Documentation Site for the Personnel Module regarding the Hot List screen.
- Added totals fields and a lien discrepancy warning to the Award Summary screen that pops up when you click the “i” button next to a Project Code field in the Personnel Section
- Made more revisions to the Hot List to ensure that all appropriate records are selected for each tab.
- Changed the Department field to a Department Code field, requiring only the 4 character Department code, on the Appointment Screen.
- Added a “Personnel Documentation” link to the Personnel menu that takes users to the main page of the online Personnel documentation.
- Added a button to the Distribution screen that is enabled only when carrying a Distribution forward from the Personnel Carry Forward screen. This button enables a user to plug in Project-related data from the previous year’s Distribution, as well as the Dist number.
- Added Printing and Exporting functionality to the Carry Forward screen.
- Added the ability to double-click the Employee First or Last name to open the Employee Information detail screen from the Distributions to Project screen
Budget module:
Some printing and display bugs associated with the Cost Centers area and with printing
PI cover sheets have been fixed.
A carry-forward bug introduced in version 4.4 which would prevent setup of the carryforward
process has been fixed.
Purchasing module:
The Vendor Blankets main display and input detail forms have been modified to
provide more user error messages and to provide better control over identification of
the Vendors and VB funding sources.
Personnel module:
A new "Employee Roster" report has been added.
The "Print Projections" report may now be printed on either legal- or letter-sized paper.
The "Print Projections" report has been modified to show summary data for the period chosen.
Some printing bugs have been fixed.
General:
A source of memory leaks which could lead to program instability has been eliminated.
There have been modifications, some substantial to the Budget, Purchasing, Personnel, Recharge and Contracts & Grants areas.
Budget Module:
Report printing: The PI Cover Sheet produced using the automatic printing could sometimes show an erroneous list of Project Codes if agency reports were also set up for the projects in question. This has been fixed.
Project Status screen: The 'Internal Balance' field was not reflecting overhead on outstanding liens. This has been fixed.
Project Status screen: If the user clicked on one of the report printing buttons before entering a valid project code a runtime error could occur. This has been fixed.
Assisted Reconciliation (autoreconcile): The GL import routine would skip the first line of data. This has been fixed.
Automatic reconciliation would sometimes erroneously reconcile GUS transactions if anticipated expenses on a particular control number were entered as expenses rather than liens and were identical to the amount of the expense to be reconciled.
One of the sub search fields on the main form for automatic reconciliation would not allow you to enter sub Y as a search option. This has been fixed.
Depending upon how the automatic reconciliation process matched GUS and GL expenses, the notes field in the GUS budget transactions was sometimes not updated. This has been fixed.
Recharges: The project code selection pulldown was including archived projects. This has been fixed.
The Financial Journal report has been made slightly smaller so that it will print without either clipping off a portion of the right-hand column or requiring rescaling to 97%.
Default GL Dates for the Edit/Reconcile and other forms would be erroneous if the forms were opened on Jan 31 (all other dates were ok). This has been fixed.
Cost Types/Object Codes management and entry have been heavily rewritten.
Award Conditions (Condition Codes) management has been completely rewritten.
Printing the Cost Center Summary report required manual scaling on the Windows platform. The form has been rewritten so no scaling is needed.
The sort order used in the Print Problems List report has been modified.
A runtime error could occur when adding a new person to the Dept Reports list. This has been fixed.
The Internal Archive main display form and project display form have been updated.
Autoreconcile has been renamed Asssited Reconcile in the Budget menu.
Award Conditions:
Basic structure rewritten to allow retention of historical award condition definitions.
Ability to import definitions via specially formatted text files. importing checks validity of pre-existing conditions added.
Added automatic update to convert old-style data records to new-style.
Main display form rewritten - increased font sizes, added additional quick searches, added help button, added +/- buttons for 4D 2004 compliance.
Added more data fields, including logging
added additional display options to show which projects use particular award condition codes.
All areas which either select or display award conditions to reflect new structure (Budget: Project setup display & selection forms, projects list info display have been rewritten. Purchasing: PO input form, proj info display form. C&G: Award setup display and selection forms.
Cost Types :
Modified basic storage structure so that cost types and object codes now exist in separate tables.
Created new menu, main display forms for both object codes and cost types
Main display forms now include more quick search options. help buttons added.
Main cost type display distinguishes between active and inactive records by changing font color.
Created new input/edit forms for both object codes and cost types. Cost types input form includes logging of primary field changes and display of which projects and subs use this cost type. Object codes are selected from choice list. Error highlighting, deletion/change control and help added.
Object Codes input form includes display of related cost types. Error highlighting, deletion/change control and help added.
Written documentation for both cost types and object codes has been created.
Added automatic conversion to move old data into new structure.
Find Transactions:
Quick search area has been modified. More searches have been added.
Displayed data may now be sorted by clicking or shift-clicking on column headers.
Purchasing:
PO main display form: POs have two ways in which to be marked "Complete". One is for receipt of goods. The other is for receipt of billing. In versions prior to this release these two values were combined into a single status column on the main PO display form. They are now separated into two columns.
The PO input form, when being used for SBPOs will no longer allow the user to enter numbers beginning with VB or KK into the PO number field.
Some users are using copy & paste to enter PO numbers into SBPOs. When doing so they sometimes copy carriage returns or multiple lines of information. This embeds invisible characters in PO numbers and causes problems with searches. Invisible characters are now filtered out when using copy & paste to the PO number field.
PO number field for SBPOs will no longer accept control numbers beginning with VB or KK. (Must be set up in the VB area.)
A sorting problem in the PO line detail information has been resolved.
Added +/- buttons to invoice and line item subforms for 4D 2004 compatibility.
Modified main PO input form so that the selection of POs on the main PO display would be disturbed less frequently when adding invoices and modifying existing PO records.
Inventory:
The permissions level needed to delete an item from the inventory list has been changed to Purchasing_Mgr.
Fabrications:
Quick searches updated in main display form.
Logging added to detail form.
Preferences:
Moved printing preferences to their own tab in order to add new options (summarize salary and benefits)
Personnel preferences reorganized.
Personnel:
Virtually all screens rewritten to improve appearance & functionality, bring button behavior into compliance with patterns in other areas of GUS
Extensive rewrite of interface code between personnel & budget modules.
UPAY form completely rewritten.
Payroll Ledger Report added.
Many 'Help' buttons have been updated.
Lingering references to social security numbers have been removed.
Modified Summary screen to allow for viewing distributions by employee.
Posting:
Borders added to data fields to improve visibility on some monitors.
Outstanding Lien Report:
New preference added to allow salary and benefits liens to be combined into a single summary line to reduce printing size
Cost Center Summary Report:
Print form rewritten so Windows users can print more easily
Contracts and Grants:
Award, Proposal, Subagreement, Matching Funds requires user to request deletion 2x before deletion occurs.
Deletion confirmation buttons have been changed so that instead of 'OK' and 'Cancel' they now say 'Delete Matching Funds' and 'Don't Delete Matching Funds' etc. to help reduce user confusion.
In order to ensure that GUS is correctly set up for each department and its users are adequately trained, GUS is made available for download only to pre-authorized users.