Key

2019.5

Notable Changes

Optimized the Charges Grid and Ports/Pins/Lens Picker.
Added an Open Source Button to the Charges Grid.
Added Ports/Pins/Lens Transfer Import
Added an Add From SDC button to the Service Desk Workflow tab
Added a unique key on Ports/Pins/Lens. The Port/Pin/Len Side is now required. This prevents users from creating duplicate Ports/Pins/Lens records and prevents the system from creating duplicate Ports/Pins/Lens records from an Import.
- Note: When the test system is upgraded to 2019.5 or later, PCR will add an Adhoc grid (to test and production) for any customers who currently use cable. Customers are responsible for cleaning up the data on production before they can upgrade to 2019.5 (or later) in production. We will NOT upgrade any customers to 2019.5 or later if the Adhoc grid still contains duplicate Ports/Pins/Lens records. If you have any issues cleaning up the data, please send an email to help@pcr.com for assistance.

Please review the Database Changes in 2019.5 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.5.2 (11-13-2019)

Component	Description	Incident(s)
Billing	Using GLA Splits no longer cause the Bill Progress Percentages to go above 100%.
	The Invoiced Amount on the Invoice Printout, Invoices Grid, and the GLA Account Totals/Current Balance now includes the Taxed Amount.	IN-2921 (IN201936601)
	Calls and Usage attached to Services with Split Expense GLAs Percentages now bill on each split. (Previously only the first split was billed).
	The Override Amount on Service Desk Equipment Charges is now carried over to the Equipment Charges after the Service Desk Item is Finalized.	IN-2922 (IN201936602)
CustomerCenter	Users can now set the Account Number/Default GLA on Stand-Alone Equipment. However, the Owner and GLA MUST be the same for all pieces of Stand-Alone Equipment. (i.e. You set the Owner and GLA on once piece of Stand-Alone Equipment and it applies to all of the Stand-Alone Equipment for that Request).	(IN201936659)
CustomerCenter	Creating a New Contact with CustomerCenter no longer throws an error.

Release 2019.5.1 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Charges stopped exactly on the Start Date of a Bill now Prorate correctly.

IN201936583

Test Bills and Bill Estimates no longer flag charges as Billing Complete.

General

Corrected an issue that:

Prevented the Bulk Update from updating Services (for customers who do not user Service Pools)
Prevented Service Actions from saving (for customers who do not have any Auth Code Types defined).

Release 2019.5 (10-07-2019)

Component	Description	Incident(s)	Documentation
API	Added token-based authentication to Service Host REST API for Team Dynamix.		Service Host Rest APIs
Billing	Added the following columns to the Admin → Billing → View/Report → Charges Grid: Prorate Flag (Only if the configuration BILL_MRC_CHANGE_FORCE_PRORATE is turned off) MRC Start Date (only populated for MRCs) MRC Stop Date (only populated for MRCs) NRC Transaction Date (only populated for NRCs) Annual/Semi-Annual/Quarterly Recurring Date (only populated for Alternate Recurring Charges) Annual/Semi-Annual/Quarterly Stop Date (only populated for Alternate Recurring Charges)		Charges Report
	Added an Open Source button to the Admin → Billing → View/Report → Charges Grid. The new button opens the Source record: Service, GLA, Equipment, or Service Desk.
	Optimized the Admin → Billing → View/Report → Charges Grid to improve grid load times significantly. By default, the grid now autoloads (rather than waiting for you to add a filter or refresh the grid).
	The Bill grid's Check Progress form no longer shows more than 100% in the Processing Bill Calls section (when multiple Expense Object Code Overrides are defined). Note: The Process Bill Calls section may still show more than 100% in if GLA splits are used.
	GLA Changes now properly update Alternate Recurring Charges (Annual Recurring, Semi-Annual Recurring, and Quarterly Recurring).		Known Issue Forum Post GLA Charges Import Service Charges Import Charge Catalog Imports Services API (Charges) GLA API (Charges) Equipment API (Charges) Charge Catalogs Inventory Tabs - Charges
Cable	Optimized the Ports/Pins/Lens picker for Equipment records that have more than 10,000 ports.
Cable	Added a unique key on Ports/Pins/Lens. The Ports/Pins/Lens Side is now required. Note: When the test system is upgraded to 2019.5 or later, PCR will add an Adhoc grid (to test and production) for any customers who currently use cable. Customers are responsible for cleaning up the data in production before they can upgrade production to 2019.5 (or later). If you would like to review the Adhoc Queries or add them before scheduling your upgrade, please download the SQL file from the release notes. If you have any issues cleaning up the data, please send an email to help@pcr.com for assistance.		Duplicate PPL Adhoc Query Downloads MySQL Oracle
Communications	Added multiple enhancements to the Avaya Module: Avaya Phone Templates: Form and Grid Adds "System Use Templates" that can be copied to make customized templates Added support for 9608SIP set types		Avaya Documentation
CustomerCenter	Approvers are now able to see the Cancel Request Button on the View Request Page for their Requests.	IN201935025
CustomerCenter	The original Owner of a Service or Equipment is now preserved for a Change Owner Request.	IN201936238 IN201834895
General	Fixed an issue where some tool-tips, filters, and hover images would appear behind a PCR-360 form.	IN201731534
General	Users can now update existing List Values.	IN201936427
Imports & Exports	Added a Ports/Pins/Lens Transfer Import that will transfer ports from one Equipment record to another.		Ports/Pins/Lens/ Transfer Import
Services	The Associated Service Picker on Equipment now restricts the Services by the Location and Service Locations (for Multiple Location Services). The Service Location(s) must match (or be a descendant of) the Location specified on the Equipment record.
Service Desk	Added an Add From SDC button to the Service Desk Workflow tab. This button allows adding SDC workflow to any existing Service Desk item that is not closed (i.e., Void, Denied, Finalized, Billed, etc.).		Additional SDC Workflow: Requirements Workflow SDC
	Add Actions created by the PCR-360 Wizard now set the Service Options (Billable, Report 911), and the Default Service Host using the Service Catalog's defaults.	IN201833229 IN201834684
	Fixed alignment issues with the Service Order Description on the Service Desk Printout.	IN201936068
	The Workgroup and Worker fields are once again editable on the Service Desk Labor Form.	IN201935841 IN201935576	Service Desk Labor
	Equipment SDCs no longer match SDCs with the 'Any' SDC type selected. Equipment SDCs must exactly match the Equipment Catalog on the Service Desk Item.

Database Changes in 2019.5

Table Name	Change	Table Changes
Table Name	Change	Table Changes
`PORTS_PINS_LENS`	Updated	CHANGE `PORT_SIDE_LISTS_RECID` `PORT_SIDE_LISTS_RECID` `int` `NOT` `NULL;` `Added a Unique index on` `(EQUIPMENT_RECID, PORT, PORT_SIDE_LISTS_RECID)`
SERVICE_HOSTS	Updated	ADD COLUMN LOGIN_ADDRESS VARCHAR(100) NULL AFTER ADD COLUMN LOGIN_HEADERS LONGTEXT NULL ADD COLUMN TOKEN LONGTEXT NULL ADD COLUMN RATE_LIMIT INT NOT NULL DEFAULT 0 ADD COLUMN RATE_LIMIT_REMAINING INT NOT NULL DEFAULT 0 ADD COLUMN RATE_LIMIT_RESET DATETIME NULL AFTER

