Stock Items Import from Excel
First, you will need to import all Finishing Goods & Bill of Material into Stock Items from Excel.
- Go to Stock > Stock Items (To Export the Excel Template)
- Select / Highlight 1 item
- Right click > choose “IO” > choose “Export” > choose “to Excel”
- Choose the Destination of Stock Items Excel Template and name of file to be create.
- Locate the Stock Items Template and fill up all the Finishing Goods and Bill of Material as Stock Items into the Stock Items Template.
- Go back to the Stock > Stock items screen
- Right click > choose “IO” > choose “Import” > choose “from Excel”
- Click on the […] button and choose the Stock Items Template file and click [OK].
- Now, all your Finishing Goods & Bill of Material have imported from Excel.
Bill of Material from Excel
Next, you will need to import all Bill of Material needed to assembly your Finishing Goods.
- Go to Stock > Bill Of Material (To Export the Excel Template) NEED TO CREATE 1 SAMPLE BOM BEFORE CAN EXPORT
- Right click > choose “IO” > choose “Export” > choose “to Excel”
- Choose the Destination of BOM Excel Template and name of file to be create.
- Locate the BOM Template and fill up all the Bill of Material with BOM Code into left table and Finishing Goods’ Material into right table.
- Go back to the Stock > Bill Of Material screen
- Right click > choose “IO” > choose “Import” > choose “from Excel”
- Now, all yours Bill of Material with BOM Code have imported from Excel.
Refer attachment for details