Prepare Excel file to import
Supported file format: xls; .xlsx
1. Create an Excel file and give the column name for the 1 string.
2. Locate columns in a certain order:
1 column (A) — Material name
2 column (B) — Part No
3 column (C) — QTY
4 column (D) — Comments
3. From the second string, list the required materials that should be imported to a BOM.
Create a Bill of Materials and Import Materials
Create a Bill of Material or open pending BOM to import materials.
1. The "Import from excel" button opens a file selection window.
2. Select a file to import.
3. Check the column mapping.
4. Click YES to confirm the import.
Review Import Result
Please note that materials cannot be imported if:
1. The price for materials related to the BP Project is not determined.
2. Material Part No. is missing from the file.
3. There is no such material in the Material List reference.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article