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 [MP1] Classic [x3 seats]
Windows 10 - Quadro P2000

4 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 [MP1] Classic [x3 seats]
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