Home bom management erp software microsoft dynamics gp technical documentation

Understanding BOM Components in Dynamics GP: A Comprehensive Guide

Updated: • 0 • min read
Table of Contents

Dynamics GP and Bill of Materials

When managing inventory in Microsoft Dynamics GP, users in manufacturing environments may encounter a specific error message while attempting to delete an inventory item. This error, stating “This item is a component on one or more bills of materials,” indicates that the system prevents deletion because the item is currently linked to existing Bills of Materials (BOMs). This safeguard is in place to maintain data integrity and prevent disruptions in manufacturing processes that rely on accurate component definitions. Understanding the reasons behind this error and the appropriate resolutions is crucial for efficient inventory management within Dynamics GP. This guide provides a comprehensive overview of the causes of this error and step-by-step solutions to resolve it, ensuring smooth inventory item deletion when necessary.

Symptoms

The primary symptom of this issue is the appearance of the following error message when attempting to delete an inventory item within the Manufacturing module of Microsoft Dynamics GP:

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.

This error message typically arises in Dynamics GP 9.0 and Microsoft Business Solutions - Great Plains 8.0, although it can potentially occur in later versions as well if the underlying conditions are met. The system effectively blocks the deletion process, preventing the user from removing the inventory item until the dependencies are addressed. This behavior is designed to prevent accidental data loss and maintain the consistency of manufacturing data.

Cause

The “This item is a component on one or more bills of materials” error message is triggered by several potential underlying conditions within Dynamics GP. These conditions are designed to protect the integrity of manufacturing and inventory data, ensuring that items critical to production processes are not inadvertently removed. Understanding these causes is the first step towards effectively resolving the error and proceeding with the desired inventory item deletion. Let’s delve into each of these causes in detail:

1. Manufacturing Order History

One common cause of this error is the existence of a manufacturing order history associated with the inventory item. If the item has been used as a component in past manufacturing orders, Dynamics GP retains a historical record of these transactions. This historical data is essential for reporting, analysis, and audit trails within the manufacturing module. Before an item with manufacturing order history can be deleted, this history must be appropriately managed, typically by closing and removing the relevant historical records.

2. Inventory in Stock

Another reason for the error message is if the inventory item is currently in stock. Dynamics GP prevents the deletion of items that have on-hand quantities, allocated quantities, or quantities available. This is a fundamental inventory management principle to prevent discrepancies and ensure accurate stock levels are maintained. Before deleting an inventory item, it is necessary to ensure that the stock levels for that item are reduced to zero through appropriate inventory transactions or adjustments.

3. Inventory History

Similar to manufacturing order history, the presence of inventory history can also prevent the deletion of an inventory item. Dynamics GP tracks inventory transactions to provide a comprehensive audit trail and historical record of item movements. If an item has inventory history, such as receipts, issues, or adjustments, this history must be addressed before the item can be deleted. Removing or managing the inventory transaction history for the item is a necessary step in the deletion process.

4. Component on a Bill of Materials

The most direct cause, as indicated in the error message itself, is if the inventory item is currently defined as a component on one or more active Bills of Materials. A BOM defines the components required to manufacture a finished good or subassembly. If an inventory item is listed as a component in a BOM, Dynamics GP recognizes this dependency. The system prevents deletion to avoid breaking the BOM structure and disrupting production planning. To resolve this, the item must be removed as a component from all relevant BOMs before deletion can proceed.

5. Finished Good or Subassembly with BOM

Finally, an item may be prevented from deletion if it is a finished good that has its own Bill of Materials, or if it is a subassembly that is part of another finished good’s BOM. In these scenarios, the item itself is not a component on a BOM in the traditional sense, but it has a BOM associated with it, or it is part of a larger BOM structure. This interconnectedness within the BOM hierarchy can also trigger the error. Resolving this may involve adjusting BOM structures or addressing dependencies within the overall product definition.

Resolution 1

