ITrack/Enterprise/Changelog Version 12

From ISoft Wiki
Jump to navigationJump to search

Release 12.7

Customer (17569)

  • Fixed: (case 22484) an issue where a user without permission to edit customers might get an erroneous change detected message when they open the customer screen.

Global Settings Extension (17563)

  • Fixed: an issue where date report parameters with fixed values might not get formatted correctly.

Interchange (17563)

  • Fixed: if the user hits enter when they're in the 'search area' of the interchange screen, a search will be performed, but hitting enter when entering interchange records down below will treat the 'enter' as a spreadsheet enter.
  • Fixed: a crash that could occur if someone doubleclicked an item with a dropdown where an invalid model was in a dropdown.
  • Removed: (case 22494) the sales meta-data no longer looks at non-stocked item sales. This speeds up sales data loading.
  • Added: the sales meta-data now also looks at work order usage history.

Report Viewer (17563)

  • Fixed: an issue where date pickers for report parameters might show the year 1899 as the default value.
  • Fixed: an issue where date report parameters with fixed values might not get formatted correctly.

Sales Orders (17681)

  • Fixed: (case 18835) an issue where sales orders for customers who required PO #'s wouldn't pop up the requirement dialog if they weren't buying at least 2 items. Now, the PO # field blinks and the warnings pop up if the invoice subtotal is greater than $0.

Vehicles (17566)

  • Added: (case 23034) misc parts on a vehicle teardown will no longer copy the year/make/model/VIN/body style from the vehicle when it is changed. Only Standard parts will automatically copy that information to all associated parts.

Vendor (17562)

  • Fixed: (case 21814) an issue where loading a vendor, then loading another vendor without clearing the screen in between might cause attachments to move between the vendors.
  • Fixed: minor issues with button sizing.

Work Orders (17568)

  • Fixed: Restored department that was removed in a previous change
  • Fixed: (case 21883) an issue where users could delete items off of a closed WO.

Release 12.6

Payment Entry

  • Fixed: an issue with negative values (case 22433)

Purchase Orders

  • Fixed: (case 21865) an issue where POs would automatically be marked as done receiving when a user without permission to receive inventory would save them after all quantity was received.
  • Fixed: (case 22419) an issue where transfer orders that were created due to a multi-store purchase from inventory overview would not properly update the 'on order' and 'on hold' quantities.


Reports

Pick List

  • Fixed: Excluded cores from the Pick List.

Sales Orders

  • Fixed: (case 22423) an issue where the various blinking static fields stopped blinking correctly.

Release 12.5

Customers

  • Fixed: (case 21196) an issue where customer default invoice terms were not being selected correctly when a customer was loaded.

Parts

  • Fixed: the location field is now larger

Work Orders

  • Fixed: (case 21188) an issue where the user could not view the part requests on voided or closed WOs.

Release 12.4

Purchase Orders

  • Fixed: (case 21052) an issue where showing the returns dialog could cause a crash.

Sales Orders

  • Fixed: (case 21102) a query error that would be thrown when the user sent an item from the warehouse management screen to an inventory adjustment document if that item had been written down more than once previously.

Release 12.3

Purchase Orders

  • Fixed: an issue where the return dialog defaulted to just showing purchases from today instead of the last 90 days, as intended.
  • Fixed: (case 20893) an issue where some of the right click options in the return dialog were not working.

Vehicles

  • Fixed: (case 20955) an issue where the hidden field vehicle.dismantled was incorrectly being set by the 'purchase date' field instead of the dismantled date.

Release 12.2

Customer

  • Fixed: (case 20872) an issue where the customer option list wasn't displaying the options it should show.

Parts

  • Fixed: an issue where the condition field on the parts screen was not in the proper location in the tab order.
  • Fixed: (case 20728) an issue where sending parts from the parts screen to the part modification screen wouldn't load anything up.
  • Fixed: (case 20896) an issue where parts/vehicles wouldn't save reordered attachment ranks if they hit the save button instead of the close button.

Vehicles

  • Performance: saving large teardowns can now be as much as 3 times faster, especially on slow connections. Many queries that were being run to see if inventory on the teardown had been modified since it had been loaded has been combined or eliminated.
  • Fixed: (case 20849) an issue where, if the user changed a vehicle's status, user status, or (especially) location, then choosing to cascade that change to all associated inventory records, that change might get rolled back if there were changes to the same items on the bids/teardowns tab.
  • Added: if the user cascades location changes from a vehicle to parts on a teardown, that change is now immediately reflected on the teardown screen without having to reload.
  • Added: the retail price in the location/status cascade dialog is now right aligned and sorts correctly.
  • Fixed: (case 20896) an issue where parts/vehicles wouldn't save reordered attachment ranks if they hit the save button instead of the close button.

Release 12.1

Purchase Orders

  • Fixed: (case 20857) an issue where the 'core exchange' column in the POs return dialog was hidden, making it impossible for the user to specify that a return associated with an inherent core charge was an exchange instead of just a credit. This issue was introduced in version 12.

Sales Orders

  • Fixed: (case 20854) an issue where opening the return dialog for a saved SO might show the saved line items on that SO twice.

Release 12.0

Highlights

  • Added: all print jobs, successful or failed, now get put into the report print queue (this can be reviewed on the report viewer screen). All print errors can be reviewed here, print jobs can be reprinted/retried, and total execution time can be reviewed. This will help improve print speeds in the future.
  • Improved: all print previewing has been improved. Cancelling/reprinting a preview now happens faster. All errors are reported in the standard ITrack error dialog. All print previews now go into the print queue.
  • Added: reports in the report viewer can now be marked as 'favorites'. This is a per-user setting so that each user can remember the reports they often print.
  • Added: various improvements to the report viewer screen's presentation.
  • Added: whenever the user performs an advanced print operation, they can easily choose print quantity as well as whether they'd like to print the job or email/save a pdf (email/save require the advanced print server solution).
  • Added: the parts and vehicles screens now show a floating attachment preview dialog. With this, the user can easily view images for the current part or vehicle without having to go to the attachments page. This popup can be located on a second monitor if the user wishes.
  • Added: there is now a global hotkey (editable in the configure->hotkeys dialog) that, when held down during a print job, will pop up the advanced print dialog. This makes changing print quantity or emailing any print job easy.
  • Changed: the way accounting is saved has been changed to make gl reports clearer.
  • Added: each store can now have a remittance address in addition to its street address.
  • Added: the returns dialog on the sales order screen has been merged with the one on the purchase order screen so that each area got all the benefits the other had.
  • Added: sales orders now allow the user to specify a reason for the return.
  • Changed: many screens got adjusted so that whether the user has done a normal search or a location specific search, results are sent to other screens in a consistent way.
  • Added: inventory can now be specified as single quantity items. In the future, this will signify items that cannot exist at multiple locations.

