Skip to main content
Alex198813-Aquamarine
13-Aquamarine
October 11, 2019
Solved

Automatic fill of Line Number in BOM's

Hi Guys,

 

Does anyone have experience will automatic population of the Line Number automatically or what should be updated or customized to reach this?

 

 

Alex

    Alex1988Answer
    13-Aquamarine
    October 15, 2020

    Hi,

     

    We ended up extending the LineNumberDataUtility.

    Each time the user expands the structure the missing line numbers are filled.

    New line number will have have a value of the the latest line number added with the line number increment.

     

    At the moment we do not use the Line Number in the ERP system, we just need it to be able to create uniqueness in the structure.

     

    Alex

     

    View in thread

    32 replies

    BenLoosli23-Emerald III
    23-Emerald III
    October 11, 2019

    By line numbers, do you mean the BOM index?

    These are added when you have a column in your BOM table that calls out the Index- &rpt.index.

    It can be locked in that BOM.

    It is automatically generated when the BOM is populated.

     

     

    See this PTC article: https://www.ptc.com/en/support/article?n=CS133915

    Translate
    joe_morton
    joe_morton19-Tanzanite
    19-Tanzanite
    October 11, 2019

    I looked through some Support articles before.. I couldn't find any automated way to do this. The closest I found is you go to the WTPart structure and click on each line item. It will "auto" number the lines you click. I want to use line items, but it's basically unusable as-is. 

    Translate
    BenLoosli23-Emerald III
    23-Emerald III
    October 16, 2019

    Can you give an example of what you are looking for?

    Translate
    joe_morton
    joe_morton19-Tanzanite
    19-Tanzanite
    October 16, 2019

    Below is the Line Number field in a WTPart Structure. We could do more logic for tracking BOM  changes if we consistently used them. Example: PN 1 in line number 10 is removed and PN 2 is added in line number 10. Downstream systems could interpret that as a Replace instead of an add/remove. The trouble is, there's no automated way to enter even the default line numbers. 

    clipboard_image_0.png

    Translate
      d_graham18-Opal
      18-Opal
      October 17, 2020

      Guys, I created an action in the WTPart action menu that will do it.

       

      I wrote the tool such that it runs only if the WTPart is checked out by the user and it is run from the Working Copy's page. If the tool is run from a non-working copy a window tells the user they need to run it from the working copy.

       

      So, let's say you start of with no line numbers or there are some missing line numbers or whatever.

      First checkout the WTPart.

      Then select the *Auto Line Number Structure option.

      Then refresh the page.

       

      As this is just an example, I incremented the Line Numbers by 1 but that could be whatever you want.

       

      lineNumbers1.png

       

      In this example I entered one line number just to do the checkout.

      lineNumbers2.png

       

      After running utility and refreshing page.

      lineNumbers3.png

       

      Seems to work well and can certainly do multi-level structures as well.

       

      David

      Translate
        DT_96816241-Visitor
        1-Visitor
        February 11, 2021

        @d_graham Can i get the java utility created for Automatic fill of Line Number in BOM's via action Auto Line Number Structure option . please share the utility here.

        Translate
        pcauwels10-Marble
        10-Marble
        September 1, 2021

        We are facing the same issue described above.

        Is it possible to receive the code to add an action in the WTPart action menu that will do it as shown above?

         

        Thanks on advance.

        Translate
        @_164713-Aquamarine
        13-Aquamarine
        October 28, 2022

        I have a solution for this and using that utility we can do autonumbering for multilevel as well as for single level also we can auto-generate line numbers on a single click and if there are already few parts with number under structure then that utility will add unique numbers only on new parts.

        Translate
        aacciano314-Alexandrite
        14-Alexandrite
        October 28, 2022

        Hi,

        Are you able to share the utility?

        Translate
        @_164713-Aquamarine
        13-Aquamarine
        October 28, 2022

        I have that utility but I can't share it if you want I can help you to sort out that 

         

        Translate
        Maged_Thabet5-Regular Member
        5-Regular Member
        December 19, 2022

        Hi Alex1988,

         

        We have implemented this feature with no special difficulties, without interfering with GWT(no decompilation needed). We even added possibilities to auto-fill other usagelink attributes. For the linenumbers auto-fill, we have implemented a preference to gather the increment that the feature will get and use starting from the max linenumber found in the bom(if it exists, otherwise, the autofill starts from zero).

        Translate
        JK_122065794-Participant
        4-Participant
        December 18, 2024

        Hi, I found a way to do this with an add-on: Link-It® Properties: Intelligent user interface for CAD data | MP Soft

        At 1:33 on this video https://youtu.be/9ln7C9UUse8 the user switches to the Bill of Materials tab and automatically inputs the line numbers.

        Translate
          Terms & ConditionsAccessibility statement