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

    • Feature - New Item Import Through CSV File

      Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...

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

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 4/25/25 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 - Customer CSV Import

      Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...

    • Feature - Bin Master CSV Import

      Release Date: 8/7/25 Version: 8.5 and Above This feature allows the user to update the Bin Master file via CSV import. This option is available from Inventory Management-> Maintenance-> Bin Master File-> Import. This application supports ...