ITrack/Enterprise/Changelog 2011-01

2011-01-25

EBayExtension

• Added: all of the ebay pages now share a single ebay handler object. This should cut down on memory requirements and cleanup difficulties.
• Fixed: a crash on the ebay screen that would be caused if the user didn't have an up to date settings extension.
• Fixed: a crash on the ebay listings page that could be caused if the user hit cancel on the export dialog.
• Fixed: made a couple export error messages more descriptive.

GlobalSettingsExtension

• Fixed: the support for the ebay extension is now fixed.

2011-01-24

Common Resources

• Releasing an updated version to (hopefully) eliminate a crash associated with the part quick search dialog (F4).

EBayExtension

• (The following change was supposed to be released on 1/3/2011, but the wrong version was uploaded)
• Added: Export to blackthorn feature. the user now has a button Export with a menu to select witch CSV file format to export to. Blackthorn is another third party eBay exporter and auction management tool. ITrack now supports both Blackthorn and Turbolister for eBay exporting.

PartConfiguration

• Fixed: resource conflict crash.

PartModification

• Fixed: Bug 1922, where sending a part from the Search Screen to Part Modification Screen when the user did not have permission to open the PM Screen would cause a hard crash. This was because between trying to open the Screen (OnInitialUpdate checks permissions, gives failure message, stops load) and closing the screen, the OnDataFromSibling() call would be run and try to use uninitialized variables.

Parts

• Fixed: releasing an updated version of the screen to attempt to fix a crash some users were getting when opening the part quick search dialog (F4) (bug 1921).

SalesOrders

• Fixed: an issue reported by Chad@VanderHaags in which saving closed SOs would not check to see if they had been modified since load. Now the modified date is always checked on save.
• Added: when the user reopens a closed invoice, the screen now makes sure that the SO in question hasn't been modified since the last load.

VendorList

• Fixed: when the user performs a search, focus is set to the first result item automaticaly (similar to the customer list screen).
• Fixed: if the user hits the enter button when a vendor is selected in the list, that vendor will be opened or returned to the calling screen. This is so that a user can use only the keyboard when selecting a vendor.

2011-01-20

ITMySQLConnection_d

• Fixed: the database error "Commands out of synch" should no longer be possible. This error was happening to some people while updating ITrack. This should no longer happen.
• Added: some rare queries should complete significantly faster.

Parts

• Fixed: a minor database error that could occur when loading a part with a core item associated with it.

2011-01-19

Database Updates

• Deleted: a couple of old, unused settings if they are present.
• Fixed: the search field "Part Description" has been renamed to the more accurate "Inventory Type Name". Also, its join clause has been updated so that searching this field won't cause an error.

Home

• Fixed: an issue on the work order tab in which master inventory items were getting linked incorrectly (reported by VanderHaags).

Login

• Fixed: (bug 1898) if a location has more than 9 stores, the store dropdown will now be sorted correctly.

MAS90Accounting

• This is an up to date version of the accounting extension. This has been shown to help reduce some crashes.

OptionsExtension

• Fixed: (bug 1898) if a location has more than 9 stores, the store dropdown will now be sorted correctly.

Parts

