Home Button  Buy Button 

Topic:   Sorting within BOMs

By: LeoPosted on: Mar 20 2018 at 09:34:04 AM
Was wondering if I was missing some sorting options, or hopefully something that is planned for the next major release. If not, please consider this a feature request.

Currently I am seeing that you can sort by one column at a time.

What I am looking for is nested sorting. Similar to how when data sorting in excel, you can set multiple sort orders, with preference. So you could, for instance, sort columns with the order of Column B, D, C, A.

This would let me see BOM print-outs sorted via Supplier first, then within that sorted by part #. Or other similar setups, depending on particular requirements.

The implementation I'm thinking of is something where you could open up a little window with a list of 1st, 2nd, 3rd, etc. where you would then select a column for each sorting priority.

By: SupportPosted on: Mar 21 2018 at 03:07:52 AM
To the right of the BOM window is an excel 'X' button. Click that and you can save the BOM as a CSV. Open that it Excel and sort it any way you want.

But sorting and filtering is something that's being improved in v5. But your multi-column sorting is unlikely to appear in the first v5 release. But maybe we'll look at it later.

On the other hand, moving the BOM into Excel takes just a couple of seconds where you have tons of layout features so should we really be reinventing the wheel?

By: LeoPosted on: Mar 21 2018 at 11:18:13 AM
Thanks, excel was the method I was planning on using for now.

As far as re-inventing the wheel, you may be right. My only concern (not sure that is the right word) is needing to have that extra step every time someone needs to build an assembly. I think the issue lies in the inventory pull. Right now when sorting by Bin location, the parts are not then sorted by part number. It seems sort of random, it doesn't seem to be sorted by item (BOM item# by miniMRP), nor by part #, Supplier, Description.

Specifically what I am trying to do:

I have a BOM with 139 items.

Inventory items are, dependent on item type, within the following areas:
a.(letter-number) inventory location i.e. A-3 or D1
b. Yellow (yellow bins area)
c. Red (red bins area)
d. SP (another section)
e. Archive (archived parts section, parts that are very old and likely haven't been used in years)

When sorting by Bin location, I'd like my employees to be able to walk to that location and pull the part #s in order rather than jumping back and forth out of order within that section. In my example above in the yellow bins section (basically nuts, bolts, washers, etc. with each part in their own yellow bin labeled with the part number) there are 58 different parts being used, held on 5 different cart sides. They should be able to go through that cart area and grab them all without going back and forth between the different cart sides.

Excel certainly allows me to do this now, and if I have to that will certainly be the way to do it. Just think it would be nice for the report/sheet coming out of miniMRP to not need any further processing.

Thanks for listening to that long diatribe! ;)

By: SupportPosted on: Mar 23 2018 at 04:13:45 AM
I think we were kind of assuming that each item would be in a unique BIN (shelf, drawer etc) so we'd sort by the BIN and the picker would just walk round the shelves picking the items in BIN order.

But you're saying that you have more than one item in the same BIN and your BINs are physically large so the guy is stepping back and forth within the BIN picking different items.

In an ideal world you'd make your BINs smaller, ie split them into smaller (sub) sections, where each section contains just one part number. Of course I don't know your industry so I'm sure you've already thought of that and, for whatever reason, it's not a practical solution.

With that in mind then your idea of sorting on multiple columns would solve the problem. All I can do at this stage is put it into the "TO DO" list and see if I can nudge it near the top.

To answer your comment about 'Random' sorting. You currently sort on the BIN and then everything else is simply pulled sequentially (fastest way) from the database in the order that it's stored in the database - likely the order in which the items were originally created in the database.

By: LeoPosted on: Mar 23 2018 at 08:24:22 AM
Thanks for the consideration.

I think I may look into what you said about making the bin area more fine tuned.

To explain it better my "Yellow" bins section is literally just a tone of yellow bins on mobile carts. Probably about 500 or so yellow bins. So, I suppose I could just go through and number each one, and change the bin location from the generic yellow, to a more specific Y-37, Y-424, etc.

Thanks for the idea!

By: SupportPosted on: Mar 24 2018 at 03:49:29 AM
Yes. If you've got hundreds of yellow bins then Numbering your yellow bins would make more sense - even more sense than us allowing multi-column sorting.

The idea is that if somebody wants a specific item then MiniMRP will direct him precisely to Y-424 and he can go straight to it. Telling somebody that the item "IS IN ONE OF THOSE YELLOW BINS OVER THERE" isn't much use.

So even if we do implement multi-column sorting then I'd still suggest you get those bins in a sensible order and number them.

By: GuestPosted on: Apr 9 2018 at 02:50:50 AM
I've reorganised my parts lists for assemblies so they are saved in location then part number order using the 'edit parts list tab'. This way I do not have to sort BOMs before producing works orders every time.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Sorting within BOMs

Enter the numbers.

Your name here is optional