APVENEXT or CPINVXRF File Not Defined in DDF40 Directory

APVENEXT or CPINVXRF File Not Defined in DDF40 Directory

Release: 09/23/2021
Version: 8.5

Q - When printing a PO this morning, I received the following error.

DDF Error Trying to Create File
APVENEXT: File not defined in DDF40 directory.



A - This is a one-time message unique to Elliott 8.5 and it is unlikely that you need to access this table through the SQL relational engine and you can ignore the message.  APVENEXT is a new table added in September 2021 for the Elliott 8.5 release.  Purchase Order Print detects that APVENEXT.BTR does not exist and creates the BTR automatically.  Before creating APVENEXT.BTR, Elliott will look up the DDF definition for this table.  If the table is not defined in the DDF, the system displays this message.

In addition to APVENEXT, you may receive a similar message for CPINVXRF when printing invoices.  Elliott looks for the DDF files in the <ElliottRoot>\Bin85\DDF40 folder.  The Elliott 8.5 update does not update the DDF files by default since it might conflict with the PSQL relational engine database.

This problem is unique to Elliott 8.5 since the DDF files for the PSQL database relational engine will reside in the <ElliottRoot>\Bin86\DDF40\STDDDF folder starting with Elliott 8.6.  The Elliott 8.6 update will always update the DDF files in the <ElliottRoot>\Bin86\DDF40 folder to avoid a conflict with the PSQL relational engine.

In addition to APVENEXT and CPINVXRF, you may receive the same kind of message for other work files, even in Elliott 8.6.  For example, the first time you run New Item CSV File Import you may receive the following message:
    IMKITWRK: File not defined in DDF4 directory.
This is a normal message and you can simply click OK and ignore it. 

This message occurs for files not defined in the DDF and the physical file does not exist so an Open I-O will create it for the first time.  The following scenarios are exceptions to this rule:
  1. Files with "LCK" in positions 3-5 of the base file name.
  2. VTSREG4, a file used by Vertex.
  3. Files created by the Open Output command.  Typically Elliott will use Open Output for a work file, but IMKITWRK is an exception where we use Open I-O in New Item CSV File Import.
EMK



    • Related Articles

    • 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 ...

    • 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 ...

    • SYSPASS DDF Shared Memory Not Available When Starting Up Elliott

      Release Date: 1/18/2019 Q - I just started to use Elliott 8.5, on a user's computer, with the EL850.EXE utility, I created the Run Local icon for the user on the desktop. When I logged in to Elliott 8.5 for the first time, right after the system ...

    • New User-Defined Functions in Elliott DDF

      Release Date: 12/6/17 Modified Date: 07/08/2024 Version: 8.5 & up In the future DDF (target to be released with Elliott 8.5,), we will add the following four user-defined functions: ELIDATE2SQL SQLDATE2ELI ELITIME2SQL SQLTIME2ELI For example, you can ...

    • Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File

      Release Date - 3/25/19 Version: 8.5 and Up This feature uses a new table, the Invoice Cross Reference table, to determine if an invoice has already been used by another unposted or posted order. The Invoice Cross Reference is updated at the time of ...