Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Next »


Release 2021.1 is now available; it is a major release that contains many new features, bug fixes, and refinements. This is also our next Long Term Support (LTS) release. Version 2021.1 replaces 2019.7 as our LTS release, meaning 2019.7 is no longer supported. An LTS release is a Major Release that PCR will support for at least 12 months.  All other releases are supported for two release cycles.  LTS Releases will be patched (as a hotfix) for any Critical or High Impact bugs applied after a release.  These include (but are not limited to): service-impacting issues, billing issues, or charge-related bugs.  These issues have no workaround, or the workaround is cumbersome.  Once the next LTS is released, PCR will work with customers to move them to the next LTS release.   


NOTE: PHP 7.4 IS REQUIRED for this upgrade.


We will begin scheduling 2021.1 updates on customer Test systems starting, May 17th, 2021.

Notable Changes

  • Added a Right-Click Menu option "Copy Cell" to all grids to allow users to copy cell content from grids.
  • Updated Server Support & Requirements
  • Optimized the Bill Generation process to run faster. Added additional output to the Bill Process Report.
  • Bill Grid Column Changes:
    •  Change the "Total" column name to "Sub Total" moved to end
    •  Moved "Total Tax" to be the last column
    •  Added "Annual", "Semi-Annual", and "Quarterly" columns
    •  Added a new column for the "Grand Total" to replace "Total"
    •  Removed "Services w/MRC" and "Services w/o MRC" columns
  • Opening a picker now moves focus to the search field on the picker.
  • Added an Equipment Charge Import.
  • Numerous Call Import Fixes
  • Completed Service Desk Actions will no longer Finalize if charges exist on the Action and the Service is not billable.
  • On the Service Desk Charges tab, the MRC and NRC total labels on the bottom have been changed to "Estimated MRC Total" and "Estimated NRC Total" and no longer include stopped charges in their calculation.
  • Added a New AdHoc grids to the AdHoc Grid Library.


Please review the Database Changes in 2021.1 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.1. The first session is scheduled for May 19th at 11:00 AM Eastern, and the second is scheduled for May 20th at 3:00 PM Eastern.

Key

Release 2021.1.2 (7-16-2021)

Component

Description

Type

Incident(s)

Documentation

API

The API will now clear the Contact Owner RECID if a Department Owner is set and clear the Department Owner RECID if a Contact Owner is set.

IN-4965

Billing

Corrected the display of the "Tax Total" and "Sub Total" columns on the Bill grid when Taxes are disabled.

IN-6689

CustomerCenter

Single quotes in a Catalog Titles used for CustomerCenter no longer cause issues with the shopping pages.

IN-6278

Cable

Optimized the Ports/Pins/Lens Picker.

IN-6312

General

Cleaned up a number of Warnings and Notices showing up in the Error Logs.

IN-6195

Inventory

Using the basic search on the Warehouse Actions grid no longer produces an error.

IN-6615

Imports & Exports

The Service Import will no longer crash when adding Equipment to a Service if more than one Equipment record is found with the same Equipment ID.

IN-6597
For Calls Import Formats, the duration formatting of the Fixed Rate interval fields now works properly.



Contact Import now allows attaching Inactive GLAs as GLA Permissions and GLA Approvals

IN-6137

Notifications, Escalations, and Events

Added Original Inquiry Number "INQUIRY_EMAIL_NUMBER" to event filters for Notifications/Escalations for all the ServiceDesk Events. It will be populated if the Service Desk item started as an Inquiry.

IN-6204


Notifications
Fixed an issue where a Notification with a missing recipient attempted to send an email (using the Office 365 adapter) with a blank recipient.


IN-6575

IN-6027

IN-6677

IN-6718


Service Desk

Corrected an issue that recreated SDC Workflow on save for Estimates, Inquiries, and Work Orders.

IN-6635
Resolves Fatal Error when Printing a Task Action with no Service Catalog.

IN-6617 
Retired Equipment is no longer displayed on the Service Desk Equipment Picker when Staging Equipment from Warehouse Actions.

