Document toolboxDocument toolbox

(v1) .Previous Releases' Notes v2020.4

Key

2020

2020.3 Release Notes

 2020.2

Notable Changes

  1. Items can now be added to a Purchase Order after Receiving has started.
  2. Changes to Estimates:
    1. Attachments are now copied to Service Orders or Actions created from Estimates.
    2. Remarks are now copied to Service Orders or Actions created from Estimates
  3. Add Locations Actions can now be created from the 360 Wizard for non-Phone Services.


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

Release 2020.2.5 (12-16-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Billing Group Pricing now applies to GLA Charges.

IN-5072

Cable

Creating a new Cable Path from the Service form no longer defaults to creating the Path with a status of Left In.

IN-5066

Calls & Rating

The Call Rating process no longer fails if the Service Host cannot be determined.

IN-5057

IN-4321 


Imports & Exports

The Call Import no longer triggers "Undefined index AUTH_CODE_FLAG" warning messages that can fill up the Error Log.



GLA Import Fixes

  • The Import no longer creates a blank component record using an empty string rather than a null value.
  • The Import can now find existing GLA records when the last component of the GLA is blank. Previously the Import was not able to look up those GLAs.

IN-4446

IN-5094


Inventory

Staging multiple pieces of Equipment at the same time from the Warehouse Actions grid no longer reuses the same Equipment record multiple times.

IN-4429 

Reporting

Corrected minor formatting issues with PDF reports.

IN-5013

Service Desk

Users can now open the Service Desk Form that corresponds to the Workflow record from the Workflow Grids (i.e. if the Workflow is on an Action, the User may open the Action form or the Workflow form from the Workflow Grids).

 IN-4427

My Service Desk

Workflow

The Service Desk Archive Log retention process now properly cleans up log entries based on the timeframe set by the configuration option ARCHIVE_LOG_RETENTION.


Archive Log
Improved the loading times for the Service Desk Tab on Services & Equipment. For Oracle customers, the grid was either extremely slow or would not load.

IN-4336
The "Type Value" selector on the Escalation Criteria form now lists all Service Desk Types.



Service Desk number formats less than 8 digits now work properly.



Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner.

Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.

IN-3335

IN-4395

IN-4340


The columns on the Service Desk Archive grids now match the corresponding Service Desk Grids (i.e. the columns on the Service Desk Actions Archive grid now match the Service Desk Actions grid.)

IN-5090

IN-3923



Release 2020.2.4 (10-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.



Billing

The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.

IN-4342
The Bill process now checks for Billling Group overrides for GLA Charges.



Custom Logic

Restored the data displayed on the Schedule Tab on the Custom Events screen.

IN-4333

Inventory

The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete.

Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.

IN-4304

IN-4262


General

Fixed issues with the validator when creating an empty database for new installs.



Reporting

Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports.  Please submit any requests to upgrade java on our portal help.pcr.com.



Services

The Call Details Tab on the Service form now includes Rated Unbillable calls.

IN-4316

Service Desk

Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.



Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).


IN-3000

IN-4225

IN-4239

IN-4365

IN-4192


Release 2020.2.3 (09-01-2020)

Component

Description

Type

Incident(s)

Documentation

CustomerCenter

Approved Service Requests are now showing in the Service Requests Grid.



Custom Logic

Customer Validation now supports using call function to invoke Write methods for API types.


Custom Validation

Syntax

Large Custom API, Custom Events, and Custom Validation scripts no longer generate erroneous error messages.  (e.g. that the str_replace function is not supported)

IN-4164

Events & Notifications

Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.

IN-4216

Services

The Service Desk tab on Services once again includes Pending Add Actions.

IN-4215

Service Desk

Completing a Service ID Action no longer clears the Path Location.

IN-4188 

SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.

IN-4196


Release 2020.2.2 (08-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.


Service Desk API Calls

CustomerCenter

The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.

IN201833105

IN-2965


SDCs are now properly applied to Service Requests when a matching SDC is found.

IN-4125
Existing Service Charges are now added to Change Actions on a Service Request.

IN-4125
Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.



Service Desk

Converting an Estimate to an Action now allows applying the Estimate to Task Actions.

IN-4153


Release 2020.2.1 (08-03-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

The "Test File" column on the Call Details grid has been restored.

IN-3983
The Available Charges Bulk Update event no longer fails on Oracle. 

IN-4066
Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits

IN-4051

Cable

The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path. 

IN-3873

Events

Events that occur during the Fall Daylight Savings Time change should no longer fail. 



Inventory

User-Defined Columns now stay in the correct position on the Equipment Grid after you save the Perspective.

IN-2899

General

Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out). 

IN-3963

IN-3965

IN-3968

IN-3970

IN-3964

IN-3966


Service Desk

Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)



Default Charges from Task type Service Catalogs are now applied to Task Actions

IN-4031

IN-3915


The Add From SDC button on the Service Desk Workflow tab, now selects from the correct SDCs.

IN-4094


Adding Equipment to an Incident Request no longer generates an Oops Error. 



Release 2020.2 (06-04-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Changing the Charge Override Amount or Quantity on an unbilled Monthly Recurring Charge (MRC) and choosing "Effective Today" now stops the charge using yesterday's date. The charge is restarted with the new amount and the current date. Previously this was using "Date to Last Billed" no matter which option was chosen.



Imports & Exports




Multiple fixes for the Service Import:

  1. The Service Import now prevents you from updating the Service Catalog of an existing Service to a different Service Type (like Phone to Backbone) or to a different Service ID format.
  2. The Service Import can now update certain Service Type-specific fields like Report 911 and Directory if the Service Catalog is not provided to the import.
  3. The Service Import no longer requires you to provide a GLA when the GLA field is mapped.
  4. Running a Service Import in a batch, with two different Import Record Formats, no longer produces the same GLA error messages multiple times.


Service Import

Fixes for the Charge Catalog Import:

  1. The Charge Catalog Import no longer fails if you do not map certain fields.
  2. The Charge Catalog Import now throws an error if you try to use an Inactive Object Code.


Charge Catalog Import

Fixes for the Service Charge and GLA Charge Imports:

  1. Both Imports no longer require you to provide certain fields, like Service and GLA and Charge Catalog, if you provide the Charge Recid in the Import file.
  2. Both Imports now throw an error if you try to use a Category type Charge Catalog to create a Charge.


Service Charge Import

GLA Charge Import

Fixes for Charge Imports:

  1. Charge Imports no longer clear the Charge Stop Date when the Import file contains Stop Dates prior to the current date.
  2. Charge Imports will now clear the Amount Override on an existing charge if you provide a blank Override Amount value during an update.


Service Charge Import
Most Imports now accept GLA values where the first or last GLA component is blank. (This does not currently cover Service Desk or Equipment Catalog Imports).

IN-3803

Inventory

Items can now be added to a Purchase Order after Receiving has started.

Won Voting List #2

Purchase Order

Purchase Order Equipment

Service Desk

Changes to Estimates:

  1. Attachments are now copied to Service Orders or Actions created from Estimates.
  2. Remarks are now copied to Service Orders or Actions created from Estimates


Users GroupEstimates
Billing Group Pricing is now applied to a Charge if the Owner is Changed on a Service Desk Order or Action.

IN-2831

IN-2964


Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner.

Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.

IN-3335
Add Locations Actions can now be created from the 360 Wizard for non-Phone Services.



Clicking "Save New" on an existing Action will now create a new Action with the Default Action GLA(s) from the Service Order. (Previously no GLAs were pulled onto the Action).

This also addresses GLA Component Pricing not being applied to the new Action when using the "Save New" button.

IN-2998 (IN201834420)

IN-2999 (IN201834421)


Changing the GLA on an Action now updates any Default Service Charges loaded from the Service Catalog with the Component Pricing.

IN-2999 (IN201834421)

 * Indicates external documentation not written by PCR.

Database Changes in 2020.2

Default Schema

Table NameChangeTable Changes
No Changes

Metadata Schema

Table NameChangeTable Changes
No Changes

Archive Schema

Table NameChangeTable Changes
No Changes



 2020.1

Notable Changes

    • Added support for creating/updating Remarks and User-Defined Field values to the Contact API endpoint.
    • Replaced PCR-360 API Token Authentication with a JSON Web Token.
    • Various security fixes and enhancements for Custom Events, Custom Validation, Custom API, and Conditional Logic.
    • Added an Audit Cleanup Event to remove Audit entries where no changes were made to the data, aside from updating the "Modified Date." These entries are effectively duplicates of the original Audit entry.
    • Enhancements and bug fixes for the Cable Path Import and Department Hierarchy Import.
    • Multiple Time Entry and Service Desk Labor fixes.

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

Release 2020.1.5 (10-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.



Billing

The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.

IN-4342
The Bill process now checks for Billling Group overrides for GLA Charges.



Custom Logic

Restored the data displayed on the Schedule Tab on the Custom Events screen.

IN-4333

Inventory

The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete.

Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.

IN-4304

IN-4262


General

Fixed issues with the validator when creating an empty database for new installs.



Reporting

Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports.  Please submit any requests to upgrade java on our portal help.pcr.com.



Services

The Call Details Tab on the Service form now includes Rated Unbillable calls.

IN-4316

Service Desk

Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.



Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).


IN-3000

IN-4225

IN-4239

IN-4365

IN-4192


Release 2020.1.4 (09-01-2020)

Component

Description

Type

Incident(s)

Documentation

CustomerCenter

Approved Service Requests are now showing in the Service Requests Grid.



Custom Logic

Customer Validation now supports using call function to invoke Write methods for API types.


Custom Validation

Syntax

Large Custom API, Custom Events, and Custom Validation scripts no longer generate erroneous error messages.  (e.g. that the str_replace function is not supported)

IN-4164

Events & Notifications

Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.

IN-4216

Services

The Service Desk tab on Services once again includes Pending Add Actions.

IN-4215

Service Desk

Completing a Service ID Action no longer clears the Path Location.

IN-4188 

SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.

IN-4196

Release 2020.1.3 (08-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.


Service Desk API Calls

CustomerCenter

The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.

IN201833105

IN-2965


SDCs are now properly applied to Service Requests when a matching SDC is found.

IN-4125
Existing Service Charges are now added to Change Actions on a Service Request.

IN-4125
Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.



Service Desk

Converting an Estimate to an Action now allows applying the Estimate to Task Actions.

IN-4153


Release 2020.1.2 (08-03-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

The "Test File" column on the Call Details grid has been restored.

IN-3983
The Available Charges Bulk Update event no longer fails on Oracle. 

IN-4066
Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits

IN-4051

Cable

The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path. 

IN-3873

Events

Events that occur during the Fall Daylight Savings Time change should no longer fail. 



Inventory

User-Defined Columns now stay in the correct position on the Equipment Grid after you save the Perspective.

IN-2899

General

Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out). 

IN-3963

IN-3965

IN-3968

IN-3970

IN-3964

IN-3966


Service Desk

Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)



Default Charges from Task type Service Catalogs are now applied to Task Actions

IN-4031

IN-3915


The Add From SDC button on the Service Desk Workflow tab now selects from the correct SDCs.

IN-4094


Adding Equipment to an Incident Request no longer generates an Oops Error. 




Release 2020.1.1 (05-29-2020)

Component

Description

Type

Incident(s)

Documentation


API

Added SDC support to the Add Incident API endpoint.


Service Desk API
The Barcode API now properly handles "Units" when creating Unit Equipment.


Barcode: Warehouse Bulk Add
Incidents created by API now automatically select an SDC when one is not provided.



Added the 'bill_date' parameter to the Service Charges API endpoint. This allows setting a Start Date for recurring charges via the API.

IN-3375Service API Calls

Billing

Clicking on the "Switch to full detail view" link, on certain Test Bills, no longer redirects you to an error page. 



Cable

The Ports/Pins/Lens Add Range functionality now properly updates Back Connects for ranges over 100 PPLs.

IN-3770
Various "minor" issues with the Port Side Requirement were addressed.



Service Desk Remove Actions now set Cable Pairs and Ports/Pins/Lens to Spare upon completion of the Action.

IN-3785

IN-3792

IN-3816


Adding Multiple Path Legs no longer causes an error when adding a non-spare Ports/Pins/Lens to the same Path.

IN-3039


General

Expanded the Authentication Mapping (AUTH_MAPPING) field on the ROLES table to allow for longer SSO Group names.


Authorization Parameters

Services

When a Service is used on a Service Order that has multiple Actions, the Service Desk tab on the Service form no longer displays data for all of the Actions on that Order.  Previously data for unrelated Actions was displayed on the Service Desk tab.

IN-3622

IN-3736


Release 2020.1 (04-10-2020)

Component

Description

Type

Incident(s)

Documentation

API


Added support for creating/updating Remarks and User-Defined Field values to the Contact API endpoint.


Contact API
Replaced PCR-360 API Token Authentication with a JSON Web Token.


Token Authentication

Service Host Rest API

Authorization Parameters

*JSON Web Token Standard

This release allows more HTML tags for HTML remarks added via the API.

Allowed tags: 'a', 'img', 'strong', 'em', 'p', 'h1', 'h2', 'h3', 'h4', 'h5', 'ul', 'ol', 'li', 'table', 'tr', 'th', 'td', 'br', 'embed'

Note: Support for these tags will come to the Remarks form in a later release.

IN-2857

Remarks: Allowed HTML Tags

Billing

Bill Summary totals on tabs/grids now include the Taxes from Usage and Calls.



Cable

The Cable Path Legs form and Service Desk Cabling Path Legs form will now populate both sides when the Port/Pin/Len is selected.



The Transfer Pair/Strand Range process now properly associates To/From Cabling Equipment pairs transferred from one cable to another. Because of this issue, the Cable Maintenance form displayed connected Equipment for Cables with no Pairs (and no Equipment for some cable with Pairs). 

IN-3446

IN-2854


Catalogs

Now, when a Location is made Inactive, the child Locations are displayed in the Locations Grid as Inactive. Previously, the child Locations were incorrectly displayed in the grid as Active.

IN-3236

IN-2879


Custom Logic


Centralized the logic used to validate allowed PHP functions in Custom Logic. This affects Custom Validation, Custom API, Custom Events, and Conditional Logic.

This change adds support for:

  • PHP array_, is_, str*, etcin Custom Logic.
  • Using PHP Constants in Custom Logic (e.g. STR_PAD_LEFT).
  • regex functions


Custom API

Custom Validation

Custom Events

Custom Logic

Import Conditional Logic

Custom Logic Syntax

Various security fixes for Custom Events, Custom Validation, Custom API, and Conditional Logic:

  • Corrects false Custom Logic validation failures when there are multiple PHP versions installed on the server.

  • Variable function calls are blocked.

  • Access to the following constants is blocked 

  • The following globals are blocked 

  • The following PHP functions are blocked 



General

Added User Defined Columns (UDCs) to the GLA picker.



Added an Audit Cleanup Event to remove Audit entries where no changes were made to the data, aside from updating the "Modified Date". These entries are effectively duplicates of the original Audit entry.


Audit

Events

Historical Data Archiving Events

Fixed various issues with Read-Only Permissions not working consistently.

IN-3387

Imports & Exports




Various Cable Path Import enhancements

  • The import now allows appending Path Legs to existing Paths.
  • The import now allows removing Cable Paths.
  • Added the configuration option CHECK_SERVICE_STATUS. When this option is set to true, the import will throw an error when attempting to add a Path to a Service that is not Active.


Cable Path Import
The Department Hierarchy Import now supports clearing and appending existing contacts to the Department Hierarchy Coordinator tab.

IN-2855


Various fixes to to the Cable Path Import

  • The import no longer allows creating a Path on a Service and Location, if that Location does not exist on the Service.
  • The import no longer replaces Paths with Service data, from a different Service that has the same Location.
  • The import now maintains the correct Pair Status values.
  • The import can now find a Service record using either the formatted or unformatted Service ID.


Cable Path Import

Various fixes to to the Department Hierarchy Import

  • The import now finds the correct SLA when a Hierarchical String is provided in the import file.
    (e.g. "Parent SLA > Child SLA")
  • The import now uses the correct concatenator (defined by the constant GLA_IMPORT_CONCATENATOR)
    for the following import fields: SLA, Default SLA, GLA, and Permitted GLA.
  • The import will now throw an error if any of the following items from the import file are Inactive: Billing Group, Default GLA, Default SLA, Default Incident SLA, and Permission GLAs.
  • The import now defaults new Department Hierarchy records to Active when no status is provided in the import file.
  • New Department Hierarchy records now require the Billing Group. An error is thrown if a Billing Group is not provided in the import file.
  • The import now restricts the allowed Default GLA, and GLA permissions to those allowed by the Billing Group provided in the import file. The import will throw an error if a GLA in the file is not allowed on the provided Billing Group.


Department Hierarchy Import
Service Order and Work Order imports now properly save the SLA provided in the import file.


Inventory

We have enhanced our API and added a Barcode Endpoint.  This will allow scanner software to interface with the API sending barcode transactions into PCR-360 to do things like Warehouse Bulk Add/Transfer, Complete Service Desk Equipment, and Logging Service Desk Labor.


Note: This does require the development of a Barcode Scanner interface (software) to initiate the API calls from a scanner.  PCR worked with a company, Big River Barcode, to develop similar scanner software for COMIT; we are working with them to develop a version to interact with PCR-360.


Barcode

Barcode API Calls

API

Events: Quick Reference

People

Multiple Time Entry fixes:

  • The Time Entry form no longer allows creating, editing, or deleting Labor entries for Voided, Billed, or Finalized Service Desk Items.
  • The following values are now required from the Labor Form, the API or an Import:
    • Date Worked 
    • Worker (Contact)
    • Labor Type
  • Deleting a Time Entry record now deletes the associated Labor record.

IN-2860

IN-2962

Time Entry

Service Desk Labor

Workflow

Service Desk

Changing the Cable Path on an Incident now adds an Activity Record to the Incident.



Incidents
Service Desk Labor Charges are no longer updated when the amount on the Charge Catalog changes. Previously, changing the amount on the Charge Catalog kicked off an event that updated all Charges, including Labor Charges. Labor Charges, particularly those using a flat-rate charge, should be static and not updated by changing the Charge Catalog.

IN201834290
Service Desk Labor Charges are no longer deleted in cases where the user attempted to delete a Labor record, but the Labor record could not be deleted. Previously, even when the Labor record could not be deleted, the associated Labor charge was deleted.



Saving a new Labor record will no longer randomly display an "Oops Error" message.

IN-3293

IN-3082

IN-3089

IN-3102

IN-3408

IN-2931

IN-2892


 * Indicates external documentation not written by PCR.


Database Changes in 2020.1

Default Schema

Table Name

Change

Table Changes

Table Name

Change

Table Changes

API_PERMISSIONSUpdatedAdded Barcode as an API Permission
API_KEYSUpdated
ADD COLUMN DEFAULT_RATE_LIMIT INT DEFAULT 60 NOT NULL;
API_KEYS_USERS_TOKENSUpdated
 MODIFY COLUMN TOKEN VARCHAR(255)  NOT NULL;
ADD COLUMN RATE_LIMIT INT DEFAULT 60 NOT NULL;
ADD COLUMN RATE_LIMIT_REMAINING INT DEFAULT 60 NOT NULL;
ADD COLUMN RATE_LIMIT_RESET DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL;
ADD INDEX API_KEYS_USERS_TOKENS_1 (`TOKEN`);
CABLES_EQUIPMENTUpdated

Create missing "From Cabling Equipment" and "To Cabling Equipment" associations.

Removed orphaned "From Cabling Equipment" and "To Cabling Equipment" associations.

BARCODERemoved
BARCODE_TRANSACTIONSNew

EQP_CATALOGUpdatedCHANGE PART_NUM_BARCODE BARCODE VARCHAR(100);
EVENTSUpdatedAdded an Audit Cleanup Event.
SERVICE_DESK_LABORUpdated
MODIFY COLUMN LABOR_TYPE_LISTS_RECID INT NOT NULL;
MODIFY COLUMN CONTACTS_RECID INT NOT NULL;
MODIFY COLUMN WORKED_DATE DATETIME NOT NULL;


Metadata Schema

Table NameChangeTable Changes
No Changes

Archive Schema

Table NameChangeTable Changes
No Changes



2019

 2019.7

Notable Changes

    • Added an AdHoc Grid Report Library to the wiki.
    • Updated various pages in the wiki to clarify current functionality.
    • Added Service Desk Archiving
      • It allows users to delete old data, such as Locations, Contacts, and Equipment (Foreign Keys to Locations, Contacts, etc. on Service Desk prevent deleting data).
      • It allows users to archive and potentially clean up (delete) old Service Desk Data.
      • It provides the ability to Demolish a Location, which allows the deletion of a Location along with all sub-Locations and associated Cable Data.  
      • Archiving old data improves the performance of grids and pickers.
      • Note: Customers interested in using Service Desk Archiving must email the Helpdesk to sign up for a training session to review how Archiving works and the implications of the various settings before PCR will turn on the Archiving Event. We will be setting up separate 2019.7 group training sessions to review new features.
    • Added Work Order functionality to allow for one-time Orders that do not create or manage Services.
    • Removed the Service Desk Cabling Report and replaced it with an AdHoc report.
    • Removed the Cable Locations Report and replaced it with an Adhoc report. 
    • Numerous fixes to Service Desk Imports.

    • Aging a Multiple Location Service that was used on an Incident no longer fails.
    • Redesigned the My Service Desk: Assigned and Workgroup grids towards a workflow focus.

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

Release 2019.7.12 (4-19-2021)


Component



Description



Type



Incident(s)



Documentation


General

Enabled Form Read/Write Permissions on Tree Elements, including the Catalogs tree tools. Users can now set the Catalog tree(s) to Readonly or Permissions Denied.

IN-5967

Reports

Emailing a grid report with all rows from the grid, now includes all rows (previously the emailed report only contained the first row).



Service Desk

Completing an Upgrade/Downgrade Action once again copies the UDF values to the Service. (This fix was back-ported from 2020.4.2)

IN-5983

Release 2019.7.11 (3-19-2021)

Component

Description

Type

Incident(s)

Documentation

General

E911 Changes

This update will update the data in the E911 snapshot and load E911 fields from All addresses in the Database. 

Generating the E911 report now requires using the USE_E911_NENA2_FIELDS configuration option, if the option is not enabled the process will throw an exception.

NOTE: This will likely create a change record for every Service on a Building where the Nena2 fields were previously blank. The change records created by this process would be a one-time change.


The E911 Report will now convert "Court" to the prefix "CT".

IN-5724

Notifications, Escalations, and Events

The Notification Log form no longer throws an error when the CC (email) Field is populated.

IN-5201

Service Desk

Added a new Escalation/Notification Filter Variable, SDWF_ADDNEW,  to Service Desk Workflow events. 

IN-5201

Escalation Criteria

Creating an Escalation

Escalations

The "Add From SDC" button on Workflow no longer triggers two Workflow Start Date Notifications

IN-5201

Release 2019.7.10 (2-10-2021)

Component

Description

Type

Incident(s)

Documentation

API

When creating Upgrade/Downgrade Actions via the API, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values (if values are not provided in the API Request).


IN-4978

IN-4987


Cable

Updating or saving a Cable Path on a Multiple Location Service no longer displays the message "A path may only be added to a Service with a Location."

IN-5670

General

The Crystal Reports: Batch Filters Grid should no longer fail to load for Oracle customers.

IN-5622

Imports & Exports

When creating Upgrade/Downgrade Actions via an Import, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values (if values are not provided in the Import File).


IN-4978

IN-4987


Services

Generating a range of non-Phone Service records should no longer fail to create the Service records.

IN-5184

IN-5222

IN-5194


Service Desk

Increased the size of the "From Equipment Catalog" and "To Equipment Catalog" columns for the Service Desk Cable records to prevent data truncation.  The Service Desk Cable Archive table was also updated.

IN-5047
Adding a User-Defined Column (UDC) to the My Service Desk Workgroup or Workflow grids no longer displays an "Oops Error" message.

IN-5189

Service Desk Archiving Fixes

  • The Service Desk Archiving process will now archive Service Desk Items where some data was not defined (such as a NULL value for the USE_QUANTITY column on Service Desk Charge records).
  • When a single Service Desk Item fails to Archive, will no longer get stuck; the process will continue to archive records.


IN-5090

IN-3923


Returning Equipment on a Billed or Completed Action should once again create a credit charge.

IN-5177

When creating Upgrade/Downgrade Actions on a Service Order, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values.


IN-4978

IN-4987


Release 2019.7.9 (12-16-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Billing Group Pricing now applies to GLA Charges.

IN-5072

Cable

Creating a new Cable Path from the Service form no longer defaults to creating the Path with a status of Left In.

IN-5066

Calls & Rating

The Call Rating process no longer fails if the Service Host cannot be determined.

IN-5057

IN-4321 


Imports & Exports

The Call Import no longer triggers "Undefined index AUTH_CODE_FLAG" warning messages that can fill up the Error Log.



Inventory

Staging multiple pieces of Equipment at the same time from the Warehouse Actions grid no longer reuses the same Equipment record multiple times.

IN-4429 

Reporting

Corrected minor formatting issues with PDF reports.

IN-5013

Service Desk

Users can now open the Service Desk Form that corresponds to the Workflow record from the Workflow Grids (i.e. if the Workflow is on an Action, the User may open the Action form or the Workflow form from the Workflow Grids).

 IN-4427

My Service Desk

Workflow

The Service Desk Archive Log retention process now properly cleans up log entries based on the timeframe set by the configuration option ARCHIVE_LOG_RETENTION.


Archive Log
Improved the loading times for the Service Desk Tab on Services & Equipment. For Oracle customers, the grid was either extremely slow or would not load.

IN-4336
The "Type Value" selector on the Escalation Criteria form now lists all Service Desk Types.



Service Desk number formats less than 8 digits now work properly.



Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner.

Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.

IN-3335

IN-4395

IN-4340


The columns on the Service Desk Archive grids now match the corresponding Service Desk Grids (i.e. the columns on the Service Desk Actions Archive grid now match the Service Desk Actions grid.)

IN-5090

IN-3923


Release 2019.7.8 (10-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.



Billing

The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.

IN-4342
The Bill process now checks for Billling Group overrides for GLA Charges.



Custom Logic

Restored the data displayed on the Schedule Tab on the Custom Events screen.

IN-4333

Inventory

The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete.

Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.

IN-4304

IN-4262


General

Fixed issues with the validator when creating an empty database for new installs.



Reporting

Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports.  Please submit any requests to upgrade java on our portal help.pcr.com.



Services

The Call Details Tab on the Service form now includes Rated Unbillable calls.

IN-4316

Service Desk

Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.



Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).


IN-3000

IN-4225

IN-4239

IN-4365

IN-4192


Release 2019.7.7 (09-01-2020)

Component

Description

Type

Incident(s)

Documentation

CustomerCenter

Approved Service Requests are now showing in the Service Requests Grid.



Custom Logic

Customer Validation now supports using call function to invoke Write methods for API types.



Custom Validation

Syntax

Events & Notifications

Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.

IN-4216

Services

The Service Desk tab on Services once again includes Pending Add Actions.

IN-4215

Service Desk

Completing a Service ID Action no longer clears the Path Location.

IN-4188 

SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.

IN-4196

Release 2019.7.6 (08-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.


Service Desk API Calls

CustomerCenter

The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.

IN201833105

IN-2965


SDCs are now properly applied to Service Requests when a matching SDC is found.

IN-4125
Existing Service Charges are now added to Change Actions on a Service Request.

IN-4125
Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.



Service Desk

Converting an Estimate to an Action now allows applying the Estimate to Task Actions.

IN-4153


Release 2019.7.5 (08-03-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

The "Test File" column on the Call Details grid has been restored.

IN-3983
Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits

IN-4051

Cable

The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path. 

IN-3873

Events

Events that occur during the Fall Daylight Savings Time change should no longer fail. 



General

Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out). 

IN-3963

IN-3965

IN-3968

IN-3970

IN-3964

IN-3966


Service Desk

Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)



Default Charges from Task type Service Catalogs are now applied to Task Actions

IN-4031

IN-3915


The Add From SDC button on the Service Desk Workflow tab, now selects from the correct SDCs.

IN-4094


Adding Equipment to an Incident Request no longer generates an Oops Error. 



Release 2019.7.4 (05-20-2020)

Component

Description

Type

Incident(s)

Documentation


API

Added SDC support to the Add Incident API endpoint.


Service Desk API
Incidents created by API now automatically select an SDC when one is not provided.



Added the 'bill_date' parameter to the Service Charges API endpoint. This allows setting a Start Date for recurring charges via the API.

IN-3375Service API Calls

Billing

Clicking on the "Switch to full detail view" link, on certain Test Bills, no longer redirects you to an error page. 



Cable

The Ports/Pins/Lens Add Range functionality now properly updates Back Connects for ranges over 100 PPLs.

IN-3770
Various "minor" issues with the Port Side Requirement were addressed.



Service Desk Remove Actions now set Cable Pairs and Ports/Pins/Lens to Spare upon completion of the Action.

IN-3785

IN-3792

IN-3816


Adding Multiple Path Legs no longer causes an error when adding a non-spare Ports/Pins/Lens to the same Path.

IN-3039


General

Expanded the Authentication Mapping (AUTH_MAPPING) field on the ROLES table to allow for longer SSO Group names.


Authorization Parameters

Services

When a Service is used on a Service Order that has multiple Actions, the Service Desk tab on the Service form no longer displays data for all of the Actions on that Order.  Previously data for unrelated Actions was displayed on the Service Desk tab.

IN-3622

IN-3736


Release 2019.7.3 (04-29-2020)

Component

Description

Type

Incident(s)

Documentation

API

Creating a Service Desk Action via the API now sets the SDC_RECID. This bug prevented Workflows, Charges, etc. on an SDC from adding to the Action.

IN-2909

IN-2894


Billing

Refinements to Billing Invoices

  • Added the GLA Description to the "Bill To" section.
  • Invoices are now more customizable.  The following may now be configured:
    • The account info color
    • The table row background-color
    • Show/hide row borders
    • The row border-color
    • Suppress the current date. The date suppression is configurable for all reports, the bill, and Invoice
    • The Invoice Remittance Coupon content is now configurable. The coupon can also be removed from the Invoice.
  • Redesigned the Invoice Remittance Coupon.
    • The Credit Card information was removed from the default design.
    • Fixed layout issues with the PDF version of the Invoice.
    • Renamed "Current Balance" to "Outstanding Balance."  (i.e. the total amount due for Net-30, Net-60, Net-90, etc.)
    • Moved the remittance coupon onto a separate page at the end of the Invoice.
  • Tweaks to the Invoice's Payment Table formatting
    • Long descriptions now wrap to the next line
    • Payment date is now mm/dd/yyyy format
  • The "Transaction Details" on the Invoice Printout are now listed and grouped by the Service ID, rather than the charge code.


IN-3519

IN-2859

IN-3207

Invoices

Billing Parameters

The GLA Conflicts grid no longer generates an "Oops Error" when getting the grid count.

IN-3688

General

Numerous E911 Fixes and Improvements.

  • Significantly increased the speed of the E911 Export process.
  • Corrected the Community Name displayed on grids. Frequently the Building Number was displayed, but the Community Name was missing or incorrect.
  • The E911 Export now includes Services with no Locations when determining if a Service should be flagged as a "Delete" in the export.


Exports

E911 Feed

Service Desk

The Assigned Workflow and Workgroup grids now include Pending Workflow on Completed Service Desk Orders.

IN-3743

Release 2019.7.2 (03-16-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Clicking the Billing tab on the Equipment form no longer causes an "oops" error.



Catalogs

Making a Charge Catalog Inactive now stops or deletes the Charges on a Service desk item when the Service Desk item has a status of Pending, Hold, or Complete. If the Service Desk item has a status of Void, Finalized, or Billed, the Charges will not be stopped/deleted. This applies to all Service Desk Equipment and Service Charges. 

Previously it would attempt to alter items with a status of Void, Finalized, or Billed.

IN-3580

Communications




Added Cisco features:

  • Added the Associated Devices tab for Directory Numbers to the Service Desk Actions Communication form.
  • Added a column to the Endpoint/Phone picker to indicate whether the endpoint/phone has an associated directory number.


Cisco Documentation
Removed the checkboxes from Cisco Bulk Update Grids.

IN-3480

The auto-assign for Cisco Gateway Endpoints/Phones on Service Desk Move Actions now uses the "Move To" Location instead of the original Location.

IN-3432Cisco Documentation
Adding a new Analog Endpoint/Analog Phone via a Service Desk Action now populates the directory number information from Device Defaults.

IN-3321

General

Refinements to the Demolish Location form:

  • Updated the demolish button image and text
  • Increased the form size
  • Changed the event comment from "Event" to "Scheduled Archive Event"


Locations

Location Catalogs

Services

Non-billable Services (i.e., the billable flag is not checked) with Charges, are now picked up by the Aging Process.



The Service Aging process now uses the "Billing Complete" flag to determine if a Service with Charges can be aged. If any of the Charges are not flagged as "Billing Complete" then those Charges are considered Active, and the Service cannot be aged.

IN-3570

IN-3566


Service Desk

Service Desk Printout fixes:

  • Saving the Print Prefs on the Service Order grid, and printing an Action, no longer leaves off the child data from the Action(s). 
  • The Service ID now displays on Service Desk Action printouts.
  • Printing the Actions for a Service Order no longer repeats the Cable info for all of the Actions on each of the Action printouts.

IN-3532
Returning Service Desk Equipment no longer drops the Equipment Charges when more than one Charge exists on the Service Desk item and those Charges have different Expense Types.

IN-3345
The GLA Replace Process once again replaces the GLA on Service Charges.

IN-3506

IN-2910

IN-2923


Release 2019.7.1 (02-21-2020)


Component

Description

Type

Incident(s)

Documentation

General

Changes in 2019.7 prevented the Oracle Data load process from disabling foreign keys; this has been fixed.



Corrected issues with the Bill, Call and Import Archiving processes.



Cleaned up notices from Dashboard Widgets that could fill up the system log.



Release 2019.7 (01-27-2020)

Component

Description

Type

Incident(s)

Documentation

API

Added the ability to create Work Orders via the API. 


Work Order API
Added API attachment support for Service Desk API calls.


Service Desk API Calls

Service Desk Action API Calls

Billing

The Billing Group totals on the Bill now match the data on the "Billing Group" form.



Cable

Removed the Cable Locations Report and replaced it with an Adhoc report. This report is available in the AdHoc Grid Report Library. The new AdHoc loads significantly faster than the original report grid.
 

IN201834275

IN201935535 

IN201834626

Service Desk Cabling Report

Building Adhoc Grids

The Ports/Pins/Lens Range Generator no longer generates PPL records with the same IP Address when using an IP Address for the Range.



Adding Multiple Path Legs no longer fails if Ports/Pins/Lens are assigned.

  • Attempting to save multiple Path Legs, when the PPL does not allow multiples, now displays the proper error message to the user.
  • Deleting the Service Desk Path Leg from the Service Desk Path Leg form no longer fails.

IN-3039

Communications

Closing an Avaya form with unsaved data now prompts the user to save the record.



General

Added a "Modified Date" and "Modified By" column to the Department Hierarchy grid.  

Note: This change may affect saved perspectives.

Users Group 2019
Removed the "Password Reset" button on the Add New Users form. (Resetting the password on a User before saving the record would throw an error)



Imports & Exports

Added a Work Order Import.


Work Order Import
Added a Service Desk Miscellaneous Action Import.


Service Order Imports
Added a field for the "Associated Project" to the Service Desk Imports and "Associated Problem" to the Work Order Import.


Service Order Imports

Numerous fixes to Service Desk Imports:

  • The CSR field now requires the Contact to have a Type of "Service Rep."
  • Available Services are now correctly validated against Service Pools and follow the same eligibility restrictions as the Actions form.
  • UDFs now work with Service Desk Imports.
  • Added support for the Action Default GLA field.
  • Services that are not "Assignable" can now be used with Remove or Task Action Imports.
  • The Service Desk Import can now create Task actions without a Service Catalog specified. Only Upgrade/Downgrade Actions require the Service Catalog.

  • The Service Desk Import now generates an error if an Owner is specified for anything other than an Add Action or Owner Change Action.

  • Added validation to the Service Desk Imports to verify the following (any invalid combinations will result in an error):
    • Only Auth Code Services use Class of Service
    • Only Auth Code Services use Auth Code Type
    • Only Backbone or Data Services use Bandwidth
    • Only Phone Services use Report 911
    • Only Phone Services use Directory
  • Some valid SDCs were throwing an error that the SDC was not valid for the action; this has been fixed.
  • The Service Desk Import no longer ignores the Inactive status on the following fields:  Service Rep, Owner Contact, Owner Dept, Requestor, Default GLA, Action Service Host, Action Owner Contact, Action Owner Dept, Action SLA, Action Location, & Action SDC.
  • The Service Desk Import now correctly supports the Move-to Location field on Actions
  • The Service Desk Import now allows the existing Available Service Catalog to be a parent of the provided catalog.
    Example: if the Available Service has a Catalog of 'phone,' then the Catalog provided to the Import could be 'phone > Avaya'. However, the Import will error if the provided catalog is 'auth code'.
  • If the SDC field is not mapped on the import definition or is not provided in an import file, the Service Desk Import no longer picks a random SDC.
  • The SDA_Number field mapping was removed from the Service Desk Import.  There is no need to set the Action number via an Import at this time.
  • The Service Desk Import no longer allows Category Catalog items (i.e., Equipment, Service, or Charge Catalogs with the Category flag set).

IN201834801Service Desk Imports

Inventory

Added a "Display SD" button to the Warehouse Actions grid that opens the Service Desk record associated with the Equipment selected on the grid.

IN-2929 Warehouse Actions

Added the "Manufacturer" and "Manufacturer Part Number" from the Equipment Catalog to the Equipment Grid.

Note: This change may affect saved perspectives.

Users Group 2019
Changed the 'Activity' tab on Equipment to 'Service Desk'.


Service Desk Tab
Related Equipment Permissions no longer fail to update when updating Equipment Catalog records with more than 1000 child records.

IN201935538
Returning Equipment on the Warehouse Actions grid now accounts for the Expense Type on the Equipment.

IN-2841

Services

Addressed issues related to Multiple Location Services:

  • Unchecking the Multiple Locations flag on Services and saving the record no longer throws an "XHttp Request Action Failed" error. 
  • It is now possible to unset the Multiple Locations flag on a Service that was used on an Incident.
  • Aging a Multiple Location Service that was used on an Incident no longer fails.

IN201833807

IN-2876

IN-2839


Service Desk

Added Service Desk Archiving Functionality

  • It allows users to delete old data, such as Locations, Contacts, and Equipment.
  • It allows users to archive and potentially clean up (delete) old Service Desk Data.
  • Added a tab to the Location form to show records preventing Location deletion (i.e., demolish).
  • It provides the ability to Demolish a Location, which deletes the Location along with all sub-Locations and associated Cable Data.  
  • Added a weekly event that will archive Service Desk Items based on the Service Desk Archiving Days setting on the tenant. 
  • Added a manual process for archiving individual Service Desk Items that are eligible for Archiving.
  • Added an Archive Grid for each Service Desk type, and printouts for each of the Archived Service Desk types. (there are no forms for Archived Items).
  • Added an Archive Log that contains information on the records that were successfully archived as well as the records that failed to archive.  
  • Added a new audit type of "Archive" to indicate (with an Audit record) when a Service Desk Item was archived.
  • The Service Desk Tab on Equipment and Services displays both archived and non-archived Service Desk Items. (Requested at the 2019 Users Group)
  • Archived Data will not be cleaned up automatically (at this time) but can be deleted manually from the grid.

IN-2949 I

N201620470

IN201731118

Users Group 2019

Service Desk Archiving Requirements

Service Desk Archiving

Archive Eligible Grid

Archiving Days (set the 'Aging' timeframe)

Archive Log

Service Desk Events

Archive Parameters

Services: Service Desk Tab

Equipment: Service Desk Tab

Usage Tab & Demolish Location

Added Work Order functionality to allow for one-time Orders that do not create or manage Services.

  • Added Work Orders to the following Grids "Service Rep," "Workgroup" and "Assigned Workflow" Reports.
  • Added a Work Order Import.
  • Added the ability to create Work Orders via the API. 
  • Renames all usage of "Orders" in PCR-360 to "Service Orders" to differentiate from Work Orders.


Work Order Requirements

Service Desk

Work Order

Work Order API

Work Order Import

Associating Work Orders to Service Orders

Added the Reference Field to Task Actions.


Task Types

Redesigned the My Service Desk: Assigned and Workgroup grids towards a workflow focus.

Note: This change may affect saved perspectives.


My Service Desk Grids
Removed the Service Desk Cabling Report and replaced it with an AdHoc report. This report is available in the AdHoc Grid Report Library. The new AdHoc loads significantly faster than the original report grid.

IN201834275

Cable Locations Report

Building Adhoc Grids

Fixed a typo in the Cabling section of the Service Order Printout. (This affected the non-graphical version only).



The Service Desk Charges Tab is now editable for Completed Service Desk Items. (Previously it was read-only)



Fixed the Email Thread Section of the Service Desk Printout; it now shows values for Name, Subject, and Email



The Service ID now displays on Remove Action Printouts for Remove Actions created from the 360 Wizard.

IN-3139
The Worker column is now populated by the SDC Workflow when it specifies the Workgroup and the Worker.  (This stopped working in 2019.5)

IN-3269
The Service Options field on Actions is no longer disabled after navigating from a Completed or Finalized Action to a Pending Action. This was problematic because if the Service Options were disabled, completing the Pending Action would clear the Service Flags (i.e., Report 911, Directory, Billable, etc.)

IN-3355


Database Changes in 2019.7

Default Schema

Table Name

Change

Table Changes

AUDITSUpdatedIncreased the ACTION column from 6 to 7 characters.
EVENTSUpdatedAdded the Weekly Archive Event.
PERMISSIONS_GRIDSUpdated

Changed the GRID_SCENARIO column values of 'orders' to 'service-orders'.

SD_TO_ARCHIVENew
SERVICE_DESKUpdated
ADD COLUMN CREATED_DATE   DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
ADD COLUMN PENDING_DATE DATETIME DEFAULT NULL,
ADD COLUMN HOLD_DATE DATETIME DEFAULT NULL,
ADD COLUMN COMPLETE_DATE DATETIME DEFAULT NULL,
ADD COLUMN FINALIZED_DATE DATETIME DEFAULT NULL,
ADD COLUMN BILLED_DATE DATETIME DEFAULT NULL,
ADD COLUMN APPROVED_DATE DATETIME DEFAULT NULL,
ADD COLUMN DENIED_DATE DATETIME DEFAULT NULL,
ADD COLUMN VOID_DATE DATETIME DEFAULT NULL
SERVICE_DESK_ACTIONSUpdated
ADD COLUMN CREATED_DATE   DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
ADD COLUMN PENDING_DATE DATETIME NULL
ADD COLUMN COMPLETE_DATE DATETIME NULL
ADD COLUMN FINALIZED_DATE DATETIME NULL
ADD COLUMN BILLED_DATE DATETIME NULL
ADD COLUMN HOLD_DATE DATETIME NULL
ADD COLUMN VOID_DATE DATETIME NULL
SERVICE_DESK_APPROVALUpdated
ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_ARCHIVE_LOGNew
SERVICE_DESK_INCIDENTSUpdated
ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_PROBLEMSUpdated
ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_CABLING_PIT
UpdatedIncreased the size of columns FROM_EQUIPMENT_CATALOG
and TO_EQUIPMENT_CATALOG columns to 255 characters
SERVICE_DESK_WORK_ORDERSNew
SERVICE_DESK_WORKFLOWUpdated
ADD COLUMN CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
ADD COLUMN PENDING_DATE DATETIME DEFAULT NULL,
ADD COLUMN HOLD_DATE DATETIME DEFAULT NULL,
ADD COLUMN VOID_DATE DATETIME DEFAULT NULL
IMPORT_RECORD_TYPESUpdatedChanged the NAME column values of 'Service Desk' to 'Service Order'.
IMPORT_RECORD_TYPES_COLSUpdatedRemoved any references to the Service Order Action number in the Service Desk Import definitions.


Metadata Schema

Table Name

Change

Table Changes

USAGE_LOCATIONNew



Archive Schema

Note: The archive schema is new as of Release 2019.7.

Table Name

Change

Table Changes

SDA_SERVICE_DETAILSNew
SERVICE_DESKNew
SERVICE_DESK_ACTIONSNew
SERVICE_DESK_ACTIVITYNew
SERVICE_DESK_ASSOCNew
SERVICE_DESK_ATTACHMENTSNew
SERVICE_DESK_CABLINGNew
SERVICE_DESK_CHARGESNew
SERVICE_DESK_COMMUNICATIONNew
SERVICE_DESK_CONTACTSNew
SERVICE_DESK_EQPNew
SERVICE_DESK_EQP_ACTNew
SERVICE_DESK_EST_EQPNew
SERVICE_DESK_EST_LABORNew
SERVICE_DESK_EST_CHARGESNew
SERVICE_DESK_GLANew
SERVICE_DESK_INC_EQPNew
SERVICE_DESK_INCIDENTSNew
SERVICE_DESK_INQUIRYNew
SERVICE_DESK_LABORNew
SERVICE_DESK_PROBLEMSNew
SERVICE_DESK_QUICKTICKSNew
SERVICE_DESK_THREADNew
SERVICE_DESK_WORKFLOWNew
SERVICE_DESK_WORKFLOW_ACTNew

SERVICE_DESK_WORK_ORDERS

New

USER_DEFINED_FIELDS_VALS

New
 2019.6

Notable Changes

    • Added the following columns to the Service Desk Equipment tab:

      • Equipment ID
      • Asset Tag
      • Serial Number
      • Mac Address
    • Renamed the Equipment column to Catalog: now the Catalog column only displays the Equipment Catalog Name and Description.
    • Adding Location Permissions to a Service Catalog no longer prevents selecting any Service Catalog on Upgrade/Downgrade Actions. Catalogs are now appropriately restricted by the Locations on the Service Catalog and Service Pools.

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

Release 2019.6.2 (01-27-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Annual Recurring Charges, Semi-Annual Recurring Charges, and Quarterly Recurring Charges now bill correctly.


Forum Post

Cable

Renumbering a Cable Path no longer fails on Services with multiple associated Service Desk Actions.



Removing Service Desk Cabling (Deleting or Voiding) now returns the cable statuses to Assigned.



The Service Desk Cabling Auto-Assign no longer throws a "Duplicate Record" error indiscriminately. (This prevented closing Service Orders.)

IN-3018

IN-3263


The Equipment ID (for Equipment that does not have a Location), is now displayed in the Completed Cabling tab.



Communications

Cisco "Change" Actions now respect the selected Directory Number (DN) on the Action.

IN-3233
Cisco Analog Endpoints/Phones now use the correct form.

IN-3319

CustomerCenter

Now, when a request is approved in CustomerCenter, the remark is created showing the actual approved amount instead of $0.00.

IN-3351


Reopening the "Order Details" for Task Actions no longer shows the wrong form.

IN-3302
The Approval Grid no longer shows the wrong Service Desk Item when using the Service Request link on the Approval page.

IN-3244

IN-3254


The Owner on a Change Action now matches the Owner on the Service record (rather than defaulting to the logged-in user)



Imports & Exports

The Full Cable Path Import no longer replaces the path with different Service values (that are on the same Location).

IN-3303

Service Desk

The Equipment Catalog is no longer missing from the Service Order Printout.

IN-3357

Release 2019.6.1 (12-10-2019)


Component



Description



Type



Incident(s)



Documentation


Cable

The Service Desk Cabling Auto-Assign now properly links existing Paths. Previously, the auto-assign was throwing a Duplicate Path error.

IN-3018


Release 2019.6 (11-14-2019)


Component

Description

Type

Incident(s)

Documentation

API

The API now properly obeys Service Location Permissions. Previously, if no Service Catalogs set any Location Permissions (used for Services), the validation failed and would not create the Service Desk item.

IN-2846 (IN201935500)

Service Pools

Upgrade/Downgrade Actions

Fixed various issues with Service Desk API Calls:

  • The 'prob_code' and 'res_code' parameters now work as intended; both need to match against the provided Catalog.
  • Owner validation now works as intended; the owner needs to match the owner on the Service or Equipment.


Service Desk API

Cable

The Show All/Show Restricted slider setting on pickers can now be saved with a Picker Perspective.

IN-2987 (IN201834047)

CustomerCenter


Changing the Stand-Alone Equipment Quantity from within the cart (using the Qty arrows) now carries through to the Service Request.

IN201936263
Phone numbers in the My Services/Equipment grid and on the Directory page are now correctly formatted like phone numbers.  


Directory

General

The Custom Event Schedule form is no longer read-only.



LDAP role mapping no longer fails when a group name contains commas.



User-Defined Fields (UDFs) can now be used as the sorting column on a Saved Perspective.

IN-2990 (IN201834114)

Imports & Exports

The Equipment Catalog Import can now import Equipment Catalog User-Defined Fields.

IN-2893 (IN201936333)


The API now correctly obeys Service Location Permissions. Previously, if no Service Catalogs set any Location Permissions, the validation failed and would not create the Service Desk item.

IN-2846 (IN201935500)

Service Pools

Upgrade/Downgrade Actions

Service Desk

Added the following columns to the Service Desk Equipment tab:

  • Equipment ID
  • Asset Tag
  • Serial Number
  • Mac Address

This change also:

  • Renamed the Equipment column to Catalog.
  • Changed the Catalog column, so it only displays the Equipment Catalog Name and Description.



Part of IN-2885 (IN201936207)Service Desk Equipment
Service Desk Task Actions now load Default NRC Charges from the Charge Catalog. Task Actions will not allow MRC Default Charges.



A change in 2019.3 caused several extra columns to appear on the Service Desk Equipment tab; the Equipment tab now displays the correct number of columns.   


Service Desk Equipment
Adding Location Permissions to a Service Catalog no longer prevents selecting any Service Catalog on Upgrade/Downgrade Actions. Catalogs are now appropriately restricted by the Locations on the Service Catalog and Service Pools.

IN-2846 (IN201935500)

Service Pools

Upgrade/Downgrade Actions

Inactive Service Pools no longer prevent selecting a Service Catalog on Upgrade/Downgrade Actions.

IN-2846 (IN201935500)

Service Pools

Upgrade/Downgrade Actions

Database Changes in 2019.6

There are no database changes for 2019.6.

 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

Type

Incident(s)

Documentation

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

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



Release 2019.5 (10-07-2019)


Component

Description

Type

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:

  1. Prorate Flag (Only if the configuration BILL_MRC_CHANGE_FORCE_PRORATE is turned off)
  2. MRC Start Date (only populated for MRCs)
  3. MRC Stop Date (only populated for MRCs)
  4. NRC Transaction Date (only populated for NRCs)
  5. Annual/Semi-Annual/Quarterly Recurring Date (only populated for Alternate Recurring Charges)
  6. 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.



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


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
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_LENSUpdated

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_HOSTSUpdated

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

Type

Incident(s)

Documentation

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:

  1. Prevented the Bulk Update from updating Services (for customers who do not user Service Pools)
  2. 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

Type

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.



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

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.

IN201935781Calendar

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_HISTORYUpdated

DROP COLUMN USERS_RECID

ADD COLUMN USERID VARCHAR(20) NOT NULL

DEVICE_DEFAULTSNewAdded the Table to PCR-360
IMPORT_FORMATSUpdated

DROP COLUMN DUPLICATES
DROP COLUMN IMPORT_RECORD_TYPES_RECID

IMPORT_RECORD_FORMATSUpdated

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_OUTRemovedDropped the Table from PCR-360
SERVICE_DESK_CABLING_PITNewAdded 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

Type

Incident(s)

Documentation

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


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



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.

IN201832773Equipment 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

Type

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

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

Type

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

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



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
  • 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 NameChangeTable 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 and older

 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

Type

Incident(s)

Documentation

Billing

Fixed an issue where the View Bill Service Summary was blank for Other Equipment Charges and Other Service Desk Charges.


IN201834648
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


Added a "Move-To" Location field to the Service Desk Wizard for Change Actions.




Release 2018.1 (12-20-18)

Component

Description

Type

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.



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

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.


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

BILL_DETAILSUpdated

ADD INVOICES_RECID NULL

DROP COLUMN INVOICE_NUMBER

BILLSUpdated

CHANGE BILL_DATE DATETIME NOT NULL

ADD LAST_INVOICE INT NULL

BULK_UPDATE_HISTORYUpdated

MODIFY USERS_RECID NULL

CHARGESUpdated

ADD ALTERNATE_STOP_DATE DATETIME NULL

DROP COLUMN MRC_CHANGE_TYPE

DROP COLUMN LAST_BILLS_RECID

DROP COLUMN PREV_BILLS_RECID

CHARGES_BILLEDUpdated

ADD BILLING_COMPLETE NOT NULL

CHRG_CATALOGUpdated

ADD BILL_BACKWARD NOT NULL

EQUIPMENT_CHARGESUpdated

DROP COLUMN CHARGE_PROCESSED

EVENTSUpdatedAdded a new Event for Accounts Receivable to update GLA Account Totals
GLA_CHARGESUpdated

DROP COLUMN CHARGE_PROCESSED

SD_NUMBER_CONFIGUpdated

DROP COLUMN FISCAL_YEAR_START

DROP COLUMN FISCAL_TOGGLE

SERVICE_DESK_CABLINGUpdated

ADD COLUMN NOTES

SERVICE_DESK_CHARGESUpdated

DROP COLUMN CHARGE_PROCESSED

SERVICE_DESK_LABORUpdated

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

SERVICESUpdated

DROP COLUMN TECHVIEW

SERVICES_CHARGESUpdated

DROP COLUMN CHARGE_PROCESSED

TENANTSUpdated

ADD FISCAL_YEAR_START NULL

ADD FISCAL_TOGGLE NOT NULL

USER_DEFINED_FIELDS_VALSUpdatedInserted data for Upgrade / Downgrade UDFs on Actions.
GLA_ACCOUNT_MANAGEMENTNew
INVOICESNew
PAYMENT_BATCHESNew
PAYMENTSNew
PAYMENTS_ATTACHMENTSNew
PAYMENTS_INVOICESNew
PAYMENTS_REMARKSNew
 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

Type

Incident(s)

Documentation

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

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