API

Billing

Added Expense Management

• Invoice Reconciliation
• Current Charges Discrepancy
• Missing Invoiced Item

Cable

Pairs/Strands

Cable

CustomerCenter

Redesigned the Shopping Cart

• Persistent Cart

  • The Cart is saved as items are added. If the user logs out of the system and then back in, the Cart will be restored.
  • The count next to the Cart Icon now indicates how many requests are in the Cart, not the number of individual items in the Cart.

• Save Incomplete Requests

  • Customers may enter partial requests and save them for later.
  • Each Request is saved automatically, even if the values required to submit the Request (s) are not populated.

• Updated Submission Process

  • Requests can be submitted individually or in bulk.
  • Customers can submit some or all of the requests from the Cart.
    • Submitted requests must specify all required information.
  • Requests missing required information cannot be submitted.
  • Each Request can have a customizable name, limited to 30 characters.  The default name will be "Request 1", "Request 2", etc.
    • When the requests are submitted, the request name will be saved as a remark on the Request.

• Completely Redesigned Cart Layout

  • The Cart may contain multiple requests.
  • Each Request has an Icon to indicate whether the Request is "Complete" or requires more information. 
  • Requests are editable from the Cart. 
  • Partial Requests cannot be submitted.

  • One or more requests can be submitted or deleted at a time.

  • Individual Actions and Equipment may be deleted from a request.
  • Requests are validated before submission. 
  • Added a configuration option to allow Pending Requests to Expire. 
    • A button to the top of the cart allows the user to toggle between current and expired Requests.
    • Expired Requests cannot be submitted.
• Added the Service Reference field to Change Actions in the Cart.

The Cart

CustomerCenter Parameters

Cart Redesign Requirements

Training Videos

CustomerCenter Administration

User Defined Fields Associations

Adding Videos to CustomerCenter

Customizable Content Requirements

Training Videos 

Options for easier selection of a Contact or Location

• Users now have the option to choose an Owner type of "Contact," "Department," or "I can't find" in the Cart.
• Users now can choose a Location using the "Find Existing Option" or "I can't find" option in the Cart.
• Note: If "I can't find" is chosen, the user can type in the Contact/Department Name or Location into a text field. This information will become a remark when the Request is submitted. 

We improved the CustomerCenter Theme Manager design.

• Improved Uploader for the Theme Logo.
• Improved Theme selector.
• Replaced the Create New Theme link with a New Theme button for creating a new Theme. 
• New buttons for Make Active, Copy, Preview, Reset, Deactivate, and Delete Theme options.

Redesigned Receipt Page (Submitted Request Summary)

Redesigned Change Menu Options in CustomerCenter.

• Report A Problem (submit an Incident)
• Change Request Options
  
  1. Request a New Service ID
  2. Upgrade / Downgrade Service
  3. Add a New Location
  4. Move to a New Location
  5. Change the Owner of the Service
  6. Other Miscellaneous updates
• Disconnect Service (Request the deactivation of the Service/Equipment)

Changed "Report a Problem" to "Report an Issue" in the Main Menu.

Note:  This is a default value in the Menu. With the customization options added to CustomerCenter, users can now change this default setting.

IN-2965

IN201833105

Autocomplete/Auto-filtered values on CustomerCenter pickers now let you select a value. (Previously, if you started typing in the picker fields and a drop-down with auto-filtered selections appeared, you could not select a value.)

Using the "Breadcrumb" navigation at the top of the Equipment Catalog page now takes the user back to the page that was selected, rather than the first page.

Certain User Defined Fields, such as Currency, no longer cause an error when a Service Request is converted to a Service Order, or when an Incident Request is converted to an Incident.

General

Added PHP 7.4 Support

Note: PHP 7.4 is not required at this time to upgrade PCR-360, however, a future upgrade will require PHP 7.4, since PHP 7.2 support is ending in December 2020.

Imports & Exports

Ports/Pins/Lens Import

• The Import no longer requires the Status value of updates. (It is still required for Adds).
• The Import now requires a Side to be specified.

Equipment Import

