Last Updated: August 16, 2022

Bug Fixes

1. Process Scheduler
   • Fixed an issue where the Schedule Job data grid (Tab B, bottom right grid) was not refreshing when the schedule or main profile grids changed rows.  Was only getting the latest data when the process schedule history grid changed rows.
   • Fixed an issue with data exports and a timeout issue where long running SQL would sometimes time out before the export started.
2. User Cross Tab
   • Fixed a strange bug when creating new formula fields on the crosstab and the formula ok button action hangs the client.
3. Code Tables
   • Budget Version and Salary Budget Version
     • Fixed a minor issue where you could change fields like year on a version when it’s set to inactive or frozen.  Note that even if frozen you can always unfreeze the record which would then allow you to change the other read-only columns on that frozen version.
4. Landing Page
   • GL and Payroll Variance Status
     • When using the “Use GL Period (Instead Of Pay Period)” parameter, the drill down queries on the Payroll Amount/Hours tabs were not filtering by GL but by Pay Period.  This was causing the drill down query to return unrelated results.  This version corrects that by filtering by GL period where appropriate instead of always by pay period.

Enhancements

1. Code Tables
   • Budget Version
     • Changed the Calc Inflation With Adjustment field to have a max value of 20 instead of 7
   • Budget Version and Salary Budget Version
     • The “Is Frozen” column (checkbox) has been replaced by a frozen state drop down with two options:
       • Frozen but allow changes with reason (same as previous logic)
       • Fully frozen…not allowing any changes to be applied
       • Note: This affects the behavior of the GL Budget and the Salary Budget pages and all of the procedures/utilities that use version as a parameter
2. Security
   • For non ADS (Active Directory Services) users, the password strength rules can now be managed by site administrators.  This can be done on the system parameters page.  These are the new parameters:
     • min_password_chars – Minimum Number Of Password Characters
     • min_num_uppercase_chars – Minimum Number Of Uppercase Characters
     • min_num_lowercase_chars – Minimum Number Of Lowercase Characters
     • min_num_special_chars – Minimum Number Of Special Characters
     • min_num_numeric_chars – Minimum Number Of Numeric Characters
   • The change password dialog on the user maintenance screen as well as the change password button for non-ads users on the users’ main menu tab will now affect the password change rules on the system parameters page.
3. Report Writer/Runner
   1. Added two new custom reporting functions.  They are:
      • GetPeriodEarnedHours
        • Takes the year, GL period, and entity and returns the earned hours for the specified period
      • GetPeriodYTDEarnedHours
        • Takes the year, GL period, and entity and returns the earned hours up to the specified period
4. User Maintenance
   • Account Summary and Account Issues now has icons next to each item for readability
   • Added a “page exclude” tab as a detail grid for the users grid.  Pages can be excluded at the profile or user level.
   • The account summary will also display the pages excluded when there are some specified for the selected user/profile.
5. Main Menu
   • On main form load any pages that are set to be excluded by the user or users’ profile will be excluded from the menu.  This special layer of security is optional and is managed by the site administrator.
6. Landing Page
   • Created two new landing pages:
     • GL and Payroll Variance Status By Cost Centre Tree
       • This is the same as the original GL and Payroll Variance Status landing page except the left grid which is used to filter the right three tree grids is now a cost center tree.  This means that you can now get summaries which can include multiple cost centres
     • Budget Adjustments By Cost Centre Tree
       • This is the same as the original Budget Adjustments landing page except the left grid which is used to filter the right three tree grids is now a cost center tree.  This means that you can now get summaries which can include multiple cost centres
7. Capital Assets
   • Added the new asset funding amortization detail tab
   • The Asset Master grid now handles all data entry using a popup form.  This was done since there are a lot of fields (around 60) on this grid and doing data-entry using the inline data-entry (default) was difficult.
8. Project Budget
   • Updated the GL Project Budget grid to include a number of new columns.
9. View Source Data
   • Updated the GL Project Budget grid to include a number of new columns.
10. Cube Management
    • On the cube column details grid when focusing on data-source or indicator fill type records a “summary” will be displayed on the right of the grid showing where the data for that field is coming from.  It shows:
      • Table
      • Field name
      • Aggregate type
      • SQL range
    • Created a new cube audit tab so that users can now identify issues with their cube before trying to build it.  These audits include:
      • Visible columns that are suppressed (illogical)
      • Calc Code with invalid variables
      • Calc Formula with invalid variables
      • Calculated fields with no calc code or calc formula
      • Check if the defined number of views for the cube master exceeds the real number of views defined in the views (warning)
      • If the number of cube levels is greater than the max levels
      • Check trees if in balance or not
      • Check trees if has duplicates (when the trees are defined as not allowing duplicates)
      • Cube is marked for deletion, frozen, or inactive (warning)