Modified Multilevel BOM Report
Hello,
I have modified the existing multilevel BOM report to get all the levels of the BOM. The OOTB feature only lets you fecth till the 5th level.
I have modified the existing report to fetch t...
Forum Discussion
Hi Mithun,
The GetItemRepeatConfig function that the Multilevel BOM Report uses accepts an attribute on the relationship called repeatTimes. The value of this attribute indicates how many levels down the query should return (this is 6 by default in my database). You can also set the value of this attribute to 0 which will return all levels.
I believe this is the only change that should be needed as the Stylesheet should be written generically to handle many different levels of a BOM structure. That being said, I don't have a large enough data set in any of my test instances to verify this.
Chris
Christopher Gillis
Aras Labs Software Engineer
Hello Chris,
If we have a certain number of fix levels for an assembly then we can define the number of colspan in the Indenture level column as we do in the stylesheet. In my case I have 1 complete assembly with around 18 levels so I have set the Indenture columns colspan as "17" but when I use the same report for other assemblies which have less levels for BOM, it still shows the empty columns in the Indenture Level column because I have hardcoded it as 17 just like in the OOTB Report, can you tell me is there any way i can check for the levels with respect to repeat times attribute as you suggested and then set its value into a variable which will be used in colspan.
Please advice.
Let me know if you need more details.
