Versions Compared

Key

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

Releases Since Our Last Meeting (

...

11-

...

20-2019)

...

USAS-R v7.26.1 Hotfix

  1. We modified a rule to be a warning instead of an error when a user attempts to post an invoice with an item that has an amount of zero dollars.

Note:  In order to discourage the posting of $0 invoices to "close a PO".  Please be aware of the intended ways to handle closing POs and canceling items in the Redesign:

  • To cancel an item that has not been invoiced, amend the PO and cancel the item from the PO
  • To close an item that has been paid/invoiced: Query all invoices for that PO and sort them in date order.  Find the last invoice and change the status of the item to FULL instead of Partial.

USAS-R V7.27.0 Release

  1. Modified the grid's MORE button to refresh the grid when the user closes the popup, not each time a field is added or removed.  Note: when the popup closes the screen refreshes with the user's desired changes and anything entered into the filter value is lost.
  2. Reverted previous change to remove user parameter from the Outstanding PO Detail report.
  3. Corrected AP Invoice to populate the item amount with the remaining invoiceable if the user chooses the FULL status.
  4. The problems related to preencumbrances, carryover encumbrances and expendable amounts with Account Change have been corrected.  
  5. Initial amounts on Cash and Appropriation accounts have been corrected.  Previously if districts posted temporary and permanent budgets the initial amounts were reflecting both amounts, not just the permanent amount.
  6. The ability to create a Report Bundle is now available in USAS under the Report menu option!  Report bundles can be created to generate multiple reports at one time based on either an event in the application or a scheduled point in time via the cron expression generator.
  7. The Revenues and Expenditures report has been updated to properly collapse cash accounts.  Cash accounts with SCC's 0001-8999 will now collapse to the 0000 SCC like the Classic report did.
  8. Updated the way the repay accounts display for Advance repays. 

USAS-R V7.28.0 Release

  1. The Monthly CD Report Bundle is now available.  See below for important details.
  2. The functionality of the MORE button on the grids has been updated to only refresh when the popup is closed.  This will prevent repeated refreshes of the grid from happening every time a field is added or removed.  Please note:  if you have entered anything in the filter row before opening the MORE button to customize your grid, the data in the filter row will be lost.  We will be working to prevent this in a future release.  If the MORE button is clicked but no changes are made the page will not refresh and the filter row will not be lost.
  3. A User Listing report is now available.  This report will list all currently active users.
  4. An additional RAM extract has been added to USAS per LACA's request.  Please do not use this new report to send your RAM extracts to LACA unless they have instructed you to do so.
  5. Per the Auditor of State's office the time restriction to repay Advances has been removed.  Previously an advance had to be repaid in the current or next fiscal year.  A repayment beyond that time would have to be processed as a transfer.  AOS has stated there are times when advances will take longer to repay and that is allowable.  It is up to the district to know how the specific advance is to be repaid.  This will no longer be determined by the software.
  6. The SSDT template reports have been updated to replace the report descriptions that were previously lost.  These descriptions are also available in the documentation.
  7. The import log has been updated to include the PO# in the suspicious invoice warning message.
  8. The following AP Invoice improvements have been made:
    1. When processing invoices, all PO items are visible when creating a new invoice.  If the items are not invoiceable they are displayed as read only.
    2. The ability to continuously create new invoices has been implemented.  The entry field will populate with the last PO number invoiced if it is still invoiceable.  If not, the user can key in a PO number and click the create button to process the next invoice.
    3. The invoice item table will now display the original, remaining invoiceable and payable amount columns for each item.
    4. The table that displays the invoice items is no longer sortable.  Previously you could sort the table which would reorder the items.

USAS-R V7.28.1-2 Hotfix

  1. Corrected a performance problem introduced with the 7.27.0 release that impacted the retrieval of the initial estimate amount.  This problem impacted reports that include the initial estimate amount and potentially account grids if the field had been added.

Upcoming Scheduled Release

USAS-R 7.28.2 (project release date: 11/20/19)

  • Hotfix to correct account sync performance problem between USAS and USPS.

USAS-R 7.29.0 (projected release date: 11/22/19)

...

  • Updated the vendor adjustments UI to require the date and amount fields.
  • Updated the vendor adjustments UI to improve the layout of the windows and improve the display of information.
  • Corrected the TAP file extract to remove extra spaces that caused issues appending the Classic and Redesign files last year.

...

.29.0 Release

  1. The Monthly Report Bundle has been updated to include the Outstanding Purchase Order Summary and Outstanding Disbursement Summary reports.
  2. The User Listing report has been updated to include user parameters to include/exclude disabled users and include/exclude users by roles.
  3. The Vendor Adjustment UI has been improved to clarify required fields.  We've also improved the overall look and feel of this UI.
  4. 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.
  5. The AP Invoice grid has been updated to allow filtering by created user.
  6. 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.  
  7. This release also corrects a problem introduced with the 7.28.2 hotfix which prevented users from viewing disbursements they posted.  

USAS-R v7.29.1 Hotfix

  • 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.

USAS-R v7.30.0 Release

  1. Improved the performance of posting Payables to Disbursements by 40%!
  2. Updated the 1099 Vendor report to display the vendor's 1099 name and address.
  3. Users can now edit the report bundles they've created.
  4. Users can now edit the jobs they've scheduled.
  5. Corrected a problem that allowed PO item issued and canceled dates to be associated with closed posting periods.
  6. Updated the UI to provide a clear message to the user when a check does not reconcile.
  7. Added the ability to sort payables by payment due date via the Detail tab of the Payables grid.
  8. Implemented the ability to print PDF versions of Distributions/Error Correction transactions.

USAS-R v7.31.0 Release

  1. 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.
  2. 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.

USAS-R v7.31.1 Hotfix

  • 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.  

USAS-R v7.32.0 Release

  1. 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.
  2. 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.
    1. 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.
  3. Template reports have been improved to
    1. prevent the loss of the report definition and tags when modify the report definition
    2. correct a problem with the control header that previously allowed the word "null" to appear instead of the proper label
    3. 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:
      1. Exclude Accounts with Zero Amounts (true/false)  Leave blank to include all accounts
        1. True: will generate a report that will exclude accounts with all amounts equal zero
        2. False: will generate a report that will exclude accounts with amounts
        3. Blank: will generate a report that will include all accounts regardless of amounts
  4. The Proration Utility has been updated so that the accounts are sorted in the expected order.

USAS-R v7.32.1 Hotfix

  • 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