Version 2014.2.2.7

This version was released to all customers on August 4, 2014.

We've added a new maintenance area called Warehouse Bin Maintenance. This area allows you to create, update, and delete the bins that are associated to the warehouse you're working with. Once the bin exists, this screen also gives you the opportunity to assign items to, or remove items from, said bin. The bin maintenance screens found within Item Maintenance still exist and can be used. This method simply allows the user to work with bins from the perspective of the bin, rather than the perspective of the item.

3792: Commission Plans

We've added the ability to specify an item number at the plan's bracket level. This allows you to create a plan that has a different commission rate for a specific item. For example, if your standard commission rate is 10%, you could add a bracket for a specific item at 15% if you are trying to encourage sales of that item.

2861: Credit Card Integration

We are no longer integrated with PCCharge. Our new credit card integration is done through a company called Payment Logistics. We are now using an integration to their Paygistix Client application. This new integration allows us to be fully removed from requirements of storing credit cards and providing functionality for swipe devices. All of that functionality is being provided by Payment Logistics. As a result of this change, your company will need to complete all credit card transactions that are in a "pre-authorized" state prior to upgrading to this version of Acclamare.

3732: Customer Maintenance

Modified the "Save As" function so that the user can specify that Promotions, Contracts, and Document Settings carry over to the new customer or not.

2586: Customer Payment

Corrected an issue that allowed a "Credit Application Only" payment to be reversed multiple times.

3773: General Ledger Inquiry

The General Ledger Inquiry query has been rewritten to improve performance.

3737: Minimum Order Rules

The "Fee Account" field is now required.

3730: Promotion Maintenance

Added a feature to allow the user to specify the catalog and page number on which the item can be found.

3731: Promotion Maintenance

Added a "Save As" feature to promotions.

3539: Purchase Order

The functionality that prevents a Vendor Drop Shipment from being printed if the associated Sales Order is on hold has been restored. Users can no longer print these documents without first clearing the holds on the Sales Order. To be clear, this functionality was only missing from within the Purchase Order screen. Orders printed via the mass printing routine were already enforcing this rule.

3734: Quick Inventory Transfer

We've added a new function called "Quick Inventory Transfer". The first part of this functionality is implemented by way of a new field in Warehouse Maintenance. The user can now specify that a warehouse is at the same physical location as another existing warehouse. Once this setting is in place, the user can then initiate a quick transfer between any two warehouses that are setup in this manner. At this time, unit controlled items and/or non-stocked items are not supported.

3795: RateLinx integration

We've added a new shipping integration. We now support the RateLinx product. This integration allows your shippers to shop for the best shipping costs that fit your need. By creating a carrier (or multiple carriers) and setting the "Carrier Type" to "RateLinx", your shipment integration will utilize RateLinx and will recognize whichever carrier and service was selected upon importing the tracking file.

3720: Sales Order

The Freight Charge table is now being used to calculate an estimated freight value for sales orders.

3729: Shipping

We've added a new field to the Shipment table that tracks the shipping cost that the carrier charges to your company. If your integration is setup to provide this information, you will be able to track the freight you're charging your customer versus the freight you're being charged.

3802: Shipping

Added a "Notes" field to the Shipping screen.

3728: Targeted Picking

We've added a new function called "Targeted Picking". This area has two main purposes. First, it attempts to optimize which available sales orders should be picked simultaneously by grouping orders together that have similar items, share bins, are in nearby bins, or are stored on the same rack. Second, it attempts to optimize the path taken through the warehouse so that picking these orders is done in the shortest route possible. Look for more details in an upcoming wiki article.

3776: User Security

Added field level security for the price in Price & Availability.

3777: User Security

Added field level security for the price in Customer Quote.

3549: Vendor Drop Ship Confirmation

The user is now prevented from saving or posting a Vendor Drop Ship Confirmation that has an outbound freight value but does not have a value for carrier.

Bug Fixes

3778: AR Aging As Of

Corrected an issue that made credits appear as positive values.

3851: Autofill

Corrected an issue that occurred due to locked orders being filled. Locked orders are no longer considered for Autofill.

3607: Bank Withdrawal

Corrected an unhandled exception that occurred when starting a new Bank Withdrawal if one of the vendor payments was tied to a vendor without a name.

3769: Customer Quote

Corrected an issue that could occur after the user had changed line numbers on one or more lines. If the user then tried to delete a line, the system, in some cases, would delete the wrong line.

3491: Customer Return

Corrected an unhandled exception that occurred when the user pressed the button for Vendor Item Cost Comparison on an empty line.

3572: Kit Maintenance

Corrected an issue that caused the Item Description to not be exported to Excel files.

3508: Kit Order

Corrected an issue that could cause incorrect GL entries. This only occurred if the kit order contained a virtual-stock item that was turned into a stock item prior to the kit being posted.

3712: Manual AR Document

