cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Automatic fill of Line Number in BOM's

Alex1988
12-Amethyst

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

31 REPLIES 31
BenLoosli
23-Emerald II
(To:Alex1988)

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

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. 

BenLoosli
23-Emerald II
(To:joe_morton)

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

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

We are currently checking for the autofill even with the default line numbers. One of our developer might have found a solution. I will keep you posted if its works completely.

Ismail_shaik
6-Contributor
(To:Alex1988)

Hi Alex,

Did you find any solution for this? If yes, could you please share the details?

LINENUMBER  and FINDNUMBER  can be added to Windchill by the site admin and then added to the assembly as a COMPONENT PARAMETER to get transferred to Windchill Structure automatically. Duplicates can be eliminated with the merge uses in Windchill

Found the article.

 

Article - CS197902

Alex1988
12-Amethyst
(To:kaudibert)

While this is a good article, it doesn't suit our solution.

Line Number is present OOTB in the Uses Tab of a Part Structure. This Attribute is filled when you click on the field. Our goal is that the user doesn't have to click in the field and gets this automatically. In cases where the user has a BOM with 300 parts it would be rather cumbersome to click every needed box to have the line number filed.

Doesn't sound like you read the article. LINENUMBER gets assigned in Creo and transferred automatically to Windchill. OOTB does not have LINENUMBER assigned in Windchill as an attribute. Uses tab get's filled in by Creo if the attribute is created. You need to have the Site Admin create LINENUMBER at the Site level.

Alex1988
12-Amethyst
(To:kaudibert)

Hi,

 

We are talking here about a WTPart Structure that is not connected yet in any way to the CAD structures.

 

 

 

 

 

Ok sorry, didn't know you were going backwards. We always start with CAD then send that to Windchill and Windchill sends that to ERP

Hi,

 

Still working on it but we encountered some difficulties at the moment. The idea is that the auto complete is done with a Data Utility when the structure is expanded in Structure Tab.

We will let you now once its finished.

See attached for the CAD centric approach

This is a video on Merge Uses in Windchill

calonso
5-Regular Member
(To:joe_morton)

Hi,

did you found finally a solution for this? Now facing the same necessity.

Thanks

Alex1988
12-Amethyst
(To:calonso)

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

 

aacciano3
13-Aquamarine
(To:Alex1988)

Hi @Alex1988 

 

Are you able to share how you achieved such customization?

 

Thanks

Alex1988
12-Amethyst
(To:aacciano3)

In our case the code cannot be shared as its client property.

d_graham
17-Peridot
(To:Alex1988)

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

@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.

pcauwels
4-Participant
(To:DT_9681624)

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.

Hello David,

Could you please provide a brief overview regarding the customization you did to achieve this?

 

Regards,

Albert

d_graham
17-Peridot
(To:d_graham)

BTW, I also have the auto line numbering working from a workflow. For example automate line number all WTParts on a Promotion Notice, Change Notice or Change Activity.

 

If anyone has a specific behavior they’d like to see post the EXACT details here or send me a private message with those details and I’ll try to write the code to do it.

 

David

Hello David,

 

Is it possible for you to share an example of your Auto line number structure method with us? That is exactly what we are looking for.

 

Regards,

Vincent

@_1647
7-Bedrock
(To:d_graham)

 

Hi

could you help us for this customization cause we stucked over there.

Hi @d_graham , can you share the sample code of this funtionality?

 

We need it too and are stucked on solution.

 

thank you.

Fábio Valente - Developer and Solution Architect
@_1647
7-Bedrock
(To:Alex1988)

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.

aacciano3
13-Aquamarine
(To:@_1647)

Hi,

Are you able to share the utility?

Top Tags