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!

  • 0


    I don't have an example and have not tested this, but it looks like you can process the changes using the SY_DeleteChange method ProcessDeleteChange(ChangeClass$, field$). This method should be exposed through the IM_DeleteChangeItems_ui object.

    The ChangeClass$ argument would be the dictionary class name for the change, for Inventory Items, this would be "ItemCode", but it could be "VendorNo" or "CustomerNo" if changing either vendors or customers.

    The field$ argument is actually the primary table so "CI_Item" for items, "AP_Vendor" or "AR_Customer" for vendors or customers.



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