D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Mass delete - Item Quality Group

  • 1.  Mass delete - Item Quality Group

    SILVER CONTRIBUTOR
    Posted May 16, 2019 02:30 PM
    We have a quality group that needs deleted.  There are over a thousand items linked to it via Item Quality Groups.  It appears we can only delete one record at a time from the Item Quality Groups.  Is there a more efficient way to delete this many items?

    Thanks.

    #AX2012
    #Beginner
    #Admin


    ​​​​

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------


  • 2.  RE: Mass delete - Item Quality Group

    TOP CONTRIBUTOR
    Posted May 16, 2019 04:35 PM
    If you have SysAdmin rights you can mass delete them from the table in the AOT, or use the Excel Add-In to delete from table InventTestItemQualityGroup.    I'd suggest you do this in a sandbox first and make sure someone who has done something like this before is the one doing it, but I've used the Add-In many times with the quality tables with no issues.

    Would it be easier to just leave that item quality group as is, create a new Item Quality group with the items you want to remain, and then go update your quality associations to call out the new item quality group?  There's no harm in having an Item quality group that has no actual quality associations.

    ------------------------------
    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role