ITrack/Pro/Changelog Version 18

REVISION 23886-24206 database version 180000

General

• Added: (case FB-55284) support for copy and paste right click options in all list controls. Copy is always allowed, paste is only allowed if the user right clicks on a cell that they can edit.
• Changed: all usage of libcURL from version 7.61.1 to 7.88.1. This update allows all of our HTTPS operations (including connecting to the auto-updater) to support TLS 1.3.
• Changed: all usage of libMySQL from version 6.1.11 to 8.0.27. This update allows connection to the newest versions of MySQL server, as well as supporting TLS 1.3.
• Changed: all usage of openSSL from version 1.0.2 to 1.1.1w. This is used both by the new version of libcURL as well as the new version of libMySQL to handle newer security.
• Changed: all usage of zlib 1.2 to 1.3. This handles compression in mysql and libcURL.
• Fixed: many queries have been updated to escape certain column names that will cause issues when using MySQL 8.

Database

• Fixed: (case 59166) an issue where renaming a part type after it had been used on some number of inventory records, the search keywords on those parts would not be updated to the new part type name.
• Added: (case 60033) some triggers to the payments and invoice tables to try to keep invoice.paid and invoice.invbalance up to date automatically to avoid issues where some users have encountered documents with bad information.
• Updated payment triggers to better keep invoice.paid up to date. Re-running the 'recalculate all' script.
• Changed: (case 60632) reportsubscription and reportsubscriptionparameter tables to be able to handle a scheduled report that will run a query and either email or save it to a directory.
• Changed: reportqueue and reportqueueparameter tables now have a sourcetype and sourcequery columns to handle distinguishing between reports that just run a query and send a CSV or those that run a crystal report and send a PDF. All existing entries with a destinationtype of CSV have been converted to sourcetype Query and have had their query value moved from the reportqueueparameter table to the reportqueue.sourcequery field.
• Changed: the event e_schedule_reports that generates reportqueue records from reportsubscription records now knows how to handle the new sourcetype field. Error handling is now specific to the sourcetype.
• Fixed: some historical updates have been made MySQL 8.0 compatible.
• Fixed: several stored procedures and functions have been modified to be MySQL 8.0 compatible.
• Added: quote.websaleorigin, a new, optional e-commerce field to store what online source spawned a document.
• Hidden: setting that is FPG related since it is no longer used.

Credit Card Processing

• Added: new global setting Integrations->"Credit Card Terminal: submit tax information to gateway" which defaults to False. This disables a feature where local taxes are submitted to heartland payment systems. This does not seem to be load-bearing and causes errors in some tax jurisdictions, so this allows a company to opt in to this feature.
• Fixed: (case 60966) an issue where trailing spaces in a customer zip code might cause the PAX S300 credit card terminal to throw an error.

Customer List

• Changed: in discussions with the Chromium team, it was decided that merging customers should not delete the previous customer but instead deactivate it. This matches the behavior in the web version of the customer list.

eBay

• Fixed: (case 60089) the 'cancel ebay auctions, if necessary' function now no longer shows the message "You do not have permission to cancel ebay listings" all the time. Now it will only be shown if the document had items on a valid ebay auction and the user attempted to cancel those listings.
• Added: (case 60089) support for the 'cancel auction' function to take an argument that allows the calling code to replace the "Remove items from document" button with a "Cancel to correct document" button for scenarios where that makes sense.
• Changed: the 'connect ITrack to ebay' button now always opens in an external browser due to deficiencies in IE.

ITMySQLConnection

• Fixed: (case 53807) an issue where, if a mysql connection was closed due to inactivity or server shutdown, the connection would silently auto-reconnect, but the first query run on the fresh connection would return no results.
• Changed: minor updates to avoid features being deprecated by MySQL.
• Changed: previously, if "usessl" in the configuration was set to False, the connection would stay in "SSL Preferred" mode, which would still attempt to negotiate an SSL connection, if possible, falling back on unencrypted connections. Now, if usessl is off, the connection will not even attempt to establish a secure connection.

Login

