Avalara - Update Requirements

Avalara - Update Requirements

Relational Database Support

The Avalara sales tax integration features available in version 8.6 are based on the PSQL relational database engine and require segmented keys and alphabetic document numbers. The integration is compatible with the version 8.5 or 8.6 DDFs. The DDFs that are installed must match the data file structure used by the Avalara sales tax integration.  Due to this requirement, the DDFs must also be updated after the installation of an Elliott update.

Running Version 8.6 Only of Elliott and Using 8.6 DDFs

Immediately after downloading and running the Elliott update, you should login to Elliott as the user SUPERVISOR.  When you do that, the startup process will compare the newer DDF files to the DDF files you were using for the relational engine (e.g., ELI86DATA or ELI86ROOT:
  • If no DDF files are different, Elliott will run without doing anything more.
  • If any changes are detected, the software will immediately copy the newer DDF files to directories (<ElliottRoot>\Bin86\DDF40\STDDDF, <ElliottRoot>\Bin86\DDFROOT\STDDDF, and <ElliottRoot>\Bin\DDF40) so that Elliott will run with the latest DDF files.
If any errors are encountered during the DDF update process, you must resolve this issue before proceeding.  See https://support.netcellent.com/portal/en/kb/articles/how-to-resolve-file-busy-or-permission-error-from-updating-ddf-due-to-login-supervisor for information on how to resolve the conflict.

Running Version 8.6 Only of Elliott Using 8.5 DDFs

If you are running version 8.6 and using the 8.5 DDFs, you must download and install both versions of the Elliott update. After the 8.5 installation procedure has completed successfully, the updated DDF files must be manually copied from <ElliottRoot>\BIN85\DDF40\LASTUPDATE to the destination like <ElliottRoot>\Bin85\DDF40 or <ElliottRoot>\Bin85\DDF40\STDDDF. If the target DDF files are used on 24x7 basis, you many need to shut down the PSQL (Actian Zen) engine in order to update them. See https://support.netcellent.com/portal/en/kb/articles/how-to-resolve-file-busy-or-permission-error-from-updating-ddf-due-to-login-supervisor for information on how to resolve the conflict.

Running Versions 8.5 and 8.6 of Elliott Side by Side

You must install the both corresponding versions of 8.5 and 8.6 Elliott updates. If you are running with the version 8.5 DDFs, after the 8.5 installation procedure has completed successfully the updated DDF files must be manually copied from <ElliottRoot>\BIN85\DDF40\LASTUPDATE to the destination like <ElliottRoot>\Bin85\DDF40 or <ElliottRoot>\Bin85\DDF40\STDDDF.  If you are running with the version 8.6 DDFs, after the 8.6 installation procedure has completed successfully you must login as SUPERVISOR and complete the DDF update procedure.

CLS
 


    • Related Articles

    • Avalara Setup Procedures - System Requirements

      Release Date: 4/28/23 Version: 8.6 and Above Supported Version Avalara integration is only supported in Elliott version 8.6 and above. Versions 8.5 & 8.6 Running Side by Side Issues While we allow users running 8.5 & 8.6 side by side, if a user ...

    • A Comparison of Elliott 7.5, 8.2, 8.5, 8.6 and 8.6 V2 DDF Files

      Release Date: 11/15/2022 Last Updated: 06/25/2024 Version: 7.5 & Up DDF Files are used to define the PSQL database schema. Generally speaking, we distribute five different types of DDF files for different versions of Elliott releases: 7.5 DDF: These ...

    • Avalara: Documentation Roadmap

      Release Date: 4/28/23 Updated: 4/29/25 Version: 8.6 and Above Introduction Elliott Business Software previously supports Vertex for national sales tax collection. Starting Elliott V8.6, we are favoring Avalara over Vertex. Existing Vertex users ...

    • Avalara Design Principles

      Release Date: 4/28/23 Date Revised: 10/4/23 Version: 8.6 and Above Issues Related to Running Versions 8.5 and 8.6 Side by Side While we allow users to run versions 8.5 and 8.6 side by side, if users turn on the Avalara interface then applications ...

    • Avalara - Customer File Maintenance

      Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the following changes will take effect in Customer File Maintenance. Customer File Maintenance must be run under version 8.6. If the user attempts to run the ...