How to update bills of material on Sage 300 Inventory Control


  1. Open Inventory Control > I/C Items and Price Lists > Bills of Material.
  2. In the From Master Item Number and To fields, specify the range of master items to update.
  3. In the From BOM Number and To fields, specify the range of BOM numbers to update.
  4. In the Update field, specify whether to update components or a cost.  Your selection in this field determines the remaining fields that appear on the screen.
  5. Fill in the remaining fields according to your selection in the Update field.
    • If you are updating components:
      1. In the Type field, specify whether to add, remove, or replace a component.
      2. In the Component Item Number field, enter or select the item number for the component that you want to add, remove, or replace.  Then, if the component is itself a master item, in the BOM Number field, also specify the BOM number that is used to assemble the component item.
      3. If you are replacing a component, enter or select the replacement item number.  If the replacement component is a master item, in the next BOM Number field, specify the BOM for assembling the replacement item.
      4. If you are replacing or adding a component item:
        1. In the Quantity field, enter the number of items to add to the build in the unit of measure displayed on the screen.
        2. In the Unit Cost field, if the new item has a user-specified costing method, enter the cost for one unit.
    • If you are updating a cost:
      1. In the Type field, specify whether you are updating fixed costs or variable costs.
      2. In the Using field, specify whether to update costs by an amount or a percentage.
      3. In the Basefield, specify whether to increase or decrease the cost.
      4. Specify the amount or percentage by which you are increasing or decreasing the cost.
  6. Click Update.


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.