BOM Import Quick Routings

A common need when importing Bills of Material is to create simple routings for the items. The BOM Import utility can create a routing by copying an existing routing from another item. This method works well if all items have a very simple, perhaps single step, routing. See “Routing Import” later in this document for details on how to use the Routing Import utility to integrate a full, detailed routing.

BOM Import has two methods to create a routing by copying an existing routing.

First, if the import file contains new Item Numbers, you will need to provide a Template Item. You can configure Item Copy to copy, among other records, the Primary Routing from the Template Item. When the new Item Number is created, the process will also create a routing by copying the routing from the template item.

Second, if the import file contains existing Item Numbers for which you are importing a BOM, or importing a new revision of a BOM, you can provide a Routing Source Item in the import spreadsheet.

As shown above, importing the new BOM for 100XLG would overwrite the existing routing by copying over the routing from CHAIR.

Another way to add a “default” routing to items is to create an item in GP whose sole purpose is to carry a default routing, and enter that Item Number as a Constant:

For example, the Item Number could be called ROUTING. The routing for this item might have a single step, with no time, or labor or machine costs, which serves the purpose of simply providing a routing because manufacturing requires one.

NOTE: Routing Source Item was added to BOM Import in April 2016. If you have an Import Map created before that date, you will need to delete the map and re-create it to have access to the new map field.

NOTE: Routing Name was added to BOM Import in January 2018. If you have an Import Map created before that date, you will need to delete the map and re-create it to have access to the new map field.

If you use a Routing Source Item, BOM Import will create/re-create routings as the final step in the import process—after it has completed importing the BOMs. If the item (BOM) being imported already has a routing (or routings), it (or they) will be DELETED, and replaced with the routing from the Routing Source Item.

By default, the new routing’s Routing Name will be the parent Item Number. A Routing Name can be provided in the import file. If a Routing Name is provided it will be used instead of the Item Number.