Delete Change Items in BOI

Is it possible to do this? I've been able to populate the IM_DeleteChangeItems table using BOI, but I can't figure out how to actually apply the changes to the item codes using BOI.

If it's not possible that's okay, but please let me know if that's the case.

Thank you!

Parents
  • 0

    Be extremely cautious with this utility.  As long as the process runs to completion, and it is a "rename", you could always do the same thing in reverse.  However, a "merge" is 100% permanent.  There is absolutely no way to undo a merge.  All history (invoices, item transactions, lot/serial, inventory, SO's, PO's, production...) table data is edited to merge everything to show the "new" item code.  The independent records of the previous Item Code values are completely and permanently gone.

    We've had clients do a merge by mistake (proceeding without our guidance), and the only way to recover was to restore a backup (with significant data loss).

    One of the benefits of running the utility manually is it forces you to print a report of what is about to be done.  I always scan the list, watching for inadvertent "merge" values, knowing those will be permanent.

Reply
  • 0

    Be extremely cautious with this utility.  As long as the process runs to completion, and it is a "rename", you could always do the same thing in reverse.  However, a "merge" is 100% permanent.  There is absolutely no way to undo a merge.  All history (invoices, item transactions, lot/serial, inventory, SO's, PO's, production...) table data is edited to merge everything to show the "new" item code.  The independent records of the previous Item Code values are completely and permanently gone.

    We've had clients do a merge by mistake (proceeding without our guidance), and the only way to recover was to restore a backup (with significant data loss).

    One of the benefits of running the utility manually is it forces you to print a report of what is about to be done.  I always scan the list, watching for inadvertent "merge" values, knowing those will be permanent.

Children
No Data