ITrack/Enterprise/Changelog Version 42

Revision 25118-25317 database version 4200

Highlights

• QuickBooks Online Support! You can now choose which of the accounting exports are enabled (Sage50, QB Desktop, QB Online), and based on that various controls appear or disappear. Use the new QuickBooks online export dialog on the shared QuickBooks journal export page to create export file(s) that can be imported into QB Online.
• Fixes for recent Microsoft bugs. Recent Windows11 updates have caused blurriness inside multi-line input controls, but only when they're inside a property page (tab). This seems to affect all historical versions of our applications. We've narrowed this down to Microsoft's ClearType technology. We've had to selectively disable this feature on these boxes.
• Internal Browser Updated! All the browsers inside the application have been updated from Internet Explorer to MS Edge. This upgrades the security and modern web support of our web browsers.
• Work Order job template lines now remember what line they were created from, even if you replace the inventory record on the line. This will allow future reporting on what exact inventory you use on your job templates, even if you have 'placeholder' inventory records.

General

• Fixed: an issue where looping across reports to update had a bug in release mode, causing a query error.
• Changed: the application is now explicitly not High-DPI aware. On some systems this helps to ensure that ITrack looks correct when windows scaling is above 100%.
• Fixed: audited every file for dialog font settings and standardized on MS Shell Dlg, which seems to be an alias for the operating system's dialog font, which seems to resolve to Microsoft Sans Serif(8). This was previously mixed with MS Sans Serif, which resolved correctly on some machines but not others, resulting in missing fonts, leading to some inconsistent looks on some windows 11 machines.
• Fixed: minor improvements to the choose folder dialog and some error reporting messages.
• Added: propert pages (tabs) now automatically change the font any multi-line edit controls when it initializes, overwriting the operating system preference for ClearType and turning it off. This is because a recent windows update now causes weird blurring to occur in multi-line edit boxes inside of property pages. Its still unclear why Microsoft did this.
• Fixed: an issue where the background of a property page would not be the correct style if it did not contain a static text area or a button.

Installer

• Added: (EE-1039) the version of ODBC packaged in the installer has been updated to be 8.0.27. This is the newest version that supports TLS 1.3 that still supports old TLS 1.0 and 1.1. This allows us to support a wide range of server security protocols.
• Fixed: the uninstaller now removes ODBC entries.
• Fixed: an issue where the ODBC registry entries were written to "SOFTWARE\WOW6432Node\WOW6432Node\ODBC" instead of "SOFTWARE\WOW6432Node\ODBC". This didn't seem to interfere with operation, but it isn't technically correct. This seems to be because it was a 32 bit installer.
• Removed: the (now) unused Microsoft redistributable package 2013, which was only included for ODBC 5. The new version uses the shared 2015-2022 package.

Database

• Removing Unused interchangesearch table
• Added: dashboard chart/report unique keys and data source name. As well as some initial dashboards loading data from google big query.
• Add a unique index on dashboardchart.name
• Updating chart logging triggers again now that we have the data source name column.
• Added: several new dashboard related permissions
• f_create_location has been renamed to f_location_import for consistency and p_location_import has been merged into it. Generally this is only used during importing, and the function is easier to use.
• Updated: minimum MOTD height to better fit the size of the page
• Added: internal comments for quotes and sales
• Changed: the description of a purchase order permission to more clearly match its function.
• Added: Transaction list join and filter that allows the user to view a list of only sellable locations an inventory record is stocked at.
• Fixed: an issue where inventorying a new core bank would create the record with a user status of C even if that is not a valid user status on the system.
• Added: (EE=1059) schema for jobpart.jobparttemplateid to allow jobparts to optionally remember what template line they came from. Also added an initial attempt at retroactively setting this information on historical records.

Accounting

• Added: better error reporting when a very rare sales order accounting bug occurs.
• Added: on the configuration page, the user can now specify whether they wish to be able to export to Sage50, QuickBooks desktop, and/or QuickBooks Online. Toggling these settings will show/hide various export areas.
• Added: the "QB Journal Push" page now only throws error popups about QB desktop if the system is set up to export to QB desktop and no QB online. Otherwise, the errors are suppressed.
• Added: the ability to export one or more selected days to CSV files to import into QuickBooks online, according to their journal entry import format. This requires that all accounts already exist in QB Online.
• Added: the user is now alerted that the "Verify AR/AP customer account" function is not supported in QB online, but they can still type an account name in, it must simply be entered into QB online manually.
• Changed: the synch QB accounts page is now only visible if the user has "QB desktop" integration enabled, it is hidden for QB online integrations only.

Customer

• Removed: (EE-1066) until options save an order in the database, the user cannot sort them.

Home

• Changed: the links on the MOTD home page to always open in an external browser. This makes some of the contact us links work even if the user prefers an internal browser.
• Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

Graphing

• Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

ITrack Online

• Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

Interchange

• Removed: unused exact interchange search box.

ITMySQLConnection

• Added: support for some more specific SSL configuration errors when the user has a SSL path set, but it is incorrect. The user is prompted to go into the configure connection settings page to fix this.
• Added: the configure database connection popup now lets the user configure the "Use SSL" checkbox along with the directory to find the SSL certs and the (optional) prefix for the cert and key.

Inventory Overview

• Fixed: issue with the help prompt at the top of the choose vendor list popup not being readable.

Part Modification

• Added: (case EE-1005) focus on adding parts from search selecting a column to tab from.

Purchase Orders

• Fixed: (case EE-1005) focus on adding parts from search not selecting a column to tab from.

Transfer Orders

• Added: (case EE-1005) focus on adding parts from search selecting a column to tab from.

Vehicles

• Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

Vendor

• Removed: (EE-1066) until options save an order in the database, the user cannot sort them.

Sales Orders

• Added: better error reporting when certain accounting errors occur.
• Fixed: (EE-1034) an issue where inaccessible columns could be unhidden.
• Fixed: Case (EE-1033) Tax not getting saved when AUTOMATIC CALCULATION is selected as the tax item.
• Added: (case EE-1005) focus on adding parts from search selecting a column to tab from.
• Fixed: (Case EE-1063) Sales order tax integration not sending description + taxable flag in query.
• Fixed: New Lines being out of synch for tax quotes.
• Changed: Dates not triggering tax quote check.
• Fixed: an inconsistency with the description on the first line of a sales order having the default string as its backing data
• Fixed: an issue where the screen could hang loading too much inventory information if the user got a shipping quote on an empty sale.

Work Orders

• Added: (EE-1059) when the user creates a job from a template, the job parts now 'remember' what template line they were created from, even if the user replaces that item with a new inventory record. This allows templates with 'placeholder' items to trace continuity through to final usage in reporting.

QuickBooks

• Fixed: a crash that could occur if you chose to click push to QB Desktop but it wasn't configured.
• Fixed: transaction number now counts up in QBO export files.
• Added: the QBO configuration popup now has settings for "Use account #'s", "use sub-account #'s", "Put GL department into QB Class, "Put GL store into QB Location", and all of these are stored in global settings.
• Fixed: a bug with the format of the QBO export file.
• Added: Browse... button to the QBO config popup where the user can choose the export directory. Previous location is remembered per user.
• Added: a help link to the QBO config popup that takes the user to a wiki article explaining the export/import process.
• Added: quickbooks online push now uses the current date as the transaction id to avoid duplicate transactions.
• Added: quickbooks online now has a field for a default customer and vendor account to tie to AR and AP transactions, respectively. The transactions need to have "Accounts Receivable"/"AR" or "Accounts Payable"/"AP" in the name exactly to be matched.
• Added: Journal entry push area now hides the customer sync and desktop push button if the QB desktop integration is disabled. Also, the "X/Y" synched to QB column in the tree is only visible with the QB desktop integration.
• Fixed: an issue where QBO would import an empty line at the end of a journal entry import file.
• Removed: "Imported From ITrack" journal entry description. The Journal entry memo should be sufficient.

EE Reports Change log version 42

Reports

REVISION 25137–25386

Inventory Count Sheet - LXW (InventoryCountSheetLXW.rpt)

• Fixed: (EE-1038) report results order to match the screen.

Posting Report (PurchaseOrderPostingReport.rpt)

• Removed: (case EE-895) old show locations setting
• Added: (case EE-895) 2 new show locations settings

Ordering Group Quick List (OrderingGroupQuickList.rpt)

• Fixed: (no case) a hard-coded reference to database "itrackenterprise" which doesn't work on some customer databases where their database name is something else.

Sales Order (SalesOrder11in.rpt)

• Added: (case EE-1035) 2 settings for short header text options

v42.1.0 (10/27/2025)

This update solves several major issues introduced by Microsoft in recent updates to Windows that affect how common controls display. Namely 2 issues:

1. large edit boxes get blurry on tabs. (Technical info: a windows update to ClearType Font rendering seems to have caused multi-line edits in property pages to stop redrawing correctly):
   
2. Editable fields look read-only on tabs after recent windows update:
   

The following improvements have been made to the look and feel of the ITrack controls as well to match the Windows 11 control themes:

1. Editable dropdowns now show the themed blue border when the user has clicked 'in'
   
2. Editable text in list controls now show the themed blue border when the user has clicked in
   
3. Editable dropdowns in list controls now show the themed blue border when the user has clicked in
   
4. Multi-line text fields in list controls now do much better about 'growing' correctly to fit the text to display to the user.
   

In addition, there are the following fixes:

1. The accounting screen was throwing an error about being unable to load the sales order erroneously. This was preventing saving finalized invoices.