- Minor Enhancements
- 2107: Bin Maintenance
- 3792: Commission Plans
- 2861: Credit Card Integration
- 3732: Customer Maintenance
- 2586: Customer Payment
- 3773: General Ledger Inquiry
- 3737: Minimum Order Rules
- 3730: Promotion Maintenance
- 3731: Promotion Maintenance
- 3539: Purchase Order
- 3734: Quick Inventory Transfer
- 3795: RateLinx integration
- 3720: Sales Order
- 3729: Shipping
- 3802: Shipping
- 3728: Targeted Picking
- 3776: User Security
- 3777: User Security
- 3549: Vendor Drop Ship Confirmation
- Bug Fixes
- Database Changes
This version was released to all customers on August 4, 2014.
Minor Enhancements
2107: Bin Maintenance
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