The following list is the changes, corrections,
and additions to the Atrex package since the most recent major release.
--- Modifications for 12.04 ---
Discounts 4 and 5 were printing discounts 2 and 3 on the inventory price and margin reports.
Modified the AR outstanding transaction retrieval function for payment processing for performance.
Modified the editability status check used when editing existing transactions for performance.
Replaced Sale Unit column on PO Creation window with the Order Unit column.
Extended cost on stock code information window was not being hidden when the standard cost field was not visible.
Added comma delimited and tab delmited text file export option for reports.
Customer Label Batch Insert window was not allowing direct entry into the selection list boxes.
Added code to determine the bottom margin size for the selected printer and compare it to the margin size defined in the selected report. If the printer bottom margin is larger than the report bottom margin, the larger value will be used to prevent information from being printed in the unprintable area and being dropped from the printout. Please note that this is only implemented when printing directly to the printer. Printing to the preview window will only use the bottom margin defined in the report even if the report is printed to the printer from the preview window.
Inventory reorder report was not excluding non-depleting items.
Attempting to merge a mobile location with a client/server parent location was failing if the parent location definition did not also point to a valid direct directory.
Modified all transaction windows to disable the window during the save function a bit ealier in the process. This will reduce the window of opportunity where quickly pressing enter can cause the save function to be processed twice resulting in an access violation on the second pass due to the transaction object already being deleted before the function call event is processed.
Enabled the PageBreak component in the report designer to allow for forcing of page breaks.
Added functionality to the repair tables option of the batch processing to automatically replace missing .blb files deleted by anti-spyware programs. Please note that while this will replace the deleted files, the offending anti-spyware program must be deactivated or uninstalled to prevent the files from being repeatedly deleted.
Inserting a container item into a purchase order was causing the first item on the PO to be overwritten with the information from the container.
Voiding a SO with a deposit paid with a credit card was not prompting to void the credit card deposit.
Server based table optimization routine was being called but not actually optimizing the tables. Pleae note that this correction requires the updated server engine to be installed in order for this correction to be implemented.
Modified the results of the batch PO creation items to sort by stock code to prevent random reordering during edits or reprints.
Attempting to authorize debit card transactions from a rapid sale was displaying an invalid object name error message.
Modified mobile location initialization function to copy the custom report table to the destination directory to prevent missing custom report template errors.
Tweaked the Open Sales Order Selection window for performance when selecting orders for editing.
Added a second Excel file export format option for exporting reports. This format is the same export format used in Atrex 11.
Cloning a previously shipped order was not clearing out the previously transferred shipping amount.
--- End of 12.04 ---
--- Modifications for 12.03 ---
Changes made to the customer service equipment by editing the customer from within a SO were not being displayed in the service equipment selection list.
Modified stock code receiving history to hide cost when the user does not have the authority to view inventory cost.
Changing the cost of an item during receiving, either directly or by splitting shipping amounts, was modifying the cost of the item on the original PO.
The stock code view allocated detail window was not displaying multiple entries for duplicated items on orders with the same quantity.
Modified the SO main window to provide two drop down listbox selections to allow for both the selection of a manufacturer from the manufacturer list and selection of customer service equipment.
Added VarIsNull function to allow for testing Variants variables in ReportBuilder RAP functions to determine if the variant value is null.
Modified the PO Batch Creation window to disable the increment search function of the window if the focused field is a direct entry field to eliminate the need to click on the field before being able to enter a value.
Tweaked the customer and vendor history windows for performance when initially opening the window.
Tweaked several of the report criteria windows for performance when initially opening the window.
Added temporary indexes to the purge serial function processing to speed up processing on large serial number tables.
Related items descriptions were not being displayed on initial display of an item selected directly.
Purge serial function was incorrectly including previously sold items that are on open RMAs as delete candidates.
Authorization codes from previously authorized charges were not being passed to the credit card processing module when voiding transactions, resulting in the inability to void authorizations.
Tweaked the customer information window for performance when initially opening the window.
--- End of 12.03 ---
--- Modifications for 12.02 ---
Added missing date stamp buttons to the PO Create dialog notes and shipping notes tabs.
On-Order quantity was not being correctly updated during receiving for items with a sale unit to order unit other than 1.
Modified SMTP setup to only pass the login ID and password for an account if the requires authentication option is checked. Attempting to send authentication when the server does not prompt for it results in a 533 error indicating that the AUTH command is not enabled.
Sending email via SMTP with an empty message body was causing the first attachment to be embedded within the body of the email rather than being sent as an attachment.
Customer credit card and CVV fields were not allowing pasting via keyboard Ctrl-V command.
Added incremental searching to location selection window.
Clearing out the online description field of a stock code record was not completely clearing the HTML column in the stock code table. This could result in the product description not being pushed up to osCommerce or ZenCart sites.
Modified the AutoSearch table and query lookup functions within the report designer to prevent large lookup lists from having to be fully loaded into memory before the AutoSearch dialog is displayed.
Customer service equipment selection was not retrieving the correct record from the lookup table if the newly selected row had the same manufacturer value.
Serial number insertion on invoices was allowing the same serial number to be selected for the same item multiple times.
Tweaked the stock code information window for performance when initially opening the window as well as reduce a bit of the overhead when scrolling between stock codes.
Many reports with stock code criteria were being processed as brute force searches on the stock code fields rather than using the available indexes.
Modified stock code on-order lookup window to exclude items that have been completely received on open purchase orders.
Added automatic email address entry when emailing customer specific AR reports.
Vendor Codes and Related Codes from the source code were being displayed for the target of a cloned code when cloning an item from within the stock code information window.
Modified the filter builder window to default the keyboard focus to the first criteria value if one is present.
Added last modified date and last modified ID to the list of stock code filter fields.
Recurring invoice editing window was not moving to the line item tab when pressing Ok or Enter if it was on any other tab.
Customer import was not properly matching on customer number for updates, so all records were being processed as new customers.
Corrected a row focus issue when editing items on the stock code label printing window.
Tweaked transaction item save routines for POs, Invoices, Orders, and Quotes to improve performance.
Tweaked the inventory category, sub-category, manufacturer, and location maintenance fields to improve performance on large databases.
--- End of 12.02 ---
--- Modifications for 12.01 ---
Modified ServiceRep field on SO main window to show User Name in addition to the User ID.
Enabled incremental search on most selection and transaction windows.
Modified ShipVia drop down listbox to be auto-sized on all instances to prevent display cutoff on the selection list.
Filters with manually specified wildcards were not being implemented as brute force searches when run against a full text indexed field.
Filters on the stock code selection window were dropping the exclude options when a filter was manually specified.
Attempting to clear the expiration date field of a credit card on the customer record was incorrectly displaying an invalid value message.
Added security checks to the customer selection window popup menu. Access to the history selections are now tied to the appropriate user security options.
When transferring quotes to invoices, serial numbers entered on the quote transfer window were not being passed forward to the resulting invoice creation window.
Global SO parts list was not being populated when editing a service quote.
Enabled sorting, grouping, and filtering on the stock code receiving history window.
Conversion of Atrex 10 and older data was failing if the data files were marked as read only.
Added port and TLS options for SMTP to allow for using web mail services such as GMail.
CVV values were not being masked on the customer or CC info windows.
Datestamps entered into direct database notes fields (customer notes, stock code notes, etc) were not including the user ID if security was enabled.
Changed phone entry field on alternate shipping address window to an open field.
Modified the inventory transfer function to clear the item list after the "process now" prompt. While the function was working correctly, the items being cleared before the prompt was causing confusion.
Modified selection grids to allow increment search to operate on the currently selected sort column for banking transaction selection, AR payment selection, open SO selection, and transfer selection windows.
Transaction logout option was only being called when canceling a function.
Filters created for the OnHand field of the stock code selection window were being cleared by the Exclude Items with Zero On Hand filter processing.
Changed filter field selection lists to be sorted by field name.
Partial search for customer phone number via ! on customer name entry window was not enabling the filter.
Added code to change the short date format to use the MM month specification (numeric only) if the Windows short date contains the MMM (alpha) month format. This will prevent invalid date messages as well as blank reports when the MMM indicator is present.
Default address to send for credit card processing during order shipping was not being set correctly.
Order item shipping window was not allowing entry of negative discount amounts.
Canceling a PO receiving session via the window "X" was leaving the PO record locked.
Modified mobile location check in and check out functions to ignore temporary database tables to prevent access denied errors.
Modified mobile location merge function to update stock code images and container definitions in the mobile location.
Added in missing menu commands from the inventory label window.
Items deleted from a SO during the completion steps were still removed from inventory as if they had not been deleted.
Improved the performance of the strip to single vendor on the PO Batch Creation window.
Installing Atrex onto a system with a client/server central connection was not updating the report layout tables.
Database Server Installation was not correctly restarting the server engine if the server engine was installed onto a system with the server already running.
Added cell width and height options for exporting to Excel to allow the user to tweak the excel format and prevent dropped columns.
Made the file export options persistent.
Updated to ReportBuilder 10.07 to correct minor issues with the report designer under Windows Vista.
Tweaked the inventory AfterPost function to only check for new lookup entries if the lookup values in the stock code have been changed to improve the performance of the data update across a network.
Transaction selection window (invoices, orders, quotes) was not including the transaction discount in the transaction total.
Made various performance tweaks throughout the package to reduce the amount of time required to display retrieved data.
Inventory worksheet update window was always sorting by stock code on reopen, regardless of the original table sort order.
PO Receiving window was not freeing itself after the receiving session was completed. This could result in the on-hand quantity and PO receiving history being incorrectly updated if the same window was used multiple times for receiving the PO without manually closing it between receiving sessions.
Sales order shipping function was not looping.
Container/Assembly definition button on the stock code information window was not being enabled if a container/assembly item was selected directly for editing.
Transfer of quotes to an invoice was not prompting for the serial numbers when customizing the containers serialized items.
Customer email extract function was extracting all fields in the customer record instead of just the email and name fields.
The silent flag for credit card processing was not being sent to the credit card plug-in modules, resulting the the recurring invoicing requiring a user to confirm each authorization result.
Added routine to v11 data conversion to force values into the crmaitem.ItemGUID field if they were empty at the time of the conversion.
Discount 4 and 5 values were editable when the pricing option was set to automatic.
Customer Invoice Report Criteria window was not allowing direct entry into the selection list boxes.
SO Return function was overwriting the last record in the SO table instead of inserting a new record.
New recurring invoices were being created with a cycle length of zero months, resulting in the newly created entries being processed each time the processing function is run.
Inventory category, sub-category, location, and manufacturer maintenance windows were not loading previously saved window customization settings.