IN-6191
Users can once again delete Cabling from Change Actions; a bug in 2021.1 prevented deletion of Cable Entries on Service Desk Actions.

IN-6717

Release 2021.1.1 (5-27-2021)

Component

Description

Type

Incident(s)

Documentation

API

The GLA List command for the Services and Equipment API no longer returns GLA formats instead of the actual GLA values.



Billing

Aggregate data processed and saved with a Vendor Charge Audit (Expense Management) Import is no longer carried over between Import Files that are processed at the same time. 



Billing Service Fees for Accounts Receivable no longer causes an error.



CustomerCenter

Permitted GLAs for a Request are now limited to the intersection of the Coordinator's Permitted GLAs and the Department's permitted GLAs.


Shopping

Stand Alone Equipment quantities are now handled correctly when adding multiple quantities from the shopping pages.



The Order Summary page now shows the correct UDF data, rather than a RECID for drop-down UDFs.

IN-6028
Fixed an issue that sometimes caused the CustomerCenter page numbers to be ghosted out on the My Services/Equipment and Department Services/Equipment widget grids.

IN-6048
Cleaned up system notices in CustomerCenter.

IN-6080

Imports & Exports

All of the Charge Imports no longer allow setting the Stop Date before the Start Date.

IN-6024
Cleaned up dataIsNotDifferent index error on Imports; these errors were building up in the System Log table.



Notifications, Escalations, and Events

Escalation Criteria now handles Checkbox Data Correctly.

IN-6250

People

The Contact Default GLA is no longer required on the Contact GLA Permissions tab. When you select a Contact Default GLA on a Contact record, it is no longer applied automatically to the Contacts GLA Permissions tab.



Service Desk

Completing Work Order with Consumable Equipment on it will no longer generate an error.

IN-6060

IN-6196


Release 2021.1 (05-17-2021)

Component

Description

Type

Incident(s)

Documentation

API

The API can now add and update Service Desk Workflow records.

IN-6147Service Desk API Calls
Added the API call request parameters to the API Request Log.


API Request Log
Added a Barcode API transaction type of 'po_receive'. This allows Equipment on a Purchase Order to be received via the API.


Barcode API Calls
The Equipment API will now set the Warranty End Date automatically when a 'received date' is provided and the Equipment Catalog has a warranty.


Equipment API Calls

Billing

Added the Error column to the Call Details grid.



Call Details
Added a new Configuration Option for Coordinator Email Subject.
Changed the "Email Coordinator" form to use a WYSIWYG editor.

IN-5084

Billing Parameters

Bills

Optimized the Bill Generation process to run faster.
Added additional output to the Bill Process Report

IN-5035

IN-5782

Bills
Bill Grid Column Changes:
  •  Change the "Total" column name to "Sub Total" moved to end
  •  Moved "Total Tax" to be the last column
  •  Added "Annual", "Semi-Annual", and "Quarterly" columns
  •  Added a new column for the "Grand Total" to replace "Total"
  •  Removed "Services w/MRC" and "Services w/o MRC" columns

IN-5893

IN-6009

IN-6023

Billing
 The Bill Archive process now only Archives a specific Bill.

IN201935142
 On the Call Detail Errors grid, the Service Host column header has been changed from 'Name' to 'Service Host'.



The Bill Forward and Bill Backward flags can no longer be changed on existing MRC Charge Catalogs. This will prevent data problems caused by Changing a Charge Catalog from non-Bill Forward to Bill Forward and vice-versa.



Calls with Expense Type Object Code Overrides now Bill properly.

IN-6223

IN-6224


Manually adding Call Details no longer fails to populate the dialed number, originating number, and/or auth code values in the grid.



Fixed issue preventing Alternate Recurring Charges from Stopping.



Cable

Added the Parent Equipment ID and edit button to the Ports/Pins/Lens form.

IN-6225

Cable Ports/Pins/Lens

Inventory Ports/Pins/Lens

Ports/Pins/Lens Grid

Ports/Pins/Lens Form

The Cabling Equipment Port copy form now properly copies the port speed.