Tools/Controls

  • Performance: upgrades to our collections that (in some cases) eliminate as much as 85% of the time spent in some loops.
  • Added: support for icons on 'push-like' buttons.
  • Added: support for typeable columns in lists can now support a 'maximum length' for the data that the user can enter. If the user enters more than this, they hear a beep and are stopped.
  • Performance: formatting of list text has been sped up somewhat.
  • Added: a shared city/state/zip field group to consistently handle all areas where these linked fields should look one another up.
  • Fixed: an issue where attachment interfaces would not lock down correctly in some scenarios. Also fixed an issue where the public checkbox wouldn't work correctly if there was more than one check in the list.
  • Fixed: an issue where custom "ok" message boxes wouldn't have their custom button text shown.
  • Fixed: an issue where times containing midnight might save incorrectly. Also an issue where date/times might save as 1899-12-30
  • Added: doubleclicking an item in a tree control now toggles the expansion of that item.
  • Fixed: an issue where the list footer would become invisible in some scenarios.

Accounting

  • Changed: (case 18825) the way gl transactions are built has been completely redone. The main upshot from this is as follows:
 1. When a SO is saved/finalized/voided, all payments attached to that invoice as well as all external WOs that are on the SO have their accounting put into the same gl transaction.  This makes it easier to relate all the 'activity' of the invoice in one place.
 2. Now, there are many gl transaction types that represent all the areas of the software the user could trigger accounting from.  This will make it easier for accounting reporting to say more exactly what the user did to cause the activity.  For example, a single invoice could have multiple gl transactions over its lifetime.  The following could  be the example transactions for a single SO: "Sales Order Saved", "Sales Order Finalized", "Sales Order Reopened", "Sales Order Finalized", "Sales Order Voided".
  • Fixed: an issue where voiding payments was incorrectly attaching the balancing entries to the original transaction, possibly at the original transaction date. Now this gets a new "Payment Voided" transaction at the current date.

Appraisals

  • Changed: (case 19419) by user request, the 'current quantity on hand' retrieved as part of sales appraisals will now limit the matched results to just items that match the category of the current item (if it is filled out). Otherwise, all categories are considered.

Approvals

  • Fixed: (case 18952) an issue where the stock category was not correctly being displayed when price rules were being loaded. The value of All would save but display as Standard on the next load.
  • Fixed: an issue where changing the document type of a price rule was not being saved.
  • Fixed: another issue that was causing part types from being saved on price rules.

Crystal Reports Extension

  • Added: (case 17915) printing reports now logs successful print information as well as errors to the print queue.
  • Added: proper support for 're-printing' items in the report queue. That way, they won't get another entry in the queue.
  • Added: print previewing now inserts an 'in progress' entry in the print queue, which is overwritten up by the report viewer screen.
  • Added: (Case 18265) the 'choose printer' dialog now has the ability to let the user choose to email a report instead, or archive it on the server. In addition, the user can have a print get 'delayed' in the queue if they wish to schedule it for later.
  • Added: the archived reports subdirectory now has a default value per report type. This way, all saved reports will automatically be saved into sorted subdirectories.
  • Removed: if the user performs an advanced print, the windows printer dialog no longer shows up. Instead, we show the ITrack choose printer dialog, which allows choosing to email or archive.
  • Added: (case 18265) a global hotkey that controls whether to automatically show the advanced print options popup during any print. This defaults to ctrl + left click when printing, but can be rebound in the hotkeys dialog.
  • Added: support for auto-complete options in the email dropdown.
  • Added: if the user enters a new email address in the dropdown, future email operations will 'remember' that option.
  • Fixed: newly created report queue entries are now correctly cleaned up, avoiding memory leaks.
  • Changed: reprinting a report queue entry no longer updates the 'created by user'.
  • Fixed: crash that would occur when cleaning up report queue entries.
  • Changed: if the user chooses to email or archive a report, all reporting code is skipped.
  • Added: support for delayed printing and emailing. If a print job is going to be printed in the future, the print operation is skipped and logged in the queue.
  • Changed: the error report field in the report queue can now go up to 1000 characters instead of being limited to the previous 250 characters.
  • Added: there is a new setting ("Printing"->"Advanced print management server installed"). The advanced printing dialog now deactivates various controls if this setting is off. Essentially, any controls that require report commander to be present are disabled.
  • Added: (case 19676) the advanced print dialog now has a quantity edit so that the user can easily change the print quantity without going into the windows printer dialog.
  • Added: report auto-updater now creates new reports with a category of "Report".
  • Added: Configure->reports page now has handling for setting a report category.
  • Fixed: (case 19832) an issue where exporting a report add script with parameter values could cause a query error.

Core Management

  • Fixed: (case 19052) an issue where typing into the part lookup on the customer cores (filter at the top) or returned cores (core bank lookup) tabs, if the user was taken to search, any result they chose would not be returned to the screen correctly.
  • Changed: the part filter field on customer cores has been modified to work more like the lookups on other screens. This should make the usage of the screen more obvious than before.
  • Changed: (case 17587) the document # column in the customer cores tab has been reformatted to match the format of the returned cores tab.
  • Removed: (case 17587) the document # columns no longer show document line item #.

