Elliott Version 8.6
Report Desk: Understanding SumValuesInGroup Aggregates
Release Date: 10/18/2022 Elliott Version: 8.6 and Higher Background The Sum aggregate is useful for calculating the sum of a value in all report rows. For example, a detail line in a report might contain a column for Quantity On Hand. You might use ...
Elliott 8.6 Requirements and Features Compatibility
Release Date: 11/08/2022 Version: 8.6 Introduction Unlike prior versions, Elliott 8.6 starts using the PSQL relational database engine to support features like Report Desk, PowerSearch, and Avalara. If you are thinking of using Elliott 8.6, this ...
Elliott 8.6 Installation & Directory Structures
Release Date: 11/14/2022 Revise Date: 09/28/2023 Version: 8.6 Network Share to Host Elliott Elliott relies on the PSQL database engine. On your PSQL server, you should have a network share to host the Elliott8 folder. For example, you could create a ...
How to Eliminate ASCII DAT Files from Elliott DATA Folder to Improve NTFS Security
Release Date: 12/08/2022 Version: 8.6 In the last decade, we have seen Ransomware attacks on Elliott users that caused a great amount of damage. Companies without proper backups can be devastated. Even nationwide organizations with sizeable IT ...
Report Desk: Missing Column Title
Release Date: 1/8/2023 Elliott Versions: 8.6 and Later How to Fix a Missing Column Title Occasionally, during custom report development, you may see something like the following when you first run the report: In this case, the column title ...
Feature: Send an Email to the User Locking a Record
Release Date: 1/26/2023 Versions: Elliott V8.5 and Above Background Some Elliott tasks, like COP Order Entry / Change Order, will cause a record to be locked while the task is executing. Subsequently, another user will start a task, like COP Order ...
How to Resolve File Busy or Permission Error from Updating DDF Due to Login SUPERVISOR
Release Date: 02/07/2023 Version: 8.6 & Up File Busy Error Installing Elliott 8.6 or a later version will cause the DDF files in the <ElliottRoot>\Bin86\DDF40 folder to be updated. However, the DDF files in <ElliottRoot>\Bin86\DDF40\STDDDF will not ...
Feature - HTML Credit Card Email Receipt Using PDF PostOffice
Release Date: 2/27/2023 Version: V8.5 (partial support), V8.6 & Up (full support) Background Before this update, credit card receipts were text-only documents, like the one here, that could be printed on paper, sent to disk. While the receipt can be ...
Feature: 8.6 Email Improvements - Multiple Email Servers, Universal Throttling & "Send From" Priority
Released Date: 07/25/2021 Revised Date: 08/19/2021 Version: 8.6 & Up 8.6 Email Servers' Settings Decoupled from Prior Version Even though users can use 8.6 with prior versions side by side, the changes with email servers' settings are significant ...
Feature - Invoice History Archive
Release Date: 8/23/21 Version: 8.6 and Above The current invoice history data tables CPINVHDR, CPINVLIN, CPINVOPT, CPINVMTL, CPINVRTG, CPBOXFHS (history version of CPBOXFIL), CPBOXHSR (history version of CPBOXSER), CPBOXHST (history version of ...
Elliott 8.6 Database Convention & Report Desk/PowerSearch
Release Date: 08/27/2021 Revision Date: 4/11/2022 Version: 8.6 Elliott 8.6 Database Naming Convention Elliott 8.6 now supports Report Desk and PowerSearch, features based on the PSQL relational database engine. Databases must be created for Report ...
Report Desk: Using PDF PostOffice
Release Date: 9/21/2021 Version: 8.6 and Higher Background PDF PostOffice is a feature that allows Elliott users to email selected documents (like Invoices, Statements, Quotes, etc.) directly to the customer as they are produced. PDF PostOffice has ...
Give Bin86 Folder Everyone Group Read & Execute Rights If NTFS Security Was Implemented
Version: 8.6 Release Date: 09/15/2021 Q - I just installed Elliott 8.6 on the PSQL Server. The installation was successful. Now, when I go to each workstation and use EL860.exe to run local, I get the following message: "This application could not be ...
Use Report Desk and Receive Message - Unable to Connect to Data Table NSCTLFIL_2
Release Date: 09/25/2021 Version: 8.6 & Up Q - When I used Report Desk for the first time, I received the message "Unable to connect to data table NSCTLFIL_2". See sample screen below: A - This may be caused by two things: Your Elliott database is ...
PowerSearch: Setup and Configuration
Release Date: 11/18/22 Version 8.6 and above PowerSearch provides a powerful developing environment for Netcellent to deliver modern searches with enhanced functionality. PowerSearch uses the PSQL relational engine to access the Elliott database. ...
PowerSearch: Overriding Standard Searches
Release Date: 4/28/23 Version: 8.6 and Above Generally speaking, PowerSearch report configuration is maintained by NETcellent and delivered in EL860S.Cfg. Customers should never modify this file, as it is overlaid with the latest version from ...
Power Search: Running and Designing Search Basics
Release Date: TBD Version: 8.6 and above PowerSearch is a new search-developing platform for Elliott Business Software. It is based on the PSQL relational engine accessing the Elliott database, which provides more flexibility when designing searches. ...
Login SUPERVISOR to Update DDF Files After Elliott 8.6 Installation
Release Date: 8/17/2022 Version: Elliott V8.6 and Higher Background Most of Elliott Business Software uses the PSQL transactional database engine (Btrieve) to perform its work. However, some new features of Elliott V8.6 use the PSQL relational ...
Report Desk: Notifications
Release Date: 8/31/2022 Elliott Version: 8.6 and Higher Background Some Report Desk reports may contain sensitive information or may need to be tracked for other reasons. Elliott Report Desk allows for email notification whenever a report is run. ...
Feature - Minimize Open Files by Elliott Defer Processing
Release Date: 7/14/2023 Version: 8.63.714 & Up Background The primary purpose of this enhancement is allow XCOPY to back up Elliott's data. Some users may choose to accomplish this by using XCOPY at nighttime through Task Scheduler. See below: The ...
Feature - Improved Support for Custom DDFs
Release Date: 6/5/2023 Elliott Versions: 8.6 and Higher Background Some customers have modified the standard Elliott DDF files to include custom information that is vital to their business. For example, the gun industry requires an FFL number and ...
Elliott Date Century Cutoff - Why Does Year 31 Become 1931?
Release Date: 12/06/2023 Version: 7.x & Up Q - What is the latest date of the web services support? We ran into a date with 2031 on an attribute date value and it was translated into 1931. A - The date century cutoff issue is probably not ...
Why Elliott 8.6 Does Not Prompt "Are Invoices Just Printed OK?"
Release Date: 12/15/2023 Version: 8.6 & Up Q - When invoicing in Elliott 8.6, we noticed Elliott no longer prompts us with the question "YES/NO Did Invoices Print OK?" Is there a setup flag we can turn on? We really need the ability to respond, "no." ...
LNA Packet Errors in Report Desk
Release Date: 1/10/2024 Elliott Version 8.6 and Up Occasionally when using Report Desk, you will get an error message on the screen containing "Invalid LNA response packet" or a red box like the following in the report output: This error is most ...
Report Desk: User-Defined Formulas
Release Date: 1/16/2024 Versions: Elliott V8.6 and Above Background Prior to this release, users had the ability to create a user-defined formula by dragging the [New Formula] node on the TreeView in the report designer to a line on the report. That ...
Report Desk: Understanding Timeout and Strikeout Scenarios
Release Date: 2/22/2024 Versions: Elliott V8.6 and Up Background: Report Desk Impact on the Database Server Report Desk sessions are run on the user's workstation -- that is to say, the creation, formatting, and delivery of the reports are done on ...
PowerSearch: Hiding All PowerSearches for a User
Release Date: 2/29/2024 Elliott Version: 8.6 and Higher Background PowerSearch allows Elliott users to have new, customizable search options. While this is generally beneficial, not all users will want to take advantage of this feature. This article ...
Report Disk: Hiding All Report Desk Reports for a User
Release Date: 2/29/2024 Elliott Version: 8.6 and Higher Background Report Desk allows Elliott users to have new, customizable reports. While this is generally beneficial, not all users will want to take advantage of this feature. This article ...
Feature: Searches for Report Desk Input Parameters
Released: 3/4/2024 Verson: Elliott v8.6 and higher Overview Until now, Report Desk users did not have the ability to search the database for a specific value of an input parameter. With this release, the ability to search for database values for an ...
Report Desk - How to Add Where Condition for Orders Qualifying for Pick Ticket without User Interface
Release Date: 03/29/2024 Version: 8.6 & Up Q - In Report Desk, I would like to modify the existing Order Edit List to develop a Pre Pick Ticket List. These are the orders and line items that qualify to print pick tickets. Therefore, I am only ...
How Do I Add A Column to An Existing UDR Report Desk Report?
Release Date: 04/11/2024 Version: 8.6 & Up Q - I would like to add ITEM_CASE_SIZE to an existing Report Desk Report. How do I do that? A - Bring up the existing Report Desk report, and click on the "Modify" button on the bottom right corner. If the ...
Feature - Preloading PowerSearch and Report Desk for Faster Startup
Release Date: 4/15/2024 Version: Elliott V8.6 and Above Background PowerSearch and Report Desk are powerful new features that bring additional capabilities to Elliott Business Software: PowerSearch gives customers the ability to use ...
Solving Elliott 8.6 Installation Conflict with Root Directory BTR Files
Release Date: 05/09/2024 Version: 8.6 Elliott 8.6 supports ReportDesk and PowerSearch features. Both features require installing BTR files at the Elliott root directory level. Some of these BTR files may change from time to time, which will be ...
Report Desk: Customizing the List of Available Reports
Release Date: 5/16/2024 Versions: 8.6 and Above Background Prior to Report Desk, the selection of a menu option to run a report usually resulted in a legacy-style parameter input screen like the following: However, if the Elliott program was modified ...
PowerSearch: Customizing the List of Available Searches
Release Date: 5/16/2024 Versions: 8.6 and Above Background Prior to PowerSearch, the pressing of F7 to start a search usually resulted in a legacy-style screen like the following: However, if the Elliott program was modified to also allow for ...
Feature: Joining Databases in PowerSearch and Report Desk
Release Date: 6/13/2024 Elliott Versions: 8.6 and Higher Background PowerSearch and Report Desk provide powerful abilities for our users to easily access and customize fast, powerful, and complex searches and reports. The default database for these ...
Issues with Running Elliott Locally for Windows User ID with Spaces
Release Date: 07/17/2024 Version: 8.6 Starting with Elliott 8.5, we encourage Elliott users to run Elliott from a local profile folder like C:\Users\User-ID\AppData\..... This method resolves the security limitations imposed by Windows OS where users ...