Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Is there a way with BoM Tables to change the configuration of the item numbers?
What I am after is the item numbers to go 10, 20, 30, 40 etc instead of 1, 2, 3, 4, 5,
Is this even possible?
Colin,
There is a way, through the use of a relation in the repeat region. We had to implement the same thing to get our BOM tables to match our ERP bills.
First, create a relation in your repeat region: index = rpt_index * 10
Then, in the index column of your repeat region, you set the value of the cell to be &rpt.REL.index
index is the value we used in this case, you could replace it with any other variable name.
in the repeat region cell, the second value (REL) calls the value index from the repeat region relations
The up side to this is that the relation is saved to the table, so if you save the table for later use, it will always come in with the 10,20,30,... numbering. The downside to this is that your BOM balloons still show up as 1,2,3,4,... and you need to reset what the BOM balloon parameter is in the table (select the table, right-click, properties, BOM Balloon tab, set the value to rpt.REL.index) each time.
Larry,
Great thanks worked well, although when I go to change the BOM Balloon parameter it is greyed out, is there a config setting to enable me to change this?
Colin,
Not as far as I can tell. I have been through my drawing config settings and I cannot find any option there related to BOM balloons that is not set to default. Honestly, I do not know what would prevent you from setting that value.
Larry,
It was because my table was set to custom balloon. If I import the table first then I can change the box, then I need to select my balloons.
If I do it the other way around the box is greyed out.... Oh don't you just love PTC lol