12.13 - Feature Release
Release Notes and Help topics can refer to changes, features, and fixes that your company may not yet have installed. Use Help and About to check your application version for comparison to the Help version. The current Help version is 12.15.35. When an update is installed, all changes up to that version are included even if your company "skipped" one or more prior updates.
It is possible for some changes, particularly fixes, to overlap more than one release. For example, an issue may be fixed independently in our production line (current release) as well as our beta or development lines. For this reason, you may see similar items that are also referenced in other notes.
Identifiers are now included with most items in the notes. These are used by our project tracking software, or source control, and are sometimes linked to support tickets. Identifiers prefixed with the letter "R" are requests, "D" are defects (fixes), and "B" or "E" stands for backlog items (enhancements or new development usually).
Note: To find individual release changes on this page, you can use the "find" function CTRL-F. Later notes for updates (stability) are also provided in separate topic(s) so that users can just view those changes. We provide links in the main "feature" notes to any stability notes topics. |
Major Features
There are six (6) major features available with release 12.13: Kiosk, Do it Best Drop Ship, Do it Best Promo Order, Unlimited Payment Method, Item Analyzer Update, and the User Interface.
With release 12.13, the ECI Spruce application was redesigned to comply with the ECI Software Solutions color scheme. Changes include new icons, logo images, and color schemes. Functionally, the application works the same as previously; however, you will notice that the green Spruce icon has been replaced with the ECI Spruce icon. The ECI Spruce icon has the same functionality as the Spruce icon did previously. All upgrades to 12.13 will update to the new ECI Spruce theme.
B-36776 - Point of Sale / Reports / Customer Orders Added "Branch" to the "Sort By" drop-down list option to allow for subtotaling by branch on the Customer Order Summary Report. B-36948 - Point of Sale / Reports / Customer Orders The QtyRecv (quantity received) and QOH(quantity on hand) columns are displayed on reports if the Item Style radio button is selected. Also, the QOH will match the QOH for the selected branch. B-48083 - Point of Sale / Blackhawk Change the Blackhawk (gift card) service to allow voids to happen up to 90 days after activation. B-49739 - Point of Sale / Sales - Cash Ticket Receipts Bank card type used will reflect on printed receipt. B-49894 -Point of Sale / Sales / Air Miles Dialog Add Air Miles bonus offers for the Collector's pop-up dialog window. B-50233 - Point of Sale / Utilities / Invoice We corrected an issue where users would get an error when saving a POS Assured invoice on the adjustment code. Users will now get a task list warning stating "No POS Assured Adjustment Code set in parameters". No task list warning will appear if the adjustment code is set to a valid adjustment code in database > parameters. B-50238 - Point of Sales / Sales - Card Processing An unlimited amount of bank cards can be entered including custom cards types defined by your company. Cards that are integrated will be processed through the terminal per set procedures. Non-integrated bank cards, will require an authorized code. Bank cards and authorization codes are setup in Maintenance > Database > Parameters. B-50476 - Point of Sale / Orders - Fixed Length Tally We added the ability for users to backorder fixed length tally child items and select deposit amounts during the order invoicing process (F12). This allows the user to process sales that include backorder items without first having to modify the tally line on orders and break them in multiple lines. B-50972 - Point of Sale / Sales - Auto Bill of Materials Added the ability to sell and manufacture a product from the Sales transaction grid. This option provides users who manufacture products using a consistent process involving basic in/out materials and finished products, a way to stream line manufacturing. B-52195 - Point of Sale / Quotes - Unit Tally Unit Tally items are now supported in Quotes. When a Quote is processed (F12), the data is saved with the quote, however the items listed on the quote will have no affect on Inventory. B-54338 - Point of Sale / Sales Single quote characters can now be used for enhanced customer search. Customer Enhanced Search must be turned on in Maintenance > Database > Parameters > Options > Point of Sale. B-55214 - Point of Sale / Sale - TSYS Cayan Added the ability to update the Address Verification System (AVS) information on file from Point of Sale (POS) if there is an AVS mismatch. This may result in transactions receiving a lower interchange rate. B-55656 - Point of Sale / Sales - Air Miles An Air Miles Collector ID can be saved for a customer account. The saved Air Miles Collector ID will be set as a default for the account when awarding Air Miles on a sale, charge return or payment transaction. The "Save Collector ID" option must be turned on in Database > Parameters to activate this feature B-55712 - Point of Sale / Utilities - Award Air Miles A new utility screen is available to award Basic and Bonus Air Miles to a sale or charge return transaction. The Award Air Miles utility allows the selection of a previously processed sale or charge return in which an Air Miles Collector ID, Air Miles Basic offer code and Bonus offers can be applied. B-60464 - Point of Sale - TSYS Cayan Send level 3 information to TSYS Cayan regardless whether the line items are displayed on the CED or not. D-37397 & D-45143 -Point of Sale / Sales Two (2) additional prompts for "card on file" will no longer appear after selecting "card on file" during a Point of Sale transaction. D-45313 - Point of Sale / Sales - Folders (F4) Prevent out of memory exception when viewing large inventory images when the software is scaled larger than 100%. D-45614 - Point of Sale / Sales Prevent "Index out of bounds" error when entering a True Value Limited Use coupon in a sale transaction. Rather, a warning will appear stating "The coupon cannot be accepted without items being entered." D-45619 - Point of Sale / Sales Corrected an issue where the grid header row sort indicator was displaying a solid black rectangle. D-45656 - Point of Sales / Sales Corrected an issue where an Unhandled Exception error was generated when choosing to use Card on File. D-45745 - Point of Sale / Orders Disabled User IDs will no longer be available for selection in Point of Sale on the Account tab of Process Order Document dialog window. D-46506 - Point of Sale / Sale Corrected an issue where applied deposits on a customer order (cash account) were updated again when ticket was invoiced, causing the deposit amount to double. This would incorrectly reduce the remaining deposit on the order. D-46596 - Point of Sale / Sales / Do It Best Rewards Removed logic that looked at default store is enabled for rewards and refactored logic to look at current branch. D-46618 - Point of Sale / Database / Account The Sort Name will not change when adding a loyalty account to and existing user account. D-48066 - Point of Sale / Sales - TSYS Cayan Due to operation timeouts, double charging could occur when a credit card payment was processed but Spruce would still receive inconclusive responses from TSYS Cayan. Spruce is now sending an inquiry to TSYS Cayan to check the status of the payment before the cashier is presented with a message to Retry. D-48423 - Point of Sale / Orders - Prolink E-Commerce orders where not always imported with payments. Orders will now use the card on file. D-48571 - Point of Sale / Orders - Tally Pull Fixed an issue where if Pull Tallies were removed from the order grid and new items were added an error would occur. D-48622 - Point of Sale / Sale - TSYS Cayan Fixed issue where custom bank card types were not being retrieved when using TSYS Cayan for a customer order. D-48934 - Point of Sale / Sales - Cash Tickets An issue was reported where the wrong logo would print on the cash tickets if the logo was not stored in the database, but rather a file path lookup was used. This issue has been solved. D-48966 - Point of Sale / Sale Fixed an issue where the application would close when splitting a non-integrated bankcard (or manual authorization bankcard) with an integrated bankcard. D-49022 - Point of Sale / Inquiry / Account - TSYS Cayan Fixed an issue where uses could make changes to the card on file in Account Inquiry. D-49064 - Point of Sale / Sales - Adjustments Discount type adjustments will always reduce the sale or credit total for the transaction. Additionally, the net transaction total between a sale and credit entered the same way (other than the quantity being the reverse sign) will match. D-49172 -Point of Sale / Quote - Adjustments Adjustment codes on quotes were not copying over to orders or sales. This has been corrected so that when a quote or order has a single adjustment code that matches the current account or job's default adjustment code, that code will be replaced with any new job's default adjustment code. Also, when a quote or order has more than one adjustment code, the job is changed, and if the new job has a default adjustment that does not match the original job's, the user will be notified, but the codes will not change. D-49299 - Point of Sale / Quotes -Unit Tally Fixed an issue where quote transactions would not save if modified, and re-saved when the Unit Tally feature was enabled D-49317 - Point of Sale / Orders - Lineal Tally Modifying a quote, order or ticket that has a lineal tally missing BOMData would sometimes return an error. This has been corrected. D-49272 - Point of Sale / Sale - Fixed Tally Item Fixed an issue where using a fixed tally item in Point of Sale would return an error. Users can now add the fixed tally item in an order and proceed with the transaction. D-49278 - Point of Sale / Sales - Air Miles Fixed an issue where an error would occur when resuming a suspended sale transaction where an Air Miles Collector ID had been entered. D-49201 - Point of Sale / Sales - ACE Gift Cards No prompt would appear when activating a gift card purchase if paid by credit card. A prompt will now appear when activating gift cards. D-49997 - Point of Sale / Sales - Verifone Corrected an issue where the signature pad would not respond if the option "No Item Display" was selected. D-50173 - Point of Sale / Sales - Processing No error should occur during completion of sale for instances of a normal sale and also instances where user continues to scan one or more items after clicking the finish button on the process form. D-50336 - Point of Sale / Sales - Auto BoM When selling an Auto BoM item at POS, materials used to generate the work order will show a reduction of quantity on hand. D-50406 - Point of Sale / Reports - Daily Sales December and January Daily Sales report will run without issues. TFS-157118 - Point of Sale / Barcode Scanning Quick fix to issue where barcode scans were double-counting items due to the code being called a second time due to the Best Rewards checks being placed inappropriately. TFS-157148 - Point of Sale / Card Processing - Verifone Point Verifone Point now allows the transmission of the customer code with purchase level II data. TFS-157324 - Point of Sale / AIR MILES Air Miles: added additional check for existence of collector number prior to bringing offer code prompt. TFS-158010 - Point of Sale / Returns referencing an Original Sale Changed routine for getting cost from a return reference. If original invoice has a higher QuantityID than the return, don't get the cost from the original invoice. Treat it as using current on-hand. Example scenario: Item is sold into the negative with the original invoice. Return is done. Since item is in closeout, the on-hand is brought back to positive by the return. This return changes average cost. Since the cost of the original invoice has not been allocated yet because it was in closeout, the cost it would get would be from the return. And the return would try to get its cost form the original invoice causing a circular reference. In this case, the return should get its cost from the current weighted average, then the original invoice would get its cost also from the current weighted average. |
B-47107 - Purchasing / Vendor EDI - Do It Best Promo Order Confirmation Purchase Orders are created when a Promo Order Confirmation file is processed. B-49754 - Purchasing / Vendor EDI - Do It Best Drop Ship Order Confirmation Do It Best will create an order confirmation from orders placed with outside vendors. This file will enable the application to create a PO (purchase order) and add the SKUs to the inventory. B-49822 - Purchasing / Order Entry - Staging There is now an option to copy staging information for back-ordered items. After creating a Purchase Order (PO) with several items, including one or more special order items and one or more manufactured items, receiving (F5) it will require you to optionally provide some textual "Staging" information for those items. If a PO with staging information is partially received, this new feature allows the user to re-use the staging that was provided previously. A prompt will appear asking the user whether they wish to use the previous staging information, if the user selects no, the information will need to be entered manually (as in previous functionality). D-48338 - Purchasing / Order Entry - ACE Rewards Fixed an issue where blue coupons would not scan. D-49401 - Purchasing / Vendor EDI When loading an EJD price update file, only the catalog and file maintenance files would populate in the grid, even though price udpates were present in the file. This has been corrected and price updates now load properly. D-49613 - Purchasing / Vendor EDI - ACE Corrected an issue where the ACE Catalog load was not pulling the electronic invoice and not the hotsheet file. The hotsheet file will now be pulled. D-50236 - Purchasing / Vendor EDI - DIB Can now send Retail Price level 0 prices to Do It Best via Purchase Order. TFS-160097 - Purchasing / Vendor EDI - ACE In-Store Pickup (ISPU) ACE ISPU send was always throwing an assertion that the script was too long. Changed the max length of the script size to a higher value. Each retrieval is doing up to 250 items so that it isn't an arbitrary large size. TFS-160753 - Purchasing / Vendor Catalog - ACE Images ACE Hardware Corporation has made changes to their public website affecting image retrieval. We have changed the retrieval method to use image URLS from the EJD tie in (same item numbers as ACE) to get the images. |
B-50465 - Inventory / Utilities / Item Analyzer Item Analyzer compares specified fields between the EDI catalog and inventory items to identify any unmatched fields. If any discrepancy occurs, a prompt will appear asking whether user wants to create a price update. These setting defaults can be set in Maintenance > Database > User IDs and Inventory > Utilities > Item Analyzer. B-50711 - Inventory / Database / Item / Import (F2) / Wizard / Update Inventory In the Update Inventory Wizard, users would have to map all 5 keywords when importing a spreadsheet or an error would occur saying that "All 5 keywords must be mapped as they must be updated together". This has been corrected and users can now import a spreadsheet while using 1-5 keywords. D-44542 - Inventory / Price Updates The “promo” drop down control displayed for the Delete Posted Sale function was including unapplied rather than posted (applied) sales. A new control has been added for use with deleting an applied sale. Only items currently on sale matching the promotion dates will be listed. Loyalty-only sales are included if they apply. D-48633 - Inventory / Price Updates Prevent users from editing datagrid columns, except the Delete column, if "Promotional Pricing Enabled" option is turned on. D-49038 - Inventory / Reports - Physical Count Worksheets Incorrect header would display on the the Physical Count Worksheets. This has been resolved. D-41795 - Inventory / Adjustments - Transfers When a transfer (not received) was selected for the same business day, a message box would appear stating that same-day transfers could not be reversed due to GL implications. This has been corrected and a message box will no longer appear. D-49354 - Inventory / Database - Material Lists Users can now use decimal values in the quantity field in Material Lists Maintenance. TFS-157314 - Inventory / Utilities / Maintenance / WMS Location Updates Added message for WMS (Warehouse Management) Location Update form: "Reassigning unlike items is not permitted." |
D-46542 - Receivables / Posting - Debit Adjustments An order would prevent adding an adjustment for an account with jobs. This has been corrected. |
D-45142 - Payables / Utilities / Check Backout Corrected an issue where check Backout wasn't clearing the "Closed Date" on the AP Billing Invoice so when the check was later paid (again), the close date remained the original value predating the new check (paid) date. D-49463 - Payables / Utilities - EOY 1099 Rearranged text in Box 7 so it now lines up with the dollar sign. |
D-49283 - General Ledger / Database - Detail Mapping Gift card activations were being considered as split bankcard transactions by End-of-Day (EOD) processing causing invalid journal entries to be generated by EOD processing. This has been corrected. R-52737 - General Ledger In some instances, when a non-standard fiscal year would close, the following AP period would default to the prior year. This would need to be fixed manually. This issue has been solved and the AP period will now automatically default to the following year. R-52935 - General Ledger / Reports - Trial Balance Fixed an issue where the wrong GL Period would show on the Financial Statements. |
B-57943 - Delivery / Utilities - GPS Tracking Browser will display Google maps without errors. |
B-48538 - Maintenance / Database / Branches - Cash Ticket Enhancements Printed cash tickets have been improved by modifying spacing, label alignment, removal of abbreviation, removal of seconds and colons. There is now the ability to select optional elements that can be included on the printed cash tickets. The Optional elements are: •List price on discounted items •Total customer savings •Customer signature •Authorized buyer •Document barcode B-50778 - Maintenance / Database / Parameters - TSYS Cayan Level 3 Reporting & Vault Tokens System can now send Level 3 reports to TSYS Cayan using bank cards or card on file with vault tokens. B-53603 - Maintenance / Database / Parameters - Kiosk A new option in Database / Parameters allows for seat control for the Kiosk feature. The Device Maintenance utility will be aware of the kiosks seat licenses and show the Scan Kiosk Remote Device Type option based on that availability. D-46455 -Maintenance / Database / Devices When a control is enabled or disabled, the control background color will immediately reflects the change. D-46540 - Maintenance / Database / Parameters Corrected an issue errors would occur when processing (F12) changes to parameters. |
B-46955 - Miscellaneous - Kiosk The Kiosk feature provides the ability for customers to view prices and check gift card balances from a stand-alone device. B-50471 - User Interface The new ECI Spruce color theme will be visible throughout the software. Software functionality remains the same throughout the software. The ECI Spruce logo at the top of the Navigation Menu operates in the same way the Spruce tree logo operated previously. B-54424 - Miscellaneous - Function Keys Function keys were sometimes missing on both the AP Billing Invoice and Database Maintenance screens. B-53349 - Database / Parameters Modified the "Version" interface in the Setup/Software tab under Parameters. The section is now called "Culture/Region" and users have the ability to change or designate a region, and indicate whether or not the region uses a VAT tax system. D-49110 - Installer The hosted Installer would fail during install while updating messages. This has been corrected. D-49529 - Remote Client The PIN dialog prompt was continuously being displayed after entering the PIN when attempting to pair a Remote Client. This has been corrected. TFS-157750 - Miscellaneous / Barcode Scanner Fix to issue where the 2D scanner model DS4308 did not scan properly. The cause of this issue was that a control character was included in the barcode string, which interfered with our ability to do database searches and the like based off of that barcode. This has been fixed by removing control characters out of the barcode before passing them on. TFS-158584 - Miscellaneous / Barcode Scanning Fix to scanning issue wherein certain characters in a barcode were being misinterpreted as key presses corresponding to buttons on a pop-up form. This fixes the issue, so that if a barcode scan is currently in progress, the code will proceed to adding the key to the barcode string regardless. |
D-49003 - Reports In instances where a fixed length tally was partially sold and the remainder backordered, some document formats were reporting the originally-ordered child item quantities instead of the backordered / remaining quantities. The reports have been updated to report the backordered or remaining quantities at the child item level D-49224 - Reports The Cashier's Report for bankcards was no longer breaking the totals by card type. The Cashier's Report and Daily Sales Report have both been updated to reflect card types. D-49303 - Reports Scheduled reports without data would return an error when created rather than create a blank PDF. This has been corrected. D-49918 - Reports / Daily Sales & Cashiers Reports Corrected an issue where bankcard totals were incorrect on Cashiers & Daily Sales reports when a transaction was anything other than an invoice. |