Skip to Content

How do I delete multiple items out of SAP B1?

I received bad data from a supplier and need to delete hundreds of unused items from my db.  I know how to delete one at a time, but is there a bette way to delete items on a more grander scale?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 21, 2015 at 09:13 PM

    I think DI is the easiest way.

    But before that, u might want to use DTW to inactive those item first, otherwise, if someone accidentally post a transaction against these items, you will not be able to delete them

    Frank

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      if you have too many records too delete, I would do a SDK program to delete them.

      I would choose one item property and I call DELETE. I would mark this property in the items to delete, and the program will try to delete the items with this property.

      In the case the item cannot be deleted, the program must mark as inactive. Remember an item with movements or in a document (quotation, order) will not be deleted.

      Kind regards

      Agustín Marcos Cividanes

  • avatar image
    Former Member
    Oct 22, 2015 at 01:10 AM

    Hi,

    You can use "Master Data Cleanup Wizard" functionality. It located on Administration\Utilities.

    Hope this helps,

    TVSon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2015 at 04:48 AM

    Hi Jonathan,

    The "Master Data Cleanup Wizard" give you ability to clean/delete all the unused Masters. You can find it under Administration--> Utilities

    Note: You have to keep the Add-Ons closed while running this wizard.

    Thanks,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded