Bills of Material Import
The Bills of Material import loads manufacturing BOM structures in bulk. A BOM lists the components and quantities consumed to produce one unit of a parent item — for manufacturers adding items regularly, building them from a spreadsheet is far quicker than one at a time.
Where to find it
Go to Setup > Import Export > Bills of Materials. Import items first — both the parent and the components must exist.
Format Data
| Column | What it holds |
|---|---|
| Parent code | The item being manufactured — the one the bill of material belongs to. |
| Item Code | A component consumed to make the parent. One row per component. |
| Quantity | How many units of the component are used per unit of the parent. |
| Location code | The warehouse the component is drawn from during production. |
| Work centre | Where the work is carried out. |
A BOM with five components is five rows sharing the same Parent code — not one row listing everything. The parent repeats down the file.
Errors and exports
If rows fail, the system returns your file with a Memo column added, naming the problem on each bad row — fix those rows and upload again. Every module supports export as well as import, so you can pull current data out in the same format.
The rules common to all imports — never rename headers, dates in Y/m/d, codes must already exist, test a few rows first — are set out in Importing Your Data.
Related pages
- Items and Services Import — must run first
- Importing Your Data — shared rules and import order
- System Preferences — manual BOM selection