I am trying to create a report that will list all Bills of Materials that contain a particular item as a component. Any ideas of which tables would contain this info?
Date
Votes
3 comments
-
Bryan Robinson In my experience, Jet cannot handle BOM reports as it requires recursive calls to determine which products a specific product is used within unless you have some sort of field in the database that shows a Master item associated with every product.
-
Wilfred Crane Our BOM by consumed material report uses table BM010115, fields PPN_I and CPN_I.
-
Bryan Robinson The problem is that any one product could have many branches and many levels to it. If we use Fabrikam's BM tables and look at the Chair, we can see that to make the chair, we need three items but two of those items are built from other materials. Jet could tell you one level such as "what products use SEAT FABRIC?" and return "SEAT ASSEMBLY" but Jet cannot return "CHAIR". Ultimately the SEAT ASSEMBLY is used in CHAIR but because the database only tells us that SEAT FABRIC is used in the SEAT ASSEMBLY., that is the only connect Jet can make.
It takes a recursive call to be able to then determine, is the SEAT ASSEMBLY used as part of another item, and is then is that item used as part of another item, etc.
Please sign in to leave a comment.