Document toolboxDocument toolbox

(v1) .Release Notes v2021.3


Release 2021.3 is now available; it is a minor release that contains new features, bug fixes, and refinements.

We will begin scheduling 2021.3 updates on customer Test systems starting, January 4th, 2022.


NOTE: PHP 7.4 IS REQUIRED for this upgrade.


Notable Changes

  • Updates native password hashing to increase security
    • Adds new password hashing
    • Adds manual password expiration to the Users form, and includes a password reset link on the confirmation message
    • Retains legacy hashing to identify old passwords
    • Expires all user passwords so they are forced to be reset using the new hash
      • Note: After the upgrade, all users using the native PCR-360 log-in will have to reset their passwords, this will not affect Shibboleth customers.
    • Adds functionality to reset expired passwords after logging in with them
  • Added two new cleanup Events:

    1. Cleans up old Bulk Update History records. (The default timeframe is 365 days)
    2. Cleans up old System Message records. (The default timeframe is 365 days)
  • Perspectives Grid Changes

    • Admins now have the ability to override the PCR grid defaults (i.e. Perspective Admin Defaults).
    • Admins may now schedule grid reports from the Perspectives Grid Page.
  • Adds support for NENA 3 compatible E911 Reports.

Please review the Database Changes in 2021.3 and make any necessary changes to your AdHoc Grids, Custom Events, and API calls.

Review and Refresh Session(s)

We are planning two Review and Refresh sessions for 2021.3. The first session is scheduled for January 12th at 11:00 AM Eastern, and the second is scheduled for January 13th at 3:00 PM Eastern.

Key

Release 2021.3.7 (08-23-2022)

Component

Description

Type

Incident(s)

Documentation

General

Optimized Location and Warehouse Pickers to be faster.

IN-8279


Release 2021.3.6 (07-25-2022)

Component

Description

Type

Incident(s)

Documentation

Archiving

Service Desk Archiving now correctly moves Service Desk Cabling data on older Service Orders.

IN-8095

Billing

Added Importable Charges RECID column to master Charges grid.
Optimized master Charges grid by adding Charge Source selector.

IN-8065
The Service Summary now displays the correct totals for customers who have multiple tax rates.

IN-8085

Cable

Resolves issue where Path To Equipment is not displayed on Ports/Pins/Lens (PPL) Grids when not linked to a PPL record.



CustomerCenter

Adjusted the "Add To Cart" pop-up in CustomerCenter, so it does not obscure the "Go To Cart" link.



CustomerCenter now correctly sets the "New Service ID," "Location," and "Rating Group" (for phones and auth codes) to Service Desk Actions.

IN-7718

General

Added better error handling to the GLA replace.

IN-8211GLA Replace

Imports & Exports

Processing a large call file containing binary data no longer crashes the rating process.

IN-8104

IN-8266


The Service Import no longer errors when changing to catalogs with parent-enforced formats.

IN-8121


Inventory

The Items at Reorder Point Report now displays items with a Reorder Point of zero that are out of stock.

IN-6746

Service Desk

Changing the "Transfer to Warehouse" Location on Warehouse Actions no longer changes the Equipment available on the Equipment picker.

IN-8080


Release 2021.3.5 (05-06-2022)

Component

Description

Type

Incident(s)

Documentation

Imports & Exports

Equipment added from an Import or SDC will now set the To Location on the Service Desk Equipment from the Action's Location or Move-to Location 

IN-8037


Service Desk

Warehouse Return Actions now properly remove the Service to Equipment Association.

IN-7305

Release 2021.3.4 (04-28-2022)

Component

Description

Type

Incident(s)

Documentation

Billing

Added GLA Description to Invoices grid.


Invoices

CustomerCenter

The Request Description field now properly limits input to 500 characters.

IN-7850
If an error occurs in CustomerCenter, a user with only CustomerCenter Permissions, is no longer presented with an erroneous "Insufficient Permissions" message.

IN-7850

Imports & Exports

Cleaned up a number of Export Format notices generated by scheduled Export events.

IN-7825
The GLA Charge, Service Charge, and Equipment Charge Imports will now properly update the stop date on Monthly Recurring Charges that are not "Billing Complete" and already have a stop date.

IN-7720

General

The autocomplete for the Location picker and Warehouse picker now shows the top ten Locations sorted by the full Location Path.

IN-7527
Adding a new Service Desk Action UDF to a Catalog with existing UDF Associations no longer removes the existing UDF Associations.




UDFs that utilize a Criteria Value can now be reordered on the UDF form.

IN-7689
Increased the size of the Grid ID column for Permissions to 100 characters to avoid issues with long Grid IDs.



Service Desk

Voiding a Service Order now returns the Cabling on each Action to its original state.

IN-5744

IN-6735


Equipment Permissions set on a Service Catalog are now respected on the Service and Service Desk Action forms.



Inherited Service UDFs are now properly displayed on the Service Desk Action form.