The Cable Path Legs form and Service Desk Cabling - Paths Legs form now auto-populate both sides of the path when a PPL is selected.

IN-3087

The Equipment PPL grid no longer shows the wrong cable name when a PPL is connected to more than one pair by removing: corrects duplicated Cable Names in PPL Grids when a PPL is assigned on multiple Cables
This fix also optimizes the PPL data queries.



Catalogs

Adding a Building inside of another Building is no longer allowed.  

Added a Building Group Location Type to allow grouping multiple buildings under a single Location that is not a site. (i.e. in cases where a building has multiple entrances with a 911 address).




IN-4313Location Catalogs
Inactive Vendors no longer appear in the list when using the Add Existing Vendor button.

IN-5169

Deactivating a Charge Catalog now properly deletes the ARC and NRC Charges.



Adding a new Location now triggers the event to update the full Location path.  Previously, when the event did not trigger, it could be difficult to use the new Location on Equipment or Services.



CustomerCenter

The CustomerCenter menu links now support a length of up to 500 characters.

IN-5700
Now, when News and Alerts are displayed on CustomerCenter the Urgency is reflected using the color scheme: green, yellow, red, (for low, medium, and high).



The Request Tracking grid now wraps rather than overflow horizontally.



Editing a link in the CustomerCenter Favorites widget now updates the widget with the changes instead of creating a new widget.



General

MySQL 8 Support

Ubuntu Support

PHP 7.4 is Required


Upgrading to MySQL 8

PHP 7.4 Upgrade

Updated System Requirements

Added a Right-Click Menu option "Copy Cell" to all grids to allow users to copy cell content from grids.


The Grid


Opening a picker now moves focus to the search field on the picker.



Added Custom Validation support for Attachment tables.



The Bulk Update Confirmation Forms now require the user to enter the number of records that will be updated.

IN-4992

IN-3638

Bulk Update Forum Discussion

Services Bulk Update

Equipment Bulk Update

Service Desk Bulk Update

The Bookmarks section no longer requires a refresh to display recently added items.



The "By Type and Service Catalog" Dashboard Widget no longer throws an error on drill-down.

IN-3629
The state of the Both/Service/Equipment button on the "Manage Phone Services" charges tab, can now be saved with a perspective.

IN-4964

Users Group 2020


Cleaned up a number of notices that filled up the Error Logs.



Imports & Exports

Added an Equipment Charge Import.

IN-6088Equipment Charge Import
Added the Service Recid and Service Swap Recid fields to the Service Order Import, to support Services that have blank Service ID.


Service Order Imports
Added the Service Recid field to the Usage Import, to support Services that have blank Service ID.


Calls Import

Usage Import

Improved logic to look up Service ID for Calls and Usage imports.



Archiving Call Details will no longer throw a "Duplicate Error" when a duplicate call already exists in an Archive table.

IN-5234

Call Import Fixes

  • The Import no longer crashes when setting the Call Type to Ignore.
  • The Import will no longer crash when a mapped Service Host error is combined with another call error.
  • The Import no longer crashes when a LATA value is over 3 digits long.
  • Invalid Call Types no longer cause the Import to crash.
  • The Import will now look up Location values if the Location fields were mapped, but blank values were provided in the file.
  • The Import no longer locks up when a decimal duration value is used with duplicate call records.
  • The Import no longer fills the Error Log Explorer with warnings triggered by processing some 7-digit number calls.
  • Format Errors on any field no longer causes the Import to crash.
  • A Blank or Invalid Bill Date in the Import file no longer causes the Import to crash.
  • Format Errors no longer trigger a "Lists Lookup" SQL error.

IN-2833

IN-5132

Call Imports

Several Usage Import crashes were fixed.



The Import Format field is no longer ignored in the Call Details 'Rerate Calls' popup.

IN-6136

Fixed several different Import crashes caused by not mapping some child tab fields.



Service Order Import Fixes

  • The Import now properly reports all validation errors.
  • The Import no longer crashes if the Service or the Service Catalog is not found.



