Fully exploding a Bill of Materials
I am trying to write a system that will allow a multilevel BOM. I can use a many-to-many table to allow the same part to be attached to many different higher level parts. I can write reports that show...
Forum Discussion
Hello Edward,
An approach you may consider is described below:
1 - Every item on a BOM has a parent coming from part master table or another part/assembly table.
2 - Create a BOM table that references part master table
3 - Assemble your product BOM with parts by selecting from part master table. Identify each BOM part with a parent. The parent will be a part. Same as you do with project task dependency
4 - Identify each BOM part with an order
5 - create your report by grouping on the parent and sorting on the order.
------------------------------
Souheil Karam
------------------------------
An approach you may consider is described below:
1 - Every item on a BOM has a parent coming from part master table or another part/assembly table.
2 - Create a BOM table that references part master table
3 - Assemble your product BOM with parts by selecting from part master table. Identify each BOM part with a parent. The parent will be a part. Same as you do with project task dependency
4 - Identify each BOM part with an order
5 - create your report by grouping on the parent and sorting on the order.
------------------------------
Souheil Karam
------------------------------
Thanks Souheil. I see how this can show all assembly/sub-assembly relationships, but I can't see a way to limit the view to just one particular top level assembly and all of its sub-assemblies. For example, if I also had an ASSMB that had components F, E, and H, how would I just see that?
------------------------------
Edward Hefter
www.Sutubra.com
------------------------------
------------------------------
Edward Hefter
www.Sutubra.com
------------------------------