Import Bill of Materials field definitions
Follow
George Sutton
Updated : Created :
Use the Import Bill of Materials template to create and update Bills of Materials (BOMs) in Unleashed in bulk.
For more details see Import/Export Production.
|
Import template field name * denotes mandatory fields |
Description |
|---|---|
| *Assembled Product Code | The unique Product Code of the product due to be assembled by the BOM. |
| *Component Product Code |
The unique Product Code of the product used to assemble the Assembled product. |
| *Quantity |
The number of component product units required to assemble one unit of the Assembled product, to 4 decimal places. |
| Wastage Quantity | The number wasted component product units used when assembling one unit of the Assembled product, to 4 decimal places. |
| Unit Cost |
The value per unit of the component product, populated from the product's Average Landed Cost (ALC), to 4 decimal places. If the component has no current Stock on Hand (SOH), the product's Last Cost will be used. If the component is a Never Diminishing Product (NDP) the Unit Cost will populate from the Cost field in the product's record, but can be overwritten at BOM level. |
| Total Cost |
The total value of the component product's quantity. NOTE: This field is only included when the template is exported as a pre-populated template. |
| Can Auto Assemble | YES or NO value to determine if the Assembled product will auto assemble when allocated to a Sales Order, see Auto Assembly. |
| Auto Assign Oldest Batch/Serial | YES or NO value to determine if the the oldest batch or serial numbers available for the component products should be assigned when the the Assembled product has an assembly generated. |
| Can Auto Disassemble | YES or NO value to determine if the Assembled product will auto disassemble when allocated to a Purchase Order, see Auto Disassembly. |
| IsObsoleted | YES or NO value to determine if the assembled product's BOM is obsoleted. |
| Expense Account |
Name of the expense account costs for the NDP component will be taken from in your integrated accounting platform: Xero, Quickbooks or Access Financials, see Expense accounts for NDPs. Maximum 50 character limit. |
| Comments | Free text field for any relevant notes on the BOM and subsequent Assemblies. |
| 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 values, determines how the total duration will be calculated based on the Expected Duration and assembly quantity. |
| Production Hours Per Day | The number of hours per day that production of the assembled product are worked on, defaults as per your Company Settings. |
| Production Days | The days of the week that production ff the assembled product are worked on, defaults as per your Company Settings. If multiple days, value must be separated by comma e.g. Mon,Tue,Wed. |
Expense accounts for NDPs
If a component product on a BOM is an NDP and your Unleashed 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.