How do I set up an item’s bill of materials?
An item’s components are edited in two places that are the same editor: the Bills of materials tab of its record and the Production → Bills of materials screen, which also lists all the company’s composite products (master/detail). It doesn’t matter which way you go in: the data is the same and so is the way of working.
How do I create the components from the item record?
Open the item in Items and go to the Bills of materials tab. If the item doesn’t have any components yet, the tab tells you so and you only need to start adding.
- In Base units, enter how many units of product the quantities you are going to type refer to. Leave 1 if your bill of materials is per unit, which is the usual case.
- In the last row of the table, which is the new-row line and is always visible, type the component code and press Enter. The code is looked up just as on a document line: the internal code, the SKU or the barcode all work, and you don’t need to type the leading zeros. If you don’t know it, press F2 or the magnifying glass: the item search by code or name opens.
- The cursor moves on its own to Quantity, with the 1 selected: type the quantity and press Enter. The row goes into the list and the cursor goes back to the code, ready for the next one. Ten components in a row can be entered without touching the mouse.
- On the rows already added you can change the Quantity, the Order and the Remarks directly, and remove one with the button on its row.
- Click Save components, at the top right of the tab, where the actions of all the record’s tabs are.
The components are saved whole and in one go. There is no saving row by row: until you click Save components nothing has changed, and when you click it everything is saved or nothing is. If you had resolved a component on the new-row line and didn’t get round to pressing Enter on the quantity, it goes in too when you save: nothing is lost for not confirming it.
Why do I see a dash in the cost column?
Because you have changed a quantity and the figure that was there is no longer valid. The cost of each row and of the product are calculated by the program, not by the screen: as soon as you change something, what is shown would no longer be true, so a dash appears instead.
When you click Save components the figures come back, already recalculated.
What do I do to remove a component or delete the whole bill of materials?
To remove a component, use the button on its row and then Save components: until you save, the row has only disappeared from the screen.
To remove them all there is Remove all components, with a confirmation. The item stops being composite: it is no longer broken down when it is produced or sold. Documents already made with that bill of materials don’t change: they keep the breakdown they were issued with.
What is ‘Do not produce when sold’?
It is a box in the components editor and it lets you leave this item out of what the company settings say. It has two positions:
- Unticked (the usual case): the general setting applies. If the company produces on sale, this item does too.
- Ticked: this item is never broken down when it is sold, even if the general setting says so.
It is for the common case of having a mixed catalogue: most composite items are produced on sale, but a couple of them are bought already assembled and the product has to be deducted, not its parts.
The box only affects sales. A production report deducts the components all the same, whether it is ticked or not: producing is producing.
How do I see which products a component is used in?
On the same Bills of materials tab, below the bill of materials, there is the Used as a component in panel. It lists the composite items that contain this item and how much each one contains.
It is the question the other way round, and it is the one you ask when something breaks: if a component runs out, goes up in price or is discontinued, there you see at a glance which products it affects.
What is the Production → Bills of materials screen for?
For working with all the company’s composite products from a single place, without going record by record. It has two parts:
- On the left, the list of composite products: one row per item that has components, with its code, its description, the base Units, how many components it has and its calculated cost. When you click a row, its editor opens on the right.
- On the right, the components editor: the same as the record tab, with the new-row line always visible, F2, Enter on the code and on the quantity, and Save components —here at the bottom of the editor, which is where you have just been typing, and not at the top as on the record—. Everything explained above applies here just the same. When you save, the list on the left updates itself.
In the list you can change two columns: the Code —with F2, which means changing item— and the Units, which are the base units. The others are calculated by the program. The two cells you can type in are easy to tell apart: they have a faint outline.
The Units are changed here and only here: on this screen the editor on the right no longer repeats that field, because it is the same data and having it in two places forces you to check which one applies. On the item record’s Bills of materials tab, which has no list beside it, the field is still there.
The order in which a row is typed is Units → Code → its components, which is how you describe a composite product: how many units come out, of which item, and what it is made of. When you confirm the code, the cursor moves on its own to the components on the right.
The list has two search boxes that combine and ignore capitals:
- Product: keeps only the composite items whose code or description contains the text.
- Containing the component: keeps only the composite items that contain a part with that code or description. It is the question ‘which items contain this screw’.
This screen also has Update composite item prices, which is explained in cost and price of a composite item.
How do I start building an item that doesn’t have any components yet?
On the last row of the list, which is the new-row line and is always visible. Type the item code there —the internal code, the SKU or the barcode all work, without the leading zeros— and press Enter, or press F2 or the magnifying glass to search for it by code or name. If the item has no components, its editor opens empty with the cursor already on the first component’s code; if it has some, it opens with them. A code that doesn’t exist opens the search with what you have typed.
Opening an item there doesn’t create anything. The item becomes composite —and appears in the list— as soon as you save its first component.
How do I move around the two lists with the keyboard?
Both lists on the screen are navigated like a spreadsheet, without touching the mouse, and with the same keys as the accounting journal:
- The arrow keys move the cursor freely from cell to cell, in the order they are shown.
- Enter starts editing the cell with its value selected; if you start typing, you replace it.
- Enter or Tab confirm what you have typed and move to the next thing that is typed, which in the product list isn’t the cell next to it: from Units you go to Code, and from Code to the components. The arrow keys follow what you see; Enter follows what you type.
- Escape discards what you were typing in that cell.
- Insert takes you to the new-row line, which is where things are added.
- Delete removes the row.
- F2 opens the search when you are on a code cell.
Tab from the product list jumps to its components list, and Shift+Tab goes back.
What happens to what I was editing if I change product with the arrow keys?
It is saved on its own, without asking. When you move to another product, the components of the one you are leaving are saved whole and silently: you don’t need to click Save components before you leave.
You are only warned when saving fails —for example, because there is a cycle or a repeated component—, and then the product doesn’t change: you stay where you were so you can correct it.
Going down the list with the arrow keys doesn’t trigger a save on each key press: the editor on the right opens when the cursor stops.
Previous: What is a bill of materials? · Next: Produce with a production report
More about Production
- How are the cost and price of a composite item calculated?
- How do I produce with a production report?
- Producing and assembling items
- Who are the workers and how are they maintained?
- How do I manage a production job with an order?
- How do I see what has been done on a project and the hours it has taken?
- What is a bill of materials and when do I need one?
- What happens when I sell a composite item?