ITrack/Enterprise/Changelog

Release 6.0

Customer

• Fixed: an issue where the user wouldn't be able to delete payment lines for $0 with no invoice association. It was possible to create these but they couldn't be deleted.
• Performance: when a payment is edited, no query is executed anymore for allocations that were not modified. This makes saving large payments on slow connections much faster.

Crystal Reports Extension

• Changed: most of the printing code has been changed to pass reports around in a way that should avoid any issues where a report might get cleaned up before the printing thread used it.
• Fixed: several possible crashes and hangs that could be caused by printing lots of reports very quickly.
• Fixed: if the user launches many print jobs that are waiting to complete, ITrack will now show the correct number of processes waiting to complete if the user tries to close ITrack before the prints have successfully begun.
• Changed: (Case 10612) if the user prints a report with 'advanced options', the printer dialog that pops up now has a quantity field on it, which will be used to override the number of copies to print.

Common Resources

• Fixed: in some circumstances, the thread dialog would crash when running a query (or chunked query) that had an error. This was because launching the error reporting dialog in the thread was colliding with the main UI thread somehow. This is resolved by sending a threaded message up to the main application to show the error at the next opportunity.

Database

• Added: 2 new options to the part modification column list, one for the total cost associated with a vehicle, and another for the vehicle cost that has been allocated (or consumed). This allows users to view more accurate costs when sending whole units to the part modification screen.
• Changed: several database functions have been modified to no longer use a view. This is because some database versions are very slow when views are used within functions.
• Changed: f_move_document_allocations function to make it compatible with the AU tokenizer.
• Fixed: Re-releasing the "Serial #" search module due to an error in the previous release's query
• Added: a fix that should ensure all databases have the Discount, Credit, and Interest adjustment types set to balance adjustments, not subtotal adjustments.
• Added: (Case 10474) A new log that should catch when documents change inventory quantity. This will record the before and after quantity and the documents that caused the change.
• Added: the necessary queries for creating and populating the ebayconditions tables
• Changed: the messagetype column in the message table has been changed to an enum to help mimimize the size and increase the speed of any indices on the field.
• Added: (Case 10518) The FIFO system now properly handles Sales Order re-opens by removing the documents allocations and freeing the inventory source.
• Added: (Case 10518) The FIFO system now treats returns differently. The system will now record the return as a negative allocation and record the credited document, whereas before it would simply delete credit allocations.
• Fixed an issue where a database error was occuring when a part's quantity was changed manually
• Changed: deliverylinehistory.userid is now NULL-able. This is because these records can no be created automatically by the database outside of ITrack.
• Added: (case 9363) recursion protection to all triggers on deliverylinehistory that call f_refresh_document_delivered. This is because, in the case of auto-picking, that function can alter the deliverylinehistory table, causing recursion.
• Added: (case 9363) f_refresh_document_delivered can now create deliverylinehistory records for all unpicked quantity on auto-pick documents. This will help users see who saved a document with auto-picking turned on (and when). All such pick history is created with an empty location, which shouldn't matter because auto-picking doesn't consider these records to count how many have been picked.
• Added: (case 9363) recursion protection to f_refresh_document_delivered because it can insert deliverylinehistory records, which can cause triggers to fire that would call the function again.
• Fixed: (Case 10867) An issue where a database error could occur when there are multiple items on a Sales Order pulling from the same picking location. This had to do with the inventoryid and inventorystoreid not being considered in the calculation of nMaxMoveQuantity.
• Added: the event that optimizes all tables now specifies the database name to avoid any confusion.
• Added: (case 326) tables for handling the new transaction list.
• Added: rank column to documentsearchfilter for ordering.
• Fixed: (case 11123) previously, serialized inventory would only be moved to a destination location if the source location of the move matched the current serial location. Now, this is only enforced if the destination location is Variance. This means that whenever a serial is moved (or found), the serial will be moved, but a serial will only be 'lost' (moved to variance) if it hasn't also been found.
• Added: there is now a category and rank column for both documentsearchfilter and documentsearchfield. These will help us categorize and order the filters and fields on the screen.
• Added: support for filters to have a documentsearchjoinid (optional).
• Fixed: (case 11099) an issue where finalizing, picking and moving all at the same time would move inventory when it shouldn't had.
• Added: (Case 11059) Fixer query to Update.sql to remedy bad log_discreteinventorymove handling in f_move_inventory_with_allocations_post_execute.
• Added: a new permission, which controls whether the user can open the new transaction list screen "Transaction List"->"Open Screen". Everyone who can perform part searches will automatically be granted this permission.
• Added: a new permission, which controls whether the user is allowed to edit/overwrite/delete saved searches created by another user.
• Added: documentsearchsource records now have a defaultaggregatefield, which is the name of an entry in the documentsearchfield table that the totals page will sum up by default.
• Added: documentsearchfield now has a fieldtype column. A fieldtype of Key specifies that a field will always be returned when that document is selected (for lookup and unique document purposes). A fieldtype of singlular means that those values are 1 to 1 with a document and must be aggregated only for unique document keys. A field type of Multiple represents a one to many relationship, which means we can simply add up rows in the results.
• Changed: the permission to open the transaction list now defaults to whether the user had permission to run advanced reports instead of users that could perform inventory searches.
• Fixed: (case 11385) an issue where the query to create f_quantity_on_order_on_document had an error in it.