To resolve the issue caused by manufacturing order history, you need to locate, close, and then remove the history of manufacturing orders associated with the inventory item you are attempting to delete. Follow these steps:

  1. Navigate to Item Transactions Inquiry: Access the inquiry window by selecting Inquiry, then point to Manufacturing, then Manufacturing Orders, and finally select Item Transactions. This window allows you to view manufacturing orders related to specific items.

  2. Close Manufacturing Orders: You need to close any open manufacturing orders that include the inventory item. There are two methods to close manufacturing orders:

    • Method 1: Using MO Close:

      1. Go to Transactions, point to Manufacturing, then Manufacturing Orders, and select MO Close.
      2. Select the relevant manufacturing order number and click Process. This will close the selected order.

    • Method 2: Using Edit MO Status:

      1. Go to Transactions, point to Manufacturing, then Manufacturing Orders, and select Edit MO Status.
      2. Select the manufacturing order. In the Change MO Status to dropdown list, choose Closed. Then, click Process. This method allows for changing the status of multiple orders efficiently.

  3. Process Reverse Transactions (Optional): If necessary, enter any reverse transactions. This step is generally not required but might be needed in specific scenarios where adjustments are needed before closing the orders. To enter component transactions, go to Transactions, point to Manufacturing, then Manufacturing Orders, and select Component Trx Entry.

  4. Remove Manufacturing Order History: After closing the relevant manufacturing orders, you need to remove their history.

    1. On the Tools menu, point to Utilities, then Manufacturing, and select Remove MO.
    2. In the From and To fields, enter a range of manufacturing order numbers that include the orders you closed in the previous steps. You can also enter a single order number in both fields to remove history for just that order.
    3. Select both the Canceled Orders and Closed Orders checkboxes to ensure you are removing history for all relevant closed orders.
    4. Click Process to initiate the removal of manufacturing order history.

    Note: Consider the implications of removing history. If historical data is critical for your company’s records, you might consider creating a test company and restoring your company data there. You can then run the history removal process in the test company, preserving the history in your live company. Alternatively, you could archive your company data before removing history in the live environment. Refer to Microsoft KB article KB - Set up a test company that has a copy of live company data for Microsoft Dynamics GP by using Microsoft SQL Server for more information on creating test companies.

  5. Attempt to Delete the Inventory Item: After completing these steps, try to delete the inventory item again. If you still encounter the error message, proceed to Resolution 2.

Resolution 2

If the issue persists after addressing manufacturing order history, the next step is to verify that the inventory item is not in stock. Follow these steps to check and adjust stock levels:

  1. Check Item Inquiry: Open the Item Inquiry window in Dynamics GP. Search for and select the inventory item you are trying to delete.

  2. Verify Quantities: In the Item Inquiry window, carefully examine the following fields and ensure they all have a value of zero:

    • Quantities On Hand: This represents the physical quantity of the item currently in your inventory.
    • Quantities Allocated: This indicates the quantity of the item that is reserved for sales orders or manufacturing orders but not yet shipped or issued.
    • Quantities Available: This is the quantity of the item that is physically on hand and not yet allocated. It is calculated as Quantities On Hand minus Quantities Allocated.

  3. Adjust Inventory if Necessary: If any of these quantity fields have a value greater than zero, you need to enter the appropriate inventory transactions to reduce them to zero. This might involve:

    • Sales Transaction: If the quantities are allocated to sales orders, ensure those sales orders are processed (shipped and invoiced) or canceled if no longer needed.
    • Manufacturing Order Completion/Scrapping: If allocated to manufacturing orders, ensure those orders are completed and closed, or any excess components are scrapped or returned to stock if appropriate.
    • Inventory Adjustment: If there are on-hand quantities that are not allocated, you may need to use an inventory adjustment transaction to write off or remove the excess stock. Ensure you have proper authorization and documentation for any inventory adjustments.

  4. Attempt to Delete the Inventory Item: After verifying and adjusting stock levels to zero, try to delete the inventory item again. If the error persists, proceed to Resolution 3.

Resolution 3

If the error message continues to appear, the next potential cause is inventory history. Removing the inventory transaction history for the item might be necessary. Follow these steps:

  1. Access Remove Transaction History Utility: On the Tools menu, point to Utilities, then Inventory, and select Remove Transaction History. This utility is designed to remove historical inventory transactions.

  2. Specify Item Range: In the Remove Transaction History window, in both the From and To fields, enter the inventory item number you are trying to delete. This specifies that you want to remove history for only this particular item.

  3. Select Removal Options: Ensure that the Remove checkbox is selected. Additionally, select the Remove Distributions checkbox. Removing distributions ensures that related financial distributions associated with the inventory transactions are also removed, maintaining data consistency.

  4. Process History Removal: Click Process to initiate the removal of inventory transaction history for the specified item.

    Note: Similar to removing manufacturing order history, removing inventory history is a permanent action. If preserving historical inventory data is important, consider the same precautions: creating a test company, restoring your data, and running the history removal in the test environment, or archiving your company data before proceeding in the live environment. Refer to Microsoft KB article KB - Set up a test company that (link provided in original article) for guidance on creating test companies.

  5. Attempt to Delete the Inventory Item: After removing inventory history, try to delete the inventory item once more. If you still receive the error message, proceed to Resolution 4.

