Error message when you try to delete an inventory item in Manufacturing in Microsoft Dynamics GP: "This item is a component on one or more bills of materials"


Symptoms


When you try to delete an inventory item in Manufacturing in Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions - Great Plains 8.0, you receive the following error message:
This item is a component on one or more bills of materials. It can't be deleted until you remove it from those bills of materials.

Cause


This problem occurs if any of the following conditions is true:
  • The inventory item has a manufacturing order history. See Resolution 1 in the "Resolution" section.
  • The inventory item is in stock. See Resolution 2 in the "Resolution" section.
  • The inventory item has an inventory history. See Resolution 3 in the "Resolution" section.
  • The inventory item is a component on a bill of materials. See Resolution 4 in the "Resolution" section.
  • The inventory item is a finished good and has a bill of materials. Or, the inventory item is a subassembly on another finished good. See Resolution 5 in the "Resolution" section.

Resolution


Resolution 1

To resolve this problem, locate, close, and then remove the history of the manufacturing orders that include the inventory item that you are trying to delete. To do this, follow these steps:
  1. Click Inquiry, point to Manufacturing, point to Manufacturing Orders, and then click Item Transactions.
  2. Close the manufacturing orders that include the inventory item that you are trying to delete. To do this, use one of the following methods.

    Method 1

    1. Click Transactions, point to Manufacturing, point to Manufacturing Orders, and then click MO Close.
    2. Click a manufacturing order, and then click Process.

    Method 2

    1. Click Transactions, point to Manufacturing, point to Manufacturing Orders, and then click Edit MO Status.
    2. Click a manufacturing order, click Closed in the Change MO Status to list, and then click Process.
  3. Enter any reverse transactions that you have to process. To do this, click Transactions, point to Manufacturing, point to Manufacturing Orders, and then click Component Trx Entry.

    Note This step is not required.
  4. Remove the history of the manufacturing orders. To do this, follow these steps:

    1. On the Tools menu, point to Utilities, point to Manufacturing, and then click Remove MO.
    2. In the From field and in the To field, enter a manufacturing order.
    3. Click to select the Canceled Orders check box.
    4. Click to select the Closed Orders check box, and then click Process.

    Note If you want to maintain all the history of the company, create a new company, and then restore the company information in this new company. Then, run the COMPANYID script in the new company to make sure that the IDs are correct. After you run the COMPANYID script, delete the history and the items in the original company. You can use the new company as a reference for the transactions that no longer exist in the original company.

    For more information about the COMPANYID script, click the following article number to view the article in the Microsoft Knowledge Base:

    871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

  5. Try to delete the inventory item. If you still receive the error message that is mentioned in the "Symptoms" section, follow the steps in Resolution 2.

Resolution 2

To resolve this problem, verify that the inventory item is not in stock. To do this, follow these steps:
  1. In the Item Inquiry window, verify that the following fields have a value of zero:
    • Quantities On Hand
    • Quantities Allocated
    • Quantities Available
  2. If any of these fields does not have a value of zero, enter the appropriate transaction to make the value zero.
  3. Try to delete the inventory item. If you still receive the error message that is mentioned in the "Symptoms" section, follow the steps in Resolution 3.

Resolution 3

To resolve this problem, remove the inventory history of the inventory item that you are trying to delete. To do this, follow these steps:
  1. On the Tools menu, point to Utilities, point to Inventory, and then click Remove Transaction History.
  2. In the From field and in the To field, enter the inventory item.
  3. Click to select the Remove check box.
  4. Click to select the Remove Distributions check box, and then click Process.

    Note If you want to maintain all the history of the company, create a new company, and then restore the company information in this new company. Then, run the COMPANYID script in the new company to make sure that the IDs are correct. After you run the COMPANYID script, delete the history and the items in the original company. You can use the new company as a reference for the transactions that no longer exist in the original company.

    For more information about the COMPANYID script, click the following article number to view the article in the Microsoft Knowledge Base:

    871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

  5. Try to delete the inventory item. If you still receive the error message that is mentioned in the "Symptoms" section, follow the steps in Resolution 4.

Resolution 4

To resolve this problem, delete the component from all bills of materials. To do this, follow these steps:
  1. Click Inquiry, point to Manufacturing, and then click BOM View.
  2. Click Where Used.
  3. In the Item Number field, enter the component that you are trying to delete.
  4. Note the finished good for all the bills that contain the component.
  5. Click Cards, point to Manufacturing, and then click Bill of Materials.
  6. In the Item Number field, enter a finished good that you noted in step 4.
  7. Click the component from the bill, and then click Remove Item from BOM. When you are prompted to delete the component, click Delete.
  8. Repeat step 6 through step 7 until you remove the component from all bills of materials.
  9. Try to delete the inventory item. If you still receive the error message that is mentioned in the "Symptoms" section, follow the steps in Resolution 5.

Resolution 5

To resolve this problem, follow these steps:

  1. Click Inquiry, point to Manufacturing, and then click BOM View.
  2. Click Where Used.
  3. In the Item Number field, enter the inventory item that you are trying to delete.
  4. Note all the bills in which the inventory item is the finished good or a subassembly.
  5. Click Cards, point to Manufacturing, and then click Bill of Materials.
  6. In the Item Number field, enter the finished good or a subassembly that you noted in step 4.
  7. Click the component, and then click Delete.
  8. Repeat step 6 through step 7 until you remove the finished good and the subassemblies from all bills of materials.
  9. Try to delete the inventory item. If you still receive the error message that is mentioned in the "Symptoms" section, contact technical support. For information about technical support for Microsoft Dynamics GP, visit the following Microsoft Web site: