Use the Import Bill of Materials template to create and update Bills of Materials (BOMs) in bulk.
Import Bill of Materials template field name*denotes mandatory fields | Description |
*Assembled Product Code | The unique Product Code of the assembled product the BOM is being created for. |
*Component Product Code | The unique Product Code of the component product is used to build the assembled product. |
*Quantity | The number of component product units required to build one unit of the assembled product, to 4 decimal places. |
Wastage Quantity | The number of component product units wasted when one unit of the assembling product is assembled, to 4 decimal places. |
Unit Cost | The current cost of one unit of the component product, populated from the product's Average Landed Cost (ALC). If the product has no SOH, thus a zero ALC, the product's Last Cost will be populated instead. The Unit Cost can only be updated via the import if the product is Never Diminishing. |
Total Cost | The sum total value of the component product's quantity. This field is only included when the template is exported as a pre-populated template. |
Can Auto Assemble | Enter a YES or NO value to determine if the assembled product will auto-assemble when allocated to a Sales Order. |
Auto Assign Oldest Batch/Serial | Enter a YES or NO value to determine if the oldest batch or serial numbers available in the component products's stock should be assigned when an Assembly is created. |
Can Auto Disassemble | Enter a YES or NO value to determine if the assembled product will auto-disassemble when receipted to a Purchase Order. |
IsObsoleted | Enter a YES or NO value to determine if the assembled product's BOM is obsolete. |
Expense Account | If the component product is an NDP, and you are integrated with Xero or QuickBooks, name the expense account costs for the NDP component will export to. A maximum 50-character limit. |
Comments | A free text field for any relevant notes on the BOM. |
Expected Duration | Based on the Duration Type selected, enter how long production is expected to take, in hours, minutes, or seconds, e.g., 6h 15m. |
Duration Type | Enter "Unit" or "Assembly" to determine whether the duration times in the BOM should apply per assembled unit or Assembly. |
Production Hours Per Day | Enter how many hours are available for production per day. |
Production Days | Select which days of the week production is available for. If multiple days, value must be separated by a comma, e.g., Mon, Tue, Wed. |
Expense accounts for NDPs
If a component product on a BOM is an NDP and your account is integrated with either Xero, QuickBooks, or Access Financials, you must provide an Expense Account per NDP component in the BOM.
If integrated with Xero, the NDP component product's Expense Account must be provided using the numerical account code, as provided in Xero.
If integrated with QuickBooks, the NDP component product's Expense Account must be provided using the full title of the account, as provided in QuickBooks.