2020-01-15 USAS Completed Work Review
Releases Since Our Last Meeting (11-20-2019)
The Monthly Report Bundle has been updated to include the Outstanding Purchase Order Summary and Outstanding Disbursement Summary reports.
The User Listing report has been updated to include user parameters to include/exclude disabled users and include/exclude users by roles.
The Vendor Adjustment UI has been improved to clarify required fields. We've also improved the overall look and feel of this UI.
An optional rule has been added to populate the invoice item received date with the vendor's invoice date. This rule is disabled by default and is not mandatory. Currently the invoice item received date is populated with the invoice date by default if the invoice item received date has been left blank.
The AP Invoice grid has been updated to allow filtering by created user.
The 1099 TAP file has been corrected to remove extra spaces that caused the fixed format to go beyond the 750 position limit as specified in the publication 1220 file specs. Â
This release also corrects a problem introduced with the 7.28.2 hotfix which prevented users from viewing disbursements they posted. Â
Corrected a problem with the new vendor adjustment rule released with 7.29.0. The rule was written to prevent posting vendor adjustments for an amount of $0.00. There is a patch that runs on newly imported databases to make sure vendor ledgers are generated for imported disbursements. When checks have items for $0.00 it caused a problem with the rule. We only want the rule to catch manual vendor adjustments posted by the user via the vendor UI, not ledgers auto created by disbursements. The rule has been updated to only apply to manually created vendor ledgers.
Improved the performance of posting Payables to Disbursements by 40%!
Updated the 1099 Vendor report to display the vendor's 1099 name and address.
Users can now edit the report bundles they've created.
Users can now edit the jobs they've scheduled.
Corrected a problem that allowed PO item issued and canceled dates to be associated with closed posting periods.
Updated the UI to provide a clear message to the user when a check does not reconcile.
Added the ability to sort payables by payment due date via the Detail tab of the Payables grid.
Implemented the ability to print PDF versions of Distributions/Error Correction transactions.
A big improvement has been made to the generation of template reports to allow users to dynamically sort and subtotal reports at run time. In addition to this improvement, we have updated 31 template reports to include the various account code dimensions so they are readily available to select from when generating the reports. Please see below for a list of the reports that were updated to include the account code dimensions. This new feature has been documented and is available here: Report Manager#ReportGenerationOptionsandDynamicSort.
The Positive Pay Extract has been updated to properly format the spacer field. Please note: any previously created extracts that contain the spacer field will need to be updated to remove the spacer and then re-add it so that it works properly. Also be aware that the format value for hte spacer will be blank regardless of the field length.
Corrected a rule that incorrectly produced an error during the account change process. The rule that requires the vendor on a purchase order to be active was firing during the account change process and produced an error that caused the overall account change process to fail. The rule has been modified so that it will no longer run as part of the account change process. Â
Users can now modify the void date on Disbursements. The posting period for the existing date and the new date must be open in order to change the void date. It's important to note that in the case of changing the void date to a date in a different posting period, this may change amounts and effectively invalidate some reports that the users will need to regenerate.
The transfer and advance grid has been updated to remove advance repays. The grid will now show only the transfers and original advances. The advance repayments are now accessible via the original advance view. In order to repay an advance the user will now need to view the advance and add a repayment via the grid. In an upcoming release we will provide users a way to link the Classic repayments to their advances. We were not able to determine which advances were actually repayments posted in Classic at import time.
Please note: the $ repay button is no longer in the grid. You can add the Repayable field to the grid and filter it to true to see which Advances are still able to be repaid.
Template reports have been improved to
prevent the loss of the report definition and tags when modify the report definition
correct a problem with the control header that previously allowed the word "null" to appear instead of the proper label
add a user parameter to allow the user to choose if they want to include accounts when all amount fields are zero. This was added to the four account summary reports and functions as follows:
Exclude Accounts with Zero Amounts (true/false)Â Leave blank to include all accounts
True: will generate a report that will exclude accounts with all amounts equal zero
False: will generate a report that will exclude accounts with amounts
Blank: will generate a report that will include all accounts regardless of amounts
The Proration Utility has been updated so that the accounts are sorted in the expected order.
A correction to the queryChecks method in the SOAP Bridge. This problem directly impacted a third party vendor's ability to query checks when the result included payroll checks that had been assigned a physical check number. Â
Made available a Calendar Year End report bundle. Â
Upcoming Releases
USAS-R v7.33.0 Release anticipated 1/17/19
Corrections to the transaction service to filter out future budgeting transactions. If transactions in future posting periods existed they were being included in the totals even if they did not fall in the dates selected for the report run.
Added a variance column to the Appropriation and Receivables by Cash Account report. Initial Cash + FYTD Receivable - Carryover Encumbrance - FYTD Appropriated.
USAS-R v7.34.0
Correction to advance repay accounts per AOS; must use IN and OUT accounts specified in the user manual
Correct issues related to filtering by createdUser
Correcting missing headers/footers on template reports when running reports from the Reports Creator
Making canned reports runnable so they can be included in report bundles
Correcting the ability to change the name of an imported template report
Cash Reconciliation performance improvement
Encumbrance issues related to imported POs; pertains to districts that imported prior to the availability of encumbrance impacts
Adding rules to all transactions to make sure accounts are active according to start/stop dates
Ability to link Classic Advances and their Repayments