Customer

  • Fixed: (case 18861) an issue where the user could type in an invalid tax item name and the value would not be cleared before saving, leading users to believe a valid value would be saved.
  • Fixed: (case 18861) an issue where no tax item selected was being saved with an invalid value (now it is correctly set to NULL).
  • Added: (case 18825) creating finance charges now falls under a gl transaction type of "Finance Charges Finalized".
  • Fixed: (case 18961) an issue where the Save & New button did not clear the screen after saving, making it seem as though nothing had happened.
  • Fixed: (case 19108) if a new customer was created without the user going to the tax/payment info tab, the default invoice terms would not be saved correctly.
  • Fixed: (case 18794) an issue where hitting Save and Clear on a customer with attachments, then creating a new customer could 'move' those attachments to the new customer.

Customer List

  • Fixed: an issue where searching by customer website would throw a database error.
  • Fixed: (case 18945) a database error that would occur if the user was searching for customers at a specific store ("Customers For All Stores" is unchecked) and they were searching by an address field (due to the recent additions allowing the system to simultaneously search alternate addresses).

Database

  • Added: support for new 'time elapsed' column in the reportqueue table.
  • Added: (case 18727) support for delayed print operations in the print queue (reportqueue.waituntil). There is also now an index on the fields that the report server scripts uses to find printable jobs.
  • Fixed: the triggers and functions that keep locations up to date no longer use a value of -1 to represent 'no location'. This was causing issues on some databases that were in strict mode. Now, the system always uses NULL.
  • Added: (case 18825) several previous gl transaction types have been retired and many new ones have been added. This is part of a push to make gl transactions a descriptive and useful way to review accounting.
  • Removed: the old comments field in gl transactions. It was generally just used for the same purpose that we now use type for.
  • Fixed: (case 18861) customer.taxitemid has been corrected to have a value of NULL instead of -1 for those rows where -1 was being inserted.
  • Fixed: (Case 18852) PO adjustments that were created before version 11 wouldn't show up on their posting correctly anymore because of the innodb changes. This fixes it.
  • Added: (case 18001) salesorderline.customerprice, which is a transactionalized copy of the price the salesman was presented with by default. All historical sales have had their value set retroactively for future reporting.
  • Fixed: (case 19027) the f_invoicepaid function had different versions on different databases. This should standardize and speed up the function slightly.
  • Performance: (case 19032) customer balance calculating functions were being too specific about what index to use. Now, they will use whichever one is best. This showed some minor speed improvements on very large customer activity.
  • Changed: maximum make length increased from 15 to 50 characters.
  • Changed: inventory make length increased to match the 50 character limit of other tables.
  • Fixed: (Case 19047) an issue the user would get a database error when deleting locations.
  • Added: (case 17859) a new permission to control whether the user can print documents that have outstanding price violations. By default, this is on for all users who could normally edit a SO.
  • Added: (case 17070) support for a user-entered 'return reason/code' that can track 'why' an item was returned.
  • Removed: a view that was created for a previous report. It is no longer in use and it not well optimized. All reports should use f_get_attachment_id instead.
  • Removed: (case 3886) the after update trigger on vehicles has been removed. This had been a previous way to keep year, make, model, etc synchronized between vehicle and inventory.
  • Added: (case 6507) a search option to inventorysetting to allow the user to search for parts by the tag # of any collections that item is in. This makes printing tags for all collection members easy.
  • Fixed: (case 17943) selling/deleting a whole unit should reject all open bids. This solves issues where users would accept bids after the vehicle was sold, marking the vehicle as available again. This should trigger if the user sells the whole unit on a SO, consumes it on a WO, or returns it to the vendor on a return PO.
  • Changed: column order rearranged in the inventory table to make more sense.
  • Added: (case 6656) there is now a 'singlequantity' flag on inventory. This flag will track items that should never have a quantity greater than 1 and should never have more than one valid location.
  • Updated: all previous vehicle whole units set to 'Single Quantity' Parts.
  • Fixed: an issue where inventory.isacore allowed NULL.
  • Added: (case 18391) vehicle bids now store an 'assigned to' user as well as the date they were closed and what user closed them. All closed bids have had their date closed set retroactively, where possible.
  • Added: (case 17070) a new table where users can define a list of 'return codes/reasons'. These can be chosen between when performing returns on an invoice.
  • Added: (case 17070) a new permission controlling who can manage return codes.
  • Added: 3 initial return reasons to handle the common cases.
  • Fixed: the right-clicking graphing template has been modified so that if the user uses a string column as the x axis of a scatter graph (but the strings contain numbers), the graph should look correct.
  • Added: (Case 19658) Schema for logging search times to log_search.
  • Changed: (case 19042) the previous part search column "Entered By (user id)" is now no longer searchable and has been replaced with "Entered By User" which allows the user to search by user name.
  • Added: comments to report table columns.
  • Added: new column for tracking a report's category, separate from its type.
  • Added: speed index to the report table based on name.
  • Fixed: (case 12267) an issue where v_pickable_jobpart was not defined correctly, causing most items to be unpickable.
  • Added: (case 19865) report.name is now enforced unique per report type.
  • Fixed: a misspelled column name in a location delete trigger.
  • Fixed: (19810) an issue where several sales order job fields wouldn't aggregate correctly on the totals tab of the transaction list.
  • Added: (case 19467) notes for why a report subscription exists

Deliveries

  • Changed: by customer request, the 'Skip Delivery' button on the picking tab has been renamed to Skip Pick/Delivery to more clearly denote that the items will not be picked.

Ebay Extension

  • Added: (Case 17835) There is now a last updated date displayed on the auctions page of the eBay module
  • Added: (Case 17835) Invoicing from eBay will now create a basic customer record if no customer with a matching email exists and the Setting "Ebay Create Customer" is set to true and receive at least the email from the ebay transaction.
  • Added: (Case 17835) Added a column "Invoiceable" that shows the count of completed transactions with no invoiceids associated. (an invoice id is not added until ebay is closed and re-opened, so this value will not either)
  • Fixed: (Case 17835) Fixed an sql error when updating ebay auctions.
  • Fixed: (Case 17328) Added 'Freight' as a shipping option.
  • Fixed: (Case 17945) Fixed a crash when launching ebay without a user account.
  • Added: (Case 19012) Added a transaction tab
  • Fixed: (Case 19012) Filtering now works correctly.
  • Fixed: (Case 18840) Freight shipping now overrides any cost or free shipping settings
  • Fixed: (Case 19012) Now hiding the ItemID column, since users have no use for it.
  • Fixed: (Case 19012) Initial load speed dramatically improved.
  • Fixed: (Case 19305) Open Screen permission is now correctly followed.
  • Fixed: A query error was corrected regarding invoices.

