Delete Warehouse DI

[Former Member]

Hi all, i would greatly appreciate it if anyone could tell me how to delete a warehouse using DI. I can delete just fine from owhs but i need the DI so that all references in Items will be deleted also and do not like deleting straight from db table.

Keep in mind that warehouse has no transactions and i have found some references on how to delete warehouse info from items allthough it would be very helpful to get pointers on this issue as well.

[former_member201110 · Accepted solution]

Hi Titos,

There is currently no way to remove the warehouse using the DI. Running a delete statement on the OWHS and OITW tables is forbidden and you would lose you support from SAP if you tried it.

I have found a workaround using a script and the B1 Test Composer tool that allowed me to automate the process of removing a warehouse through the UI. This works really only as a one-off task and not something that could be scheduled. The original thread we discussed it on is here:

I used this technique to completely remove a warehouse for a client who had created one by mistake and would otherwise have had to manually remove 2000+ items from the warehouse before it could be deleted.

I haven't checked 2007A yet. Maybe Warehouse deletion is possible in that version(?)

Kind Regards,

Owen

[Former Member · Accepted solution]

Thank you Owen for the prompt response.

B1TC works for vesrion 2004A too.

Created a script which deletes the Warehouses from the Stock Data (OITW) but unfortunately it seems to "point" on the row no. meaning that I cannot select the Warehouse to delete only the row number. If on a different item the Warehouse is on a different row then it will not work and not only that, it will delete the wrong warehouse.

Any ideas would be greatly appreciated.

Message was edited by:

Titos Economides