(v1) .Previous Releases' Notes v2019.4
- David Engblom
Key
2019
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. | |||
Changed Building Number to Building ID on the Locations grid and the Locations' Address tab. | ||||
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. | IN201832773 | Equipment Import | ||
If the Service Import triggers certain errors, it no longer rolls-back the import lines that were processed before the error occurred. All Imports now commit all changes after each line is processes; if an import aborts for some reason, the lines in the file before the error will stay processed, instead of being rolled back. | IN201833708 | |||
Resolved a number of issues with the Import definition header functionality:
| ||||
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.
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. |
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. | |||
Added Avaya Authorization Code functionality. | Avaya Authorization Codes | |||
CustomerCenter | Added Package Types. | Packages | ||
On the Order Details Form:
| 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. | ||||
Fixed an issue where long Package Descriptions (with line breaks) were causing layout inconsistencies on the Packages page. | ||||
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:
| How To: Scheduling Regular Maintenance | ||
Improvements to Custom Validation 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 |
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. |
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.
| |||
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. | ||||
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:
| IN201833443 | |||
Added the Effective Flag to the following Charge APIs:
| ||||
Added the ability to create the following Action types via the API:
| Users Group | Service Desk Action API | ||
Modified the names and columns for various API tables. | Database Changes in 2019.1 | |||
Now all POST Requests require content in the body of the request. URL String parameters are no longer supported for POST Requests. | API | |||
Added a check to the Services API POST to allow editing a Service with a Formatted Service ID. The API now checks for the Service, removing the requirement that Service RECID be passed via the API Request. Previously the API incorrectly created Duplicate Services. | Services API | |||
Corrected the API Service Charge Error message to properly reference the Service Charge rather than Equipment Charges. | ||||
Corrected an issue with the Service Desk API not filling in all Auth Code Service Details. Added additional fields to Service Desk API | Service Desk API | |||
Updated the API to send proper response codes.
| API Response Codes | |||
Fixed an issue where the GLA API was not properly enforcing required GLA Components. | GLA API | |||
Fixed an issue where the API did not populate Service Location on Remove Action if service is Multi-Location and only has one Location. | IN201834748 | |||
The Service Desk API Change and Remove Actions now allow a Location for a Multiple-Location Service only if that Location is already associated to that Service. The API now returns appropriate error messages for change actions ("The 'location' provided is not associated with the Service." and "This Service has multiple Locations and requires the 'location' parameter.") | IN201834748 | Service Desk Action API | ||
Fixed an issue where the Services API allowed duplicate GLA types of 100%. | IN201935127 | |||
Billing & Charges | The Bill process will be prevented from running if the Bill range overlaps an existing bill. | Bills | ||
Cable | Fixed an issue where the From Equipment Location disappeared on the Cable Maintenance Grid when a pair strand was saved. | IN201935022 | ||
Calls | Fixed an issue where Call Rating would sometimes use the wrong Service Host value for Rating. | IN201832461 | ||
CustomerCenter | Fixed an issue where adding Stand-Alone Equipment to the cart would erroneously cause the system to report that Order Details were missing and prevent the cart from submitting. | |||
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:
| 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:
| ||||
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. | ||||
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 | |||
Fixed an issue causing the GLA Import to fail when trying to populate a GLA Picker UDF on a GLA. | ||||
Fixed an issue where certain types of errors would cause the Cable Full Path Import to crash. | ||||
Service Desk | Added MAC Address to the Service Desk Equipment Form and Service Desk Equipment Picker. | IN201622826 | ||
Fixed an issue where the duplicate Path Leg error message just displayed 'Failed to Save Record'. The error message has more detail to allow the user to correct the data. | IN201834772 | |||
Fixed an issue where the Service ID was not displayed on the Service Desk Cabling Diagram for an Add Action. | ||||
Fixed an issue that caused odd formatting of graphical Cabling Data on print reports. | IN201834904 | |||
Fixed an issue where the Location Picker on the Service Desk Wizard allowed the user to select Inactive Service Location records. |
Database Changes in 2019.1
Table Name | Change | Table Changes |
---|---|---|
APIS | Removed | |
AUTHENTICATION_LOG | Updated | Added AUTH_SOURCE VARCHAR(20) |
BILLS | Updated | Added BILL_END_DATE DATETIME NULL Changed BILL_END_DATE to not allow NULL |
API_KEYS | New | |
API_KEYS_PERMISSIONS | New | |
API_KEYS_USERS | New | |
API_KEYS_USERS_TOKENS | New | |
API_PERMISSIONS | New | |
API_REQUESTS | New |
Additional Information on Hidden Locations
Before this change, if you had a Location record that you hid using the Hide Button on the Location Grid, and you tried to get the Cable Full Path or Location Import to create that Location, you would get an error. The import would check to see if the Location already existed. The check was ignoring hidden locations, treating them like they didn't exist. So, the import tried to create a new Location record and caused an SQL Duplicate error.
After this change, these two imports will notice that the Location already exists in a hidden state. Now the import retrieves the hidden Location record and updates it, so it is no longer hidden. The process will blank out any old information on the Location (from before it was hidden), so it will seem like a fresh new record. The remaining import logic will treat it as a new record and fill in the values as normal. The Imported Records grid will display a line showing a new Location record added.
A consequence of this is that if there were any old Service Orders that referenced this Location, then any details of the Location that were displayed on the Service Order will now show the new Location values instead of the original values. This problem will eventually be solved by the Service Order archiving change.
2018 and older
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:
| 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:
| Accounts ReceivableGLA Account ManagementInvoicesPaymentsPayment BatchesAccount Details | ||
Added Invoice links to the ViewBill. | View Bill | |||
Added new functionality to Invoices:
| Invoices | |||
Added Back Billing:
| ||||
Modified the Email Coordinator Bill Process to use Coordinated Department GLA Permissions, Assigned Department GLA Permissions and Contact GLA Permissions. | IN201833950 | Bills | ||
Added the Fiscal Start and Fiscal Start Next Year values to Tenant Management. | Tenant Management | |||
Cleanup and optimization of the Charge grids. Note: This will likely cause an issue with saved Perspectives on Charge Grids. You may need to rebuild those Perspectives after the upgrade. | ||||
Fixed an issue where Service Orders and Actions were not consistently marked as Billed. e.g. Orders or Actions Finalized In October (with a September Finalization date) and a September 1 - September 30th Billing cycle would not get marked as Billed until the next billing cycle.
| IN201731381 | |||
Addressed a number of Bill Caching issues by linking the Bill Cache to the User's session.
| 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)
| IN201731656 | Service Tabs: ChargesEquipment 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.
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 GLABulk UpdateBulk Update on InventoryCharge CatalogsCharges TabsG/L Account (GLA) CatalogsInventory TabsService 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:
| 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 ActionsService Desk ImportService Desk API | ||
Incident codes are now displayed in Alphabetical order | IN201832233 | |||
The Reference Field on Service Desk Actions is now editable on Remove Actions. | IN201832469 | |||
The Service Desk Labor Grid now displays the Worker Rate from when the Labor Charges were added (not the current Worker Rate). | IN201833925 | |||
Fixed an issue where Finalizing a Remove Action did not always set the correct Stop Date on Charges. | ||||
Services | Fixed an issue where the Call Details tab on custom Phone-Type Services (such as Calling Cards) displayed all calls rather than just the calls for that Service. | |||
Creating a Range of Services (from the Service Grid or Service Pools Form) no longer sets a default for the Bandwidth field. | IN201833945 | |||
It is now possible to add a Call Type to a Service Catalog Expense Object Code. |
Database Changes in 2018.1
Table Name | Change | Table Changes |
---|---|---|
Table Name | Change | Table Changes |
BILL_DETAILS | Updated | ADD INVOICES_RECID NULL DROP COLUMN INVOICE_NUMBER |
BILLS | Updated | CHANGE BILL_DATE DATETIME NOT NULL ADD LAST_INVOICE INT NULL |
BULK_UPDATE_HISTORY | Updated | MODIFY USERS_RECID NULL |
CHARGES | Updated | ADD ALTERNATE_STOP_DATE DATETIME NULL DROP COLUMN MRC_CHANGE_TYPE DROP COLUMN LAST_BILLS_RECID DROP COLUMN PREV_BILLS_RECID |
CHARGES_BILLED | Updated | ADD BILLING_COMPLETE NOT NULL |
CHRG_CATALOG | Updated | ADD BILL_BACKWARD NOT NULL |
EQUIPMENT_CHARGES | Updated | DROP COLUMN CHARGE_PROCESSED |
EVENTS | Updated | Added a new Event for Accounts Receivable to update GLA Account Totals |
GLA_CHARGES | Updated | DROP COLUMN CHARGE_PROCESSED |
SD_NUMBER_CONFIG | Updated | DROP COLUMN FISCAL_YEAR_START DROP COLUMN FISCAL_TOGGLE |
SERVICE_DESK_CABLING | Updated | ADD COLUMN NOTES |
SERVICE_DESK_CHARGES | Updated | DROP COLUMN CHARGE_PROCESSED |
SERVICE_DESK_LABOR | Updated | ADD COLUMN REGULAR_HOURLY NOT NULL |
SERVICES | Updated | DROP COLUMN TECHVIEW |
SERVICES_CHARGES | Updated | DROP COLUMN CHARGE_PROCESSED |
TENANTS | Updated | ADD FISCAL_YEAR_START NULL ADD FISCAL_TOGGLE NOT NULL |
USER_DEFINED_FIELDS_VALS | Updated | Inserted data for Upgrade / Downgrade UDFs on Actions. |
GLA_ACCOUNT_MANAGEMENT | New | |
INVOICES | New | |
PAYMENT_BATCHES | New | |
PAYMENTS | New | |
PAYMENTS_ATTACHMENTS | New | |
PAYMENTS_INVOICES | New | |
PAYMENTS_REMARKS | New |
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:
| 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. |
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