ITrack/Enterprise/Changelog Version 38

Revision 24037-24206 database version 3800

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

• Removed: an unused field from the job template table to avoid confusion.
• Changed: (Case FB-26062) if the document type is Manual Inventory Adjustment, allow non-deplete inventory to change their quantity. Otherwise the locations and the QoH get out of sync and the user can't change quantity on the parts screen for non-deplete parts.
• Added: f_purchaseorder_total function so that its easier to grab PO totals when displaying them.
• Added: (case FB-9678) foreign keys to all non-log tables that have a glcategoryid column. This way, if a gl category gets deleted in any way, all 'invalid' values will be set to NULL, preventing invalid gl categories from messing up accounting exports.
• Added: EE-306: PO and SO Adjustment descriptions as display fields in Transaction List
• Fixed: (issue CS-290) added an index to the salesorderline table to make lookups from eBay that want to check if an auction "needs invoiced" fast.
• Fixed: (issue EE-397) missing permissions on customer databases
• Added: EE-445: Add Vehicle Bid Vendor, Vehicle Bid Amount filters to the Transaction List for the Vehicle Source
• 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.
• Fixed: (CS-1299) an issue where a customer could get a divide by zero error in some corner cases when order routing non-depletable items
• Hidden: setting that is FPG related since it is no longer used.
• Removed: several permissions that were FPG related since they are no longer used.
• Added: several foreign keys to the userpermission table.
• Removed: a ROW_FORMAT value on a table that could prevent conversion to mysql 8.0.
• Removed: an unused setting that was renamed several versions ago, it should be safe to delete now.
• Added: audit logging to the important purchase order and transfer order tables. This will assist in debugging any issues users have with changes to purchase or transfer orders.
• Fixed: a minor issue in the update script where a comment was being run as a query.

Accounting

• Fixed: an issue where the 'export to sage50' button wasn't working correctly if the current filter's date range was unbounded. Now, all visible data will be exported correctly. Added better feedback in the popups to tell the user how many file(s) were created.
• Fixed: an issue where tabbing off of some of the buttons might cause a screen refresh unnecessarily.

Customer List

• Fixed: an issue where the assess finance charges dialog would not limit the invoice results to the selected terms.
• Fixed: a memory lead when loading invoices, which could lead to slowdowns over time.
• Changed: the assess finance charges dialog now uses a shared due date calculation system used by reporting.

Deliveries

• Fixed: an issue where the deliveries screen could crash the application if the user clicked into the truck dropdown on the run sheets list.

eBay

• Changed: the 'connect ITrack to ebay' button now always opens in an external browser due to deficiencies in IE.

Home

• Added: (case FB-44090) the purchase orders list now has a total column, with a sum at the bottom.

ITMySQLConnection

• 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.

Locations

• Fixed: (FB-22777) if the user gets a query error due to too long of a location during save, they will now see a user friendly error message.
• Added: (FB-22777) before attempting to save, the location system will now compute the full location string for each item in the tree. If this value is too long to save, the user will be shown an error message telling them which location(s) need modified and save will be aborted.
• Added: full locations are computed and set before save, making save operations faster.

Login

• Changed: user creation now allows user names up to 320 characters in length to facilitate logging in using email addresses, which can be quite long.
• 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.
• Fixed: (EE-463) a typo in a 'first time user signup' popup.
• 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.

Sales Orders

• Changed: the document terms dropdown has been moved into the 'payment' area.
• Fixed: an issue where the 'expiration date' label might not correctly disappear when the date picker was hidden.
• Added: a new field "Payment Due Date" which is calculated based on the currently selected terms and the current document date. This should match any due date shown in the Assess finance charges dialog and reports. If no terms are selected, payment is due on the document date.
• Added: (case FB-35782) there is now an attention icon in the sales order list that shows up if the item is a return. Hovering over this icon will tell the user what document is being returned, and doubleclicking the icon will open that document on the screen.
• 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.
• Changed: minor adjustments to default column widths to make the experience better for new accounts.
• Changed: (FB-7062) if a loaded customer has $0 pricing, it will correctly set items' prices to $0. Previously, $0 customer prices were ignored, and the previous value would be kept.
• Fixed: a minor bug where inherent core charges on items sold on ebay would show the attention icon for "not enough quantity to fulfill auctions"
• 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.

Search

• Fixed: increased the very small default values of the sidebar widths to make the experience better for new accounts.

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.

Vehicles