Service Desk Action changes

  • Action Completion no longer sets Stop Dates on Equipment Charges
  • Finalizing an Action now sets Equipment Charge Stop Dates
  • Corrected an issue affecting Billing Group Pricing when stopping Equipment Charges and the Owner is removed
  • Added Associated Equipment Charges to the Service Billing Estimate

IN-7553

IN-7882


Release 2021.3.3 (03-14-2022)

Component

Description

Type

Incident(s)

Documentation

API

The Service Desk API no longer applies an SDC automatically to an Action when an SDC is not provided in the API call.

IN-7629
The Services API no longer requires the serv_catalog parameter for updates, only on new records.

IN-7394

Billing

Stopping Bill Forward MRC Charges, on the Billed through date, no longer crashes the Bill process.



Imports & Exports

Charge Import Fixes

  • The Charge Imports no longer deletes the CHARGES record of a Charge without creating a replacement CHARGES record.
  • The Equipment Charge Import now validates the Charge Type properly. (e.g. Monthly Recurring, Nonrecurring, etc.)

IN-7652

General

Modified the "Cleanup Audit data" process to use less memory and prevent the Event from crashing.


IN-5973
Deleting Messages now also deletes the files attached to the message.



Services

Fixed an issue with the Add Range of Services process that was introduced in version 2021.3.

IN-7670

IN-7726


Service Desk

Consumable Equipment no longer requires a Location on Incidents.

IN-7518
The Cabling section of the Service Desk Printout now displayed the List Values, instead of the List Codes. Now when a customer renames the Service Desk Cable Action entries, the printout displays the new value(s). 


List Values
Completing Change Actions (with Equipment) and no Move-To Location no longer fails.

IN-7471
Stopping ARC Charges from Service Desk no longer throw a "Failed to Field Action", or "Failed to Save record" error message when Finalizing an Action.



Release 2021.3.2 (02-07-2022)

Component

Description

Type

Incident(s)

Documentation

Imports & Exports

Fixed a bug that caused some Imports to fail with an invalid date error, even though the file contained valid date/time values.

IN-7624

IN-7700

IN-7701

IN-7702


Release 2021.3.1 (01-20-2022)

Component

Description

Type

Incident(s)

Documentation

Billing

The Bill Completion Export now works with Archived Bills.



Bill Forward Charges, that have never been billed, no longer incorrectly issue a credit.



Corrected the BILLDATE parameter in Bill Exports to allow for "YYYYMM" in the export filename.



Bill Forward Charges will now Prorate when the charge is stopped before Bill Generation with Stop Date in Forward Cycle.

IN-7417Forum Post Discussion

Cable

Resolves an issue where the non-graphical Cabling Report failed to print correctly from the Service Form.

IN-7497
The Location Picker is no longer blanked out on the Cable Paths Form when saving the record.



CustomerCenter

Corrected a column misalignment for the My Services/Equipment and Department Services/Equipment widgets.

IN-7299

IN-7569


Corrected a fatal error that occurred when hiding all widgets in CustomerCenter, or all widgets are already hidden.

IN-7170

IN-7236

IN-7406


Viewing the Cart in CustomerCenter no longer errors for certain Change Actions; specifically Changes with UDF fields.

IN-7473

Inventory

Adding an Equipment Catalog inventory spec with a threshold now displays the item on the Warehouse Inventory tab. Items with zero quantity will display on the Warehouse Inventory tab grid.

IN-6746

IN-7168


Imports & Exports

Fixed a bug preventing Exports from emailing when using the Office365 Client.

IN-7472

General

Cleaned up some application notices that caused the application to become non-responsive.

IN-7526

Adding GLA(s) to Equipment and Services (on a new, unsaved, Equipment/Service record) no longer throws an error when trying to save the GLA(s).

IN-7324
Updating an existing Buiding Address via "Create/Edit New Address" no longer errors upon save.



Addresses created from the form no longer prioritize the Tenant's default State when the Country is not a "System Use" Country.



Building Locations no longer incorrectly require the Address Fields.



Resolves issue where an SSO login (i.e. Shibboleth) may redirect to reset a Native Password when both are available to a user. The prompt should now only occur when using the Native PCR-360 Authorization Adapter.



Release 2021.3 (12-30-2021)

Component

Description

Type

Incident(s)

Documentation

API

Added new validations for Charges
  • The API now verifies a Service is billable when adding a Charge
  • The Owner is required for a new GLA Charge
  • The Override GLA format is validated against the Owner Billing Group GLA format
  • Standardize the parameter charge_catalog_recid for the charge catalog, charge_recid and catalog will still be accepted
  • Prorate may be set only if the BILL_MRC_CHANGE_FORCE_PRORATE config option is set to false
  • The API now validates whole and fractional quantities for Charges
  • An error is thrown if:
    • The amount is provided and the Catalog does not allow overrides
    • A quantity is provided for a Catalog that does not allow a quantity. (The Quantity is only allowed if the Catalog allows a quantity.)
    • The item does not have a Default Expense GLA


