ITrack/Enterprise/Changelog 2011-10

2011-10-04

CoreManagement

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

CreditApproval

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

Database Updates

• Added: as per bug 2137, distributor prices have been added to vendor price class.
• Merged: all the new tables and functions created in the 'database images' branch have been merged back into trunk. This is to prepare for ongoing merging of this functionality.
• Added: the file table now has a 'Report' type option.
• Added: the report table now contains a fileid and version field. This will be used for reports in the database and more specific report updating.
• Fixed: purchase order lines with positive quantity now show up as pickups while negative quantity PO lines show up as deliveries.
• Renamed: several setting values to match the new value being looked for in the software
• Added: by user request, the inventory pricing function now uses higher price levels as a replacement for missing ($0) price levels. For example, if a customer is supposed to get jobber price, but an item doesn't have one, wholesale price will be used instead (or retail if wholesale is 0), etc.
• Added: new database utility function, f_copy_grant_permission, which simply gives everyone the same access level for permission B as they had for permission A. This works both for individual user permissions and group permissions.
• Fixed: v_deliverable_transferorderline and v_pickable_transferorderline now properly join inventory on using the source store id rather than the destination store id. This will fix issues where part # or location might not show up.
• Added: many new permissions to the vehicles screen. These permissions cover each of the tabs on the screen, as well as one that controls the status fields specifically (bug 2191). All these permissions have been granted to anyone who could edit parts.

Deliveries

• Added: as per user request, "Pickup" delivery lines now show as dark red in the deliverable items list.

GlobalSettingsExtension

• Added: there are now checkboxes on the screen for the user to enable/disable different setting types. For example, all "Interface history" settings are hidden by default, because they aren't really important to see. This will make managing settings much easier.
• Added: there is now a column that displays the setting type. This allows the user to quickly discern which items are important to configure.
• Changed: the "Product Code" setting has been renamed to be more human readable, and is now marked as an important configuration.

Home

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

InventoryOverview

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

ITMySQLConnection_d

• Fixed: an issue where large files being saved to the database might not properly get escaped.

ITSQLFramework

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

Login

• Added: the 'Hide inactive users' checkbox is now available and working. It defaults to checked, but the last chosen value is now a user setting.

MAS90Accounting

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

PartConfiguration

• Fixed: an issue where the user's store was being retrieved from the wrong location.
• Fixed: an issue where the default category column was not populated with the appropriate choices for each model.
• Fixed: the inability to add new model pricing levels for categories that didn't have one.
• Fixed: an issue where model/category pricing levels' notes were not being saved.

Parts

• Fixed: an issue where assembly parts were created with non-0 quantities.
• Fixed: an issue where performing an assembly breakdown didn't show any components.
• Added: as per user request, the back button goes to the last part, and the forward button goes to the first part if nothing is currently loaded. IE, the arrows now 'wrap around'.
• Added: distributor prices now pay attention to price class distributor price multipliers.
• Changed: the various used parts cost markup settings have been moved from CompanyInfo to Parts and are now named more human readable things.
• Fixed: an issue where having a used parts cost markup breakpoint of 0 or "" would cause these values to not be used.

Payment Entry

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

PurchaseOrders

• Added: all calls that check for settings' values now properly have a setting type. For example, 'Preferences', 'Important Configuration', 'Interface History', etc. This will make configuring settings on the settings screen a lot easier.

SalesOrders

• Added: the distributor price level has been worked into the interface. If the user doubleclicks the price field, distributor price is now one of the price levels that will be cycled through.
• Added: all price levels in the above price cycle system now pay attention to whether they are hidden. Any hidden price levels will be skipped.

Search

• Fixed: when printing the truck spec sheet report, the images directory is now formatted to an absolute path. This fixes issues where images weren't printing correctly.

Vehicles

