Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Link Fixer

Releases Since Our Last Meeting (

...

05-

...

15-2019)

  • USAS-R V7.19.0 Release4 Hotfix (45/2515/19)
    • Implemented State Treasurer's Online Checkbook export file 
    • Various improvements to the Budget Scenario interface including the ability to clone scenarios.  Any new scenarios created after this release will be able to be cloned.  Scenarios created prior to this release cannot be cloned.
    • Updated the budgeting worksheets to put each prior year's amounts in separate columns.
    • Improved the Five Year Forecast extract to include expendable and receivable amounts.  We've also improved the grid sorting so that within forecast line number the lines show in account code order.
    • Added username to the Activity Ledger.
    • Corrected a problem with the CSV format with regard to commas.  Commas in item descriptions was causing data to shift and not appear in the appropriate columns.  We've also updated the CSV option to use data from the extended report properties, overriding column names for example.
    • Updated the USAS_MANAGER role to include permissions for the Mass Load option and Transaction Configuration.
    • Corrected a problem with the check number not printing on Refund checks, PDF and XML formats.
    • Improvements to the Financial Detail Reports.
      1. Improved report titles so user can easily distinguish between the three available versions.
      2. Corrected the ending balance on the Financial Detail Report July 1 Cash Balances.
      3. Corrected a problem with encumbrances not appearing on the Financial Detail report.  This was due to the PO transaction type incorrectly being excluded.
    • Improved performance of posting payables to disbursements.  Users should see a significant improvement with performanceapplication health
    • Corrected the import log to correctly display the status of the Encumbrance Ledger Job
  • USAS-R V7.19.5 Hotfix (5/20/19)
    • Modified the import to set the effective date for the PURGEDAMTS* invoices to be the same date as the last full invoice.  This will ensure partial invoices are posted before full invoices and a more sensible date is used.
    • In an effort to order them more consistently, when importing invoices the effective date used for the invoice is the invoice date, however if multiple invoices are posted on the same date the created date and time will be used to determine effective date.
    • Updated the post import process to create missing posting periods and close and archive them when appropriate.
  • USAS-R V7.19.6 Hotfix (5/21/19)
    • Corrects a problem related to the Application Health that applies only to empty databases.
  • USAS-R V7.20.0 Release (6/12/19)
    • AP Invoice rewritten into the new grid style format.
    • Implemented auto assign preferences for requisitions.
    • Implemented future year balance checking for requisitions and purchase orders.  This was implemented as rules that will need to be enabled if future year balance checking is desired.
    • User account filters now apply to all detail reports.
    • Implemented reporting levels for account code dimensions.  These include 1 & 2 digits of function, 1 & 2 digits of receipt, 1 digit of object, 2 digits of subject and 1 digit of OPU.
    • The 'as of period' user parameter was added to a dozen more reports including the various account summary reports.
    • Discovered and corrected a performance problem related to account filters that appeared to make the user interface hang.
  • USAS-R V7.1920.1 Hotfix  (56/120/19)
    • Allows the user to determine which bank account will be the default bank account.  The bank account permissions are available to the group manager role and higher.  The standard user role does not include the bank account permission.
    • Allows the user to select the bank account they wish to use when processing a Refund with a Check.  The bank account drop down will initially be populated with the bank account that is selected to be the default bank account.  The user can select another bank account if desired.  The bank account selection will be read-only unless "Create Check" is selected.
  • USAS-R V7.19.2 Hotfix (5/6/19)
    • The budgeting worksheet reports have been updated to move the account code and description into a detail header to allow for more room for the amount columns.  We've also summed the next year proposed amount as this was previously missed.
    • Users should now be able to re-open a PO that was imported from Classic.  When a user cancels a charge, deletes an invoice or voids a disbursement the encumbrance amount should adjust to reflect the action and the PO will be at an invoiceable status once again.  We have also added a view option to the purchase order charge that will allow users to see the impacts on encumbrance created for that charge.  
      • The Group Manager and Standard USAS roles will have the ability to view the encumbrance impacts for all charges and also view the legacy PO status and legacy outstanding values if it is a legacy charge, meaning the charge was created in Classic and imported into the Redesign. 
      • The Admin role will be able to add/remove adjustment impacts if the charge is a legacy charge and the effective date of the impacts are in an open posting period.  The ability to see and modify encumbrance impacts on the charge is specific to the USAS_ENCUMBRANCEIMPACT permissions.  This has been put in place to assist with balancing Redesign to Classic after import when no other cleanup option is available.  It is recommended that ITCs should consult SSDT before adding or removing adjustment impacts on encumbrance.
    • The RAM extract has been updated to properly cope with quotation marks when used in the item description.
    • The purchase order remaining encumbrance was not properly updating after posting disbursements due to a recent performance improvement.  The accounts reflected the correct amounts, but the purchase order totals were incorrect.  
    • A problem caused by the previous hotfix that prevented standard usas users from processing positive pay.  The permission needed was removed from the standard usas user role, but has been corrected.
  • USAS-R V7.19.3 Hotfix (5/9/19)
    • corrects a problem with the CSV report format option with regard to the handling of double quotes.  Users are including double quotation marks (") in the item description of the Requisition and it's causing problems with the RAM extract.  We attempted to fix this on the previous hotfix, but ended up breaking the CSV report format.  This problem has been corrected.

Upcoming Scheduled Releases

  • USAS-R 7.19.4 Hotfix (anticipated later this week)
    • Improvements to the usasimport.log and System/Monitor Status tab to properly report job status.  We've also added a message to the Posting Period tab to report on the health of the application.  If an import or post import job did not successfully complete, the following warning message will display:  "There was a problem during the post import process; not all jobs completed successfully.  Check the import log for errors."
  • USAS-R 7.20.0 Release Scheduled Issues (anticipated next week)
    • Adding the "as of period" parameter to all applicable objects to allow adding this user parameter to additional reports, including account summary and the financial detail report.
    • AP Invoice has been rewritten into the new Vaadin format
    • Implement reporting levels for account code dimensions
    • Apply account filters to all detail reports, regardless of entity.  
    • Implement vendor tax identification number configuration
    • Implement auto assign preferences for requisitions
    • Implement balance validations for future year requisitions and purchase ordersThe SSDT Revenue and Expenditures by Fund and by Cash Account template reports have been rewritten as canned reports to correct a problem with grand totals.  Previously the revenue and expenditure amounts were being added and displayed an incorrect grand total.
    • Corrected problem editing a receipt.  Users with account filters were unable to modify receipts they would have access to.
    • Per the EMIS Manual the 7600 function codes have been updated to remove the restriction of 900 object codes like the rest of the 7000 function codes.
    • Performance improvement: corrected a problem that made the promote feature of scenarios appear to hang when an error occurred.
    • Corrected the rule to prevent a partial invoice from being posted after a full invoice.  The rule wasn't working as intended for transactions posted in the Redesign.
    • Implemented the ability to post Leave Projections into USAS from USPS.  When transactions are posted in USPSR they will be available via Pending Transactions.  Once accepted, receipt transactions will be posted in USASR.
    • Repaying and advance in the current fiscal year has been updated to refund the money to the revenue account (original "In" account) and reduce the expenditure in the expenditure account (original "Out" account). 
  • USAS-R V7.20.2 Hotfix (6/26/19)
    • Corrected a problem posting budget adjustments.  When posting budget adjustments for a date outside the current period the service was using the current FYTD Expendable/Receivable amount, not the amount for the period the transaction date is in.  Districts who posted adjustments and used a transaction date outside the current period (the period that was current when the adjustment was posted) should review their accounts to make sure amounts are correctly reflecting what they expect.
    • We've added an option under the Utility menu to allow admin users the ability to refresh the state of a purchase order.  This option was added because a user amended a po to change the date, but the po ended up in an invalid state.  We have determined the cause of the problem and will be releasing a 7.20.3 hotfix to correct it.  This refresh state option will cause the state of the po to be re-evaluated and properly updated, allowing the transaction to recover from this invalid state.  This is currently limited to the admin role.
  • USAS-R V7.20.3 Hotfix (7/1/19)
    • Corrected the rule that governs creating and updating transactions with regard to posting periods.  The rule was not preventing the creation of transactions with dates in a prior fiscal year when posted via a third party vendor via the soap service. 
  • USAS-R V7.20.4 Hotfix (7/8/19)
    • Implemented a performance improvement to the process of applying proposed amounts and posting budget adjustments.  We discovered that when these transactions were being posted the filter crosswalks were being recreated, which caused the performance problem.  The filter crosswalks only need to be updated if the budget code itself changes.
  • USAS-R V7.21.0 Release (7/11/19)
    • Performance improvements have been made to posting payables, budget scenario promotion to proposed amounts and accounts.
    • Added a rule to prevent posting payroll disbursements if the accounts are inactive.  This rule is not mandatory but is enabled by default.
    • Restrict requisition only users from seeing the ACH fields on the vendor.
    • Canceled items on the printed PO will now display with a "C" before the item as they did in Classic.
    • Corrections to totals on the Spending Plan Comparison report.
    • The remaining balance calculation in the Fund UI has been corrected.
    • Corrected problem with Mass Load accounts.
    • Updated downloadable report link to be shareable with others.
    • The Listing of Transactions by Account report has been corrected to include received amounts.
  • USAS-R V7.21.1 Hotfix (7/17/19)
    • Corrected problems with control headers and control footers on template reports.  This impacted reports that contain additional information in the control areas mentioned, such as the Financial Detail Reports for Current Period and July 1 Cash Balances, the Disbursement Detail report and the Listing of Transactions by Account report.

Upcoming Scheduled Release

USAS-R 7.22.0 Release (anticipated next week)

  • The ability to mass add accounts, for example taking an existing grant account and copying the account hierarchy to a new account.
  • Recreated Classic's PAYABL report.  This report was implemented as a canned report because the query required is too complex for it to be a template report.
  • Removal of Legacy Requisitions 
  • Corrected method that determines if all amounts on an account are zero.
  • A 30% performance improvement was made to the Financial Detail Report July 1 Cash Balance
  • The default date has been removed when posting Budget Adjustments.  Users will be required to enter a date.
  • Various improvements to the new AP Invoice UI, including the addition of the check number, updated default grid sort and real time updates to the invoice and canceled totals before saving the invoice.