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	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
Billing	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	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-8211	GLA Replace
Imports & Exports	Processing a large call file containing binary data no longer crashes the rating process.	IN-8104 IN-8266
Imports & Exports	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	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
CustomerCenter	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
Imports & Exports	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	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
API	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
General	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	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-7417	Forum Post Discussion
Cable	Resolves an issue where the non-graphical Cabling Report failed to print correctly from the Service Form.	IN-7497
Cable	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	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: Cleans up old Bulk Update History records. (The default timeframe is 365 days) 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-4985	Importing 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-6713	Charge 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-6594	Zero 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 Name	Change	Table Changes
EVENTS	Updated	Added two new events.
IMPORT_FILES	Updated	ADD `IMPORTED_BY` VARCHAR(20) NULL
IMPORT_RECORD_TYPES_COLS	Updated	Updated data.
TENANTS	Updated	ADD `BULK_UPDATE_HISTORY_DAYS` INT DEFAULT 365 NULL ADD `MESSAGE_DAYS` INT DEFAULT 365 NULL
USERS	Updated	CHANGE COLUMN `PASSWORD` `PASSWORD` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci' ADD COLUMN `PASSWORD_EXPIRED` TINYINT(1) NOT NULL DEFAULT 1
USERS_PASSWORDS	Updated	Reset the password for all users. CHANGE COLUMN `PASSWORD` `PASSWORD` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci'
USERS_PERSPECTIVES	Updated	ALTER TABLE `USERS_PERSPECTIVES` MODIFY `USERS_RECID` INT NULL

Metadata Schema

Table Name	Change	Table Changes
No changes

Archive Schema

Table Name	Change	Table Changes
No Changes

Notable Changes

Review and Refresh Session(s)

Release 2021.3.7 (08-23-2022)

Component

Description

Type

Incident(s)

Documentation

General

Release 2021.3.6 (07-25-2022)

Component

Description

Type

Incident(s)

Documentation

Archiving

Billing

Cable

CustomerCenter

General

Imports & Exports

Inventory

Service Desk

Release 2021.3.5 (05-06-2022)

Component

Description

Type

Incident(s)

Documentation

Imports & Exports

Service Desk

Release 2021.3.4 (04-28-2022)

Component

Description

Type

Incident(s)

Documentation

Billing

CustomerCenter

Imports & Exports

General

Service Desk

Release 2021.3.3 (03-14-2022)

Component

Description

Type

Incident(s)

Documentation

API

Billing

Imports & Exports

General

Services

Service Desk

Release 2021.3.2 (02-07-2022)

Component

Description

Type

Incident(s)

Documentation

Imports & Exports

Release 2021.3.1 (01-20-2022)

Component

Description

Type

Incident(s)

Documentation

Billing

Cable

CustomerCenter

Inventory

Imports & Exports

General

Release 2021.3 (12-30-2021)

Component

Description

Type

Incident(s)

Documentation

API