• The Import now validates values for IP Addresses, subnets, gateways (IPv4 and IPv6), and the MAC Address. 
• The Import no longer crashes (throws an SQL error) when some Equipment Import fields are mapped and no values were provided in the file.
• The Import no longer fails when the Purchase Price is left blank.
• The Import now requires the Serial Number for new records if the REQUIRE_SERIAL_NUMBER configuration option is set.

• The Import can now find existing records by Serial Number, or by the new Equipment RECID field. Note: This is useful when trying to update Equipment where the Equipment ID and Asset Tag are both empty.
  The lookup order for the Import:  Recid, Asset Tag, Equipment ID, then Serial Number.

Service Order Import

• The Import now supports the Rating Group Service detail option.
• The import can now use GLAs where the first or last GLA Component is blank.

Cable Path Import

• The Cable Path Import now has a mappable Service RECID field to let you specify a Service that has a blank Service ID.

Service Import

• The Import now reports an error when you try to add Equipment to a Service that is already associated with another Service.
• The Import now allows users to create an Other Type Service or Custom Type Service that has a blank Service ID.

Unified the logic for Service ID lookups in the following Imports to provide a more consistent experience between Imports: Cable Path, Service Charge, Service Order, and Service. The Imports now find the correct Service record if you provide an Alias, a formatted Service ID, or an unformatted Service ID.

Inventory

MAC Address Changes

• The MAC Address is now a unique value across all Equipment Records and is enforced by a database constraint. Note: Before upgrading to 2020.3, you will need to remove any duplicate MAC Addresses. An AdHoc query to find duplicate values has been provided in the documentation column.
• Customers will now have a more consistent experience when searching for a MAC Address on the Equipment grid.
• It is now possible to bulk add Equipment records with the MAC Address.

Inventory: Network Tab 

AdHoc Duplicate Query

AdHoc Library

MAC Address Requirements

Services

Service Desk

MAC Address Changes

• The following information was added to the Service Desk Incidents, Orders, and Actions Printouts.
  
  • Equipment ID
  • Serial Number
  • MAC Address
• The MAC Address field on Service Desk Equipment now accepts both formatted and non-formatted MAC Addresses. 

• The MAC Address field is now enabled on the Incident Equipment Form, just like it is on Service Desk Orders and Actions.

• The MAC Address and other identifiers (Equipment ID, Asset Tag) will not be updated on the Equipment Record until the Service Desk Equipment is completed.

Image Modified

Warehouse Actions

Service Desk Equipment 

Incidents 

MAC Address Requirements

Added Service Desk Action User Defined Fields.

• This change renamed the User Defined Fields Tab to Service UDFs on Actions.
• Action UDFs are displayed on the User Defined Fields Tab on Actions.
• Action UDFs can also be displayed on CustomerCenter.

IN-2819

IN-2900

IN-3007

IN-2919 (IN201936593)

IN-2885

IN-2966 (IN201833140)

IN-2966

Completing Unit Equipment that is in a Picked-Up state, no longer displays an erroneous error message that there is no Equipment Available at the chosen Location.

IN-4083

IN-4361

IN-3798

IN-4014

IN-4064

IN-4205

IN-3560

ADD SECOND_CRITERIA_COLUMN VARCHAR(50)

ADD SECOND_CRITERIA_RECID INT(11)

Updates data in the CRITERIA_VALUE column.

Updates data in the CONTROLLER_NAME column.

ADD `AUDIT_THRESHOLD_PERCENT` DECIMAL(18,5)  NULL
ADD `AUDIT_THRESHOLD_AMOUNT` DECIMAL(18,5)  NULL
ADD `AUDIT_THRESHOLD_STATUSDAYS` INT  NULL
ADD `AUDIT_EXPECTED_CHARGES` LONGTEXT  NULL

EQUIPMENT

ADD UNIQUE INDEX EQUIPMENT_12 (`MAC_ADDRESS`)

SERVICE_DESK_CABLING_PIT

SERVICE_DESK_EQP

ADD COLUMN `EQUIPMENT_ID` VARCHAR(100) NULL
ADD COLUMN `ASSET_TAG` VARCHAR(100) NULL
ADD COLUMN `MAC_ADDRESS` VARCHAR(20) NULL

SDA_SERVICE_DETAILS

ADD COLUMN `RATING_GROUP_LISTS_RECID` INT NULL