• Fixed: an issue where, if the user split a "Both" side item into Left/Right the two components might not get contiguous SKUs.
• Fixed: an issue where, after loading a saved teardown, the items in the list are no longer sorted in part type order.
• Added: there are now permissions for each page on the vehicles screen. Each of these permissions were granted automatically to anyone who had the 'can edit parts' permission.
• Added: new permission, "Can edit statuses" which control just the status and user status fields (bug 2191).

Vendor

• Added: the price class interface has been rewritten to use the new price class objects.
• Added: the price class area now shows, loads, updates, and saves distributor prices along with everything else (bug 2137)

WorkOrders

• Fixed: A bug where misc parts that a user without ADD_MISC_ITEM permissions tried to add would get saved to the work order, even when they were no longer in the list.
• Fixed: A bug where users without the Add Misc Item permission were not able to modify core values on valid inventory entries.
• Changed: Users who don't have the Add Misc Item permission are now able to mouse into and out of the line item without it being erased.
• Fixed: the "Default Days to return core" setting has been moved from the "Inventory" category to "Parts".
• Added: setting type to various settings calls.
• Added: f_workorder_saved (a default db api call) is now called when the user hits save, even if there is an error (as long as the WO gets an ID).

2011-10-07

RPT: TruckSpeckSheet

• Removed: Vehicle Q&A section, which has been gone from the database for awhile.

2011-10-11

CoreManagement

• Added: support for an upcoming report system change.

CrystalReports

• Fixed: the threaded printing solution no longer creates the heaped copies of report objects as ITCrystalReports. Now, they are copied as ITEEReport, or whatever other class they happen to be.
• Added: before calling crystal reports, the desired report now gets a "Prepare report file" function called on it. This is designed to allow EE to store its reports in the database and write them to disk right before printing.
• Added: this module now overrides ITrack's report update handling. The version of these files is stored in the report table in a new column. When an updated report file is downloaded, instead of copying into the reports directory, it is instead written to the database as a Report type file. This file is then associated with the report record in the reports table in a new column.

Customer

• Added: support for an upcoming report system change.

Deliveries

• Added: support for an upcoming report system change.

InventoryOverview

• Added: support for an upcoming report system change.

ITMySQLConnection_d

• Added: new function, EscapeLimitedSubstring, which is like EscapeString, except that, instead of assuming the size of the output should be 2 x the input, it only escapes the proper subset of the input that will fit in the output.
• Added: ITMySQLBlobs now have a BlobType which can be TINYBLOB, BLOB, MEDIUMBLOB, or LONGBLOB. This is passed into some of the functions used to save the blob to the database so that maximum byte lengths (other than maximum packet size) can be taken into account.
• Added: more specific behavior when escaping large strings (blobs) for writing into the database.

Master

• Fixed: an issue where ITrack might think it needed to download the same update over and over due to have more than one entry in the version list table.
• Added: support for modules to override ITrack.exe's handling of updates as well as module versioning. This allows ITrack modules to specify a custom way for certain updates to be versioned (such as reports) and updated.
• Changed: support for custom update modules during updating has caused a need for database access and for all modules to be loaded before initializing updating. This shouldn't affect anything, but the Updater will no longer launch before ITrack has loaded all extensions and connected to the database.
• Refactored: the way the update downloader downloads files to facilitate new custom updater module system.
• Added: calls in the update downloader that check to see if Master has any custom updater modules that should handle specific updates. This happens in 2 steps. First, the custom modules are given a chance to specify the version of a module. This overrides the basic 'versionlist' system. The second step is, if the module shows up as needing an update (using basic or custom versioning), custom modules are given a chance to handle the application of the update in question.

Parts

• Fixed: an issue where the rank 1 location on the advanced tab might say "Main" instead of the actual location.

Payment Entry

• Added: support for an upcoming report system change.

PurchaseOrders

• Added: support for an upcoming report system change.

ReportViewer

• Added: support for an upcoming report system change.

SalesOrders

• Added: support for an upcoming report system change.

Search

• Fixed: HTP search button now looks in the new setting location for the company product code.

Vehicles

