Forum Discussion
DonLarson
Qrew Commander
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
------------------------------
MarkShnier__You
2 years agoQrew Champion
In my experience with these type of apps, the issue is that a subassembly gets used in other subassemblies recursively.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------