Version 2018.1.2.3

This version was released to all customers on Tuesday, October 16, 2018.

Minor Enhancements

8984: Customer Quote

Added the new "Record Not Found" logic to this area.

8791: Datetime and Date Fields

Throughout the system, where it makes sense, we've changed columns that were of data type datetime to the data type of date.

When Acclamare was originally being developed, the date type was not available in SQL Server. As of SQL Server 2008, the type has been available, but we weren't able to switch to it because not all of our customers were on the most recent version of SQL Server. Over the years, as more customers have upgraded, we no longer have any sites using any versions that don't support this data type.

As such, we've changed over to the date type in all but a very few number of columns. The columns that remain of type datetime have historically, and will continue to, contain a timestamp along with the date.

This change was made for, but not limited to, the following reasons:

Reduced storage requirements.
Slight performance improvements.
Easier SQL querying.
Easier report parameters. Dates that contain a timestamp make equality (=, <=, & >=) as well as statements like 'between' provide unexpected results unless the user is fully aware of the timestamp implications and how to appropriately handle them.

The change was made in the following areas, some of these areas may still contain datetime columns when appropriate:

AP Adjustments
AR Adjustments
Authorize Customer Unreturned Merchandise
Bank Deposit
Bank Withdrawal
Blank Checks
Bottom Line Discount Maintenance
Customer Alert Maintenance
Customer As-Of Aging
Customer Class Maintenance
Customer Collections
Customer Contact Maintenance
Customer Credits
Customer Item Maintenance
Customer Payor Maintenance
Customer Quote
Customer Refunds
Customer Return Receipt
Customer Returns
Customer Trade Reference Maintenance
Customer Type Maintenance
Expedite & Follow-up
General Ledger
General Ledger Dates
General Ledger Entries
General Ledger Manual Entries
General Ledger Recurring Entry Maintenance
Hazardous Material Maintenance
Item Alert Maintenance
Item Family Maintenance
Kit Orders
Landed Cost
Miscellaneous Cash Receipt
Order Source Maintenance
Price & Availability
Price & Cost Changes
Product Group Maintenance
Promotion Maintenance
Purchase Order
Purchase Receipt
Quantity Adjustment
Recurring Vendor Invoice Maintenance
Replenishment
Requisitions
Rework Order Receipt
Sales Invoice
Sales Invoice Commission Adjustments
Sales Invoice Post
Sales Invoice Tax Adjustment
Sales Order
Sales Order Tracking
Shipment
Stock Item Maintenance
Terms of Sale Maintenance
Territory Maintenance
Vendor As-Of Aging
Vendor Alert Maintenance
Vendor Class Maintenance
Vendor Contact Maintenance
Vendor Contract Maintenance
Vendor Credits
Vendor Dropshipment Confirmation
Vendor Invoice
Vendor Item Maintenance
Vendor Payments
Vendor Quotes
Vendor Rebate Maintenance
Vendor Return Confirmation
Vendor Return Shipment
Vendor Returns
Virtual Stock Item Maintenance
Warehouse Transfer Receipt
Warehouse Transfers

8921: Dynamic Inquiries

Added a column chooser option to the Current Inventory inquiry for Control Number.

8907: High DPI support

The widgets we use throughout the system now support High DPI. We've turned this support on in the Acclamare client.

8906: Look & Feel

We've changed the way that Look & Feel is selected and added a new skin called "The Bezier"

8635: Taxing Entity Drop-Down

The list is now sorted by Entity Name by default

8919: Units of Measure

In transaction areas, the unit of measure drop-downs have been removed and replaced with a search-like feature instead. File maintenance areas, for the most part, remain unchanged.

This change will accomplish a few things.

Reduced code complexity. Right now, the code has to:
1. maintain a full list of UMs at all times that are not item specific
2. filter the list in the widget so that it is only item specific as soon as the user touches the drop-down widget
3. set the widget back to its original state as soon as the drop-down is closed, otherwise, any item that doesn't have a UM in the filtered list from step 2 will show a blank value for that cell
It will eliminate hard to find errors that occur in step 1.2 and 1.3 above.
It will ultimately give a better presentation and explanation for items that have more than one alternate.
We'll be able to add add-on-the-fly functionality.

Instead of a drop-down, the user will not be able to edit the field directly, but will be able to press the standard ellipsis button in the cell to fire the new window and then optionally select an alternate unit of measure. The screens that are being changed are as follows:

Counter Sales
Customer Item Maintenance
Customer Jobs
Customer Quotes
Customer Returns
Customer Unreturns
Item Maintenance -> Kitting
Item Maintenance -> Rework
Kit Orders
Kit Quotes
Price & Availability
Purchase Orders
Quantity Adjustments
Replenishment
Rework Orders
Sales Orders
Vendor Quotes
Vendor Returns
Warehouse Transfers

8897: Vendor Item Maintenance

When deleting a vendor item bracket, any associated price/cost change record is being deleted as well.

3848: Virtual Stock Item Maintenance

In the past, virtual stocking items have been created just-in-time. That approach was used in order to prevent unnecessary storage requirements in the database. However, that approach has two downsides.

First, it creates a performance burden in every process that attempts to write to the record in that the process must determine whether or not the record exists prior to updating it.

Second, if a process fails to perform this check, some records my wind up having incorrect data in them when a later process performs the check and then applies an update.

We've made a change so that when a new item is created, all appropriate virtual stock records are created as well.

Bug Fixes

8783: Authorize Customer Unreturned Merchandise

Corrected an issue that could cause the warehouse of a small amount of customer credits to be changed when a user posted Unreturned Merchandise for a warehouse that was different than their default warehouse.

9000: Customer Quote

Corrected an issue that could cause the user to be stuck in a loop of pop-ups when the following steps were taken:

Create new Customer Quote and add a customer.
Enter a partial item number into the line, forcing a lookup and cancel it.
Minimize the quote window
In the taskbar, click the quote window to open it again
The lookup screen is also now reopened. If the user cancels it, they will be trapped in a loop of pop-up error messages.

8759: Daily Clean-Up

Corrected an issue that could cause the routine to fail while trying to delete old expired quotes that contained comment lines.

8626: Dashboard Maintenance

Corrected an unhandled exception that prevented the user for being able to access this screen. The cause of the error was a missing dll.

8896: Price and Cost Changes

Corrected an issue in which the the item's Last Price Update was not being updated when the user posted the change through this screen.

9050: Price Contract Maintenance

Corrected an unhandled exception that occurred due to the typical "where" error at the customer level.

9048: Pricing Engine

Corrected an unhandled exception that occurred if the user set up any pricing method that contained a margin based calculation in which the margin was set to 100%.

8985: Printing

Now trapping an error that can occur during communication between the client and printer. The printer, network, or operating system is returning an error message that states "The operation completed successfully." The system now gives a more user-friendly message instead of the error screen.

9049: Printing

Now trapping an error that can occur during printing. The error occurred when the user's hard drive was so full that the report could not be saved to the drive prior to being sent to the printer. The system now gives a more user-friendly message instead of the error screen.

8970: Purchase Order

Corrected an issue that could cause the cost to be $0 when the vendor item had a Quantity UM that was greater then the base item's SKU and Quantity UMs and the vendor item contained bracketed costing that started with a bracket that had a quantity that matched the vendor item Quantity UM.

Wiki