13-Aquamarine

Solved

Automatic fill of Line Number in BOM's

Forum|Forum|6 years ago
October 11, 2019
6 replies
21711 views

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

General Customization

Best answer by Alex1988

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

B

BenLoosli

23-Emerald III

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

joe_morton

18-Opal

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.

B

BenLoosli

23-Emerald III

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

joe_morton

18-Opal

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.

D

d_graham

18-Opal

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.

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

After running utility and refreshing page.

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

David

D

DT_9681624

1-Visitor

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

P

pcauwels

10-Marble

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.

@

@_1647

13-Aquamarine

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.

A

aacciano3

14-Alexandrite

Hi,

Are you able to share the utility?

@

@_1647

13-Aquamarine

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

M

Maged_Thabet

5-Regular Member

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

J

JK_12206579