Common Resources

  • Added: a generalized version of the picture viewer dialog used on search. This will be usable by other screens that would like to show image attachments for parts and vehicles.
  • Moved: the view pictures dialog from search has been moved to common resources so it can be shared between screens.
  • Added: the title text of the pictures dialog is now more descriptive, and shows total number of images in the title.
  • Changed: the last location of the pictures dialog is no longer stored in the ini file.
  • Added: the picture view dialog now uses a type of image cache that holds onto previously loaded file information. This should make load operations faster if the user goes back and forth between items.
  • Fixed: the page up/page down buttons seemed to do the opposite of what was expected when scrolling through images.
  • Added: support for showing images on unsaved parts and vehicles.

Global Settings Extension

  • Fixed: an issue where the print queue page on the report viewer screen would incorrectly ignore the 'show printed' checkbox.
  • Added: support for print logging in the report queue.
  • Added: support for mouse buttons in key bindings.
  • Added: doubleclicking a keybinding now allows the user to immediately rebind that action.
  • Added: an auto-complete handler that looks up all historical email addresses of users, customers, customer alternate addresses, and previous emailed reports.
  • Changed: to support the new way that search results are sent between screens, the ebay handler had to be updated.
  • Added: support for various new report viewer features.
  • Performance: when a user closes a screen, column order is now saved with an INSERT ON DUPLICATE KEY UPDATE instead of REPLACE INTO, which will reduce traffic and disk writes.
  • Fixed: (case 19255) an issue where user settings would not save any changes if the user logged out and logged back in before closing the application.

Home

  • Fixed: an issue where, if WO type of "All" wasn't first in the list alphabetically, it would not correctly look at all types.
  • Changed: (case 18791) the work orders tab now uses tagnumber instead of vendorcode and partnumber for all work order master parts. This should resolve issues where some users would get inconsistent labeling for master parts
  • Added: tooltips to all columns headers as well as the body of the work orders tab.
  • Added: the user can now click into the description and notes fields on the work orders tab, making it easier to read multiline entries and copy text out.
  • Added: (case 16389) 2 new columns to the work order tab: % Done and Job Status.  % Done shows a value that represents what % of the jobs on the WO are now at status Done. The Job Status field shows the status detail of all jobs on the WO. These fields show VOID if the WO is void and the status shows as FINALIZED if the WO is closed. In all other cases, the columns receive the most appropriate status colorization to match the colors used for statuses on the WO screen.

ITrack Online

  • Added: any javascript errors encountered on any pages being navigated to will now be automatically suppressed on client systems, but not in testing.

libITSQLFramework

  • Fixed: the timestamps in the query log now use local times instead of UTC times. Also, the values are formatted a bit more logically.

Login

  • Fixed: a minor flickering issue when opening up the configure->users dialog causing it to load slower.

Options

  • Added: the configure->Stores dialog now has an area for a remittance address and phone #. By default, this is the same as the street address of that store, but the user can make them differ. Soon, this information will show up on billing statements and invoices.
  • Added: the configure stores dialog now uses a state auto-complete to populate the state dropdowns, which will speed up loading slightly.
  • Added: changes to configure stores dialog to copy address information to the remittance area if the 'use same address' checkbox is checked.

