From the Maximo Support Desk - Notes on Deleting a Storeroom

Body

A frequent question by Maximo administrators is whether it is possible to delete a Storeroom.  A Storeroom may not be needed anymore, or has physically changed or merged into another existing Storeroom.  The short answer to this question is that a Storeroom can only be deleted if there has never been items or tools added to it. This also means that no inventory transactions have been conducted for this storeroom.

If your situation meets that criteria, you can delete a storeroom record using the Delete Storeroom entry on the Select Action menu in the Storerooms application...  again, only under the condition that no items or tools have ever been added to this Storeroom.  One of the reasons that Maximo only allows deletion under this condition is to thoroughly preserve the data integrity of the feature which allows items to have statuses. This was not available in previous versions of Maximo.  From a database standpoint, even if the item or tool records are set to "obsolete" status, they still hold a relationship to the inventory table. (as history records)

If you had hoped to delete a storeroom record, but there have been inventory transacations associated with it, then consider the following recommendations to make the Storeroom Inactive.  A few conditions need to be met regarding the items that currently exist in the Storeroom in order to effectively prevent the Storeroom from being accessed by non-admin Users:

• In the Storeroom record, un-check the box for "Use in PO/PR?. This will effectively make the Storeroom unknown and inaccessible to the Users, and none of the items can be selected or viewed from this Storeroom inadvertently.
• You can remove access to it by modifying any Security Groups which either have specific access to this Storeroom, or by modifying any Security Groups which have the "Access To All Storerooms" privilege.
• For Security Groups which have access to all Storerooms:

1. In the Security Group application open the record for the Security Group and go to the Storerooms tab
2. Un-check the box for "Authorize Group for All Storerooms?" and then add the desired Storerooms via the New Row button
3. Save the record.

• For Security Groups which have specific access to the Storeroom:

1. Delete the row for that Storeroom
2. Save the record.

Make the Storeroom's Items Obsolete

• Each item must have no balance; balances can be transferred to another storeroom via the Inventory Usage application, or can be issued through normal business operations until the quantity reaches zero. (consumables).
• Each item must be changed to OBSOLETE status; the items must not be used on any open/pending transactions such as PR, PO, SRs, Desktop Requisitions, or be associated with active Work Orders or Job Plans:
• Please note that the item status must first be changed to Pending Obsolescence, and then the item status must be changed to Obsolete.
• Close, process, or otherwise complete all open Purchase Requisitions, Service Requests, Desktop Requisitions, and Purchase Orders which have PR/MR/PO Lines for any item in the Storeroom.
• Close or edit all open Work Orders which have material reservations for any item in the Storeroom (advanced search for the Storeroom in the Work Order application will indicate the items)
• Edit all Active Job Plans which have material reservations for any item in the Storeroom (advanced search for the Storeroom in the Work Order application).

Tom Richardson is an IBM Maximo Support Engineer and frequent contributor to the Asset Management Blog community.  For a complete index of links to his articles, visit
Index of articles by Tom Richardson, Support Engineer