Topic: Set quantities of many parts to Zero
|By: Scott||Posted on: Jan 16 2020 at 05:56:43 AM|
|We haven't used the inventory tracking abilities of MiniMRP yet but we are ready to start. To get going, I need to change several hundred part numbers to 0 quantity on hand. It's very time consuming to do this one part at a time. Is there a way to make this happen. Our numbers get there from receiving PO's in the past that sets a quantity of parts received. However, we generally receive the PO and the parts go directly to assembly and not to stock. We should have recognized this long ago...now we have tons of parts with bogus quantities. Please help. Scott|
|By: Guest||Posted on: Jan 16 2020 at 09:18:42 AM|
|Hey Scott. We do this at the start of every year.|
First make a backup.
Go to the menu 'All Components'. Click that. Bottom right corner is a box showing number of items in the list. Make a note of that.
Then over to the right you see the green 'excel' X button. Click that to export the list to a CSV file. Open that file with excel. Make a new column containing nothing or zeros. In Excel SaveAs CSV.
Then, back to the MiniMRP menu below the all components button is the CSV import. For import select the part number column and revision if necessary. Also that new zero column. At the bottom of the import window is a checkbox saying to upate quantities of items that exist in your inventory.
Run the import. All your item quantities will be set to zero.
This doesn't create new items if they already exist in your inventory. It just updates the details with that from the CSV file.
The reason I said to make a note of the number of items in your all components list is because it's easy to mess up if you have part numbers AND revision numbers. For example if you have revision numbers but forgot to include the revision column in the import then that could be seen as a different item and be imported again. Look at the number of items you have. Should be the same. No problem if you made a backup you can restore it and do it again.
|By: Scott||Posted on: Jan 16 2020 at 06:35:15 PM|
|That's cool, but seems like a work around and will be great for us this time, but in the future is we will not want to wipe the quantities clean, but maybe select only a group of part numbers to change the quantities of the group to zero?|
Really appreciate the help!
|By: Guest||Posted on: Jan 17 2020 at 03:41:34 AM|
|If you just wanted to zero a small workable group of components then when looking at 'All Components' you see a 'lock' over to the roght of the window. Click that to unlock. Now you can key directly into the QTY column of the grid.|
So, using filters on catagory or some other criteria on any column you can get your group and then quickly key/cursor down the list setting to zero.
Yes I suppose exporting to excel is a workaround but we do quite a lot of other work in excel and we like working in excel so exporting/importing between minimrp and excel is fine for us and really quite quick once you've done it a few times. I think such work-arounds means minimrp stays mini. In other words they don't want price and complexity of minimrp to increase just to add features that many people wouldn't want and, for those that do, work arounds exist.
|By: Scott||Posted on: Jan 17 2020 at 03:08:31 PM|
|That's really great. I missed the "Unlock" that make is work the way I wanted. Thanks for your help!|
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.