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
- MySQL 8 Support: Upgrading to MySQL 8
- Ubuntu Support
- PHP 7.4 Is required: PHP 7.4 Upgrade
- Updated System 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.
- Bill Details Transactions Query including Charge Quantities
- Scheduled Reports by User (User Perspectives)
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.3 (9-21-2021)
Component | Description | Type | Incident(s) | Documentation |
---|---|---|---|---|
Archiving | Voided Service Desk Items, with charges, are now eligible for Archiving. Previously, a bug prevented Archiving these items. | IN-6911 IN-6756 IN-6954 IN-6988 | Service Desk Archive | |
API | Cleaned up a number of notices that filled up the Error Logs. | IN-6730 | ||
The API now allows more complete Content-Types for JSON API requests. content-type application/json; charset=UTF-8 | ||||
Billing | The Bill Coordinator Email now repeats the report header image, GLA, Invoice Number, and Bill Date Range for each GLA in the PDF report. | IN-6731 | ||
Corrected Service and Equipment GLA forms to only update associated charges if the GLA actually changes. | ||||
Cable | Fixed an oops error when using the auto search on the PPL picker. | IN-6825 IN-6928 IN-6975 IN-6982 | ||
Adds Cables/Pairs connections without a path to PortsPinsLens grid and Picker. | IN-6776 IN-7049 | |||
CustomerCenter | Required Service Desk Action UDFs are now enforced on CustomerCenter Cart Request Actions. | IN-6976 | ||
General | Fixed an Oops Error when saving an API Key on MySQL 8. | |||
Imports & Exports | Added an EFFECTIVE_DATE flag to the Service Import to control when any changes to Active MRC charges (starts/stops) take effect. | IN-6629 | Service Import | |
The Usage Import now properly populates the SERVICES_RECID. | IN-6983 | |||
Inventory | Equipment PPL grids now correctly display User Defined Columns values. | IN-7005 | ||
Locations | A more helpful error message is displayed when attempting to open a deleted source record on the Locations' Usage tab. | IN-6710 | ||
Notifications, Escalations, and Events | Added a new config option DISABLE_EMAIL to disable all emails send/receive, without having to alter the .ini file. Users should now define the email from the Tenant record, rather than the .ini file. Note: This value defaults to 'true' for test environments. | |||
The OAuth2 validation error page now displays what data is missing when a request is rejected for missing data. | ||||
The Email column is no longer required on the Notification Log. Errors caused by missing emails are now properly logged. | IN-6813 | |||
Notification/Escalations now have both Action UDFs and Action Service UDFs data available. | ||||
Service Desk | Corrected the Equipment Picker logic to only include Equipment with the correct status. (i.e. an Add Equipment Actions only Allows Unassigned Equipment) | IN-6191 | ||
Stopping Charges from a Service Order Remove Action will now delete any unbilled Charges on the Service if those charges are set to start billing after the Finalization Date. | IN-6616 | |||
The Service Desk Cabling grid buttons now launch the correct form. | IN-7065 |
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-6147 | Service 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 | |||
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:
| 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 | ||
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 | ||||
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-4313 | Location 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 | |||
Added a Right-Click Menu option "Copy Cell" to all grids to allow users to copy cell content from grids. | ||||
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 | |||
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-6088 | Equipment 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. | ||||
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
| 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 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. | IN201833009 | Incidents | |
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-3809 | Service 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 2016 | Service 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 Name | Change | Table Changes |
---|---|---|
MENU | updated | Increased field size to 500 characters |
USERS_PREFERENCES | updated | Updated Value column |
BILLS | updated | DROP COLUMN `TOLL`; |
BILLS_PROCESSLOG | updated | ADD INDEX `BILLS_PROCESSLOG_3` (`BILLS_RECID`, `RECORD_RECID`, `RECORD_TABLE`) |
Metadata Schema
Table Name | Change | Table Changes |
---|---|---|
No changes |
Archive Schema
Table Name | Change | Table Changes |
---|---|---|
No Changes |