• Fixed: an issue where assembly models were not being loaded when a collection was loaded. This was causing all the collection items to lose their assembly model.
• Fixed: a crash that could occur if the vehicles screen was closed during an appraisal then reopened.
• Fixed: overactive change detection. Essentially every vehicle with a whole unit record was registering as changed on every load (erroneously).

Vendor

• Added: support for an upcoming report system change.

WorkOrders

• Added: support for an upcoming report system change.

2011-10-25

CoreManagement

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

CrystalReports

• Added: all standard IDispatch crystal report errors should now include a line that specifies the report filename.

Customer

• Added: the invoices list on the Sales tab now has a 'footer'. This footer will soon be used to display totals for columns in which this makes sense.
• Added: summary footer to the unapplied payments list.
• Fixed: summary footers now get cleared correctly when the screen is cleared.

Database Updates

• Added: as per a request by VHI, the f_get_attachment_id function now has a parameter for specifying whether to look at only public attachments.
• Added: f_count_file_references now takes the report table into account.
• Added: some new import fields to the inventory prices import type (bug 2205).
• Added: the function that decides whether a serial # is on hold now ignores the price quotes (salesorder lines with the hold checkbox unchecked).

Deliveries

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

InventoryOverview

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

PartModification

• Added: the change log comment dialog is now an ITDialog. This fixes issues where the dialog could appear off the user's screen and be hidden.
• Added: the fixed total line has been replaced by a floating footer on the main list control. This makes totals much easier to view in long lists.

Payment Entry

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

PurchaseOrders

• Fixed: the transfer orders screen no longer attempts to perform accounting if accounting is turned off for the company.
• Removed: the global setting "Use GL Accounting for Purchasing" is no longer used for transfer order accounting.
• Fixed: shipping methods which don't have "Show on document" checked will no longer show up.
• Fixed: (bug 2202) an issue where, a PO with a duplicate item might not properly reverse all activity when it is voided.
• Fixed: wording in a dialog to be more accurate.
• Added: some configuration settings now have more specific configurations.

ReportViewer

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

SalesOrders

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

Vehicles

• Added: the prompt on the dialog that comes up when the vehicle's status/location changes now has a better description of why some items are checked.

Vendor

• Fixed: if the report fails to write the database report file out to disk (for any particular reason) the filename and directory of the report are not updated.
• Fixed: the ini setting: "General"->"attachment_cache_directory" is no longer updated if it was previously empty. This is to avoid issues where a machine retrieved a user-specific directory then saved it in the ini (making all other users' attachment saves fail).

WorkOrders

• Fixed: an issue where the serial # dialog wasn't remembering the size/position the user last put it in.
• Fixed: several resizing issues in the serial # dialog.
• Added: when the user resizes the serial # dialog, the columns in the Q&A pane are now resized to take advantage of all available space (bug 2206).
• Fixed: the Configure->Users...->Worker Groups is now permission controlled. The same permission is used for this as the configure->users dialog.
• Added: some configuration settings now have more specific configurations.==2011-10-12==

Database Updates

• Removed: duplicate entries in the versionlist table. The primary key has also been changed to omit the version column. This will keep out duplicate rows causing issues in the updater.
• Added: fileid to the store table, which will store the company logo as a link in the database.
• Fixed: f_get_user_permission should now work as designed.
• Fixed: a misspelling in the f_workorder_saved function.

ReportViewer

• Fixed: an issue where string parameters were defaulting to "True" instead of blank

SalesOrders

• Added: the permissions "Can edit sales orders" and "Can create sales orders" have been in the system but not functioning. They now work as expected.

WorkOrders

• Fixed: a crash when deleting the last job off of a WO and saving.

2011-10-28

Parts

• Fixed: an issue where using the manufacturer part # box to change the manufacturer/model of a part, the pricing levels might get messed up on the aftermarket page.
• Fixed: an issue where, sometimes when the 'link assembly model to model' check wasn't keeping the models in synch.==2011-10-27==

PartConfiguration

• Fixed: an issue where changing vehicle models might not work correctly.