Is there a way to mass delete/merge Miscellaneous Item Codes?

Over the years our Miscellaneous Item Code list has grown into a mess. We recently identified 400+ Item Codes that can be deleted. Is there any way to mass delete Miscellaneous Item Codes with no history, and Mass Merge Item Codes that do have history?

  • 0

    Since you can't use the Delete and Change utility against misc. items, i think you only have 2 options, which you should test in a copy of your production company before doing it against it to make sure you get the desired results.

    One option involves exporting all fields for all records of the table and then delete the rows out of the file that you don't want to keep.  Then reinitialize the table and use VI Import to import back in only the records you kept.  I'm not a fan of this approach because there are some fields that you normally can't set with VI and other fields that you can't control that will get reset to current date/time stamps.

    The other option is using a VI import with perform logic to delete records.  For this approach, you would prepare the source file to only contain records you want to delete and it would still be subject to the business object interface checking to see if record can truly be deleted.  See my answer here for more details. https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/125437/im_pricecode_bus-doesnt-have-a-delete-function/334945#334945