• Fixed: the user can no longer get to edit->options before the log in. This was allowed in old versions so they could set up the database connection, but that is now handled in a different way.
• Fixed: the shipping configurations page is no longer editable if the user does not have the Options->Edit permission.
• Removed: support for old, insecure password encoding methodology that we have been moving away from for many years. Updating to support MySQL 8 require dropping support for this insecure password methodology.
• Added: if a user attempts to log in to the application using the deprecated password encoding methodology, they will be shown an error message telling them that they cannot log in this way anymore and must now perform a password reset or contact someone who can reset their password.

Master

• Fixed: an issue where the logout vs close value wasn't being sent correctly. This was causing weird popups in some screens.

Options

• Fixed: a crash that could occur when going to the Options dialog to configure taxes.
• Added: if the user gets a database error when they launch the application they will be asked if they'd like to configure their database configuration. This makes recovering from incorrect installation settings easier.

Parts

• Added: (case FB-52157) there is now a global setting “Parts”->"Allow manual entry of part tag #'s" which defaults to "True". This setting allows an administrator to turn off the ability for users to invent new tag #'s for new or existing parts. The user will see an error popup on save if they change the tag #.

Quotes

• Fixed: (case 60089) an issue where saving a document might show a message "you do not have permission to cancel ebay listings". Now this will only appear if the items are on an ebay auction and the user chooses to cancel those listings. Also removed a button in the popup that did not do anything.
• Fixed: an issue where updating a saved quote would not correctly update the 'last modified' timestamp in the database.
• Added: (case EE-274) support for sending weight, weight unit, shipping dimensions, and shipping dimension units from a quote/invoice to the shipping quote web page.
• Fixed: an issue where the user could edit the controls on the e-commerce tab, though those values wouldn't save. Now they are read-only
• Added: (EE-458) support for a new web sale origin field from e-commerce partners so that a salesman can know what online partner spawned the document. If it is not filled out, it will fall back what website the record came from.
• Removed: support for FPG shipping, as they have disabled their API cutting off the integration. Sadly this means that support for FPG has had to be removed.

Sales

• Fixed: (case 60089) an issue where saving a document might show a message "you do not have permission to cancel ebay listings". Now this will only appear if the items are on an ebay auction and the user chooses to cancel those listings. Also removed a button in the popup that did not do anything.
• Removed: the explicit handling of lastmodified from the sales view so that, for consistency, the database can handle it.
• Fixed: (case FB-51065) re-ordering the lineitem list (and doing nothing else) will now properly trigger change detection, allowing the user to save that item order.
• Added: (case EE-274) support for sending weight, weight unit, shipping dimensions, and shipping dimension units from a quote/invoice to the shipping quote web page.
• Removed: support for FPG shipping, as they have disabled their API cutting off the integration. Sadly this means that support for FPG has had to be removed.
• Fixed: (PRO-61) an issue where the customer balance figure would not be loaded onto the screen in some circumstances when the customer was loaded onto the screen.

Search

• Fixed: an issue where choosing a model with a forward slash or back slash in its name might not correctly show interchange options to choose from.
• Fixed: an issue where the user might get a mysql error if they entered a part type #, year, or model with quotes in it when doing an interchange option search.
• Fixed: (case FB-55043) an issue where searching vehicle models with a blank series would find inventory with any vehicle model that also has a blank series. Now blank series models are not allowed to 'interchange' in that way.

Settings

• Changed: new users in the Pending Activation stage now default to a password encoding of PBKDF2 to avoid the (soon to be deprecated) MySQL Password option.

Shipping Integrations

• Changed: the code that gets the company login token is now shared between EE and Pro. So now both products should correctly set an 'initial' SAV token in settings if one is not found. An override set in settings will override this functionality.
• Removed: support for FPG shipping, as they have disabled their API cutting off the integration. Sadly this means that support for FPG has had to be removed.

Reports

Default Billing Statement (Billing.rpt)

• Added: (case 59873) remittance address in place of standard address, when present.
• Changed: (case 60190) report can now handle the existence of multiple stores without duplicating results. New hidden store parameter controls which store address prints and does not filter report results.

Default Invoice (Invoice11in.rpt)

• Added: (case 59384) company email address. company phone moved right to make room.
• Changed: (case 59872) replaced company address with remittance address when present (not NULL, not empty string)
• Changed: (case 60959) fixed an issue that made the payments section appear on invoices with no payments.

Purchased Vehicles (PurchasedVehicleReport.rpt)

• Changed: (case 42603) Cost to total cost and clarified field names.