ITrack/Pro/Changelog Version 19

REVISION 24207-24809 database version 190000

Installer

• The installer has been rebuilt and modernized. Unnecessary dependencies have been removed, and some components updated to newer versions.
• Added uninstaller
• Uninstallation now removes install/release key
• Removed instantVNC
• Fixed: downloading TSC_Lastest tag printer installer now works again
• Added: blat.exe is part of the base installer file shared between the desktop installers. This is because although this file (which is a command line emailer application) is generally assumed to be downloaded from the auto-updater, some anti-virus applications fail to do so, and this blocks the ability to undergo password recovery.

Database

• Added: new zip codes
• Fixed: the dashboard query for line_sales_over_time_and_previous_period no longer has "GROUP BY DESC"
• Update: the wa_quote view to include the new websaleorigin quote column
• Added: (PRO-68) several new part types to the stock part type list based on new part types being added on heavy truck parts.net.
• Fixed: an issue where partuse.used could be NULL. Any NULL values have been changed to False, and the column no longer allows NULL.
• Fixed: a query released in the previous version had a conflict with the state of live customer databases, so correcting that query and re-releasing it for any customers who have already updated.
• Added: (PRO-73) add a nightly event, adapted from a similar event in ITrack Enterprise. This event will look for any quotes that expired in the last week and cause binlog entries to be created so that anything following the binlog will be forced to recalculate
• Added: logging triggers to dashboard tables
• Fixed: an issue where deleting a payment might not cause invoice.paid or the invoice balance to recalculate correctly.
• Added: various columns in the partuse table now have a comment to note that they are deprecated and unused.
• Added: quickbookslog has been deprecated, as it appears to be unused by desktop. It will be dropped in a future version.
• Dropped: several report backup tables created in 2017
• Removed: several unused tables (user_session, vehiclesearch) and deprecated an unused table espmodel.
• Removed: inventory.global.
• Fixed: f_adjust_inventory function to properly account for replenish and deplete flags
• Fixed: an issue where lineitem.bodystyle and qline.bodystyle were not the same width as inventory and invmaster.bodystyle. Now they match and this helps avoid any query errors.
• Deprecated: the decodeexec table, as it was for keeping track of 16 bit executables that cannot be sources or run on modern operating systems. This will be removed in a future version.

Controls/Tools

• Fixed: a potential crash that could occur when modifying visibility of a button.
• Fixed: a potential crash when modifying the icon on a button.
• Added: support for easily toggling sorting and/or drag and drop on and off on a list control since in some places, sort order can be saved, and therefore must be disabled when the list is read only.
• Fixed: (EE-237) a subtle and rare bug that could cause a tree control with a footer to sometimes be shorter than it was supposed to be. Changes from the list control from 2018 have been adapted to the tree control to bring the two in line for their behavior.
• Fixed: an issue where some popups would not be tied to the application correctly. This meant that the user could sometimes use alt+tab to access the application still even though a popup was present. This also fixes an issue where auto-refresh timers were not being halted while these popups were visible. Now they will pause correctly.
• Changed: the way popups center on their parent window now works in a way that doesn't require breaking how popups are tied to the application.
• Added: email via MAPI error message support. Now, if an email fails to send, the popup will have an error message as well as an error code.

Configuration

• Added: (EE-141) the system will now close all historical user sessions if a user is locked or deactivated.

Crystal Reports Printing

• Added: print jobs now have a title set based on the user friendly name of the report, plus a file extension. Testing revealed that this causes some PDF printers to name the default file equal to this title, making printing to PDF slightly easier.
• Fixed: (PA-562) the edit->reports page file upload dialog now shows an error box if it failed to read the file in windows.

Customer

• Added: the 'tax expiration' field now has a check so that the user can remove the tax expiration for a customer.
• Changed: the tax expiration field now defaults to unchecked.
• Added: change detection on the tax expiration field now works if that is the only field being changed on the screen.
• Fixed: an issue where the advanced tab and the customer units and service tab were not resizing to use up all the space correctly
• Fixed: (PRO-89) a possible crash that could occur when changing units.
• Fixed: an issue where a change to a unit service row might not save if the user immediately changed unit selection
• Fixed: an issue where clicking on and off a unit repeatedly would keep adding new service rows
• Fixed: an issue where the 'new' unit and service row didn't always stay at the bottom of the sorted list.

eBay

