Cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

BOM Sorting Order - Material Thickness

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hello Edge-heads,

 

One of my guys asked, and I was stumped for a solution....."how can the material thickness sort order, in a BOM, be made to respect the numerical sequence, and stack correctly?"

 

So currently the option in our BOM sort order is "Plate" [renamed - Material Thickness] as the first order filter, BUT it doesn't sequence correctly....in that, it can read, as follows....

 

2018-07-13 (1).png

 

2018-07-13 (2).png

 

In my mind, 10 & 20 are greater than 3 & 5. What am I missing?

 

Sean Cresswell
Design Manager Streetscape Ltd
Solid Edge 2019 [MP2] Classic [x3 Seats - Cloud Enabled]
Windows 10 - Quadro P2000

7 REPLIES

Re: BOM Sorting Order - Material Thickness

Genius
Genius

Hello

 

If You code name of a plate lake this:

PSM-00.9

PSM-01.9

PSM-02.0

PSM-03.0

PSM-05.0

PSM-10.0

PSM-20.0

Then everything will be as it shuld be.

 

Regards

SE ST9 + TC 10.1.7

Betreff: BOM Sorting Order - Material Thickness

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hi @SeanCresswell

 

 

I believe that this is a deeper problem and somehow based on certain Windows optuins/changes.

 

I have seen same with files sorted by filename in a folder.

If Your filenames start with numbers then You will see similar sort result.

 

I think to remember that this was a modification between XP and Win7 or so, and that there was a registry entry to change it back.

But I fear that this has no influence to SE as long as we do not have the option for a numerical sort rather than a alphanumerical which is in use at the moment.

 

 

PS.: this also is the reason why I name my images always in the form yyyyMMdd-hmm (20180713-0757)

This will give me a proper search and sort result rather than starting with day and month without leading zero.

Since that will mix them in a non usable way.

 

regards
Wolfgang

Betreff: BOM Sorting Order - Material Thickness

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Thanks for your input @Wollverine & @hawcad,

 

But the file name is really not the issue, as the problem exists even when the proper [this was a test scenario only] file names are used......the only problem is with the material thickness [gage] column, and the sorting.

 

Solid Edge doesn't allow entering preceding zero's to the thickness field, the limitation starts there.

Sean Cresswell
Design Manager Streetscape Ltd
Solid Edge 2019 [MP2] Classic [x3 Seats - Cloud Enabled]
Windows 10 - Quadro P2000

Betreff: BOM Sorting Order - Material Thickness

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

Hi @SeanCresswell

 

 

Yes, 


all entries in a SE table are interpreted as alphannumeric text rather than numbers, that's the basic problem!

 

 

regards
Wolfgang

Betreff: BOM Sorting Order - Material Thickness

Experimenter
Experimenter
Hi @hawcad @SeanCresswell @Wollverine

In the end there's no solution for this problem?

regards
Luca

Betreff: BOM Sorting Order - Material Thickness

Phenom
Phenom

@LukeSkyW wrote:
Hi @hawcad @SeanCresswell @Wollverine

In the end there's no solution for this problem?

regards
Luca

I just tryed with ST10 - MP10 and the ordering by material thickness works well

 

partlist.png

Betreff: BOM Sorting Order - Material Thickness

Phenom
Phenom

I don't think I would have any problem sorting by material thickness. I bet could also easily group the different thicknesses as well. But I personally don't use the "Material Thickness" to sort by, I use the gage. And if you have whatever decimal that equals as the name for that gage, I can say I definitely have no problem sorting like that.

Below is a bad example, but it's what is up on my computer right now. I assure you it all stays sorted in just this way.

 

Capture.JPG

Solid Edge 2019
Windows 7 Professional
Nvidia K2200 & Intel Xeon
"You're doing it wrong"