Services

Equipment

GLA

Service Desk

Actions

Contacts

Cable

Barcode

The API now supports international addresses.


Contacts API
Added Billing Group validation when adding new GLA's to a Service. Also added validations for an ownership change in the API


Service API

Cleaned up a number of notices in the Purchase Order and Barcode API calls:



Catalogs

On the GLA grid, the "Select GLA Format" selector allows switching to the first format if you switched to another.

IN-7323

General

Added two new cleanup Events:

  1. Cleans up old Bulk Update History records. (The default timeframe is 365 days)
  2. Cleans up old System Message records. (The default timeframe is 365 days)

IN-4442

Tenant

Inventory

Services

Service Desk

Messages

Events

Perspectives Grid Changes

  • Admins now have the ability to override the PCR grid defaults (i.e. Perspective Admin Defaults).
  • Admins may now schedule grid reports from the Perspectives Grid Page.

IN-7123

Perspectives Grid

Video: Perspectives Grid

Updates native password hashing to increase security
  • Adds new password hashing
  • Adds manual password expiration to the Users form, and includes a password reset link on the confirmation message
  • Retains legacy hashing to identify old passwords
  • Expires all user passwords so they are forced to be reset using the new hash
    • Note: After the upgrade, all users using the native PCR-360 log-in will have to reset their passwords, this will not affect Shibboleth customers.
  • Adds functionality to reset expired passwords after logging in with them'


Users (Password Management)

Adding a new widget to the dashboard no longer removes existing widgets from the dashboard.

IN-6659

IN-4951

IN-7114


Cleaned up a number of homepage/dashboard notices (that were filling up the log in some cases).



Searching on a date column in Oracle, with certain query strings, no longer throws an error.

IN-6323

Form Perspectives now save content for rich text editor fields (i.e. WYSIWYG fields).



International Address support on forms does now supports Custom Countries.



Imports & Exports






Added the user (who imported the file) to the Imports Grid.

IN-4985Importing a File

Charge Catalog Import changes:

  • The Import now supports Remarks and Remark Author.
  • The Import now saves the correct value when USE_QUANTITY is set to Disabled
  • The Import no longer blanks out the Amount for Default Charges on existing Equipment Catalogs.

IN-6713Charge Catalog Imports
Adds support for NENA 3 compatible E911 Reports.


Enhanced 911

Misc Parameters (Config Settings)

Imports now support international addresses.



Removed the extra "Default GLA" import field from the Charge Catalog import.



Inactive GLAs can now be used with the following imports:

  • Department GLA Permissions
  • Contact GLA Permissions
  • Contact GLA Approvals


Contact Import

Location Import

GLA Import

Inventory

Purchase Order Remarks and Return Order Remarks now support rich text.



Purchase Order

Return Order

Improved the performance of Equipment Catalog Pickers, specifically the Bulk Add Equipment Catalog Picker.



The Approved By field on Purchase Orders is now read-only once Closed.



Reports

The Zero / Low Calls Report now includes Archived Call Details data; Added Call Count and Duration Thresholds to the report.

IN-6594Zero Calls Report

Services

When Bulk-adding Service IDs the message displayed when some of the Service IDs in the range already exist no longer include out-of-range Service IDs.

IN-6692

Service Desk

Added the Override GLA column to the Service Desk Charges grid.




Added the Service Desk Action Status column to the Service Order child grids.


Service Desk Tabs

Charges with Billing Group Pricing are now properly updated when the owner of an Action is changed.



Completing a Move Action for a Multi-Location Service no longer throws an error when a "To Location" is not specified.

IN-6775

 * Indicates external documentation not written by PCR.



Database Changes in 2021.3


Default Schema


Table NameChangeTable Changes
EVENTSUpdatedAdded two new events.
IMPORT_FILESUpdated
ADD `IMPORTED_BY` VARCHAR(20) NULL
IMPORT_RECORD_TYPES_COLSUpdatedUpdated data.
TENANTSUpdated
ADD `BULK_UPDATE_HISTORY_DAYS` INT DEFAULT 365 NULL
ADD `MESSAGE_DAYS` INT DEFAULT 365 NULL
USERSUpdated
CHANGE COLUMN `PASSWORD` `PASSWORD` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci'
ADD COLUMN `PASSWORD_EXPIRED` TINYINT(1) NOT NULL DEFAULT 1
USERS_PASSWORDSUpdated
Reset the password for all users. 
CHANGE COLUMN `PASSWORD` `PASSWORD` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci'
USERS_PERSPECTIVESUpdated
ALTER TABLE `USERS_PERSPECTIVES` MODIFY `USERS_RECID` INT NULL


Metadata Schema


Table NameChangeTable Changes
No changes


Archive Schema


Table NameChangeTable Changes
No Changes


Supported Versions

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242