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.

2.

3.

4.

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 coloncolon.

=

=

BH

=

=

=

=

=

=

=

=

BH	BOM Header which stands for the BOM information
BL	BOM Lines which make up the BOM or build inventory lines
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