Deleting Location in Location or Inventory Location Control Files May Cause Referential Integrity Error

Deleting Location in Location or Inventory Location Control Files May Cause Referential Integrity Error

Release Date: 03/14/2025
Version: 7.x & Up

Q - We no longer have our warehouse in Tulsa, OK (TL), and I would like to delete the location “TL” in Elliott.  The Stock Status Report shows there is no inventory on hand in the TL location.  Is it as simple as going to Location Control File Maintenance – Create – then “D” for delete and all items for Location TL?  Or is there anything else that needs to be verified before proceeding with this action?

Any other file cleanup you would recommend?


A - Deleting a location in Elliott could be risky and potentially create database referential integrity.  That is to say we can’t predict what may happen when there’s an open or history records reference to a location that is deleted. For this reason, we recommend you simply mark the “TL” location description as “Do Not Use” to avoid this issue.

Deleting unused Inventory Location Control records has lesser risk, but the risk still exists, it depends on if there are any order (including COP, PO, and BOMP) references to the location control record. I have seen errors happen with reset allocations on a work order with components where the Location Control record no longer exists. Also, there’s no mass delete utility and it would be tedious for you to delete these records one by one.  If you really want to delete these records.  We can save these records first and use the backend to mass delete them.  If the mass delete causes a problem, we can restore these records back.  You will not be able to handle this on your own so please coordinate with our support.


EMK

    • Related Articles

    • Feature - Prevent Deleting Customers with Histories

      Release Date: 5/1/2024 Version: 8.5 & Up Background In the past, there were some prerequisites before a customer could be deleted in Elliott. Those were: The customer cannot have any open items on file (AROPNFIL). The customer cannot have any sales ...

    • Feature - BOMP Integrity Check Utility

      Release Date: 07/22/2011 You can access this utility from Global Setup -> Utilities -> BOMP Utilities-> Utilities-> BOMP Integrity Check. The purpose of this utility is check the integrity of two database tables: Bill of Material Product Structure ...

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

    • Avalara Setup Procedures - Integrity Check

      Release Date: 4/28/23 Date Revised: 6/10/24 Version: 8.6 and Above You should run Avalara integrity check on daily, weekly or monthly basis. The frequency depends on if you can commit resources for someone to look at the output of this report and ...

    • EL800CC Elliott V8 Control Center

      Elliott V8.0 Control Center The Control Center replaces the Elliott main menu and module menus from previous releases. From the Control Center, you can launch nearly every feature of Elliott into a new process, independent of all other Elliott ...