2020-08-19 USAS Completed Work Review
Releases Since Our Last Meeting (7-15-2020)
Limit EMIS extract field length to comply with data collector.
Add new fund per AOS: 510 Coronavirus Relief Fund
Add fiscal year user parameter to Federal Assistance Detail report.
Added new tab delimited user listing extract per Auditors; report added to Monthly Report Bundle as requested.
Created infrastructure to allow importing transactions via CSV files.
Corrected create new/save close feature to provide message to user when record can't be created.
Patch to correct a problem with the change password link on the login page.
Ability to post Receipts via CSV file.
Improve error messages to be clear and consistent. Some errors related to posting periods do not show enough detail and are found to be misleading to the user.
Corrected Financial Summary by Fund report; July 1 cash balance incorrect when excluding accounts with all zero amounts.
Corrected the Mass Add option of Cash Accounts to allow mass adding all valid accounts and provide an error message for any accounts that could not be added due to invalid dimensions.
Corrected the import process to not required the AR sswat files.
Corrected the permissions related to transactions that are impacted by both USAS and Accounts Receivable.
Corrected a problem with the account histories that was caused by changes to the account summaries.
Corrected additional permission problems related to the Accounts Receivable module. The USAS_RO role was not excluding permissions to the Accounts Receivable options.
Corrected a problem with the budget histories caused by changes to the account summaries. The bug caused additional carryover impacts to be posted which impacted the CCOR report. The budget histories were created incorrectly due to a timing issue which caused the carryovers to be created in error.
Improve performance of the Revenues and Expenditures report by 98%.
Corrected a problem with the AR customer import related to address fields having null values. We also improved the import when comparing the address of vendors being imported to prevent duplicates.
Corrected the Web-GAAP extract to only pull the first 50 characters of the cash account description, which is a limitation of Web-GAAP.
Corrected the account change process to also update the account on void disbursements.
Upcoming Releases
USAS-R v8.2.0
Per the State Treasurer's Office we updated the menu option and caption for the checkbook extract to be "OhioCheckbook.gov".
Corrected a bug that allowed posting more than one budgeting transaction to post the initial amount via the Expenditure account.
Improved the account change process to only allow one account change to be processed at a time. Due to the opening and closing of posting periods done by the process to update all transactions, more than one process running at a time could interfere with each other causing one to fail. If an account change job is "in progress" another one cannot be started until it completes. We also refactored the handling of posting periods to improve the performance of the account change job.
Wrote a discovery patch to determine user preferences related to customizing grids and saved queries. This information will be used as we are rewriting the UIs to be more performant.