Ebay Extension

• Added: Expanded TurboLister export information.
• Added: a config page for settings
• Added: a default ebay customer field that will be used when sending auctions to invoices when the email of the buyer isn't in the customer table
• Added: product specific support for the customer tables and the Customer List Screens
• Added: Send to Invoice now works for enterprise thanks to above
• Fixed: a typo with motorcycle default category
• Moved: Category map things to config tab
• Changed: messages to use the right name for the ebay extension
• Added: Users can now choose how pictures are exported via the Config tab
• Added: A warning is now thrown if there is no matching customer and no default customer for an auction being sent to incoice
• Added: small fix for an SQL error that would be thrown if no ebayaccounts are registered with itrack
• Added: Updated some objects to be ready for shipping options
• Added: Direct to ebay is now functional
• Added: config tab now has defaults for required listing information
• Added: edit and template dialogs now have shipping information.
• Fixed: a crash on direct export to ebay
• Fixed: Account edit now populates on first use
• Fixed: a bug where Shipping Service Options and Payment Methods and Return Policy Options didn't get filled in automatically on EE Ebay listings
• Added: zip code to the query so that zip code will be automatically populated
• Fixed: a bug where items where being cleared from the list but not from the ToList list behind the scenes causing items to be relisted
• Fixed: a bug where sending to invoice wasn't calling the correct setting to ask for the default customer
• Fixed: a bug where the default customer edit won't clear if its passed an empty string (this happens sometimes)

ITrack Online

• Added: a message specific to ebay so that we know when the user is done filling out their account info

Login

• Added: a way for extensions that are shared between products to check some permissions. Specifically, this should allow the transaction list screen to properly check user permissions.
• Added: a way for extensions that are shared between products to get user names. This allows the transaction list screen to show user information.

Master

• Added: handling for a new registered window message, WM_REPORT_HEAP_ERROR. This message takes an ITErrorReport* that was declared on the heap and launches an error report dialog for it. This is mostly so that threads without UI handling can report errors without causing thread collisions on the main UI thread. To use this, just copy an error onto the heap and call PostMessage to send the message to master.

Part Modification

• Fixed: many possible crashes that could happen if custom columns were created that do not match the name of any columns in the inventory table (and no associated lookup was stored in inventorysettingjoin).

Parts

• Added: (case 10974) if the user adds or modifies a location on the parts screen, the hold quantity is now refreshed. This fixes an issue where switching a location might leave the hold quantity from the previous location. Now the hold quantity should match the new location name.

Purchase Orders

• Fixed: an issue where the "minus" icon wasn't showing up correctly in the returns dialog.
• Fixed: (case 10409) POs should now load the correct vendor catalog record when there are multiple options to choose from and the PO is to the default purchase vendor.

Sales Orders

• Added: handling for ebay auctions
• Fixed: an issue where, if the user attempted to load a new SO when the existing SO was modified and they hit "Cancel" on the save dialog, the subtotals on the screen would not update again until the screen was closed and reopened.
• Fixed: an issue where sending an item to invoice from the ebay screen might not work right if there were already items on the screen. Also, quantity and currency are formatted correctly in this case.

Search:

• Fixed: (case 8619) the search HTP.net button now links up to the year range, category and keyword functionality of HTP.net searches. The base URL for HTP is no longer stored in the ini file, it is now a global database setting.
• Removed: the car-part search button because it relies on a separate executable that is not deployed with ITrack Enterprise and auto interchange, which is rarely present.

Settings

• Changed: a couple modifications to support an upcoming change to the printing framework.
• Added: the edit->options->reports page now loads the valid list of 'printer types' in the printer type dropdown from the list of all types in use on all reports in the database.
• Added: an external function handler for "ViewDynamicObjectDetail", which is designed to open the appropriate object on the appropriate screen, and is useful for 'dynamic' screens that don't know about how to open objects.

Transaction List

• Added: (case 326) This is a new screen for performing searches against documents in the software. The user can search, save/load old searches, export/print results, and group summary data dynamically. In order to use this screen, the user must have permission.

ITMySQLConnection

• Changed: the maximum packet size used by ITMySQLBlob is now capped at 1MB. This is to attempt to battle the out of memory issues some users have received.

Warehouse Management

• Fixed: an issue where changing the location on the manual count page with the mouse might cause the search to be run twice if any pop-ups appeared.

Release Candidate Change Log

• Release Candidate Notes

Changelog Archives

• Version 5
• Version 4.5
• Version 4.4
• Version 4.3
• Version 4.2
• Version 4.1
• Version 4.0
• Version 3.0
• Version 2.3
• Version 2.2
• Version 2.1
• Version 2.0
• Version 1.4
• Version 1.3
• Version 1.2
• Version 1.1
• 2013-01
• 2012-12
• 2012-11
• 2012-10
• 2012-09
• 2012-08
• 2012-07
• 2012-06
• 2011-12
• 2011-11
• 2011-10
• 2011-09
• 2011-08
• 2011-07
• 2011-06
• 2011-05
• 2011-04
• 2011-03
• No changes for month of 2011-02
• 2011-01
• 2010-12
• 2010-11
• 2010-10
• 2010-09
• 2010-08
• 2010-07
• 2010-06
• 2010-05
• 2010-04
• 2010-03