The Equipment Import will now set the warranty end date automatically when a 'received date' is provided, and the Equipment Catalog has a warranty.


Equipment Import

Inventory

Added columns for Serial Number, Equipment ID, and Associated Service ID to the Warehouse Actions Grid



IN-4272

Users Group 2020

Warehouse Actions
Added an Equipment Condition column to the Equipment picker grid of the Return Orders form.


Return Order

Services

Corrected an issue with the Services grid, which should also improve load times for Oracle customers.



Fixed Phone Service form perspective error when a Catalog was set on the perspective.



Service Desk

Added an SLA column to the Incident Grid.


IN201833009Incidents
Added an SDC Type column to the Service Desk Classification grid to aid in searching for a specific SDC.


Service Desk Classification (SDC)
Added the SDC Name column to the 'Add Existing' Workflow picker in the Service Desk Classifications grid

IN-3809Service Desk Classification (SDC)
Added a column to the Multi-Location picker that shows the number of Path Legs assigned in the Location.

IN-5097

Completed Service Desk Actions will no longer Finalize if charges exist on the Action and the Service is not billable.


Service Desk Charges
On the Service Desk Charges tab, the MRC and NRC total labels on the bottom have been changed to "Estimated MRC Total" and "Estimated NRC Total" and no longer include stopped charges in their calculation.

Users Group 2016Service Desk Charges

Clicking on the Service ID field in the Service Desk View Path Report (when a Service does not exist on an Add Action) no longer triggers an error.



The Service ID column on the Service Desk Action grid now allows filtering by non-formatted Service IDs.

IN-3810
Service Desk Charges will now update with Billing Group Pricing, from a Contact Owner's Department Billing Group, if a Billing Group is not set for the Contact.



Disconnect, Swap, and Service ID Actions are now able to view the Path from the Cabling tab.



Fixed an error from the Service Desk 360 Wizard which would happen if the user set a Request Date on the Wizard and if the Service had a remark on it already.

IN-3257

IN-4376

IN-4466

IN-4467

IN-5668


Opening a Service Desk record from a Service/Equipment Activity Grid will now display the "Last Modified" information.

IN-5056

IN-5875


Fixed bug that prevented adding a Path Legs from Incident Requests and Incident Reports.

IN-5004
Deleting a Swap Action now properly restores the PPL/Pair/Strand Status.

IN-5744

Fixed issue when a single unit of Equipment is completed for a multi-unit piece of Equipment the entire Equipment record was updated.

IN-5627
Service Orders will no longer error when completing them with at least two Actions of different change types.

IN-5686

IN-5924


Inactive Contacts are no longer displayed in the email field when using the Request Update Form on Service Desk Workflow.

IN-5675

 * Indicates external documentation not written by PCR.



Database Changes in 2021.1


Default Schema


Table NameChangeTable Changes
MENU
updatedIncreased field size to 500 characters
USERS_PREFERENCES
updatedUpdated Value column
BILLS
updated
DROP COLUMN `TOLL`;
DROP COLUMN `LOCAL`;
DROP COLUMN `MRC_SERVICES`;
DROP COLUMN `NON_MRC_SERVICES`;
DROP COLUMN `CALLS_DURATION`;
CHANGE `MRC` `MONTHLY_RECURRING` DECIMAL(18,5) DEFAULT 0;
CHANGE `NRC` `NONRECURRING` DECIMAL(18,5) DEFAULT 0;
ADD `ANNUAL_RECURRING` DECIMAL(18,5) DEFAULT 0 NULL;
ADD `SEMI_ANNUAL` DECIMAL(18,5) DEFAULT 0 NULL;
ADD `QUARTERLY` DECIMAL(18,5) DEFAULT 0 NULL;
BILLS_PROCESSLOG
updated
ADD INDEX `BILLS_PROCESSLOG_3` (`BILLS_RECID`, `RECORD_RECID`, `RECORD_TABLE`)


Metadata Schema


Table NameChangeTable Changes
No changes


Archive Schema


Table NameChangeTable Changes
No Changes


Supported Versions

  • No labels

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