Is cetec capable of creating a multilevel BOM like this?
see the image attached?
Yes. Make parts for each of the boxes. Then for each of the parts with children, make them assemblies (there’s a button to make them a bom) and then add their children. When you then go back and look at the top level “Parent” BOM, you will see this structure there.
Or you can make an excel file with a similar structure, e.g. with part and parent columns, and import it in.
Or you can use the API and upload a structure like that if you are the programming type. It will create parts if they don’t exist, but you can’t add a description (last I checked).
The nice thing here is that if you have the same phase and project setup you can just work with the revision of the SUB BOM’s and call them by project/phase/deliverable revision.
That way you will be able to keep a history and potentially reuse at convenience.
I would recomend building support to use the API to upload and update.
After having constructed more than 150 recepies in excel and uploading them I have come to the conclusion that I need to make a tool that utilizes the API in order for the process to not become to “clunky”.
I have started by simply writing som VBA code so that I can do it straight from excel.
I might have to change strategy though as handling json strings is not very efficient in VBA.
my two cents
//H
P.S
Adding a snippet of how i structure the excel sheet to keep the assemblies a part.
I then read the all lines with a powerquery in excel and remove all blanks and just keep one header.
So you end up with this file to import.
(note* 2 diffrent products displayed)
D.S
Can I import the BOM when creating a work order?
Also if i want it to have multi-level BOM how do I identify each level.
You identify each level by the top level PRC part.
So each line that is identical corresponds to on subassembly
So in my example
SNCFUMI Minty Blueberry Strong…
contains many parts
Whereas QLTPOUCH FUMI MINTY BLUEBERRY STRONG …
Contains only one part.
And you simply state how much of the part you want per top quantity.
You will have to import the BOM before you create the workorder. (to my knowlwdge at least)
//H
Yeah, thats the part i was curious about. If you have to import BOM before creating a workorder.
Your Excel sheet is awesome and makes it easy to read and understand.