• Fixed: if an item with a core record is replicated to another store (where the core record doesn't exist), opening that part will no longer report "Unable to load core".

PurchaseOrders

• Added: (bug 1883) if the currently selected purchase order line item is a return line, the PO document it was a return for shows up in the bottom list of the orders info page on the left side of the screen. In this situation, the item will have green text. If an item has been returned on other POs, information about those PO(s) (an item can be partially returned on multiple documents) shows up in the same area in red text. Double-clicking any such lines will open that document.
• Fixed: an issue where the manufacturer code was being put at the start of the vendor part #. This seems to be a holdout from the days of inventory vendors.

SalesOrders

• Fixed: an issue where quotes (SOs that didn't affect inventory) were popping up the 'which parts to sell off of a whole unit' dialog. This now only happens when an invoice is being finalized.

Search

• Fixed: the previous version had references to a feature that is still in development.
• Fixed: an issue where a smart search ending with a \ might cause errors.
• Fixed: an issue where a smart search ending with a */ might cause a different set of errors.
• Fixed: (bug 1914) an issue with the way search modules are parsed. This caused some search modules to find the incorrect # of results.
• Added: the inventory record that is opened when the user double-clicks a vendor catalog record will now be the version of the item at the store they are currently logged into.

Vehicles

• Changed: the setting "Vehicles"->"Vehicles have whole units by default" was set to a user setting. This has been changed to a global setting.

WorkOrders

• Fixed: an issue where a new job might not inherit the shop supplies charge default from the work order type.

2011-01-17

PurchaseOrders

• Fixed: an issue where some smart search modules may not work as designed.

SalesOrders

• Fixed: an issue where some smart search modules may not work as designed.

Search

• Fixed: an issue where some smart search modules may not work as designed.

WorkOrders

• Fixed: an issue where some smart search modules may not work as designed.

2011-01-14

Database Updates

• Fixed: a search module wasn't working right if it was the only search module used.
• Fixed: any cores not showing up on core management due to core status errors on SOs should now be fixed.

SalesOrders

• Fixed: another issue where stocked items with inherent core charges might not show up on core management.

2011-01-11

Master

• Fixed: an issue where version 59 might create the database version function in a way that not all mysql versions support.
• Added: when the update downloader attempts to grab the current database version, it now looks for .f_database_version() rather than just f_database_version. There seem to be situations in which this works better.
• Added: if the ITrack client is unable to retrieve the current database version, the reason for this is reported to the error reporting server. This is to help ISoft track why some updates are being run more than once.
• Added: more information to update.log when database updates are being run for better debugging.
• Added: more information to error reports for failed database updates to help ISoft debug updates being run more than once.

2011-01-10

CoreManagement

• Fixed: the layout of the returned cores tab is now like the layout of the customer cores tab.
• Added: store filter dropdown to the returned cores tab. This filters the list to just those cores being returned into the selected store. This dropdown is limited to the stores the user has the permission "Can view returned cores" at.

Customer

• Fixed: the layout of the pricing tab is now consistent with the other pages on the customer screen. The page now utilizes screen space more efficiently.

Database Updates

• Removed: duplicately named search modules.
• Added: unique key to the search module table based on name so that updates that get run more than once won't re-insert the same module.

DataManagement

• Fixed: an issue where the backup table tree wasn't grouping backups by table name.

Parts

• Fixed: an issue where the core required to vendor checkbox might get set to the wrong value immediately after a part was loaded.
• Fixed: an issue where, if a part was created from the vendor catalog, the assembly model wouldn't be filled out.

Search

• Removed: the purchase date from/through and received date from/through fields.
• Added: a single date dropdown and from/through fields. Now, the user can choose which date they wish to search by (received date/purchase date/teardown date/title received date) and fill out the date range to search by.
• Added: the vendor catalog search tab now has the core pricing levels in the result set.

Vendor

• Added: the core pricing levels are now visible in the vendor pricing property page.
• Added: if the user hits the "Add item to inventory" on the vendor pricing page, it now checks to see if that item is already in inventory. For items at the same store, that item will be opened instead of creating a new item. This solves the very rare case in which one user adds the inventory record after another user opens the screen or a user that hits add twice.
• Added: if the user hits "add item to inventory" and the item already exists at another store, that item is opened instead so that the user can replicate it to the current store.

WorkOrders

• Fixed: an issue where the cost of inherent core lines that were fulfilled through order routing might not get set correctly.
• Fixed: an issue where the tag # column of an inherent core line might be set to just " CORE" if the inherent core line was on a non-stocked part.

2011-01-07

Database Updates

• Fixed: an issue where duplicate permissions could be added to the permission table.
• Fixed: all the data import types should be set up to silently ignore duplicates when doing lookups. Before, these issues would cause a database error something like "subquery returned more than 1 row"

SalesOrders

• Added: SOs now deal with core status appropriately. This will fix issues where returned cores aren't showing up in the returned cores tab.

2011-01-06

Parts

• Fixed: an issue where the core required to vendor checkbox might be checked when it shouldn't be.

2011-01-03

Appraisals

• Fixed: Potential memory leak during normal use.
• Fixed: A reported 'memory leak', which was the connection not being deleted after the connection was closed.
• Changed: Moved to a formulaic version of choosing deviances per appraisal combo. Basically, if you have very few parts, your guess is rather random and might as well include more parts. As you gain more parts, you get progressively lower numbers of included parts, making your estimate more accurate by removing outliers. These assume roughly normal distribution, which is not exactly the case with HTP parts.
• Changed: Origin selector now won't let users choose an origin that didn't have any auctions when it was built.

CoreManagement

• Added: special core management document for sharing data between property pages on the screen.
• Added: when permissions change, the pages will now adjust to them.
• Added: new field called 'core status' to the sales order line and job part tables. This allows items to be marked as either 'N/A' (for normal inventory records) to 'Available' (for unreturned cores) to 'Rejected' (for cores that won't show up anymore).
• Added: The user can discard or reject customer cores. This means that those particular core liabilities will never show up again. This is a way to filter items out of the list that the user knows will never be returned.
• Added: the customer core query now uses the core status column to figure out which cores to show. This makes the customer core query significantly faster.
• Added: store dropdown to the customer cores screen. This allows the user to choose to view customer cores from invoices at a specific store. This defaults to the store the user is logged into. There is also an option that allows the user to view cores at all stores they have permission at.
• Added: new permission that controls what stores a user can view customer cores at.
• Added: when the user hits the return button, it verifies that all selected items are still available according to the core status field. They are unavailable if they were returned by another user since the user loaded the screen or if they were discarded, or if the document they were sold on has been voided or deleted.
• Added: the discard button also verifies that the cores are still available.
• Added: when items are returned, they get deleted from the list. This way, the user will be less likely to try to return something twice.
• Added: buttons on customer cores tab are greyed when they are not applicable.
• Added: the returned cores tab now uses the core status field rather than SKU to decide if items have been returned or discarded in the previous steps. This makes the returned cores query much faster and allows us to ignore items that were discarded.
• Added: hitting the "Inventory" button on the returned cores tab now verifies that the item is still available. This should solve issues where another user has inventoried or discarded the dirty core in question since the user opened the screen. Also, if the invoice the return happened on has been deleted or voided, the item will disappear.
• Added: hitting the "Discard" button on the returned cores tab now verifies that the item is still available.
• Added: inventorying a core marks it as Processed so that it will not show up anymore. Discarding the item marks it as discarded.
• Added: the discard cores button on the customer cores tab now actually discards the selected items. (bug 16, bug 1534)
• Added: confirmation dialog when discarding customer cores.

CrystalReports

• Fixed: an issue where, if usedefaultdb was set to False (so that the printer server was different from the default db server) the username and password were not encrypted in the .ini file.

Customer

• Fixed: (bug 1858) an error that could be caused if the user attempted to add a service unit to a customer record that had not been saved before. This resolves an issue that was transmitted through the error reporting system.

Database Updates

• Removed: duplicate import type fields. Duplicates were causing errors when trying to import for some yards. These duplicates must've been caused by database updates performed more than once.
• Added: unique keys on importtype, importtypefield, and importtypefieldsource so that duplicates will be impossible in the future.
• Added: jobber core to the vendor catalog import.
• Added: 3 new permissions for core management, "Can view customer cores", "can view returned cores", "Can discard customer cores". These control the stores at which the user can use the customer cores and returned cores tabs. These permissions have been granted to everyone by default because they are new.
• Added: core status field to the sales order line and job part tables.
• Added: new permission category "ITrack LX" with new permission "Can login" which controls which users can log into ITrack LX (the mobile itrack handheld application).
• Fixed: a field was named incorrectly in runsheetline. This was causing an error on the deliveries screen.
• Added: the ability to see the readonly sell price class name on the part modification screen (bug 1872).
• Added: made sellpriceclassid visible by default.
• Added: new database functions f_check_user_permission and f_get_user_permission for checking user permissions at the database level. This will probably be employed by various web based applications or other ITrack modules (such as ITrack LX EE or the salesman application).

EBayExtension

• Added: Export to blackthorn feature. the user now has a button Export with a menu to select witch CSV file format to export to. Blackthorn is another third party eBay exporter and auction management tool. ITrack now supports both Blackthorn and Turbolister for eBay exporting.

Master

• Added: ITrack catches win32 exceptions differently (at a higher level) now. This means that exceptions thrown anywhere inside the application should be caught. Before, exceptions in other modules (for example EESearch.dll) wouldn't be caught here and therefore would not be reported.
• Added: support for registering auto-encrypt settings (for host.ini). This allows other parts of the application to register .ini settings as auto-encrypted.

Parts

• Fixed: a reported crash that would happen when the user typed in certain model #'s that caused the model dropdown to change pages.

Search

• Fixed: the model field on the vendor pricing search now correctly clears when the user hits the clear button.
• Fixed: if the user types in a vendor and hits enter, the vendor will now be looked up
• before
• the search is performed.

WorkOrders

• Fixed: (bug 1868) an issue where NEW serial #'s created on a WO would be created at the store of the document rather than the store of the inventory item. This only mattered when creating new SNs for items that were from different stores than the document store.
• Added: Previously, if a serialized work order master part is added to a WO at 0 quantity, the serial # dialog doesn't pop up. Now, if you change the quantity of that item to something other than 0, the serial # dialog will pop up, asking the user to choose a serial #.