• Fixed: (issue CS-726) where loading a vehicle might set the model to blank instead of loading the correct vehicle model, but only if a model existed with a blank name.
• Fixed a minor incorrect phrasing in a popup after a VIN decode where a model issue would actually be labelled a make issue.
• Fixed: a minor issue where vehicle teardown lists would not load if the vehicle whole unit (inventory) record had been set to status D or C. Component parts that are C/D are still hidden from a teardown, but if the whole unit itself is status C, the teardown will now show up.

Vendor

• Added: the gl category field is now bolded if the field is required to save, matching other screens with required fields.
• Added: the gl category field is no longer a required field if gl accounting is turned off.
• Added: a new setting "Default vendor GL category", Default: "New Parts" which controls the default gl category for newly created vendors.
• Fixed: an issue where vendors with no GL category saved might show one on load.

Warehouse Management

• Fixed: (case 61559) an issue where 'In Transit' serials didn't correctly show as 'on hand' in the store like they do on the parts screen.
• Fixed: (case FB-11427) non-countable locations were showing in the dropdown for locations to do a manual count at. They are now excluded.

Work Orders

• Fixed: an issue where creating a 'new' serial on a WO master part would not correctly load the serial 'defaults' from the part if it was the first serial on the SKU.
• Fixed: an issue where manufacturer/model specific Q&A options would not show on 'new' serials on the WO master part until the user saved and reloaded the WO. Now they'll show up immediately.

Reports

Billing Statement (Billing.rpt)

• Fixed: (case EE-219) OIA subreport for the corner case where payment customerid does not match SO customerid

Parts Change Log (ChangeLog.rpt)

• Added: (case 59446) a new report showing changes made to parts and the user who made the change

External Work Order (WorkOrderExternal.rpt)

• Added: (case 61722) memo and a new store setting for memo
• Added: (case 61722) a new store setting for using html markup on memo
• Added: (case 61722) signature lines and a new store setting for whether or not to include new signature lines

Inventory Count Sheet - LXW (InventoryCountSheetLXW.rpt)

• Fixed: (case EE-161) Updated query to make the report match the screen. In-transit serials are treated consistently between the screen and report.

Labor Log By Employee (LaborLogByEmployee.rpt)

• Fixed: (case FB-61587) row duplication possibility on getting user group and work order master parts
• Fixed: (case FB-61587) user filter
• Added: (case EE-312) additional summary options

Sales By City And Customer (SalesByCityAndCustomer.rpt)

• Removed: (case 61678) deprecated the report, functionality has been absorbed by Sales By State report

Sales By County City And Customer (SalesByCountyCityCustomer.rpt)

• Removed: (case 61678) deprecated the report, functionality has been absorbed by Sales By State report

Sales By State (SalesByState.rpt)

• Added: (case 61678) a state filter
• Added: (case 61678) the ability to group by State, State & City, or State & County

Sales Order (SalesOrder11in.rpt)

• Changed: (case EE-187) number format conditionals on quantities to allow for more digits. Decimals will no longer show when there aren't partial quantities present.
• Added: (case EE-235) a new setting to show completed job tasks on job lines
• Fixed: (case EE-219) payments, etc subreport for the corner case where payment customerid does not match SO customerid
• Added: (case EE-457) French mode will now display "Facture" instead of "Invoice" and "Internet Sale" unless disabled by setting. Only these two salesorderdocumenttypes are affected.

Sales Order Returns (SalesOrderReturn.rpt)

• Added: (case EE-165) the ability to toggle how store filtering is handled
• Changed: (case EE-165) minor report overhaul and cleanup

Pick List (PickList.rpt)

• Added: (case FB-61616) store location sorting when needed

Unbalanced Sales Orders (UnpaidSalesOrders.rpt)

• Fixed: (case EE-162) balance issues in corner cases where payment document has a different customerid than the associated SO
• Changed: (case EE-162) aesthetic improvements

Work Order Tag (WorkOrderTag.rpt)

• Changed: (case FB-61681) major report overhaul to look better, not have fields that could vertically stretch the report beyond the size of a tag, and work with work order master parts when desired in addition to customer units

V38.1.0 (1/15/2024)

Sales Orders

• Added: (EE-513) when we retrieve third part tax quotes or register tax invoices, sales order id, sales order line id, and inventory ids will now be send to the API, when the items in question have been saved previously. This allows compatibility with external tax systems that require an ERP document number.

Work Orders

• Added: third party tax quotes updated to match the changes to the SOs screen.

V38.1.1 (1/15/2024)

Shared Controls

• Fixed: a potential crash that could occur when modifying visibility of 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.

Part Configuration

• Fixed: (EE-416) the inventory options area of inventory types tab now respects the 'can edit inventory types' permission.
• Added: the ability of the user to sort/reorder the Q&A lists is now disabled based on the permission to avoid being able to modify and save sort order.