Parts

  • Fixed: (case 18858) an issue where the parts screen was setting locationid as part of its insert/update queries, when this field was supposed to be omitted. It is handled elsewhere, and this was causing errors on databases with strict mode on (as virtual locations used a value of -1 which is no longer an allowed value.
  • Fixed: (case 6663) the refresh button on the parts transactions tab now refreshes the transaction cache, so any newly created transactions will be found. For speed purposes, the previous/next page buttons will not rebuild the cache.
  • Performance: the process of building the cache of transaction history for the transactions tab has been sped up. This will make loading this information faster, especially on slower networks.
  • Changed: attachment management has been upgraded to a newer methodology that will be compatible with a new picture viewer pane.
  • Changed: several things about the header of the parts screen have been modified to introduce consistency between the parts and vehicles screens.
  • Removed: the advanced page no longer checks to see if the enter key should work like tab. This is to establish consistency with other areas.
  • Added: (case 1545) this screen now displays a non-modal picture dialog when the user opens the screen. It will allow the user to view part and vehicle images for the currently loaded part at a glance. The dialog is the same one that has been in use on the search screen since version 1. The user may position the dialog on another monitor or in unused space. The dialog is automatically hidden if the user goes to another screen.
  • Added: the screen will remember if the user wishes to show the picture dialog, and automatically show/hide it the next time the screen is opened.
  • Added: The user can toggle whether the pictures dialog is visible using the new 'toggle' button at the top of the screen.
  • Added: user hotkey (can be customized in configure->user hotkeys) for toggling the state of the picture dialog. The default is "Ctrl + P".
  • Added: new tool tips for all header controls.
  • Added: if the user adds/removes/edits any attachments on the current record, the picture dialog is refreshed.
  • Fixed: an issue where image ordering might be overwritten the next time the user opened a part.
  • Added: (case 6507) a button to the links page that performs a search for all members in the current collection. This makes printing tags for all collections members easy.
  • Fixed: an issue where, if there was an error while saving collection components, the user might not be able to correct the issue and save again.
  • Added: (case 17595) as part of saving new collection component items (such as for assemblies), the user is warned if the tag #'s they enter match any existing items in inventory.
  • Fixed: an issue where inventory tagnumber was saving only 20 characters, when it was supposed to be 50 characters.
  • Added: (case 6656) a new checkbox on the advanced tab called "Single Quantity Part". Parts with this checked attempt to enforce that their quantity never goes above 1 and they never have more than 1 valid location. This represents 'discrete' parts that only exist once in any store (such as vehicles and most parts created from teardown).
  • Added: (case 6656) 2 new errors on save if the user has 'Single Quantity Part' checked and the quantity on hand is greater than 1 or there is more than one valid location.
  • Added: (case 6656) any 'new' collection components created as part of a collection (usually an assembly) will create all 'child' parts as 'Single Quantity Items' if their quantity is 1 or less. This should make it so that most of these parts won't ever have to end up in a state where they have multiple locations when that doesn't make sense for such 'simple' parts.
  • Fixed: (case 19678) an issue where Q&A on new serials was not saving correctly.
  • Fixed: (case 19663) an issue where clearing the parts screen after loading a part with a single serial # would not clear the "Serial #" field on the part info tab.

Part Configuration

  • Fixed: a possible database error that could happen if the user entered a make longer than the maximum allowed make.
  • Fixed: the user could not 'uncheck' the start/end date on part type messages.

Payment Entry

  • Added: (case 18825) when payments/discounts/credits are saved, they are now put under a GL transaction type of 'Payment Batch Updated'.

Print Queue

  • Fixed: (Case 17810) All errors are now written to file and an exception has been added for writing errors to the database.
  • Fixed: (Case 18665) Added timers, written to db. It should also update lastsenton.
  • Fixed: (Case 18160) Now has an enterprise handler that should pull in printers using f_get_setting.
  • Fixed: (Case 19360) Syntax errors and handling for when no parameters are passed.
  • Fixed: (Case 19360) removed an errant else clause possibly causing failure loops
  • Fixed: (Case 19360) execution time now correctly quoted.
  • Fixed: (Case 19360) PrintQueue now handles missing reports instead of crashing
  • Added: (Case 18528) error reporting emails
  • Fixed: (Case 18430) Now enabled report commander's native error logging. -v flag effects it. To set a custom logfile, a new config setting 'reportcommanderlogfile' exists.
  • Fixed: Printing reports no longer makes a pdf
  • Fixed: Saving files to folders no longer deletes them
  • Fixed: (Case 18727) Now supports a waituntil date/time which specifies when a report should print.
  • Fixed: (Case 19605) Printing to the selected printer now works for reports that have No Printer checkbox checked in the crystal report file.
  • Fixed: (Case 19718) Python now corrects the product config setting from ITrack Enterprise to ITrackEnterprise
  • Fixed: (Case 19406) We now group_concat on | for parameters to avoid splitting off and ignoring subquery parameters.
  • Fixed: (Case 19484) Printqueue now uses f_set_setting to let the other products know that the Advanced Print Management Server is installed.
  • Added: a bunch of comments to make PrintQueue.py simpler to understand, as well as a convenience method for query error handling.
  • Fixed: (Case 19850) Added some error handling for when queries return no results.
  • Added: (Case 19850) Added a setting emailerroron, which when set to False will turn off email error reporting
  • Fixed: (Case 19850) Allowed not specifying a printer.
  • Fixed: (Case 19878) Fixed another crash

Purchase Orders

  • Added: (case 18825) future PO/TO accounting will now be done under GL transaction types of 'Purchase Order Received', 'Transfer Order Received', 'Purchase Order Voided', and 'Transfer Order Voided'.
  • Changed: the returns dialog on the SO screen now shares resources with the PO return dialog, this should help them have the same features in the future.
  • Added: by user request, the PO returns dialog now has many features that were only in the SO return dialog up until now:
    • Previous/next page buttons
  • Added: PO return dialog now has a document # filter edit. The user can enter a document # (wildcards supported), or enter something in the "store #-document #" format.
  • Changed: (case 6656) the error attention icon/popup related to receiving a vehicle a second time has been generalized to include any parts that are 'Single QUantity Items' (whole units count).
  • Added: a new warning attention icon/popup related to whether it looks like a PO will cause a single quantity part to go above 1 QoH. This is a warning because the user is not actually receiving the stock right now.
  • Fixed: an issue where a user with permission to edit POs after they have been marked as Done Receiving wouldn't see attention icons/warnings regarding changes they were making. Now, the presence of the warnings is based on whether the user can fix the issue.
  • Fixed: an issue where the 'too many locations chosen' pop up dialog on PO save would sometimes show the incorrect number of 'bad lines'.
  • Changed: error/warning attention icon hover text has been changed to be more consistent with other screens.
  • Added: when the system shows warnings/errors that 'Single Quantity' items (such as vehicles) will get a quantity above 1, it now checks quantity across all stores, as single quantity items can only have a single quantity at any location at any store.

Reports

Billing Statement

  • Added: (case 18402) a setting to hide terms. They will show by default.
  • Changed:(case 18218) mode setting name and options.
  • Fixed: (case 19138) specified sort order in Activity and OIA sections: date, store, salesorder.
  • Added: (case 17516) settings for alternate address and logo layouts at the top of the document for lining up with envelope windows and preference. This was also done to the SO report. Billing calls a global setting. SO calls a store setting.
  • Changed:(case 18805) replaced store address info in the tearoff with remittance info.
  • Fixed:(case 19932) suppressed the Finance Charge line in OIA mode when it is 0.00.

GL Activity

  • Changed: (case 18134) renamed GL Sales Activity report to GL Activity. Improved the report to include glentries from all types of documents, sorted by the document and transaction that generated the entries.

GL Entries By GL Account

  • Changed: (case 18138) Combined GL Entry Detail By Account and GL Entry Summary By Account functionality into a new report: GL Entires By GL Account. You can summarize by GL Account, GL Entry, or Document of Origin.

GL Entry Detail By Account

  • Removed: (case 18138) functionality has been folded into GL Entries By GL Account.

GL Entry Summary By Account

  • Removed: (case 18138) functionality has been folded into GL Entries By GL Account.

GL Entry Verification

  • Removed: (case 18140) Deprecated report.

Inventory Age

  • Added:(case 16912) this is a new FIFO report that figures out average age and oldest per SKU. Requires FIFO.

Labor Summary By Employee

  • Changed: (case 18671) renamed some column headers.
  • Fixed: (case 19135) non uservisible activity were rows showing up. Now they are not.

Packing Slip

  • Fixed: (case 19347) the report was showing date closed instead of date, which was sometimes showing 1899 for open SOs. This now matches Sales Order 11in. I also hid shipping information when appropriate the for Ship Method.

Purchase Order Posting

  • Changed: (case 18137) now displays postingnumber instead of purhcaseorderhistoryid.

Received Items

  • Changed: (case 18137) now displays postingnumber instead of purhcaseorderhistoryid.

Received Items By Source

  • Changed: (case 18137) now displays postingnumber instead of purhcaseorderhistoryid.

Received POs With Unapproved Postings

  • Changed: (case 18137) now displays postingnumber instead of purhcaseorderhistoryid.

Sales By GL Category

  • Fixed: (case 19370) this was referencing an old view, recently deprecated for being inefficient. Updated the report query to use the UNION salesorder line and salesorder adjustment information like other SO reports. Note that adjustments do not have a glcategory. They are still included in the report under "unassigned"
  • Changed: (case 18133) combined Sales By GL Category, Sales By GL Department, and Sales By GL Department And Category into one report with multiple summary levels.

Sales By GL Department

  • Removed: (case 18133) functionality has been folded into Sales By GL Category.

Sales By GL Department And Category

  • Removed: (case 18133) functionality has been folded into Sales By GL Category.

Sales By Invoice

  • Changed: (case 18360) updated with a new mode parameter to view the information at different levels: lineitem, salesorder, or day. Sales By Invoice Extended and Sales By Invoice Extended Detailed can now be removed. Tidied the report.
  • Fixed: (case 19361) a bug where the report would ignore the store ID parameter.

Sales By Invoice Extended

  • Removed: (case 18360) functionality has been folded into Sales By Invoice.

Sales By Invoice Extended Detailed

  • Removed: (case 18360) functionality has been folded into Sales By Invoice.

Sales Order 11in

  • Fixed: (case 18857) jobpart quantity rounding.
  • Fixed: (case 18941) shipping address fields on Sales Order 11in to hide if there is no ship method.
  • Added: (case 17516) settings for alternate address and logo layouts at the top of the document for lining up with envelope windows and preference. This was also done to the Billing report. Billing calls a global setting. SO calls a store setting.
  • Fixed:(case 17517) jobpart quantity rounding formulas, made the report react to "print labor detail", and cleaned up the job sections in general. The part and labor subreports are now combined, and I moved things to look cleaner.
  • Performance: (case 19738) removed an unnecisary JOIN.
  • Replaced customer unit id with customer unit number.

Sales Order Return

  • Added: (case 19542) added return reason column.

Teardown

  • Added: (case 18638) vehicle stocknumber to the footer of every page.
  • Changed: (case 18219) report layout to look cleaner, swapped it to Landscape.

Top Customers Trending

  • Added: (case 16724) a new parameter that allows you to specify how "top" is determined, by counts or sums. It was added to all "Top...Trending" reports.

Top Customer Types Trending

  • Added: (case 16724) a new parameter that allows you to specify how "top" is determined, by counts or sums. It was added to all "Top...Trending" reports.

Top Part Type Age Trending

  • Added: (case 16724) a new parameter that allows you to specify how "top" is determined, by counts or sums. It was added to all "Top...Trending" reports.
  • Fixed:(case 18891) Make/Man grouping when 'Make/Man' is selected on on Top Part Type Age Trending.
  • Fixed: (case 19708) a rare divide by 0 error that happened when the grand sum (of sales or quantity, depending on what you picked for the based on parameter) = 0.

Top Part Type Sales Trending

  • Added: (case 16724) a new parameter that allows you to specify how "top" is determined, by counts or sums. It was added to all "Top...Trending" reports.

Top Salespeople Trending

  • Added: (case 16724) a new parameter that allows you to specify how "top" is determined, by counts or sums. It was added to all "Top...Trending" reports.

Transfer Order

  • Fixed: (case 18863) barcode format. Previously, if it included commas, which would make the barcode unreadable (transferorderid > 999).

Vehicle Photos 2x3

  • Added: (case 17695) Vehicle Photos 2x3 is a new report that prints one photo per vehicle 6 per page, 2 across, 3 down. It also prints year, make, model, and stocknumber. If there is no image, it prints the text "no photo".
  • Performance: (case 17695) made photo selection better by using 2 functions instead of a function and a bad view. Updated report type to "Vehicle Search" so it can print from the Search screen Vehicle Search tab Results button.
  • Changed: (case 17695) set printer to 'Photos' so people can set a different default printer than the majority of the reports. Since the report is mostly images, they may want higher quality printing.

Vehicle Spec Sheet

  • Performance: (case 17695) removed the join to a old view.
  • Added: (case 18976) added vehicle notes and description, both suppressible via setting. Tidied the report.

Vehicle Value Analyis

  • Added: (case 11433) an age column - resized the fields to make room and tidied.
  • Added: (case 8706) closed, non-void jobpart values into the parts sold section.

Work Clock Times

  • Changed: (case 18291) renamed Time Clock Work Clock to Work Clock Times and improved the report. It shows Work Clock Time on the left and the division of that time (Time spent on WOs + Time spent on Internal Activities) on the right with percentages + efficiency and lost hours calculations.
  • Fixed: (case 18545) default user parameter for showing all users ('All Users'). It was previously entered incorrectly as .

Work Order, External

  • Fixed: (case 18857) jobpart quantity rounding.

Work Order, Internal

  • Fixed: (case 18857) jobpart quantity rounding.

Work Orders

  • Added: (case 18690) additional information to the summary section.

Report Viewer

  • Added: print queue page now has columns for report type as well as report name.
  • Added: column for the new execution time value.
  • Added: the print status column is now bolded and color coded.
  • Added: notes and error info columns are now multiline edits for easier reading.
  • Added: the user can now edit notes on each queue entry.
  • Added: support for reprinting items in the queue now updates the execution time as well as parameter values for the existing entry.
  • Added: clicking the 'cancel' button (little red x) while a preview job is running now cancels the job completely.
  • Added: cancelling a preview either with the little red x or by closing the screen now updates the print queue with a status of Cancelled.
  • Added: previewing reports now correctly saves the execution time in the repot queue as well as when it was previewed.
  • Added: errors that occur during print preview are now reported with the same error reporting box as all other printing errors. These errors are also saved in the print queue.
  • Fixed: any queued report that is sent to the previewer will now correctly save "Preview" as the destination for the report.
  • Fixed: an issue where reprinting reports by sending them to preview would cause a new queue entry to be created.
  • Changed: the report viewer tab now shows report categories and report names in a tree instead of 2 lists.
  • Added: report categories can now contain multiple levels and are no longer attached to the report type (what button it prints from).
  • Added: buttons for setting which reports are a user's favorites.
  • Changed: deselecting a report now makes various parts of the screen read only.
  • Added: the report and parameter lists now save and load their column order and widths.
  • Added: when reports are first loaded up (or they are reprinted) various pieces of meta-data are loaded for the report, including average execution time, who ran the report last, a well as how often it is run.
  • Added: (case 19808) support for adding reports to the user's favorite reports. All favorite reports show up in a special "* Favorites" area.

Sales Orders

  • Changed: default document type has been changed from Quote to Invoice. This won't affect existing users, just new ones.
  • Changed: (case 18354) the way 'default' document types work has been reworked. There is still a setting that controls this value, but it is no longer saved when the user closes the screen. Now, the user must choose to set it manually by right-clicking on the document type dropdown.
  • Fixed: the 'send items to location map' option in the right click menu will now show the user's current key binding.
  • Changed: the email to salesman and email to customer options now print an invoice to PDF and emails it instead of building a text email. This will be much more accurate to the print outs.
  • Added: the context menu (right click) now has options for emailing to customer and emailing to salesperson.
  • Added: (case 18825) when an invoice is saved, finalized, reopened, or voided, all attached payments and work orders will now have their accounting inserted under the same GL category as the invoice itself instead of separate ones.
  • Changed: accounting now happens under the gl transaction types of "Sales Order Updated", "Sales Order Finalized", "Sales Order Reopened", and "Sales Order Voided" to make the transaction log easier to understand.
  • Added: (case 18001) the 'customer price' the salesman is presented with is now saved with all lineitems for historical reporting.
  • Fixed: saving new lineitems will now be slightly faster, especially on very slow connections.
  • Fixed: (case 19013) an issue where loading an item onto a SO without any locations could cause the part to be opened on the parts screen instead if the search sent it over by location. Now the item will be loaded onto the SO with no location.
  • Added: (case 17859) support for a new permission to control whether the user can print documents that have outstanding price violations. By default, this is on for all users who could normally edit a SO.
  • Changed: the returns dialog on the SO screen now shares resources with the PO return dialog, this should help them have the same features in the future.
  • Added: by user request, the SO returns dialog now has many features that were only in the PO return dialog up until now:
    • Date range filter
    • Remembering what documents were expanded when the user changes pages or filters
  • Added: SO return dialog now has a document # filter edit. The user can enter a document # (wildcards supported), or enter something in the "store #-document #" format.
  • Added: (case 17070) when the user opens the perform returns dialog, there is now a 'reason for return' dropdown. The user will be shown all previous reasons in an auto-complete, but they can enter new reasons as well. This 'reason' will be applied to all items returned at that time and is remembered for future returns.
  • Added: if the user opens the edit item dialog for an item and that item is a return, the return reason will be shown in a special auto-complete dropdown (and can be modified). This is useful for situations where many items need to be returned, but only one or two have a different 'reason'.
  • Changed: to eliminate errors caused by the user sending part search results to screens with and without the "group by location" checkbox checked, the two types of messages have been merged into one. This change should be transparent to the user, but it hopefully eliminates cases where screens were handling these 2 cases very differently.
  • Added: (case 17070) a new configure->Documents->Return Codes configuration dialog. Users with the appropriate permission can open this dialog to add/edit/remove 'return codes/reasons' which can be chosen between when performing a return on an invoice.
  • Changed: (case 17070) the 'return reason' in the perform returns dialog (as well as the edit items dialog) now load entries from the new returncode table. In addition, they now display both the code and name of the return reason. This should give administrators a tighter control over what options can be chosen by users when performing returns.
  • Added: return reasons that the user can choose between now show in 'rank' ordering. This allows yards to customize the order that return reasons are displayed in (instead of alphabetical).
  • Added: the return dialog now has a Configure button next to the return reasons dropdown. Users with permission to manage this list can click this button to be taken to the configure->return codes dialog.
  • Added: configure->return codes now has support for showing which items are in use, and deleting an in-use return code will prompt the user to choose a replacement.
  • Fixed: (case 19505) an issue where, if an invoice had payments on it that had a payment method that was not a valid option for the current customer, nothing would show in the payment method column.
  • Added: (case 19551) when items are sent to a inventory adjustment document from warehouse management, 'found' items now attempt to find previously written down documents to 'return'. Essentially, if the item in question was ever written down with sufficient quantity, that original write down cost will be used instead. If no appropriate write downs are found, then the item is 'found' with a cost of $0 like before. This helps with yards who would like 'found' inventory to not come back in at $0 average cost.

Search

  • Added: (case 8668) if a search returns no results, the popup now has a 'search on HTP' button which will attempt to perform the same search (when possible) on HeavyTruckParts.net.
  • Fixed: all options in the right click menu will no correctly show the user's current key binding.
  • Fixed: (case 18899) a crash that could occur if the user deselected all vehicles and then clicked on any header to sort the list. This was a long-occuring bug that had been difficult to track down, credit to Ryan@Active for reproduction information.
  • Changed: when the user sends search results to other screens, they are now sent in just a single format, instead of 3 or 4. This will make communication between screens easier and more consistent, but breaks compatibility with old versions of other screens.
  • Removed: some code that might re-order results being sent from search to other screens. Now items should arrive at other screens in the same order they were viewed on search.
  • Moved: the picture viewer dialog that the screen used has been moved to common resources to be shared with other screens.
  • Changed: (case 1545) the view pictures dialog is now shared with the parts and vehicles screens. For this reason, some adjustments have been made to the icons and title text to be more useful.
  • Added: any images shown in the image viewer dialog are now cached locally, so going quickly between parts will force items to be loaded the first time, but on subsequent visits, the images will already be available. This should make going back forth between search results with images faster, especially on slow connections.
  • Added: (Case 19658) Search logging now records execution time, so we set it here.

Transaction List

  • Fixed: all options in the right click menu will no correctly show the user's current key binding.

Vehicles

  • Changed: the user interface of the main vehicles screen has been significantly reworked. Its layout should now much more correctly match the parts screen.
  • Fixed: an issue where the tracking # field at the top of the screen was not emptying when clearing the vehicle.
  • Added: (case 1545) this screen now displays a non-modal picture dialog when the user opens the screen. It will allow the user to view part and vehicle images for the currently loaded part at a glance. The dialog is the same one that has been in use on the search screen since version 1. The user may position the dialog on another monitor or in unused space. The dialog is automatically hidden if the user goes to another screen.
  • Added: the screen will remember if the user wishes to show the picture dialog, and automatically show/hide it the next time the screen is opened.
  • Added: The user can toggle whether the pictures dialog is visible using the new 'toggle' button at the top of the screen.
  • Added: user hotkey (can be customized in configure->user hotkeys) for toggling the state of the picture dialog. The default is "Ctrl + P".
  • Added: new tool tips for all header controls.
  • Added: if the user adds/removes/edits any attachments on the current record, the picture dialog is refreshed.
  • Fixed: an issue where image ordering might be overwritten the next time the user opened a part.
  • Added: (case 3886) when the user saves a vehicle, whole unit records now correctly save changes to year, make, model, VIN, body style, etc.
  • Added: the vehicle's whole unit now correctly copies the user status, similar to the vehicle status, which was already working.
  • Fixed: (case 19419) the local sales/usage column in the vehicle bid/teardown area was always 0.
  • Added: (case 17595) as part of saving new teardown component items, the user is warned if the tag #'s they enter match any existing items in inventory.
  • Added: (case 6656) whole units now are always created as 'single quantity items'. This can be manually overridden on the parts screen, but this should be correct for all cases.
  • Added: parts created on a teardown now are created as single quantity items if the quantity of the item on the teardown is 1 or less. THis should cover the default case, where most vehicle parts only exist in one place at all stores. For any parts where this is not true, they will have to be edited on the parts screen.
  • Fixed: a possible infinite loop that could occur when the user attempted to add another bid when the current bid's name ended in "(1)", as it was being interpreted as -1 instead of 1.
  • Added: (case 18391) columns to the bid document list:
    • Created By (set automatically when bid is created)
    • Closed by (set automatically during accept/reject)
    • Closed date (set automatically during accept/reject)
    • Assigned to (set with a new dropdown of user names)
  • Fixed: an issue where vehicle bids were no longer saving a 'last modified' time.
  • Fixed: sorting by the 'date' column should now work correctly, no matter the user's locale date format.
  • Added: (case 18987) a store-specific "Minimum gross margin" value on the bid screen.
  • Added: a maximum bid amount based on the minimum gross margin.
  • Changed: moved various controls around in order to ensure that all controls are visible at minimum resolution.
  • Fixed: (case 19950) part type column in the bids/teardown list is now sortable by part type name.
  • Added: made sure that part types in the bid/teardown list order by part type # if they all have the same cost impact (items with high cost impact will still be at the top).

Warehouse Management

  • Fixed: all options in the right click menu will no correctly show the user's current key binding.
  • Changed: (case 19551) 'found' items now show an approximate cost impact in grey (similar to how vehicle items were shown in grey before). This is to represent the fact that 'found' items now sometimes come back in at the cost that they were last written down at (when possible). Since this is based on the availability of previously written down inventory, it is only an approximation, but is probably more accurate than always showing $0 like before.

Work Orders

  • Fixed: all options in the right click menu will no correctly show the user's current key binding.
  • Added: (case 18825) when an internal WO is saved, finalized, or voided the gl transaction now uses one of the new types "Work Order In Progress", "Work Order Finalized", and "Work Order Voided". External WOs will use the same "Work Order In Progress" and "Work Order Voided" type, but they are finalized as part of "Sales Order Finalized".
  • Changed: to eliminate errors caused by the user sending part search results to screens with and without the "group by location" checkbox checked, the two types of messages have been merged into one. This change should be transparent to the user, but it hopefully eliminates cases where screens were handling these 2 cases very differently.
  • Fixed: If the user sent search results from search to the current WO (without clicking the add item button first), if there were items loaded on the job, they would be replaced by the results.
  • Fixed: several situations where sending multiple search results to the job on the current WO would load all items onto the same line, causing only the last one to be shown.
  • Fixed: (case 19180) an issue where items deleted off of a job could still cause a "Warning: it appears that the item '<this item>' is already on the WO, would you like to continue adding it again?" popup to appear.
  • Fixed: (case 2401) if the user unchecks the 'override cost' button, the cost value will now go back to the correct calculated average cost instead of $0.
  • Fixed: a reversion in one of the recent versions where the context menus in the parts list stopped working.
  • Fixed: an issue where clearing a WO wouldn't refresh the job list footer totals.
  • Added: when doing an internal WO, the WO master part list now has an attention column similar to many other document lists.
  • Added: master part attention icons for empty item and 'insufficient serials selected'.
  • Added: (case 6656) master parts now have an attention icon for when a build order would exceed the maximum quantity of a single quantity item.
  • Added: pop-up on save regarding single quantity items having their quantity driven above 1.
  • Performance: WO save/refresh process now runs a single query to refresh GL info instead of one query per master part. This should make saving WOs with many master parts much faster.
  • Performance: various things are only calculated when the user changes values in the work order master part list, instead of just when they tab around.
  • Fixed: (Case 19722) potential crash when saving a WO where one or more core charges were ordered to be 'before' the item they are attached to.
  • Fixed: (case 19971) an issue where loading a WO template would not correctly load up non-stocked items that were saved on that template.
  • Fixed: non-stocked items added to jobs from a template now correctly get a storeid, keeping them from showing the "Empty" icon.
  • Fixed: several issues where inherent or dirty cores added from a template would not have the correct lookup column.