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
I am assuming that you have your application has a structure that lets you build the BOMs. Something like this:
Now there are two answers I use.
1) In the Sub Assembly Table run a report
Grouped on Related Product
Group again on Related Assembly
Sort on Related Item Master
Instead of the "Related Field", you should use the Description field for those tables or what ever data from the tables makes sense for your BOM Report.
2) Get the data out and use Tableau, PowerBI, Sigma, QLIK or another BI/BA tool. This is more work but gives you the control to really make the report look like you need it, so it is intuitively inform the user.
------------------------------
Don Larson
------------------------------
Now there are two answers I use.
1) In the Sub Assembly Table run a report
Grouped on Related Product
Group again on Related Assembly
Sort on Related Item Master
Instead of the "Related Field", you should use the Description field for those tables or what ever data from the tables makes sense for your BOM Report.
2) Get the data out and use Tableau, PowerBI, Sigma, QLIK or another BI/BA tool. This is more work but gives you the control to really make the report look like you need it, so it is intuitively inform the user.
------------------------------
Don Larson
------------------------------
Thanks Don. I am set for going down (or up) one level in the assembly/sub-assembly chain.
I am looking for a way to see everything above or everything below a component (assuming that a component is made of sub-assemblies, which in turn are made of sub-assemblies, which in turn are also made of subassemblies, etc.).
------------------------------
Edward Hefter
www.Sutubra.com
------------------------------
I am looking for a way to see everything above or everything below a component (assuming that a component is made of sub-assemblies, which in turn are made of sub-assemblies, which in turn are also made of subassemblies, etc.).
------------------------------
Edward Hefter
www.Sutubra.com
------------------------------