BOM Multiple Import

Still coming or will be in new release

 Bill of Materials (BOM) multiple import

 This will allow for multiple BOM imports from one Excel sheet.

 Go to Inventory > Configuration > BOM setup

 Click on Print/ Export drop down and select Import BOMs

 

 Select your file for import, upload and import

 

 Exception report

 There will be an except report afterwards which will show what Bill of Materials have not imported due to the following:

1.Bill of materials code is not unique, duplicate found

2.Inventory line item does not exist, or is Not active

3.Bill of materials result item does not exist

4.Bill of materials result item is not marked as a BOM

  Excel file layout

 Prepare the Excel file for import

The file is prepared in a CSV file and separated by Semi colon

 BH = BOM Header which stands for the BOM information

BL = BOM Lines which make up the BOM or build inventory lines

 BH

Code = This is unique and is the code of the BOM (Required)

Description = Description of the BOM (Required)

Result item = is the code of the BOM inventory item which is flagged as a bill of materials item (Required)

 BL

Code = Inventory item code (Required)

Description = Description of inventory item

Qty = Quantity of BOM line which will make up one item (Required)

Warehouse = Stock item warehouse code (Required for stock items)

Cost = Cost price of line

          Stock items will get cost from system

          Service and custom items will update cost that is set here

          Note - if value is left blank for service and custom, this will bring in a cost of zero

 

 Template

 Import template can be found under System Configuration > Administration > Imports