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 till 18th level which was my initial requirement, this part is hardcoded and I want to make it dynamic.

Please advice me on this topic.

Just to gave a background, I have increased the indenture level in the Report stylesheet to 18 and made other changes accordingly, please let me know if this can be done dynamically.

Please let me know.

Thanks in advance,

Mithun

Parents
  • 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.

Reply
  • 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.

Children
No Data