Document toolboxDocument toolbox

(v1) .Release Notes v2021.1


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

  • Dropped official support of Internet Explorer 
  • 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.10 (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

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

Imports & Exports

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

IN-8104

IN-8266


Inventory

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

IN-6746

Release 2021.1.9 (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.




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.



Release 2021.1.8 (03-11-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

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.1.7 (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 a 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


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

Release 2021.1.6 (12-20-2021)


Component

Description

Type

Incident(s)

Documentation

Imports & Exports

Corrected an issue preventing the NEW_CONTACT_DEFAULT_BILLING_GROUP flag from working properly for Contact Imports.

IN-7546

Service Desk

Fixed a bug (introduced in 2021.1.3) that prevented Charges from being stopped on the old Service after completing and finalizing a Service Desk Actions.

IN-7300

IN-7319

IN-7396

IN-7523


Release 2021.1.5 (11-15-2021)

Component

Description

Type

Incident(s)

Documentation

Archiving

Archiving Service Desk Items with more than 1000 child items will no longer fail.

IN-6259
If BILL_ZERO_COST is set to false, $0.00 nonrecurring charges will be ignored when determining archive eligibility.  (i.e. When BILL_ZERO_COST is set to false Service Desk Items with only $0.00 nonrecurring charges can be archived, even if the Service Desk Item has not been Billed)

IN-6970

Billing

Corrected the 2021.1 upgrade process that incorrectly added Call and Usage to Non-Recurring Charges total on Bill grid.

IN-7263
The View Bill now displays only the lowest level of the Department Hierarchy


View Bill

Cable

Improved the performance of several Ports/Pins/Lens queries. 



Filtering the port on the Equipment Ports/Pins/Lens grid no longer throws an error. 



Catalogs

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

IN-7323
GLA components can now be up to 100 characters long, up from 50.



CustomerCenter

Custom Validation error messages now work correctly in CustomerCenter.

IN-7254
Fixed a bug that prevented the Service ID from showing when viewing a Service Request / Order in CustomerCenter. Also changes to the Request Tracking grid to be more descriptive of Orders.

IN-7144

Imports & Exports

Fixed bug where some Service Orders Actions created by Import were not filling in Existing Service's Location, Rating Group, and Reference.



The scheduled export email field now supports up to 500 characters, up from 200.

IN-7249

IN-7102

IN-6929


Service Desk

Corrected an issue preventing the creation of Remove Equipment Actions on Service Order Actions, Incidents, etc. 

IN-7296

IN-7257


The Append to Service Remarks checkbox no longer unsets itself.

IN-2825

IN-2916

IN-6968 (IN201936573)


Switch Interfaces

Requests made to Inactive Cisco Service hosts no longer cause a fatal error. 

IN-7129

Call Forwarding options now save properly on a Directory Number (Cisco).
Picker cells on a User-Defined Table, or Cisco forms, no longer display "null" when cleared.

IN-6991

Release 2021.1.4 (10-07-2021)

Component

Description

Type

Incident(s)

Documentation

Billing

Added Waive to Invoice grid.

  • Waving an Invoice will cancel/void all the changes on that Invoice.
  • Only Billed Invoices can be Waived.

Note: This is only available when the Accounts Receivable License is turned on.


IN-6324
The View Bill permissions now properly hide the turned-off sections of the Bill.



Credit (negative) Invoices now receive a "Credited to Account" status. The Credit Amount is applied to the Account Totals and any outstanding amount due.

IN-6324
Billing Exports now execute all scheduled Bill Completion Events instead of the last one.

IN-7102

General

Office 365 Integration

  • Requests coming from Outlook 365 will no longer randomly create requests with dates far into the future.
  • Grid reports can once again be sent from the application when using Outlook 365 for outgoing mail.

IN-7143

IN-7083

Invoices

GLA Account Management



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-6629Service 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-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

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