Date: October 27, 2004 These are the release notes for Response v8.1 (build 3053) IMPORTANT NOTE! Only Response 8.x users may install this update. --------------------- --- 3053a Changes --- --------------------- The Unshipped Orders and Media Master Listing reports failed with a formula error. This has been fixed. Orders containing drop-ship items will not be set to "B" status if the other items are fully backordered. This allows the order to be authorized and printed along with regular "E" orders for purposes of allowing the drop-ship PO to print. Otherwise the drop-ship PO would not print for reason "order not authorized". Using TransFirst, prepaid orders authorized/settled through batch mode were not updateing the order's deposit amount correctly, resulting in an additional settlement attempt when the item was shipped. This additional settlement would fail since it did not have a valid authorization, but was still an error condition.. Warehouse Picklist settings in Picking Ticket screen were not being loaded/saved properly when entering/exiting or loading a .PSL file. The picklist settings will now load and save properly. --------------------------- --- Enhancements [3053] --- --------------------------- SQL Rewrite [Phase One] Many Response processes were encoded in native SQL. This optional behavior is activated by the presence of the file SQL.FLG in the \r4w\data directory. If the flag exists, the SQL versions will run instead of the DataFlex/Mertech code. Please note that you must restart Response after adding or deleting the SQL.FLG file. Order Entry Kit Expansion (5 separate update routines, out of a total of 7 or so, were coded in SQL. The performance gain is huge.) Changing Media Code (and associated updates including lineitems) Changing Order Date (ditto) Entering/Changing discount percentage (as it updates sales history for customer/inventory/media). Period End [Month/Year-End] Processing All update routines (dramatic increase in performance). NOTE: SQL Stored Procedures are created with the sp_update.vd7 program (run like chgfiles). Basically, sp_update.vd7 is executed (doesn't affect Response directly), then create SQL.flg to enable the SQL procedures. Please contact support@colinear.com before activating the SQL code inside Response with sql.flg. Customer Service Lookup / Inventory Inventory now shows Vendor Name, Vendor Item ID, and Vendor Item Description. Customer Service Lookup / Orders "Order Review" button added. Paymentech Orbital ECC Gateway Handling real-time authorizations better. Will perform an auth-reversal when the auth is declined for AVS, and AVS handling will occur in Response, not at the processor. Also, streamlined the popup messages received in Order Entry. TransFirst ECC Gateway spaces in addresses/names would not be sent correctly, could possibly affect AVS result. Batch authorizations will now perform an auth reversal for Response AVS declines. Authorize.Net ECC Gateway Handling real-time authorizations better. Will perform an auth-reversal when the auth is declined for AVS, and AVS handling will occur in Response, not at the processor. Also, streamlined the popup messages received in Order Entry. Import Utilities "Other Defaults" functionality added to import programs to set defaults for user-defined fields in that file. RMail Optionally quote original message when replying/forwarding a message (flag option). ------------------------ --- Bug Fixes [3053] --- ------------------------ Import Utilities Could get "Key Values May Not Be Changed" error when importing. This was a result of a built-in function which loads the active record onto the screen when you open a different view (example: open customer service lookup and the customer data is already on the screen). The side-effect of this was that importing data would try to overwrite the existing data. Inventory Items Modifying Bin information (rank/refill level/refill qty) could give a "please enter a valid record ID" error. Could enter ANY vendor name in the "preferred vendor" field, even if that vendor did not exist. Vendor Item IDs now stored as "lookup IDs" using Ctrl+F. Import - Keywords would be added to keyword search file even if "not for retail sale" or "discontinued" was checked. Bin Locations Creating a bin "on-the-fly" (transfers, po receive, receipts/adjustments, returns) could result in the rZONE being left blank, which causes "please enter a valid record ID" errors later. Outstanding Orders Report (orddue.rpt) Was occasionally showing items that were already shipped. Order Entry Kit Allocation could result in kit master suggested=0 while all components suggested > 0. Kit Components could be "orphaned" without a kit master, not shown in order entry, but printed on picking tickets. Could get error "invalid message msg_search" after entering order comments, then alt+tabbing out of Response, then back. Rate Shop (web-based) would not set the residential indicator properly (based on ShipTo residential checkbox). Drop-Ship POs would not cancel properly if changing the ShipTo on a Drop-Ship lineitem. Discount Amount would not reflect properly to Media/Customer/Inventory history numbers. Check Number entry in Order Entry could not be closed with Alt+C (instead, the Customer tab would be activated). Changed to Alt+L. ShipTo Entry - Middle Initial was not forced to ALL CAPS. Import - If not importing Shipping Method Code, the selection in the "Defaults" tab would not work properly. Would result in "SHIPMETH code no match for " hold reason. Picking Tickets Fixed problem with picking ticket SPE (picktick.spe) where reprinting would result in no records being written. Service items were not being shown with a bin location (when present). Warehouse Picklist Service Items were not being shown on warehouse picklist. PO Edit - Save & Print would print canceled lines. Menu - Add-Ons Some Options would be greyed out when they were not supposed to be, and vice versa. Repeating "Unresolved Object Reference" errors could occur when entering a view. Customer Service Lookup / Inventory Bin locations would never show bin-specific pickable/location information. Start of Day Automatically deleting "T" status (Temporary) orders would leave orphaned ShipTo records in "T" status. Flag Options could get "unresolved object reference" error. Checks Module Refund checks could be created for credit card customers. Returning more than one item would result in multiple checks (one check subtotaled per item) to the same customer. These are now combined into one. Bins Changing from pickable to unpickable and vice versa would not properly update the inventory available qty. Warehouse picklist The first item on the picklist could be skipped. Import Utilities Full Name parse name function could result in setting first names less than 5 characters' salutation to "Mrs." Credit Card Processing Item merchant IDs for installment billing now support a separate "full-pay" merchant ID specified by payment number 0. Instant Authorizations now support auth increase factor (to authorize for X% more than actual balance due for purposes of settling with actual shipping charges, etc.). Flag Options / Credit Card Processing, last Flag Option. Enter, for example, 1.15 (max 1.25) to authorize for 15% more than the balance due. Undeposited Shipped Credit Card Orders Report was truncating credit card number, and ShipTo ID was shown with thousands separators. Check/Correct On-Order Quantities Could get SQL Error on WHSINV. ------------------------ --- Usability [3053] --- ------------------------ New Flag Files maxordqty.fil - if exists, contains the maximum lineitem order qty. The default limit is 9999. Increase up to 9,999,999. **Use at your own risk. ptspeix3.flg - Sort Lineitems in Picktick SPE (picktick.exp) in Bin Location order. torderdays.fil - number of days to keep "T" status orders in the system, older than this are automatically deleted at Start of Day. incresrv.flg - Available column in Order Entry includes Reserve (unpickable) qty. noboatoe.flg - Disable the "B" status setting at Order Entry (follow old rules). aliasonly.flg - Include ONLY item Aliases in the Item Lookup (Ctrl+F) lookup list. reauthrules.flg - Use Reauthorization rules to automatically retry declined batch authorizations (status D orders). settlerules.flg - Use Reauthorization rules for declined settlements. quotereply.flg - Quote original message when replying/forwarding RMail messages. Inventory Drilldown - PO On Order Qty drill down now shows the PO Entry date. Authorize.Net Retry logic added to the DEPOSIT section. Deposits were often declining for one of 2 reasons. 1) Return code = 47. This means they tried to settle for more than the auth amount Changed so Authorize.Net users will automatically authorize for 10% more than the order balance UNLESS the AUTHINCR.FIL flag is set to something other than 0 or 10. Also added retry logic in the deposit section so when a deposit fails for reason 47, the existing auth is backed out and an attempt to force capture on the balance of the shipment is made. These two working together should work pretty well. Tech note added 7/22/05: you can't actually tell Response to multiply simply by 1.0 (to not increase the amount at all). We advise those who wish to do so, set the Value in Authincr.file to 1.000001 This will increase the authorization amount by so little I don't think you'll even see it. At most a penny or two 2) Return code = 16. This means settlement was attempted twice using the same auth code. (e.g. auth for $100, ship $40, then ship $60). The first change was made was to blank out the order's auth code and auth date when ANY settlement is made against the authorization. This requires that a NEW auth obtained prior to printing backorders. Retry logic in the deposit section was added which, when a deposit fails for reason 16, attempts to settle with CAPTURE only (instead of prior_auth_capture). Again, these two changes should work well together.