tag:blogger.com,1999:blog-5285970135510371565.post5265155125881514288..comments2024-03-29T08:01:13.871-04:00Comments on The Dynamics GP Blogster: Using T-SQL and recursive CTE to generate a BOM treeMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5285970135510371565.post-9563237700860356022015-09-10T05:07:53.820-04:002015-09-10T05:07:53.820-04:00Is it possible to have the roll up qty for the com...Is it possible to have the roll up qty for the components? Based on the above script, it will always pick the design qty defined for the sub-components based on 1 unit of the previous parent's item.<br /><br />Any suggestion on how that can be done?<br /><br />Mayhttps://www.blogger.com/profile/06932427694714973817noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-49312156799416982112014-02-07T12:55:09.740-05:002014-02-07T12:55:09.740-05:00Customer's are asking for this but the compone...Customer's are asking for this but the component costs and rollup cost to the parent item. Do you have anything that would add this data already written?Anonymoushttps://www.blogger.com/profile/06605443041929439474noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-84066716797409220252010-09-04T08:18:54.442-04:002010-09-04T08:18:54.442-04:00Beat,
I am not familiar with the Manufacturing BOM...Beat,<br />I am not familiar with the Manufacturing BOM tables, but I am sure the concept is the same.<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-43930190887012542762010-09-03T12:28:08.083-04:002010-09-03T12:28:08.083-04:00Hi Mariano,
The recursive CTE stuff looks very pro...Hi Mariano,<br />The recursive CTE stuff looks very promising to me, and I tried to apply it by analogy to the Manufacturing BOM Tree... but then I get a type mismatch error somehow : << Types don't match between the anchor and the recursive part in column "item" of recursive query "BOMCTE". >><br />Any idea ? I can send you the code if you would like...<br />Have a great day,<br />BeatBeat BUCHERhttps://www.blogger.com/profile/07394259942485626115noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-82599665584515240282009-06-16T18:20:52.700-04:002009-06-16T18:20:52.700-04:00Japheth,
As always much thanks for your input. I ...Japheth,<br /><br />As always much thanks for your input. I will test your suggestion and post back with the results.<br /><br />Best regards,<br /><br />MG.-<br />Mariano Gomez, MIS<br />Maximum Global Business, LLC<br />http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-78868137203668766832009-06-16T17:51:03.933-04:002009-06-16T17:51:03.933-04:00Just trying out this script and it's great but...Just trying out this script and it's great but I think I found a bug. I think the recursive join back to the CTE should be <br /><br />JOIN BOMCTE AS C ON (B.itemnmbr = C.component)<br /><br />Let me know what you think.Anonymousnoreply@blogger.com