Feature - Add IMINVLOC Table Support for Attribute Import

Feature - Add IMINVLOC Table Support for Attribute Import

Date: 07/16/2023
Version: 8.5 & Up

In Elliott, we support Attribute Import through an CSV file by going to Util-Setup-> System File Setup-> Import-> Attribute Import. The following files were supported with this import utility:
  1. ARCUSFIL: AR Customer File
  2. APVENFIL: AP Vendor File
  3. IMITMFIL: Item Master File
  4. CPORDHDR: COP Order Header File
  5. POORDHDR: Purchase Order Header File
  6. BMORDFIL: BOMP Production Order File
  7. SFORDFIL: Shop Floor Order File
  8. EMPFILE: Employee File
  9. ARSLMFIL: AR Salesman File
  10. SYCONTCT: System Contact File
  11. CPSHPFIL: COP Ship-To File
In this update, we are adding support for IMINVLOC (Inventory Location file). See sample screen below:


Please be aware that the primary key of the IMINVLOC table consists of a 15-digit item number + 2-digit location code.  If the item number is less than 15 digits, you must pad the trailing space to make it 15 digits before appending the location code.  See the following example:



Modified Programs: SYATTRIS, SYATTRIP, SYREFCHK


EMK


    • Related Articles

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 1/26/28 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

    • Feature - Add Support for Customer Tax Codes to the Mass Change Customer CSV Import

      Release date: 5/6/2019 Version: 8.5 and up Added support for columns AC, AD, AE (Customer Tax Codes) to the Mass Change Customer CSV Import. TaxCode1 If provided: If Global Setup --> Add-Ons --> Vertax Sales Tax --> Use Vertax Sales Tax = "Y," ...

    • Feature - Add Serial Number Support to PO Warehouse Receiving Import

      Release Date - 6/25/18 In Elliott, the PO -> Processing -> Utility -> Warehouse Recv Import application supports receiving through CSV file import. The CSV file currently supports the following columns: Vessel ID Vessel Comment Vessel Receiving ...

    • Feature - Support Payment Record in Sales Order Import

      Release: 06/07/2023 Version: 8.5 and Higher Introduction Elliott Sales Order Import is used extensively to import orders from EDI transactions and eCommerce websites. In this enhancement, we expanded Sales Order import to support "Payment" records. ...

    • Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export

      Release date: 4/12/2018 User-defined code table support has been added to the IM user-defined CSV export. The following new column types are now supported: UD: User Defined Code Description UE: User Defined Code ERG# UH: User Defined Code Hazardous ...