Home Button  Buy Button 

Topic:   Mass update to default vendor (for multiple parts)

By: GuestPosted on: Jul 24 2020 at 09:10:53 PM
My goal is to have my BOM roll up to a cost, but the cost component prices did not update because the vendor is not the default vendor on the BOM with the price. Is there a way to take multiple parts and choose the default vendor all at the same time?

By: GuestPosted on: Jul 25 2020 at 08:42:40 AM
The BOM does show a cost but, as you've noticed, it uses the "Default Vendor's" price to calculate the costs of components.

If the components have something in common such as category or partial part number so there was some way to filter the components you want to change you could then export that as a CSV. Then, in excel, add a column for the vendor ID and vendor name. Then import that CSV back into MiniMRP. MiniMRP should switch the default vendor to the one shown in the CSV.

Before doing that though make a backup in case you do something wrong. Couple of things you could do wrong
1. If your items have revision numbers and you forgot to include that in the import it could create new items (because the revision didn't match what already exists so it assumes it's a different item/revision.
2. The imported vendorID did not exactly match the one already in the database then it would assume it's a different vendor and cerate a new vendor record.

So. Make a backup then you can have as many runs at is as you want

By: GuestPosted on: Jul 25 2020 at 02:08:14 PM
Is there any way to update multiple parts at the same time to indicated them as the default vendor?

By: GuestPosted on: Jul 25 2020 at 04:15:34 PM
Sorry, I don't understand. BTW, I am a very new user. Is there a way for every single part in the system to make the default vendor one that has a price attached to it. I have multiple vendors on one part, but only one vendor has a price and the other is zero. For example, the system attaches the default vendor with zero price. I need the system to take the vendor with a price attached to it. The only way I see to do this is to update each part individually. I have way too many parts to do that one at a time. For the BOM cost to roll up I need to do this.
Is there an another work around?

By: GuestPosted on: Jul 25 2020 at 04:17:50 PM
THANKS and please disregard the above post. I see the possible answer now and will try that!

By: MaryPosted on: Jul 26 2020 at 11:26:14 AM
I tried to apply what you suggested. I can identify a list of parts that need the default vendor changed. For these parts, there is an existing supplier already identified. You suggest adding a vendor name and vendor id. Aren't vendor and supplier one in the same? I also note when a part has more than one vendor their is an identifier in an unmarked field of "MFR", does this indicator do anything? Thanks.

By: MaryPosted on: Jul 26 2020 at 02:45:56 PM
Sorry, this does not answer my question.

There is an existing supplier and supplier id field, so when I export the CSV they are obviously there. There is not a field for vendor or vendor ID. Are supplier and vendor the same thing? Also, I did add 2 columns and try to add vendor and vendor ID, all it did was add a 3rd vendor to the component. My goal is to make the proper vendor the default vendor so that the BOM cost rolls up correctly. I have do have a component list for upload that is specific to my BOM that needs cost. Thanks.

By: GuestPosted on: Jul 27 2020 at 02:50:34 AM
You said it adds it as a 3rd vendor.

If the vendor ID being imported is different to one that already exists in the database then it assumes it's a different vendor so adds it as a new vendor.

But it should have made that new vendor into the default.

What version of the software do you have? 5.0.?? (What's those last 2 numbers of the verson)

By: GuestPosted on: Jul 27 2020 at 02:53:30 AM
Terminology. Supplier and Vendor are the same thing.

MFR. This is the Manufacturer of the part. Manufacturer is also a supplier.

By: SupportPosted on: Jul 27 2020 at 04:10:23 AM
@Mary. If it was something simple - something you can describe - then I may be able to do it for you.

For example. All parts in Assembly_A from Vedor_X then Vendor_X should be the default vendor.

Or saying that all Parts in the whole database that are available from Vendor_X then Vendor_X should be the default vendor.

If you can describe what you want then please contact us by email.

By: MaryPosted on: Jul 27 2020 at 09:52:52 AM
Thanks for you support. I have emailed you directly.

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:- Mass update to default vendor (for multiple parts)

Enter the numbers.

Your name here is optional