Versions Compared

Old Version 26

changes.mady.by.user David Engblom

Saved on

compared with

New Version 27

changes.mady.by.user David Engblom

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Release 2021.1 is now available; it is a major release that contains many new features, bug fixes, and refinements. This is also our nextLong 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
Toggle cloak
 Cloak

   
Bug Fixes
New Features


Changed Features
Improved Performance
Removed Features


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.
Image Added
IN-4965
Billing
Corrected the display of the "Tax Total" and "Sub Total" columns on the Bill grid when Taxes are disabled.
Image Added
IN-6689
CustomerCenter
Single quotes in a Catalog Titles used for CustomerCenter no longer cause issues with the shopping pages.
Image Added
IN-6278
Cable
Optimized the Ports/Pins/Lens Picker.
Image AddedImage Added
IN-6312
General
Cleaned up a number of Warnings and Notices showing up in the Error Logs.
Image Added
IN-6195
Inventory
Using the basic search on the Warehouse Actions grid no longer produces an error.
Image Added
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. 
Image Added
IN-6597
For Calls Import Formats, the duration formatting of the Fixed Rate interval fields now works properly.
Image Added


Contact Import now allows attaching Inactive GLAs as GLA Permissions and GLA Approvals
Image Added
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.
Image Added
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.
Image Added

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.
Image Added
IN-6635
Resolves Fatal Error when Printing a Task Action with no Service Catalog.
Image Added
IN-6617 
Retired Equipment is no longer displayed on the Service Desk Equipment Picker when Staging Equipment from Warehouse Actions.
Image Added
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.
Image Added
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.
Image Modified


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. 
Image Modified


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


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.
Image Modified


The Order Summary page now shows the correct UDF data, rather than a RECID for drop-down UDFs.
Image Modified
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.
Image Modified
IN-6048
Cleaned up system notices in CustomerCenter.
Image Modified
IN-6080
Imports & Exports
All of theCharge Imports no longer allow setting the Stop Date before the Start Date.
Image Modified
IN-6024
Cleaned up dataIsNotDifferent index error on Imports; these errors were building up in the System Log table. 
Image Modified


Notifications, Escalations, and Events
Escalation Criteria now handles Checkbox Data Correctly.
Image Modified
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.
Image Modified


Service Desk
Completing Work Order with Consumable Equipment on it will no longer generate an error.
Image Modified
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.
Image Modified
IN-6147Service Desk API Calls
Added the API call request parameters to the API Request Log.
Image Modified

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.
Image Modified

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.
Image Modified

Equipment API Calls
Billing
Added the Error column to the Call Details grid.
Image Modified


Call Details
Added a new Configuration Option for Coordinator Email Subject.
Changed the "Email Coordinator" form to use a WYSIWYG editor.
Image Modified
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
Image Modified
IN-5893
IN-6009
IN-6023
Billing
 The Bill Archive process now only Archives a specific Bill.
Image Modified
Image Modified
IN201935142
 On the Call Detail Errors grid, the Service Host column header has been changed from 'Name' to 'Service Host'.
Image Modified


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.
Image Modified


Calls with Expense Type Object Code Overrides now Bill properly.
Image Modified
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.
Image Modified


Fixed issue preventing Alternate Recurring Charges from Stopping.
Image Modified


Cable
Added the Parent Equipment ID and edit button to the Ports/Pins/Lens form.
Image Modified
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.
Image Modified


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.
Image Modified
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.
Image Modified


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


Image Modified

IN-4313Location Catalogs
Inactive Vendors no longer appear in the list when using the Add Existing Vendor button.
Image Modified
IN-5169
Deactivating a Charge Catalog now properly deletes the ARC and NRC Charges. 
Image Modified


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.
Image Modified


CustomerCenter
The CustomerCenter menu links now support a length of up to 500 characters.
Image Modified
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). 
Image Modified


The Request Tracking grid now wraps rather than overflow horizontally.
Image Modified


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


General
MySQL 8 Support
Ubuntu Support
PHP 7.4 is Required
Image Modified

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.
Image Modified

The Grid

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


Added Custom Validation support for Attachment tables.
Image Modified


The Bulk Update Confirmation Forms now require the user to enter the number of records that will be updated.
Image Modified
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.
Image Modified


The "By Type and Service Catalog" Dashboard Widget no longer throws an error on drill-down.
Image Modified
IN-3629
The state of the Both/Service/Equipment button on the "Manage Phone Services" charges tab, can now be saved with a perspective.
Image Modified
IN-4964
Users Group 2020

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


Imports & Exports
Added an Equipment Charge Import.
Image Modified
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.
Image Modified

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

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


Archiving Call Details will no longer throw a "Duplicate Error" when a duplicate call already exists in an Archive table.
Image Modified
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.
Image Modified
IN-2833
IN-5132
Call Imports
Several Usage Import crashes were fixed. 
Image Modified


The Import Format field is no longer ignored in the Call Details 'Rerate Calls' popup.
Image Modified
IN-6136
Fixed several different Import crashes caused by not mapping some child tab fields.
Image Modified


Service Order Import Fixes
  • The Importnow properly reports all validation errors. 
  • The Import no longer crashes if the Service or the Service Catalog is not found. 
Image Modified


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

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

Image Modified

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.
Image Modified


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


Service Desk
Added an SLA column to the Incident Grid.
Image Modified

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

Service Desk Classification (SDC)
Added the SDC Name column to the 'Add Existing' Workflow picker in the Service Desk Classifications grid
Image Modified
IN-3809Service Desk Classification (SDC)
Added a column to the Multi-Location picker that shows the number of Path Legs assigned in the Location.
Image Modified
IN-5097
Completed Service Desk Actions will no longer Finalize if charges exist on the Action and the Service is not billable.
Image Modified
Image Modified

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.
Image Modified
Image Modified
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.
Image Modified


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


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.
Image Modified
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.
Image Modified
IN-5056
IN-5875

Fixed bug that prevented adding a Path Legs from Incident Requests and Incident Reports.
Image Modified
IN-5004
Deleting a Swap Action now properly restores the PPL/Pair/Strand Status.
Image Modified
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.
Image Modified
IN-5627
Service Orders will no longer error when completing them with at least two Actions of different change types.
Image Modified
IN-5686
IN-5924

Inactive Contacts are no longer displayed in the email field when using the Request Update Form on Service Desk Workflow.
Image Modified
IN-5675
 * Indicates external documentation not written by PCR.
...
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
...