I'm using the (NL)Sheets function on the BOM Component table gathering quantity of each component needed for a parent item. I can filter by parent item. I would like to create a summary sheet that will display the components and total quantity of each component needed (When choosing more than one parent item). Seeing as the sheets are created when the report runs and the number of items required for each parent item varies, I cannot use one particular cell reference, it has to be a range of cells. I'm not sure how to do this. Anyone have any ideas?
Date
Votes
2 comments
-
CascadiaDataworks On your summary sheet, change your NL Sheets to NL Rows. This will then create a sheet with the same results just in one column instead of a sheet per result. If you need both the parent and child items, you will need to do a grouping report where the parent item is the main group, then the children is the secondary group.
If you are after a true BOM report where you need parts of children of children, Jet really isn't the best solution. It is one of the few reports that Jet doesn't do.
-
Rachel Schaefer I was afraid that was the case. I was hoping for some magic that I hadn't thought of. Thanks for answering.
Please sign in to leave a comment.