Home Button  Buy Button 

Topic:   Quantity Assembled under item's "Used In" tab

By: BethPosted on: Aug 2 2017 at 08:11:28 PM
We have many items that go into more than one assembly. It may be an item sold on it's own or in a set with something else; or it could be a component used to build more than one item.

I spend a lot of time going back and forth between the item and the multiple assemblies the item goes into, to see how many of that item we have in house total. That way if I am short in one place and I can borrow from another I know from where. Also for ordering, answering am I really low on that item or do I just have a lot of them in assemblies and I don't really need to order any of that base part right now.

What would be hugely helpful is a column in the items "Used In" section. Next to where it says how many go into that assembly, it could say how many of those assemblies there are. Since it is already pulling information from that assembly for the quantity used, hopefully it would be a really easy add.

This would be a tremendous time saver, and I could get my boss to start using MiniMRP instead of him having me double enter everything into a spreadsheet, since he can't see all of any part in one location. No exaggeration, this would save me hours a week that I really could be using much better.

Thank you for your consideration.

By: SupportPosted on: Aug 3 2017 at 02:59:26 PM
Have I understood this correctly.

In the "Used In" section it shows you which assemblies the item is used in. You also want it to show how many of that assembly you have in your inventory.

Now this is the bit I'm not sure about - you want to know how many of the assembly you have because instead of buying more parts you might want to take the parts from some assemblies so that you can use the parts somewhere else?

Have I understood that right?

By: BethPosted on: Aug 4 2017 at 06:14:14 PM
Yes, basically. We do regular updates to our products, and we want to manage the inventory as first in first out, so that all the previous version is gone before we start moving the updated version. In order to do this I have to dwindle down the parts that are currently in house among all the assemblies they go to. This means disassembling items (which I would love an easier way to do than part by part, but that's another subject), and reassembling that part into another assembly that is moving faster.

Additionally when ordering a item we have a minimum quantity we want to have in house. That minimum quantity includes how many of that item are already in assemblies. If I can see in one screen everywhere that I have that item, then I will know if I have actually hit the minimum quantity or if the quantity assembled gets me where I need to be. It would be nice to be able to do this in one screen.

Thank you for your time!

By: BethPosted on: Aug 4 2017 at 06:23:44 PM
As I was writing that, hopefully without making things too complicated, also being able to see how many of those assemblies are already required for customer orders would be amazing, so that I am not stealing parts from assemblies that are already allocated to another order.

So under "Used In", you would see the assembly, how many are required for that assembly, how many of that assembly is already built, and how many of that assembly is needed for customer orders.

It would be a perfect snapshot of everything involving that part.

By: SupportPosted on: Aug 6 2017 at 01:24:29 PM
MiniMRP assumes that you build things and ship them to a customer or put them on the shelf waiting to be sold.

It doesn't expect you to (often) take the assembly off the shelf, break it down and re-use the components to build something else.

I guess we assume that the assembly process involves some machining, soldering, welding, manufacturing etc which means components are simply consumed and can therefore not be re-used.

Having said that MiniMRP does allow you to UnDo a WorksOrder which will, in effect, take assemblies off the shelf and return components to your inventory. But it just never occurred to us that you'd be doing it on a regular basis as if your inventory of finished assemblies is just a quick source for components.

After all that. The current version can't show what you want in a single window. The information is there. Just in different windows.

I've put this into the suggestion box as an improvement in the next version.

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:- Quantity Assembled under item's "Used In" tab

Enter the numbers.

Your name here is optional