Resolution 4

If none of the previous resolutions have resolved the error, the most likely cause is that the inventory item is still defined as a component on one or more Bills of Materials. You need to identify and remove the item from all BOMs where it is used. Follow these steps:

  1. Use BOM View to Find Usage: Navigate to Inquiry, point to Manufacturing, and select BOM View. This window provides tools to view and analyze Bills of Materials.

  2. Select “Where Used”: In the BOM View window, select the Where Used option. This function allows you to search for all BOMs where a specific item is used as a component.

  3. Enter Item Number: In the Item Number field, enter the item number of the inventory item you are trying to delete. This will initiate the search for BOMs where this item is a component.

  4. Identify Finished Goods: The BOM View window will display a list of finished goods (and potentially subassemblies) for all Bills of Materials that include the specified item as a component. Note down the item numbers of these finished goods. You will need these in the next steps.

  5. Open Bill of Materials Card: Go to Cards, point to Manufacturing, and select Bill of Materials. This will open the Bill of Materials Maintenance window.

  6. Enter Finished Good Item Number: In the Item Number field of the Bill of Materials window, enter one of the finished good item numbers you noted down in step 4. This will load the BOM for that finished good.

  7. Remove Component from BOM: In the Bill of Materials Components grid, locate and select the component item (the item you are trying to delete). Then, click Remove Item from BOM. Dynamics GP will prompt you to confirm the deletion. Click Delete to remove the component from the BOM.

  8. Repeat for All BOMs: Repeat steps 6 and 7 for each finished good item number you identified in step 4. This ensures that you remove the component from all Bills of Materials where it is used.

  9. Attempt to Delete the Inventory Item: After removing the component from all identified BOMs, try to delete the inventory item again. If you still encounter the error message, proceed to Resolution 5.

Resolution 5

If, after completing all previous resolutions, you are still unable to delete the inventory item, there might be a more complex scenario involving the item being a finished good with its own BOM or a subassembly in another BOM. In these less common situations, you might need to review the overall BOM structure and dependencies more carefully.

Unfortunately, the provided text extract ends abruptly at the beginning of Resolution 5. To fully resolve this final scenario, you would typically need to:

  1. Examine BOM Relationships: Carefully review the Bill of Materials for the item you are trying to delete if it is a finished good or subassembly. Identify any parent-child relationships in the BOM structure.

  2. Adjust BOM Structure (If Necessary): Depending on your business needs, you might need to restructure your Bills of Materials. This could involve:

    • Replacing the item in BOMs: If you are no longer using the item, replace it with a different component in the relevant BOMs.
    • Discontinuing the BOM: If the finished good or subassembly itself is no longer produced, you might consider discontinuing or inactivating its BOM.

  3. Address Circular Dependencies (If Present): In rare cases, complex BOM structures can create circular dependencies, which might prevent deletion. Identify and break any such circular references.

  4. Consider Inactivating Instead of Deleting: If deletion is proving difficult due to complex BOM relationships or historical data concerns, consider inactivating the inventory item instead of deleting it. Inactivation removes the item from active use but preserves its historical data and BOM relationships. This can be a practical solution if you need to retain the item’s records for audit or reporting purposes but no longer want it to be used in production.

  5. Contact Support (If Needed): If you have exhausted all resolutions and are still unable to delete the item, and you suspect a more complex data issue or system behavior, consider contacting Microsoft Dynamics GP support or your Dynamics GP partner for further assistance. They can provide more in-depth troubleshooting and guidance specific to your system and data.

By systematically working through these resolutions, starting with manufacturing order history and progressing through inventory stock, inventory history, and BOM component relationships, you should be able to identify and address the cause of the “This item is a component on one or more bills of materials” error and successfully delete the inventory item in Microsoft Dynamics GP when it is appropriate to do so. Remember to always back up your data before performing any data removal or history deletion processes in a live Dynamics GP environment.

Do you have any further questions about managing BOM components or inventory items in Dynamics GP? Let us know in the comments below!

Post a Comment