Document toolboxDocument toolbox

(v1) .Previous Releases' Notes v2019.3

Key

2019

 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

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