Import Bill of Materials field definitions
Follow
George Sutton
Updated : Created :
| Field Name | Description |
|---|---|
| *Assembled Product Code | Product code of the assembled product. NOTE: The product must has "Assembled Product" enabled in it's product record prior to import (see Create Products). Only one BOM can be created per assembled product. |
| *Component Product Code |
Product code of the component product required to assemble the assembled product. NOTE: The product must has "Component Product" enabled in it's product record prior to import (see Create Products). |
| *Quantity | Quantity (numeric) of the component product required to assemble 1 unit of the assembled product. |
| Wastage Quantity | Quantity (numeric) of any wastage of the component when assembling the product. |
| Unit Cost |
Cost per unit of the component product, automatically updated based on the component's Average Landed Cost (or Last Cost). NOTE: If the component is a Never Diminishing Product the Unit Cost will populate from the "Cost" field in the product's record, but can be overwritten at BOM level. |
| Total Cost | Total cost of component quantity (Unit cost * Quantity) |
| Can Auto Assemble |
YES or NO value determines whether the assembled product will automatically create an assembly when added to a Sales Order:
|
| Can Auto Disassemble |
YES or NO value determines whether the assembled product will automatically create a Disassembly when receipted on a Purchase Order or Credit Note
|
| IsObsoleted | YES or NO value, determines whether the BOM is active or not. |
| Expense Account | Name of the "Expense Account" associated with the any component that's a Never Diminishing Product. NOTE: This field is required if you have an accounting provider integration (Xero, Quickbooks or Access Financials). (There's a 50 character limits on Expense Account header for Quickbooks Online) |
| Comments | Any comments related to the Bill of Materials |
| Expected Duration | The time it's expected to take to complete an Assembly for of one unit of the assembled product in hours, minutes or second or a combination e.g. 6hr 10m |
| Duration Type | Unit OR Assembly |
| Production Hours Per Day | As per your Company Settings |
| Production Days | As per your Company Settings. If multiple days, value must be separated by comma e.g. Mon,Tue,Wed |
* denotes mandatory fields. Ensure that you enter correct values in the template before importing into Unleashed.
How Bill of Materials is displayed in a CSV file
The below illustrates an example of how to enter the field values for Expense Accounts when integrated with an accounting provider:
Expense Account for Xero:
Expense Account for QuickBooks:
Helpful Links:
Import Assemblies and Bill Of Materials