2019.4

Notable Changes

We added Historical Cable Data to Service Desk. This corrects several issues with Cable Statuses on Actions. In particular, completed Actions will now reflect the Cable status at the time of completion, not the current cable status.
We have converted Service Order Only Actions to Task Actions. This change gives customers a more generic way of tracking work on a Service Order; since not all work relates directly to a Service. This change replaces the Service Catalog type of "Service Order Only" with "Task" and adds a "Task" option to the Action selector on Service Desk Actions. Services cannot be created using "Task" type Service Catalogs.
We added several new Cisco Features and fixed several bugs.
We removed calDav support from the PCR-360 Calendar.
Users with an Administrator role can now add the Row ID column to any grid or picker.
When an Action is saved with a Service selected, Service Remarks are now automatically copied into the Activity/Remarks tab of the Action.
Added the ability to run Imports in Batches.

Please review the Database Changes in 2019.4 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.4.3 (11-13-2019)

Component	Description	Incident(s)
Billing	Using GLA Splits no longer cause the Bill Progress Percentages to go above 100%.
	The Invoiced Amount on the Invoice Printout, Invoices Grid, and the GLA Account Totals/Current Balance now includes the Taxed Amount.	IN-2921 (IN201936601)
	Calls and Usage attached to Services with Split Expense GLAs Percentages now bill on each split. (Previously only the first split was billed).
	The Override Amount on Service Desk Equipment Charges is now carried over to the Equipment Charges after the Service Desk Item is Finalized.	IN-2922 (IN201936602)

Release 2019.4.2 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Charges stopped exactly on the Start Date of a Bill now Prorate correctly.

IN201936583

Test Bills and Bill Estimates no longer flag charges as Billing Complete.

General

Corrected an issue that:

Prevented the Bulk Update from updating Services (for customers who do not user Service Pools)
Prevented Service Actions from saving (for customers who do not have any Auth Code Types defined).

Release 2019.4.1 (09-13-2019)

Component

Description

Type

Incident(s)

Documentation

General

Addresses slowness issues with the 2019.3 upgrade.

Note: This fix reverts a bugfix introduced in 2019.1. "Fixed an issue where saving a Perspective sometimes unchecked the Auto Load Data checkbox." This bug will be addressed in a future release.

IN201936364

IN201936437

Release 2019.4 (08-26-2019)