Corrected an unhandled exception that occurred when the user pressed 'Save' while no document was loaded in the screen.

3746: Price and Availability

Corrected an unhandled exception that occurred if the user tried to release a customer quote that didn't have a warehouse specified.

3473: Quantity Adjustments

Corrected an issue that prevented the user from selecting damaged serial numbers when doing a "Damaged to Available" or "Decrease Damaged" adjustment.

3770: Sales Order

Corrected an issue that made it appear to the user that minimum order charges could not be applied to an order. This only occurred if the user visited the totals screen multiple times.

3467: Shipping

Corrected an issue that prevented the "Customer Name" field from being populated.

3713: Unit Cost Adjustment

Corrected an unhandled exception that occurred when starting a Unit Cost Adjustment on an item that did not have a description.

3850: Vendor Credit

Corrected an unhandled exception that occurred if the user posted the credit prior to saving it.

Database Changes

New Computed Columns

We've added computed columns to several tables throughout the database. These columns are mostly being used to translate a numeric value into a meaningful English value.

In every case, the first part of the name of the column is the same as the name of the column being translated. This name is followed by the word "Computed". For instance, ARTerm.TermType is described by the computed column named ARTerm.TermTypeComputed.

We believe that these new computed columns will enable users to understand their data better and be more effective at report modification.

The list of columns that have been added is as follows:

