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

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

Children