Component	Description	Incident(s)	Documentation
API	Added a Service Desk Task Action endpoint.		Service Desk API Calls
Billing	Added a GLA format column to the Invoices grid.
Billing	The GLA Replace process now adds a remark to the GLA record and the Replacement GLA record containing the Original GLA, the New GLA, the effective date, and the user that updated the record.	IN201834069 IN201832689	GLA Catalogs GLA Tabs
Cable	Added buttons to the Service Desk Cable form that open PPL Range forms for Origination and Destination Equipment.		Service Desk Cabling Ports/Pins/Lens Form
	Replacing a Pair on the Path Leg form now replaces the From and To Ports.
	Replacing a Pair or Port on the Paths Legs form now changes the old pair to Spare (if it isn't on any other paths).
Communications	New Cisco features: Added Gateway Device Support to Service Desk Actions. Added End User support to Service Desk Actions. Added Device Templates to support Analog Devices.		Cisco Communication Module Service Desk Communication Service Hosts
Communications	Fixed number of form issues and bugs in the Cisco Module.
CustomerCenter	Service Order Only Actions are now Task Actions.		See Task Actions changes for more detail
	User-Defined Date fields in CustomerCenter no longer erroneously fail validation.
	We have fixed several display issues in CustomerCenter: Pickers now render correctly. The "Add Row" menu for User-Defined Tables in CustomerCenter now displays over the table.
	Removed the 'Catalog Search' Box from Change and Remove Request forms.
	Services and Equipment owned by a user will now show up in the "My Department Services and Equipment" grid on the home page for coordinators.
	Ordering stand-alone Equipment no longer adds multiple Default GLAs to the Request.
	Service and Equipment UDFs are now displayed on Report A Problem.
	Equipment UDFs can now be shown in CustomerCenter.	IN201935752
	Deleting Ready To Submit requests no longer throws an error.	IN201936307 IN201936258 IN201935476
Escalations & Notifications	Fixed layout issues with the Escalation Sequence form.
General	Users with an Administrator role can now add the Row ID column to any grid or picker.		How to get RECID values Permissions
	Added a Master Lock mechanism to reduce the database impact from demanding Events. Only one Event in the Master Lock group may run at any given time.		Events
	Removed calDav support from the PCR-360 Calendar.	IN201935781	Calendar
	User-Defined Fields can be deleted from the system entirely; the system will no longer throw an error if values are assigned to the UDFs.	IN201833382
	Location History Report now includes changes to Location Servicing Equipment.	IN201726075
Inventory	Added an "Add Existing" Button to the Equipment Children tab.		Inventory - Equipment Children
Imports & Exports	Added a Service Desk Task Action Import.		Service Desk Imports
	Imports can now run in batches. A single import definition can run the same file through multiple import types. (e.g., a CSV file containing Service and Location information could run through a Location import first to create Locations, then a Service Import to create new Services with the Locations in the file).		Import File Formats
	The Available Charges Bulk Update no longer fails when triggered from an Import (i.e., the Charge Catalog Import). This change drops the USERS_RECID (Foreign Key) column and replaces it with the USERID column (string/text).
Services	Improved the Service ID validation against the Service Catalog's Format for the API, Imports, Services, Service Desk Actions, etc.
Service Desk	Added Task Actions to Service Orders. This change: Replaces the Service Catalog type of "Service Order Only" with "Task." Adds a "Task" option to the Action selector on Service Desk Actions. Note: This functionality replaces Service Order Only Actions. Services cannot be created using "Task" type Service Catalogs.		Task Action Requirements Task Action Usage Service Catalog Changes Service Desk Actions
	Added Historical Cable Data to Service Desk. Once a Service Desk Item is Completed or Voided, Cabling data is captured and stored permanently. Completed Service Desk Items do not reflect changes to live Cable Data.	IN201935605 IN201834358	Service Desk Cabling Service Desk Completed Cabling
	Added two new reporting buttons to the Completed Cabling tab: View Historical Path displays the Path before completing the Order. View Current Path displays the current path on the Service.		Service Desk Completed Cabling
	When an Action is saved with a Service selected, Service Remarks are now automatically copied into the Activity/Remarks tab of the Action. Note: This functionality won on Voting List #3		Service Desk Activity/Remarks
	Increased the size of the Data ID field on Service Desk Actions.	IN201935599	Service Desk Actions Service Desk Cabling Service Desk Communication
	Removed the Catalog value from the Service Picker display to improve performance. This will improve the performance of grids showing the Service ID and Catalog, as well as the performance of the Service Picker.		Service Desk Actions Service Desk Cabling Service Desk Communication
	Task actions (formally Service Order Only Actions) with charges can no longer be completed without an Owner.	IN201833454
	Upgrade/Downgrade Actions no longer fail validation if the Service Catalog is not selected when creating the Action. Previously, if you did not select the Service Catalog and saved the Action, a field validation error was displayed, and the form prevented correcting the data.	IN201834380
	For Upgrade/Downgrade Actions, selecting a Service Catalog no longer overwrites the Services Options on the action. The Service Options on the Action come from the options already set on the Service.		Upgrade/Downgrade Actions Create an Upgrade/Downgrade Action
	Upgrade/Downgrade Actions now update the Service Catalog on the Service upon completion of the Action. This stopped working in 2018.1.
	The entire Service Desk Cabling form is now "Read Only" for Out Cable Actions. The Add, Clear, and Swap buttons are no longer accessible on Out Cable Actions.
	Swap Actions now complete without an error when one Service has a Cable Path, and the other does not.
	Pairs/Ports are now Assigned after completing a Swap Action.
	Deleting the Cable Path Legs on a Swap action now sets the Pairs/Ports back to Assigned, rather than Pending Connect/Pending Disconnect.
	The Service Desk View Path report now displays the Service/Circuit ID and Reference for Pending Actions.
	The Service Desk 360 Wizard now populates the SDC column for Service Desk Actions.	IN201935119
	Adding new Cable Data to Incidents no longer throws an error.
	Alternate Recurring Charges with an action of "Stop" on Service Desk now properly stop when the Order/Action is Finalized.	IN201935363
	Completing a Service Order with no Actions on it no longer throws an error.

Database Changes in 2019.4

Table Name	Change	Table Changes
BULK_UPDATE_HISTORY	Updated	DROP COLUMN USERS_RECID ADD COLUMN USERID VARCHAR(20) NOT NULL
DEVICE_DEFAULTS	New	Added the Table to PCR-360
IMPORT_FORMATS	Updated	DROP COLUMN DUPLICATES DROP COLUMN IMPORT_RECORD_TYPES_RECID
IMPORT_RECORD_FORMATS	Updated	ADD IMPORT_RECORD_TYPES_RECID INT NOT NULL ADD FORMAT_SEQUENCE INT DEFAULT 10 NOT NULL ADD DUPLICATES VARCHAR(1) DEFAULT NULL
SERVICE_DESK_CABLING_OUT	Removed	Dropped the Table from PCR-360
SERVICE_DESK_CABLING_PIT	New	Added the Table to PCR-360

2019.3

Notable Changes

The most significant change to PCR-360 we have made in this release affects all grids and pickers in the application. By default, the grid count is now disabled on all grids and pickers. We have made this change in order to drastically improve performance by reducing the grid load time across the application. In our testing, we found some grids load, on average, twice as fast, or more. We believe this change will improve the overall usability of the application and allow our users to complete their work more efficiently. Please review the documentation (linked in the release notes below) to see how the grid functionality has changed with this release.

Release 2019.3.9 (11-13-2019)

Component	Description	Incident(s)
Billing	Using GLA Splits no longer cause the Bill Progress Percentages to go above 100%.
	The Invoiced Amount on the Invoice Printout, Invoices Grid, and the GLA Account Totals/Current Balance now includes the Taxed Amount.	IN-2921 (IN201936601)
	Calls and Usage attached to Services with Split Expense GLAs Percentages now bill on each split. (Previously only the first split was billed).
	The Override Amount on Service Desk Equipment Charges is now carried over to the Equipment Charges after the Service Desk Item is Finalized.	IN-2922 (IN201936602)

Release 2019.3.8 (10-23-2019)

Component	Description	Type	Incident(s)	Documentation
Billing	Charges stopped exactly on the Start Date of a Bill now Prorate correctly.		IN201936583
Billing	Test Bills and Bill Estimates no longer flag charges as Billing Complete.

Release 2019.3.7 (09-13-2019)

Component

Description

Type

Incident(s)

Documentation

General

Addresses slowness issues with the 2019.3 upgrade.

Note: This fix reverts a bugfix introduced in 2019.1. "Fixed an issue where saving a Perspective sometimes unchecked the Auto Load Data checkbox." This bug will be addressed in a future release.

IN201936364

IN201936437

Release 2019.3.6 (08-29-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

The Viewbill Service Summary no longer lists Services twice under each Charge Account.

Cable

Significantly improved the performance of Ports/Pins/Lens Pickers when the Equipment has over 1000 connected Ports/Pins/Lens.

Release 2019.3.5 (08-20-2019)

Component

Description

Type

Incident(s)

Documentation

CustomerCenter

Fixed an error caused when adding Stand-Alone Equipment to the Cart after a Package containing Stand-Along Equipment was added to the Cart.

IN201936263

Call Processing

Call Rating no longer fails for 7-digit dialed numbers when the default NPA is blank.

Release 2019.3.4 (08-05-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

The Bill Archive process no longer fails.

Release 2019.3.3 (07-26-2019)

Component

Description

Type

Incident(s)

Documentation

API

The Services API Endpoint now adds Service Charges with the default Catalog Amount if no Amount is specified in the API call.

CustomerCenter

The Pending Requests page no longer errors under certain (edge case) conditions.

Calls

Restored the Call Type Column to the Call Details grid.

Release 2019.3.2 (07-08-2019)

Component

Description

Type

Incident(s)

Documentation

General

The Charge Total fields on forms stopped displaying data after the grid count changes; these fields now display data.

Affected forms: GLA, Services, Service Desk (Charges tab and Labor tab), and Service Desk Estimate.

IN201935883

Imports

The Path Full import expects Location Types to be provided with multiple components (just like the Location). The Import no longer fails if multiple levels are provided for the Location Type.

Time Entry

The "Hours Total" on the Time Entry grid stopped displaying data after the grid count changes; this field now displays data.

Release 2019.3.1 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

When processing Monthly Recurring Charges that were Stopped on the Billed Through Date the billing process was incorrectly generating Bill Details transactions. The process should only flag the charge as Billing Complete and not generate any Bill Details transactions.

IN201935378

Service Desk

The Workflow tab on Actions stopped displaying data after the grid count changes; this tab now displays data.

Release 2019.3 (05-28-19)

Component	Description	Type	Incident(s)	Documentation
Component	Description	Type	Incident(s)	Documentation
API	Added a Service Desk Labor endpoint to the API.			Service Desk Labor API
Billing	The CSV option for the "Full Detail View" of the Bill now returns a CSV file containing the full Bill Details.		IN201731626 IN201731500	View Bill
	Long Service Desk Descriptions without spaces no longer run off the side of the Report Printout.		IN201731654
	Bill Approval no longer throws an error when the Invoices configuration option is disabled.
Calls	Added "Cost Before Markup" to the Call Details and Usage Details grids.
CustomerCenter	Removing a piece of stand-alone Equipment from the My Equipment Grid in CustomerCenter no longer triggers a 500 Error.		IN201935413
CustomerCenter	The Request Tracking Page now displays the "Move To Location", "Move Address", and "Move Building ID" when a "Move To Location" is entered on the 'Action'.
General	Grid counts are now disabled by default. This greatly improves overall application performance and reduces load times on grids.			The Grid Pickers Count Report Getting Started
	Changed Building Number to Building ID on the Locations grid and the Locations' Address tab.			Locations Tabs Locations Imports 360 View
	Subgrid page navigation now works correctly. Some subgrids were not displaying information; this has been fixed.			The Grid
	Dashboard drill-down now displays the correct number of results.		IN201832282
	Navigating Tab Grids with the Next and Previous buttons no longer generates an error when trying to navigate past the first or last page.
Inventory	Inventory counts now exclude Consumed Equipment Records. This includes the Equipment Availability Indicator.
Inventory	The Associated Service ID Picker on Equipment now properly limits the Services by Location for Single-Location Services.		IN201834873
Imports & Exports	Improved the performance of the GLA Charge Import.		IN201935271
	The Equipment Import can now update the Location of Existing Equipment.		IN201832773	Equipment Import
	If the Service Import triggers certain errors, it no longer rolls-back the import lines that were processed before the error occurred. All Imports now commit all changes after each line is processes; if an import aborts for some reason, the lines in the file before the error will stay processed, instead of being rolled back.		IN201833708	Imports
	Resolved a number of issues with the Import definition header functionality: Adding a new Header Record no longer erroneously adds additional mappings. Adding a new Header Record now appears in the grid after saving the record. Adding mappings now correctly restricts the user from entering an Index and a Start/End position for the mapping. Import files can be Delimited or Fixed-Width, not both.
	The Equipment Import no longer throws an error when the import line contains unit values.		IN201935592
Reporting	When CSV is the default option on the Generate Report Form, the Send Email checkbox is now enabled.
Services	Added the fields "Company ID", "Reference" and "Rating Group" to the Service Bulk Update.		IN201834935 IN201834931	Service Bulk Update
Service Desk	Added a "Location Column" to the Service Desk Workflow Report. Added a "Move To Location" Column to the Service Desk Workflow Report.
	Optimized the Service Desk Equipment Report so it no longer hangs when loading the grid.
	The Service Desk Labor Report now correctly opens the Service Desk Form instead of the Service Desk Labor Form.

Database Changes in 2019.3

No Database changes were made for 2019.3.

2019.2

Note: All versions after 2018.1 require an upgrade to PHP 7.2, hosted customers and customers who have 2018.1 already have the PHP upgrade. Most updates to test systems will need to occur during non-business hours. Please send any scheduling requests to help@pcr.com.

This release contains some table changes that could cause issues with Adhocs, API calls, or other custom processes. Please review the Database Changes in 2019.2 to review the changes and make the necessary changes to your customizations.

Licensed Customers will need to install PHP 7.2 before we can upgrade test to 2019.2, the instructions can be found here: PHP 7.2 Upgrade. Please consult PCR before upgrading your system.

Release 2019.2.4 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

When processing Monthly Recurring Charges that were Stopped on the Billed Through Date the billing process was incorrectly generating Bill Details transactions. The process should only flag the charge as Billing Complete and not generate any Bill Details transactions.

IN201935378

Release 2019.2.3 (05-23-2019)

Component

Description

Type

Incident(s)

Documentation

API

To address a rapidly growing API Request table, full API responses will not be saved for successful SQL POST calls or GET API Calls; only error responses will be saved.

IN201935671

Release 2019.2.2 (05-10-2019)

Component

Description

Type

Incident(s)

Documentation

API

The permissions set on each API Endpoint are now obeyed when called from a Custom Endpoint.

Custom API

Escalations & Notifications

Added a process to convert the Escalation Sequences to the new format used in 2019.1.

IN201935672

Release 2019.2.1 (04-25-2019)

Component

Description

Type

Incident(s)

Documentation

General

Corrected a missing parameter from the Initial 2019.2 release.

Release 2019.2 (04-19-19)

Component	Description	Incident(s)	Documentation
API	Reworked the API Error Responses to be consistent for all endpoints.		API
Cable	Fixed an issue where using the general search on the Ports/Pins/Lens grid (on the Equipment form) would throw an error.	IN201834888 IN201935103
Communications	Added COR functionality to the Avaya module.		Communications Module Avaya COR
Communications	Added Avaya Authorization Code functionality.		Avaya Authorization Codes
CustomerCenter	Added Package Types.		Service Desk Packages Packages
	On the Order Details Form: Changed the "Apply All" label to "Apply Order Details". Changed the "Yes" option to "Overwrite All Order Details".		Order Details
	The Location Picker was displayed on every Catalog page; now it is only displayed on the page when items on that page have Location Restrictions.		Add a Service Add Equipment
	Fixed an issue where long Package Descriptions (with line breaks) were causing layout inconsistencies on the Packages page.		Service Desk Packages Packages
	The Additional Charges section now displays the text "none" when no charges exist (instead of a blank line).
Events & Notifications	Fixed an issue causing Events to fail during the fall Daylight Savings Time transition.
General	The following functions, keywords and classes are now allowed in Custom Logic: new DateTime DateInterval add sub diff format setTimestamp setTime setDate		Custom Logic Syntax How To: Scheduling Regular Maintenance
	Improvements to Custom Validation Messages The Customer Name is displayed on the first line of message. This includes messages generated from a form, the API or Imports. The Error Dialog title was changed to "Error (Custom Validation)" to identify Custom Error messages. The Warning Dialog title was changed to "Warning (Custom Validation)" to identify Custom Warning messages.		Custom Validation
	Fixed an issue with Custom Validation where improperly formatted code in the validation message would trigger an "Oops Error" instead of displaying the appropriate error message.
	Fixed an issue where some pickers would not load the Default Perspective.	IN201833946 IN201834044
	Fixed a variety of display issues related to HTML in Remarks data. HTML entered into the system via the API, Imports or the Remarks form is now filtered to remove any potentially problematic or malformed HTML.	IN201832912 IN201732074 IN201832314	Allowed HTML Tags
Imports & Exports	Fixed an issue causing Exports to fail when manually triggered from the Exports Files grid.
	Removed several unused columns from Import Definitions.		Database Changes
	Fixed an issue where Authcode Calls were not always rated using the correct call type for local or long-distance calls.
Reporting	Fixed an issue preventing the Crystal Report Batch process from sending the completion message. Fixed an issue preventing the Crystal Report Batch process from deleting Event the Batch is linked to.	IN201834202
Service Desk	Fixed an issue where Service Desk Remove Actions removed the Location on the Service after completion of the Action.	IN201833926
	Fixed an issue where returning Equipment with a credit charge was applying a double credit after the return (rather than a Debit to cancel out the original credit).	IN201833399
	Fixed an issue where the Service Desk Auto-Assign was not filtering by the Location selected on the Action.

Database Changes in 2019.2

Table Name	Change	Table Changes
Table Name	Change	Table Changes
CONTACTS_REMARKS	update	ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
DEPT_HIERARCHY_REMARKS	update	ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
SERVICES_REMARKS	update	ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
EQUIPMENT_REMARKS	update	ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
SERVICE_DESK_ACTIVITY	update	ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS
PURCHASE_ORDER_ACTIVITY	update	ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS
RETURN_ORDER_ACTIVITY	update	ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS
PAYMENTS_REMARKS	update	ADD COLUMN HTML_REMARKS NO NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
PACKAGES	update	ADD COLUMN PACKAGE_TYPE_LISTS_RECID INTEGER NOT NULL
IMPORT_RECORD_TYPES_COLS	update	Removed BILLED_DATE, CONSUMED, SDA_NUMBER and AVAILABLE_SERVICE_HOST as column options.
LOCATIONS_REMARKS	update	ADD COLUMN HTML_REMARKS NO NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS
GLA_ACTIVITY	update	ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS
AVAYA_AARDIGITCONVERSION	update	Renamed AVAYA_AARDIGITCONVERSION TO AVAYA_AARDIGITCONVERSIONS
AVAYA_ABBREVIATEDDIALINGGROUP	update	Renamed AVAYA_ABBREVIATEDDIALINGGROUP TO AVAYA_ABBREVIATEDDIALINGGROUPS
AVAYA_AGENT	update	Renamed AVAYA_AGENT TO AVAYA_AGENTS
AVAYA_ANNOUNCEMENT	update	Renamed AVAYA_ANNOUNCEMENT TO AVAYA_ANNOUNCEMENTS
AVAYA_ARSDIGITCONVERSION	update	Renamed AVAYA_ARSDIGITCONVERSION TO AVAYA_ARSDIGITCONVERSIONS
AVAYA_AUDIOGROUP	update	Renamed AVAYA_AUDIOGROUP TO AVAYA_AUDIOGROUPS
AVAYA_AUTHORIZATIONCODE	update	Renamed AVAYA_AUTHORIZATIONCODE TO AVAYA_AUTHORIZATIONCODES
AVAYA_CABINET	update	Renamed AVAYA_CABINET TO AVAYA_CABINETS
AVAYA_COR	update	Renamed AVAYA_COR TO AVAYA_CORS
AVAYA_COVERAGEPATH	update	Renamed AVAYA_COVERAGEPATH TO AVAYA_COVERAGEPATHS
AVAYA_CTILINK	update	Renamed AVAYA_CTILINK TO AVAYA_CTILINKS
AVAYA_EXTENSIONTYPE	update	Renamed AVAYA_EXTENSIONTYPE TO AVAYA_EXTENSIONTYPES
AVAYA_HUNTGROUP	update	Renamed AVAYA_HUNTGROUP TO AVAYA_HUNTGROUPS
AVAYA_IPSERVERINTERFACE	update	Renamed AVAYA_IPSERVERINTERFACE TO AVAYA_IPSERVERINTERFACES
AVAYA_MEDIAGATEWAY	update	Renamed AVAYA_MEDIAGATEWAY TO AVAYA_MEDIAGATEWAYS
AVAYA_PICKUPGROUP	update	Renamed AVAYA_PICKUPGROUP TO AVAYA_PICKUPGROUPS
AVAYA_PORT	update	Renamed AVAYA_PORT TO AVAYA_PORTS
AVAYA_REGISTEREDIPSTATION	update	Renamed AVAYA_REGISTEREDIPSTATION TO AVAYA_REGISTEREDIPSTATIONS
AVAYA_ROUTEPATTERN	update	Renamed AVAYA_ROUTEPATTERN TO AVAYA_ROUTEPATTERNS
AVAYA_SIGNALINGGROUP	update	Renamed AVAYA_SIGNALINGGROUP TO AVAYA_SIGNALINGGROUPS
AVAYA_STATION	update	Renamed AVAYA_STATION TO AVAYA_STATIONS
AVAYA_TRUNKGROUP	update	Renamed AVAYA_TRUNKGROUP TO AVAYA_TRUNKGROUPS
AVAYA_UNIFORMDIALPLAN	update	Renamed AVAYA_UNIFORMDIALPLAN TO AVAYA_UNIFORMDIALPLANS
AVAYA_VDN	update	Renamed AVAYA_VDN TO AVAYA_VDNS
AVAYA_VECTOR	update	Renamed AVAYA_VECTOR TO AVAYA_VECTORS
AVAYA_WITNESSSTATION	update	Renamed AVAYA_WITNESSSTATION TO AVAYA_WITNESSSTATIONS

2019.1

Note: All versions after 2018.1 require an upgrade to PHP 7.2, hosted customers and customers who have 2018.1 already have the php upgrade. Most updates to test systems will need to occur during non-business hours. Please send any scheduling requests to help@pcr.com.

This release contains some table changes that could cause issues with Adhocs, API calls, Grid Perspectives, or other custom processes. Please review the Database Changes in 2019.1 to review the changes and make the necessary changes to your customizations.

Licensed Customers will need to install PHP 7.2 before we can upgrade test to 2019.1, the instructions can be found here: PHP 7.2 Upgrade. Please consult PCR before upgrading your system.

Release 2019.1.4 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

When processing Monthly Recurring Charges that were Stopped on the Billed Through Date the billing process was incorrectly generating Bill Details transactions. The process should only flag the charge as Billing Complete and not generate any Bill Details transactions.

IN201935378

Release 2019.1.3 (05-23-2019)

Component	Description	Type	Incident(s)	Documentation
API	To address a rapidly growing API Request table, full API responses will not be saved for successful SQL POST calls or GET API Calls; only error responses will be saved.		IN201935671

Release 2019.1.2 (05-10-2019)

Component	Description	Type	Incident(s)	Documentation
Escalations & Notifications	Added a process to convert the Escalation Sequences to the new format used in 2019.1.		IN201935672

Release 2019.1.1 (05-10-2019)

Component	Description	Type	Incident(s)	Documentation
API	The permissions set on each API Endpoint are now obeyed when called from a Custom Endpoint.			Custom API

Release 2019.1 (03-25-19)

Component	Description	Incident(s)	Documentation
API	Added the ability to use Authentication with API calls. Redesigned the API Permissions form. Added the ability to require Authentication. Added the ability to specify an Expiration Date for the API key.		API API Permissions Authorization Parameters
	Added the ability to Add and Update Contacts via the API.		Contact API Calls
	Added the ability to specify the Source field using the Service Desk API.		Service Desk API Calls
	Added an API Request Log to assist users with troubleshooting API calls. The log contains all Requests made to the PCR-360 API and the Response.		API Request Log
	Added the ability to associate Equipment with a Service Desk Item via the API.		Service Desk Equipment API Service Desk API
	Added the ability to add or update the Rating-Group via the Services API.		Services API
	Added the ability to specify an SDC with a Service Desk Action API call.		Service Desk Action API
	Added the ability to Stop the following types of Charges via the API: Service Charges Equipment Charges GLA Charges	IN201833443	Equipment Charges API Service Charges API GLA Charges API
	Added the Effective Flag to the following Charge APIs: Service Charge Equipment Charge GLA Charge		Equipment Charges API Service Charges API GLA Charges API
	Added the ability to create the following Action types via the API: Add Locations Actions Change Owner Actions Service ID Actions	Users Group	Service Desk Action API
	Modified the names and columns for various API tables.		Database Changes in 2019.1
	Now all POST Requests require content in the body of the request. URL String parameters are no longer supported for POST Requests.		API
	Added a check to the Services API POST to allow editing a Service with a Formatted Service ID. The API now checks for the Service, removing the requirement that Service RECID be passed via the API Request. Previously the API incorrectly created Duplicate Services.		Services API
	Corrected the API Service Charge Error message to properly reference the Service Charge rather than Equipment Charges.
	Corrected an issue with the Service Desk API not filling in all Auth Code Service Details. Added additional fields to Service Desk API - auth_code_type - classes_of_service - bandwidth		Service Desk API
	Updated the API to send proper response codes. API sends a 400 response code when the API key is missing or has invalid permissions. API requests now fail with a 503 response code when the application is in Maintenance Mode. More codes are specified in the documentation.		API Response Codes
	Fixed an issue where the GLA API was not properly enforcing required GLA Components.		GLA API
	Fixed an issue where the API did not populate Service Location on Remove Action if service is Multi-Location and only has one Location.	IN201834748
	The Service Desk API Change and Remove Actions now allow a Location for a Multiple-Location Service only if that Location is already associated to that Service. The API now returns appropriate error messages for change actions ("The 'location' provided is not associated with the Service." and "This Service has multiple Locations and requires the 'location' parameter.")	IN201834748	Service Desk Action API
	Fixed an issue where the Services API allowed duplicate GLA types of 100%.	IN201935127
Billing & Charges	The Bill process will be prevented from running if the Bill range overlaps an existing bill.		Bills
Cable	Fixed an issue where the From Equipment Location disappeared on the Cable Maintenance Grid when a pair strand was saved.	IN201935022
Calls	Fixed an issue where Call Rating would sometimes use the wrong Service Host value for Rating.	IN201832461
CustomerCenter	Fixed an issue where adding Stand-Alone Equipment to the cart would erroneously cause the system to report that Order Details were missing and prevent the cart from submitting.
CustomerCenter	Fixed an issue with the CustomerCenter Accounts Receivable Details widget where it only displayed Invoices for up to 8 accounts.
Escalations & Notifications	Added the following verbs to Escalations Sequences: POST (Create) PATCH (Change) PUT (Replace) DELETE		Escalations / Notifications
Escalations & Notifications	Changes to the Escalations Sequences Form: Updated the Escalations Sequences Form to allow only JSON for Service Host Rest Escalations. Removed the Table from the Escalations Sequences Form and replaced it with a JSON input area that validates JSON for Service Host Rest Escalations. Added a Template Data Selector to the Escalations Sequences form for Service Host Rest Escalations.		Escalations / Notifications Escalations / Notifications Prior to 2019.1 (for comparison)
General	Added a Source column to the Authentication Log to indicate whether a user logged in using LDAP, Shibboleth, the API etc.
	Renamed some Authorization Constants: Renamed AUTH_SESSION_EXPIRATION_SECONDS to AUTH_SESSION_ACTIVITY_SECONDS Renamed AUTH_SESSION_REMEMBER_SECONDS to AUTH_SESSION_LIFETIME_SECONDS Replaced AUTH_ADAPTER = "DbTable" with AUTH_ADAPTER = "Native"		Authorization Parameters API Permissions API
	With this release, the Catalog tab and the Default Charges tab are always visible on the Equipment Catalog form. Default charges are only deleted when the category flag is checked and the record saved. Both Active and Inactive charges are deleted from the Catalog.		Equipment Catalog
	PHP 7.2 removed support for mcrypt. All usages of mcrypt in PCR-360 have now been replaced with Openssl.
	Fixed an issue where the Adhoc Query Builder form would fail to load for certain users.	IN201832648
	Fixed an issue where saving a Perspective sometimes unchecked the Auto Load Data checkbox.	IN201622826
Imports & Exports	Added an Equipment Catalog Import.		Equipment Catalog Import
	Added the ability to Unhide Locations using the Cable Full Path Import or the Location Import.		Locations Import Cable Full Paths Import Additional Information on Hidden Locations
	Improved the performance of the GLA Import when updating UDF values.
	The Pair/Strand, Ports/Pins/Lens, and Full Path Imports now account for duplicate Equipment IDs. If the same Equipment ID exists on multiple Equipment records in the application and is referenced in the import file, the import will insert an error line into Imported Records instead of failing the entire file.	IN201833921 IN201833126	Ports/Pins/Lens Import Pair/Strands Import Cable Path Full Import Imports
	Fixed an issue causing the GLA Import to fail when trying to populate a GLA Picker UDF on a GLA.
	Fixed an issue where certain types of errors would cause the Cable Full Path Import to crash.
Service Desk	Added MAC Address to the Service Desk Equipment Form and Service Desk Equipment Picker.	IN201622826
	Fixed an issue where the duplicate Path Leg error message just displayed 'Failed to Save Record'. The error message has more detail to allow the user to correct the data.	IN201834772
	Fixed an issue where the Service ID was not displayed on the Service Desk Cabling Diagram for an Add Action.
	Fixed an issue that caused odd formatting of graphical Cabling Data on print reports.	IN201834904
	Fixed an issue where the Location Picker on the Service Desk Wizard allowed the user to select Inactive Service Location records.

Database Changes in 2019.1

Table Name	Change	Table Changes
APIS	Removed
AUTHENTICATION_LOG	Updated	Added AUTH_SOURCE VARCHAR(20)
BILLS	Updated	Added BILL_END_DATE DATETIME NULL Changed BILL_END_DATE to not allow NULL
API_KEYS	New
API_KEYS_PERMISSIONS	New
API_KEYS_USERS	New
API_KEYS_USERS_TOKENS	New
API_PERMISSIONS	New
API_REQUESTS	New

Additional Information on Hidden Locations

Before this change, if you had a Location record that you hid using the Hide Button on the Location Grid, and you tried to get the Cable Full Path or Location Import to create that Location, you would get an error. The import would check to see if the Location already existed. The check was ignoring hidden locations, treating them like they didn't exist. So, the import tried to create a new Location record and caused an SQL Duplicate error.

After this change, these two imports will notice that the Location already exists in a hidden state. Now the import retrieves the hidden Location record and updates it, so it is no longer hidden. The process will blank out any old information on the Location (from before it was hidden), so it will seem like a fresh new record. The remaining import logic will treat it as a new record and fill in the values as normal. The Imported Records grid will display a line showing a new Location record added.

A consequence of this is that if there were any old Service Orders that referenced this Location, then any details of the Location that were displayed on the Service Order will now show the new Location values instead of the original values. This problem will eventually be solved by the Service Order archiving change.

2018.1

Release 2018.1.5 (06-20-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

When processing Monthly Recurring Charges that were Stopped on the Billed Through Date the billing process was incorrectly generating Bill Details transactions. The process should only flag the charge as Billing Complete and not generate any Bill Details transactions.

IN201935378

Release 2018.1.4 (03-21-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Fixed an issue with Prorated Charges started during the current billing cycle. The charges billed for the entire month rather than using the Charge start date to calculate the cost.

IN201935380

IN201935378

Fixed an issue with the View Bill not displaying Calls or Usage in the Service Summary.

Service Desk

Fixed an issue where UDFs were not populated on Actions created from the 360 Service Desk Wizards.

IN201834648

Release 2018.1.3 (03-01-2019)

Component

Description

Type

Incident(s)

Documentation

Dashboard

Optimized the "Call Metrics" widget and fixed an issue where the widget prevented the application from loading. Customers using the Call Metrics widget will no longer receive the "Service Temporarily Unavailable" message.

Release 2018.1.2

Component

Description

Type

Incident(s)

Documentation

General

Fixed an issue where the "Last Modified" user was not updating after saving an existing record.

IN201935192

Release 2018.1.1

Component	Description	Incident(s)
Billing	Fixed an issue where the View Bill Service Summary was blank for Other Equipment Charges and Other Service Desk Charges.	IN201834648
Billing	Fixed an issue with the Accounts Receivable pre-loader to prevent a rollback when inserting records.
Service Desk	Fixed Multiple issues with the Service Desk Wizard: The Wizard now creates Change/Remove Actions for Suspended Services. Fixed an issue where Move Actions created by the Service Desk Wizard were not adding the "Move-To" Location on Equipment loaded from the Service. Fixed an issue causing the Service Grid on the Location 360 Form to display duplicate entries. Fixed an issue preventing Location selection on the Service Desk Wizard for Multi-Location Services. Fixed an issue where the wrong SDC was selected for Upgrade/Downgrade Actions. The Location field is now read-only for Change/Remove Actions on Services with no Locations.	IN201834801 IN201834580 IN201834648
Service Desk	Added a "Move-To" Location field to the Service Desk Wizard for Change Actions.

Release 2018.1 (12-20-18)

Component	Description	Incident(s)	Documentation
Billing & Charges	Added Accounts Receivable (AR) Module: AR Specific GLAs for calculating 30, 60, 90 and 120+ day totals Account Management Report GLA Import for AR Accounts Printable Invoices Remittance coupon with AR enabled 30, 60, 90, 120+ totals with AR enabled Payments & Batch Payments Payment Receipts CustomerCenter "Account Details" widget on Homepage Note: This module is available at an additional cost. Please contact your account manager if you are interested in purchasing this module.		Accounts Receivable GLA Account Management Invoices Payments Payment Batches Account Details
	Added Invoice links to the ViewBill.		View Bill
	Added new functionality to Invoices: Converted all Invoice Numbers to INVOICES table records New Invoices form, grid and printout		Invoices
	Added Back Billing: Creating a new Monthly Recurring Charge with a Start Date set in the past will bill additional charge amounts to make up past billing. When Stopping existing Monthly Recurring Charges if the Stop Date is set previous to the Billed Through date for that Charge the Bill will then credit the appropriate amount based on what was previously billed. Catch-Up billing is controlled by the "Bill Backward" flag on Charge Catalog and Fiscal settings in Tenant.		Back Billing
	Modified the Email Coordinator Bill Process to use Coordinated Department GLA Permissions, Assigned Department GLA Permissions and Contact GLA Permissions.	IN201833950	Bills
	Added the Fiscal Start and Fiscal Start Next Year values to Tenant Management.		Tenant Management
	Cleanup and optimization of the Charge grids. Note: This will likely cause an issue with saved Perspectives on Charge Grids. You may need to rebuild those Perspectives after the upgrade.
	Fixed an issue where Service Orders and Actions were not consistently marked as Billed. e.g. Orders or Actions Finalized In October (with a September Finalization date) and a September 1 - September 30th Billing cycle would not get marked as Billed until the next billing cycle. Note: Only Incidents, Orders and Actions with Charges will be marked as Billed. Items without Charges will stay Finalized.	IN201731381
	Addressed a number of Bill Caching issues by linking the Bill Cache to the User's session. Fixed an issue where the Clear Bill Cache form would occasionally display the wrong Bill Date Range. Fixes an issue where the Date Ranges were incorrect for an emulated user. Fixes an issue where the GLA Permissions were incorrect for a given User, but correct when emulating that User. Fixes an issue where a Coordinator was unable to see Department Bills that they manage. Addresses other various display issues with Cached Bills. Note: The Bill Cache is now cleared when the User logs out or closes the browser.	IN201731938 IN201833982 IN201834542 IN201834557 IN201834592	Bills
	Added a Billing Complete flag to Charges. The totals on Services and GLAs are calculated based on the Billing Complete flag.	IN201832565
	Updating the Description or Prorate Flag on a Service Charge, Equipment Charge, or Gla Charge now carries over to the Charge Record (and properly displayed on the Bill). However, this will not trigger a Start or a Stop on the Charge.	IN201834411
	Fixed issues surrounding Charge Start Dates set in the future. (i.e. Charges set with a Start Date of next year) Future Start Dates will not Start or Stop when Effective Today is selected. Future Start Dates will not be recreated with today's date when Date to Last Bill is selected.	IN201731656	Service Tabs: Charges Equipment Tabs: Charges
	Stopping Annual, Semi-Annual and Quarterly Charges now triggers the bill to generate a credit. This is only for the current billing period and does not utilize Back Billing.
	Fixed a display issue with the Service Charges tab that was triggered after clicking Save New on the Service Form.
	Changing the Default Amount on a Charge Catalog and choosing the "Update Charges" option now properly uses Billing group pricing or GLA Component Pricing when applicable.	IN201833284
	Adding a new GLA Component Pricing or Billing Group Pricing entry now prompts the User to update the existing Charges. When the User elects to "Update Charges", the Charges are now updated based on the new GLA Component Pricing or Billing Group Pricing.	IN201833996	GLA Pricing Models
	Fixed an issue on the View Bill where the Billing Group dropdown displayed "All" even after a Billing Group was selected.
	Fixed an issue with the View Bill where the Owner showed a different value on the CSV and PDF reports. The Owner column on the PDF displayed the Contact but the CSV displayed the Department.	IN201834235
	Fixed an issue with the Bill Process Report where clicking the blue "i" icon would sometimes open the wrong record or display an error message.	IN201834361
	The GLA Replace Process now properly handles Charges that have never been billed. (Previously the Charge Dates were incorrect on the new GLA) Note: This fix is in addition to the Hotfix provided in patch 6 of 2.1.4: Charges not transferring during GLA Replace process
CustomerCenter	Added a CustomerCenter "Account Details" widget to the Homepage (Accounts Receivable license only).		Account Details
CustomerCenter	Fixed an issue where the CustomerCenter Theme Editor would not save or preview changes.
General	Migrated the application from PHP 5.6 to PHP 7.2. PHP 5.6 is no longer supported past December 2018. PHP 7.2 brings various performance enhancements, reduced memory usage and current security fixes. Note: PHP 7.2 is required for 2018.1 and all subsequent releases.
	Added a Wiki Help slide-out to the application that connects directly to the new PCR-360 Wiki.		Integrated Wiki Help
	Changed the Prorate/Don't Prorate prompt to an Effective Date prompt with modified verbiage & buttons.		Replacing an Existing GLA Bulk Update Bulk Update on Inventory Charge Catalogs Charges Tabs G/L Account (GLA) Catalogs Inventory Tabs Service Tabs
	Improved the performance of the Contact Pickers in the application, particularly the Contact Owner picker on Service Desk.
	Changing a GLA with the Bulk Update process now allows the user to choose whether the Charges will Prorate or not. A prompt is displayed that gives the user two options: to update the GLA Effective Today, or Backdate to the Last Bill. Note: This affects both Service and Equipment Bulk update processes.		Bulk Update
Imports & Exports	Added a Charge Catalog Import.		Charge Catalog Import
	Removed the Call Flags tab from the Import File Format form.
	Updating the Default GLA on a piece of Equipment now prompts the User for the Effective Date of the change.
Inventory	Fixed an issue where the Equipment Bulk Update failed to update the Equipment Owner when the Billing Group on the New Owner matched the Billing Group on the Original Owner.	IN201833813
Inventory	Removed Remaining Techview references.
People	Adding a new Worker Rate from the Contact Form will automatically populate the Regular, Overtime and Double Overtime fields with the Default Rate on the selected Workgroup.		Workgroups
Reporting	CSV is now the default value on Grid Reports. Note: This change was suggested during the 2018 Users Group.		Reporting on a Grid
Service Desk	Added a Path Legs Notes field to Service Desk Cabling.		Service Desk Tabs
	Add Locations Actions no longer prompt the user when creating the Action. Services with a single location are not modified to a Multiple Location Service until the Action is completed.		Service Desk Change Actions
	Enhanced Email Block Functionality: Wildcards and regular expressions may be used for both the Email and Subject values. Whitelists can be created using a negative look ahead regular expression.		Blocked Emails
	The User-Defined Fields (UDFs) on an Upgrade/Downgrade Action now retain the Original Values from the Service UDFs when an Action is completed. The UDF tab displays the Original Values and the New Values that were applied to the Service. The Imports, Service Desk Wizard and API will all set the Upgrade/Downgrade UDF values.	IN201730410	Service Desk Actions Service Desk Import Service Desk API
	Incident codes are now displayed in Alphabetical order	IN201832233
	The Reference Field on Service Desk Actions is now editable on Remove Actions.	IN201832469
	The Service Desk Labor Grid now displays the Worker Rate from when the Labor Charges were added (not the current Worker Rate).	IN201833925
	Fixed an issue where Finalizing a Remove Action did not always set the correct Stop Date on Charges.
Services	Fixed an issue where the Call Details tab on custom Phone-Type Services (such as Calling Cards) displayed all calls rather than just the calls for that Service.
	Creating a Range of Services (from the Service Grid or Service Pools Form) no longer sets a default for the Bandwidth field.	IN201833945
	It is now possible to add a Call Type to a Service Catalog Expense Object Code.

Database Changes in 2018.1

Table Name	Change	Table Changes
Table Name	Change	Table Changes
BILL_DETAILS	Updated	ADD INVOICES_RECID NULL DROP COLUMN INVOICE_NUMBER
BILLS	Updated	CHANGE BILL_DATE DATETIME NOT NULL ADD LAST_INVOICE INT NULL
BULK_UPDATE_HISTORY	Updated	MODIFY USERS_RECID NULL
CHARGES	Updated	ADD ALTERNATE_STOP_DATE DATETIME NULL DROP COLUMN MRC_CHANGE_TYPE DROP COLUMN LAST_BILLS_RECID DROP COLUMN PREV_BILLS_RECID
CHARGES_BILLED	Updated	ADD BILLING_COMPLETE NOT NULL
CHRG_CATALOG	Updated	ADD BILL_BACKWARD NOT NULL
EQUIPMENT_CHARGES	Updated	DROP COLUMN CHARGE_PROCESSED
EVENTS	Updated	Added a new Event for Accounts Receivable to update GLA Account Totals
GLA_CHARGES	Updated	DROP COLUMN CHARGE_PROCESSED
SD_NUMBER_CONFIG	Updated	DROP COLUMN FISCAL_YEAR_START DROP COLUMN FISCAL_TOGGLE
SERVICE_DESK_CABLING	Updated	ADD COLUMN NOTES
SERVICE_DESK_CHARGES	Updated	DROP COLUMN CHARGE_PROCESSED
SERVICE_DESK_LABOR	Updated	ADD COLUMN REGULAR_HOURLY NOT NULL ADD COLUMN OVERTIME_HOURLY NOT NULL ADD COLUMN DOUBLE_OVERTIME_HOURLY NOT NULL ADD COLUMN DEFAULT_RATE NOT NULL
SERVICES	Updated	DROP COLUMN TECHVIEW
SERVICES_CHARGES	Updated	DROP COLUMN CHARGE_PROCESSED
TENANTS	Updated	ADD FISCAL_YEAR_START NULL ADD FISCAL_TOGGLE NOT NULL
USER_DEFINED_FIELDS_VALS	Updated	Inserted data for Upgrade / Downgrade UDFs on Actions.
GLA_ACCOUNT_MANAGEMENT	New
INVOICES	New
PAYMENT_BATCHES	New
PAYMENTS	New
PAYMENTS_ATTACHMENTS	New
PAYMENTS_INVOICES	New
PAYMENTS_REMARKS	New

2.1.4.8

Release 2.1.4.8-HF1 (03-20-2019)

Component	Description	Type	Incident(s)	Documentation
Billing	Fixed an issue with the View Bill not displaying Calls or Usage in the Service Summary.
Service Desk	Fixed an issue where UDFs were not populated on Actions created from the 360 Service Desk Wizards.		IN201834648

Initial Release

Component	Description	Incident(s)
Billing	Fixed an issue where the View Bill Service Summary was blank for Other Equipment Charges and Other Service Desk Charges.	IN201834648
Service Desk	Fixed Multiple issues with the Service Desk Wizard: The Wizard now creates Change/Remove Actions for Suspended Services. Fixed an issue where Move Actions created by the Service Desk Wizard were not adding the "Move-To" Location on Equipment loaded from the Service. Fixed an issue causing the Service Grid on the Location 360 Form to display duplicate entries. Fixed an issue preventing Location selection on the Service Desk Wizard for Multi-Location Services. Fixed an issue where the wrong SDC was selected for Upgrade/Downgrade Actions. The Location field is now read-only for Change/Remove Actions on Services with no Locations.	IN201834801 IN201834580 IN201834648
	Fixed an issue where UDFs were not populated on Actions created from the 360 Service Desk Wizards.	IN201834648
	Added a "Move-To" Location field to the Service Desk Wizard for Change Actions.

2.1.4.7

The release notes for 2.1.4.7 can be found on the PCR forums here: Release Notes - 2.1.4.7 (2018-10-09).

(v1) .Previous Releases' Notes v2019.6

Notable Changes

Release 2019.5.2 (11-13-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

CustomerCenter

Release 2019.5.1 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

General

Release 2019.5 (10-07-2019)

Component

Description

Type

Incident(s)

Documentation

API

Billing

Cable

Communications

CustomerCenter

General

Imports & Exports

Services

Service Desk

Database Changes in 2019.5

Notable Changes

Release 2019.4.3 (11-13-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Release 2019.4.2 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

General

Release 2019.4.1 (09-13-2019)

Component

Description

Type

Incident(s)

Documentation

General

Release 2019.4 (08-26-2019)

Component

Description

Type

Incident(s)

Documentation

API

Billing

Cable

Communications

CustomerCenter

Escalations & Notifications

General

Inventory

Imports & Exports

Services

Service Desk