ARTermType.TermTypeComputed
BankWithdrawlDetail.DetailTypeComputed
BlankCheck.BlankCheckStatusComputed
Carrier.CarrierTypeComputed
ChartOfAccounts.AccountTypeComputed
CommissionPlan.CommissionBasisComputed
CommissionPlan.SaleBasisComputed
CommissionPlan.CostBasisComputed
CounterSale.CounterSaleStatusComputed
CounterSaleLine.ItemTypeComputed
Customer.StatusComputed
Customer.FOBComputed
Customer.FreightPaymentMethodComputed
Customer.InvoiceDeliveryMethodComputed
Customer.AllowBackorderComputed
Customer.PricingStrategyComputed
CustomerCollectionCallDocument.CallActionComputed
CustomerCredit.CustomerCreditStatusComputed
CustomerCreditLine.ItemTypeComputed
CustomerLocation.FOBComputed
CustomerLocation.FreightPaymentMethodComputed
CustomerLocation.AllowBackorderComputed
CustomerOverpayment.OverpaymentStatusComputed
CustomerPayment.PaymentTypeComputed
CustomerPayment.PaymentStatusComputed
CustomerPayment.CCStatusComputed
CustomerPayor.PayorStatusComputed
CustomerPayor.StatementDeliveryTypeComputed
CustomerQuote.FreightPaymentMethodComputed
CustomerQuoteLine.PriceSourceComputed
CustomerRefund.RefundStatusComputed
CustomerRefund.CCStatusComputed
CustomerReturn.CustomerReturnStatusComputed
CustomerReturnLine.ItemTypeComputed
CustomerReturnReceipt.ReceiptStatusComputed
CustomerUnreturn.CustomerUnreturnStatusComputed
CustomerUnreturnLine.ItemTypeComputed
DocumentControl.DocumentTypeComputed
DocumentControl.DeliveryMethodComputed
DocumentControlCustomer.DocumentTypeComputed
DocumentControlCustomer.DeliveryMethodComputed
DocumentControlUser.DocumentTypeComputed
DocumentControlUser.DeliveryMethodComputed
DocumentControlVendor.DocumentTypeComputed
DocumentControlVendor.DeliveryMethodComputed
DocumentControlWarehouse.DocumentTypeComputed
DocumentControlWarehouse.DeliveryMethodComputed
FreightAllowance.FreightAllowanceTypeComputed
FreightCharge.FreightChargeTypeComputed
GeneralLedgerCategory.AccountTypeComputed
GeneralLedgerInventoryPostingHeader.InventoryTypeComputed
GeneralLedgerReason.ReasonTypeComputed
GlobalPriceBracket.PriceBasisComputed
GlobalPriceBracket.CostBasisComputed
HazardousMaterial.ShipmentTrackingComputed
HazardousMaterial.PickTicketTrackingComputed
HazardousMaterial.MSDSTrackingComputed
Item.ItemStatusComputed
Item.ControlTypeComputed
Item.BracketPriceBasisComputed
Item.BracketCostBasisComputed
Item.BracketTypeComputed
Item.ItemTypeComputed
ItemFamily.DiscountLevelComputed
ItemFamily.BracketBasisComputed
KitOrder.KitOrderStatusComputed
KitOrder.ItemTypeComputed
KitOrderLine.ItemTypeComputed
LandedCostDetail.LandedCostBasisComputed
ManualARDocument.DocumentTypeComputed
ManualARDocument.DocumentStatusComputed
MinimumOrder.MinimumOrderTypeComputed
MiscCashReceipt.ReceiptStatusComputed
MiscCashReceipt.ReceiptTypeComputed
PALine.PriceSourceComputed
PhysicalCount.CountTypeComputed
PhysicalCount.UMTypeComputed
PhysicalCount.CountSequenceComputed
PriceContractFamily.PriceMethodComputed
PriceContractFamily.PriceFormulaComputed
PriceContractFamily.CostBasisComputed
PriceContractGroup.PriceMethodComputed
PriceContractGroup.PriceFormulaComputed
PriceContractGroup.CostBasisComputed
PriceContractItem.PriceMethodComputed
PriceContractItem.PriceFormulaComputed
PriceContractItem.CostBasisComputed
PriceContractFamilyBracketHeader.PriceFormulaComputed
PriceContractFamilyBracketHeader.CostBasisComputed
PriceContractGroupBracketHeader.PriceFormulaComputed
PriceContractGroupBracketHeader.CostBasisComputed
PriceContractItemBracketHeader.PriceFormulaComputed
PriceContractItemBracketHeader.CostBasisComputed
ProductGroup.PriceBasisComputed
ProductGroup.CostBasisComputed
ProductGroup.TableTypeComputed
PurchaseOrder.PurchaseOrderStatusComputed
PurchaseOrderLine.ItemTypeComputed
PurchaseReceipt.ReceiptStatusComputed
PurchaseReceiptLine.ExcessDispositionComputed
RecurringVendorInvoice.ReleaseScheduleComputed
Replenishment.ReplenishmentTypeComputed
ReplenishmentDetail.ItemStatusComputed
ReplenishmentDetail.ReorderLevelComputed
ReplenishmentDetail.ReorderMethodComputed
ReplenishmentDetail.ReorderClassComputed
Requisition.RequisitionStatusComputed
ReworkLandedCostDetail.LandedCostBasisComputed
ReworkOrder.ReworkOrderStatusComputed
ReworkOrderLineIn.ItemTypeComputed
ReworkReceipt.ReceiptStatusComputed
SalesInvoice.SalesInvoiceStatusComputed
SalesInvoice.SummaryBillStatusComputed
SalesInvoiceLine.MissTypeComputed
SalesInvoiceLine.ItemTypeComputed
SalesOrder.SalesOrderTypeComputed
SalesOrder.SalesOrderStatusComputed
SalesOrder.FreightPaymentMethodComputed
SalesOrder.AllowBackorderComputed
SalesOrderLine.MissTypeComputed
SalesOrderLine.ItemTypeComputed
SalesOrderLine.PriceSourceComputed
SalesOrderLineDetail.LineTypeComputed
Shipment.ShipmentStatusComputed
StockItem.ItemStatusComputed
StockItem.ReorderLevelComputed
StockItem.ReorderMethodComputed
StockItem.ReorderClassComputed
StockItem.ReviewCycleComputed
StockItem.SafetyStockTypeComputed
UnitCostAdjustmentDetail.LineTypeComputed
Vendor.VendorStatusComputed
Vendor.DefaultPaymentTypeComputed
VendorContractDetail.ContractFormulaComputed
VendorContractDetail.CostBasisComputed
VendorCredit.CreditStatusComputed
VendorDiscount.DiscountBasisComputed
VendorDiscount.DiscountLevelComputed
VendorFamily.DiscountBasisComputed
VendorFamily.DiscountLevelComputed
VendorInvoice.InvoiceStatusComputed
VendorInvoice.ManualPaymentTypeComputed
VendorItem.BracketTypeComputed
VendorLandedCost.LandedCostBasisComputed
VendorPayment.PaymentStatusComputed
VendorRebateDetail.RebateBasisComputed
VendorRebateDetail.CostBasisComputed
VendorRebateDetail.PriceBasisComputed
VendorReturn.VendorReturnStatusComputed
VendorReturnLine.ItemTypeComputed
VendorReturnShipment.ShipmentStatusComputed
VendorTarget.TargetBasisComputed
WarehouseTransfer.TransferStatusComputed
WarehouseTransferLine.FromItemTypeComputed
WarehouseTransferLine.ToItemTypeComputed
WarehouseTransferReceipt.ReceiptStatusComputed

Removed Functions

As a result of adding computed columns, some of scalar functions are no longer needed and have been removed. The list is as follows:

fCostBasis
fCustomerPaymentType
fCustomerReturnStatus
fDiscountLevel
fFamilyBracketBasis
fItemStatus
fKitOrderStatus
fMissType
fPriceBasis
fPurchaseOrderStatus
fReorderLevel
fReorderMethod
fSafetyStockType
fSalesInvoiceStatus
fSalesOrderStatus
fSalesOrderType
fStockItemStatus
fVendorInvoiceStatus
fVendorReturnStatus
fWarehouseTransferStatus

Wiki

Wiki

Version 2014.2.2.7