Menu Close

How to Create a Bill of Materials in Sage 50 Cloud Accounting

If you use Sage 50cloud Accounting with the Premium plan or higher then you will have access to strong inventory features that allow you to track levels on hand as well as quantities committed to proposals and purchase orders. You can also set up product assembly items with a BOM record.

What is a bill of materials?

A bill of materials (BOM) is a comprehensive inventory listing the raw materials, assemblies, sub-assemblies, parts and components required to build a product. Also known as a production recipe or assembly component list it can be created in a hierarchical format and is typically used by manufacturers to track the components needed for assembling an item.

There are many details that can be included within a BOM record including reference designators, unit of measure, revision dates, part numbering systems and more. These details can help ensure that an accurate estimate of raw material and finished goods inventory is made, which is crucial for precise purchasing and conveying to the assembly line.

The level of detail in a BOM can vary by company and industry. In some cases the bill of materials is a single level listing and in others it can be very complex, allowing for detailed breakdowns of machine, labour, and reporting costs.

In addition to providing a comprehensive inventory of raw and finished goods, Sage 200’s BOM feature can be used in conjunction with other modules such as works orders, reporting and stock management for advanced assembly and manufacturing capabilities. Cim50 has a BOM module that is highly configurable and includes features such as machine, labour and reporting templates as well as visualising costing breakdowns.

How do I create a bill of materials?

The Bill of Materials module for Sage ERP MAS 90 and 200 (formerly Sage 100) allows you to track the assembly items that go into your end product. The BOM also includes a costing breakdown of the individual components that make up each item. You can set up additional cost items for calculating your material, labor, and machine overhead costs. You can also setup a special account into which you want to record the total unit cost for each item. This allows you to compare your actual production and inventory costs with the estimated unit cost for each assembly item.

When creating a BOM, you must be sure to register any consumables that are needed for the product. Typically, these are items like fasteners, glue, labels, boxes and cartons, and other packaging materials. Adding these as component items to the BOM will help you to track usage and purchase costs of those materials over time.

You can view BOMs within the Maintain Inventory Items window by clicking the BOM tab and selecting a BOM. You can also view a BOM tree and component list by clicking the button at the top of the screen and choosing one of these options.

If you need to change a BOM, it is important that you first copy the existing assembly item and then edit the new item. This will allow you to keep all of the assembly history intact for the original item that was produced.

How do I edit a bill of materials?

There are a few ways to edit a bill of materials. One way is to create a new inventory assembly item with the same ID as the old item and a different bill of materials. This will allow you to change the assembly item’s BOM without having to change all of the existing Sage 50 items that use it. Another way is to change the current accounting period in Sage 50. This will cause all new transactions to use the updated BOM, but existing invoices and credit memos that were issued in the old period will not be affected.

If you need to change the BOM for an assembly item, open the Maintain Inventory Items window and click on the Bill of Materials tab. This will display a list of existing BOM revisions for that assembly item with the original one being Revision 0. To edit a BOM, select a revision from the list and click the Edit button. You can also add or remove components, move them up or down in the order of priority or clear all to start over.

This will open a window with the assembly item’s BOM, showing all of the components needed to make it. You can view a multi level BOM explosion in tree format, a list of the component parts and their quantities or a breakdown by cost. You can even see the unit of measure and location of each component. This is a powerful feature that allows you to manage your manufacturing process as well as your inventory.

How do I create a phantom bill of materials?

The BOM Module helps you create detailed bills of materials for your manufactured products. These will be used to record the production costs for your assemblies, including things such as labour, machine setup costs, run costs and close-down costs. Using the BOM Module will save you time and help to improve your manufacturing efficiency.

For each component on the bill of materials, you can specify attributes such as operation sequence, item sequence, usage quantity and yield. You can also set security so that only certain users can update the bill of materials for a particular item type. For example, you might restrict access to the BOM: Standard Item Access profile option at the site level for all employees, while enabling the BOM: Planning Item Access profile option for engineering staff to enable them to create and update planning items.

Unlike inventory records, which can only be edited or deleted once they are created, you can edit the details of a BOM and change its beginning unit cost. For example, you might want to increase the minimum stock or reorder quantity of a specific item.

To edit a BOM, select it and then click the Maintain Bill of Materials tab. The original BOM is the first revision; each subsequent BOM revision is numbered. You can use the Revisions button to see a list of existing BOM revisions, or you can click New to create a new revision. You can also set an effective date for the revision so that only transactions dated after the revision will use it.