Feature - Allow Mass Delete of Attribute Records

Release date: 1/9/2019

Revised Date: 02/14/2024

Version: 8.5 & up

This feature will allow mass deletion of attribute records. It is called from Util-Setup-> System File Maintenance-> Import-> Mass Delete Attribute. This application will delete the attribute data records (SYATTRIB). It will not delete the attribute definition (SYATRFIL).

 

It has three menu options - Pre-Interface, Interface, and Layout.

The Layout screen has the following fields:

1. File Name - this is like ARCUSFIL, APVENFIL, IMITMFIL, SYCONTCT...etc.
2. Attribute Code - the attribute code up to 15 digits.
3. Reference ID - This is the primary key value of the file.  For example, for ARCUSFIL, it is the Customer Number; for IMITMFIL, it is the item number; and for SYCONTCT, it is the Contact ID.  You need to provide leading zeroes for some of the files if the primary key values are numeric.  For example, customer and vendor number must be exactly 6 digits in length;  contact id must be exactly 9 digits long.

The Pre-Interface and Interface screens have the following options:

1. CSV File Name:                         
           
2. Import File With Header Row ?     

CSV File Name - The filename is stored in the registry and used as a default.
Import File with Header Row - The Value is  stored in the registry.

When the pre-interface is run, the records will have a status of Deleted or an error message.  During pre-interface, records will not be deleted.

When the interface is run, the user will be prompted with the following question:

After the interface is completed the input file will be deleted and the following report will be created.  Note the "Total No. Deleted Records."

Field requirements:

File Name 
Valid values are: ARCUSFIL, APVENFIL, IMITMFIL, CPORDHDR, POORDHDR,        BMORDFIL, SFORDFIL, EMPFILE, ARSLMFIL, SYCONTCT, CPSHPFIL 
Field is converted to upper case
Field is required

Attribute Code
Field is required
Field is converted to upper case
Code must exist in SYATRFIL

Reference ID
Field is required
Field is converted to upper case

Error Conditions:
Invalid File Name
Attribute Code Not On File
SYATTRIB record not found

Modified programs: SYATTRIS, SYFILMNU, SYDELATS (new), SYDELATP (new)

DLM 

• Related Articles

• Feature - Control Deletion of Box Shipment Records

  Release date: 8/5/2021 Versions: 8.5 & Up Program changes have been made to control, at the Global Setup level, the ability to Delete Box Shipment records. In COP --> Processing --> Print Pick/Pack Ticket & Lbls --> Print --> Vics bill of lading, ...

• Feature - Mass Change Salesman Utility

  Release date: 1/17/2017 A new Mass Change Salesman utility has been added to Global Setup, Utilities, and A/R Utilities. This utility can assist in situations where a salesperson has left the company and their customers are reassigned to a new ...

• 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 - Warehouse Receiving Mass Receiving

  Release date: 11/18/2017 The following changes were made to PO --> Processing --> Warehouse Receiving process A new option has been added: Mass Receiving. Warehouse receiving records (POWHRECI) are created using passed values from the screen program, ...

• How to Allow User to Edit Other User's Attribute

  Release Date: 04/05/2023 Version: 8.0 & Up Q - In the following example, an attribute is created by user CMOORE. User MELISSA has the right to modify. How to I allow user VANESSA to also have the right to modify? A - Please go to Password Setup -> ...