• Added: when retrieving transactions from the API, we now request the 'containing order' information. This allows us to know if the invoice has been cancelled.
• Changed: the transaction status column now pulls from the containing order. This allows display of Cancelled or in the progress of being cancelled as a status.
• Added: the transactions list now shows status in red if the transaction has been cancelled so that the user knows why it doesn't need to be invoiced.
• Added: the transactions list now shows the items with different background colors based on status, similar to the auction list.
• Added: the transactions list now shows the document # field in Green if it has not been invoiced yet, but the purchase is completed.
• Changed: loading auctions now considers ebay transactions that are Complete or Completed only when counting how many have to be invoiced. This will exclude items that are cancelled, in progress, or being cancelled.
• Added: (FB-54488) a new checkbox to "Remember this Category as the default for part type XXXX" to the edit listing popup. When checked, the user's selected category will be saved in the database for future listings.
• Removed: a deprecated field according to ebay documentation.
• Added: support for a new tag when building listing, "Side".

Interchange

• Removed: references to the now deprecated decodeexec table. This seemed to be part of an old system of 16 bit executables that ITrack could run to decode some serial numbers of specific types, but they could not be sourced or run on modern copies of windows, so the feature has been removed. The dropdown on the screen still has the options for decoding options that read from ITrack directly.
• Changed: the VIN decode option now uses the shared VIN decoder dialog from the rest of the software, improving its functionality.

ITMySQLConnection

• Fixed: a minor issue where, if ca-cert.pem is completely missing, requiring SSL might not throw an error when connecting.
• Added: comment /*RECONNECT QUERIES CHANGED FOR CONNECTION "X", RUNNING NOW:*/ to the start of the queries run by mysql every time we reconnect to the database.

Master

• Changed: suppressed a database error that could be thrown from help->about if the database did not have a version in it.

Part Configuration

• Removed: references to a "read-only" flag on part types. This was not used and somewhat unhelpfully labelled "RO" on the screen.
• Renamed: Used to Active to more clearly denote function of the column and match Pro Web.
• Removed: the unused 'Core' field from the part type configuration area, as this field is not in use. It was probably an early prototype of the model/category core default pricing.
• Removed: some unused fields in the part type management area. The assembly, tag type, and tax code fields were all unused, and have been removed from the screen so that they can be removed from the database in the future.

Parts

• Removed: reference to unused field inventory.global

QBToolkit

• Removed: references to partuse.usecorecharge. It appeared to be unused, and removing references to it allows us to remove the unused field in the future.

Report Viewer

• Added: (EE-164) the user can now see the "Delayed until" column in the print queue history tab. In addition, there are now filters for all job statuses and a filter to display only jobs with a delay until date.

Sales

• Removed: pick column, which didn't do anything

Settings

• Added: The configure->settings dialog now refreshes global and site level settings when the user visits this page. This should help avoid issues where the user sees 'old' information in this popup that was changed by another user or in the database directly.

Vehicles

• Fixed: when a cost is sent to a PO, the purchase order is now created with a status of NEW instead of VOID.
• Fixed: some issues with VIN decoding. This is now compatible with the new, online VIN decoding system.
• Added: a VIN lookup button that uses the shared VIN Lookup dialog that shows VIN decoding results in real time as the user types a VIN. This dialog was recently shared from ITrack Enterprise and contacts the ITrack online VIN Decoding service, which is a faster, shared VIN decoding solution that returns more information for most VIN Decode requests.

Vendor

• Fixed: the POs list was always quite small whenever the user reopened the screen.
• Added: the size of the PO list is now remembered per user based on what they set it to last time, it now defaults to a much more reasonable size.

Vendor List

• Fixed: Changed the vendor merging code so it doesn't delete the other vendor, but instead just marks it as inactive

VIN Decoding

• Notice: the VIN Decoding library being used in the background has been changed from VIN Power to the online NHTSA VIN Decoder, which generally seems to return more information. This will also avoid issues every December with difficult rollout of licensing updates. VinPower licensing will be supported in ITrack Pro and ITrack Enterprise up through the end of 2025, at which point, users must update to a version of ITrack that switches over to online VIN decoding or lose access to VIN decoding entirely.
• Added: VIN Decoding displays more information per decode (though many fields are still blank on the average decode).
• Changed: VIN information is broken into more categories, and the dialog has been made taller to accommodate this.
• Added: compile dependency so that downstream dependencies will link now that we use curl to communicate over the wire.
• Changed: ITVinPowerHandler has been rewritten to use our online vin decoding micro-service deployed to GCR.
• Added: VINLookupDialog now resizes to use all the horizontal space.
• Changed: VIN Lookup dialog no longer shows a year of 0, instead blank will be shown.