The Dude
Hot Rolled
- Joined
- Oct 19, 2010
- Location
- Portland, OR
Working with a company using Quickbooks Enterprise. They are an OEM and the level of documentation in QB is way behind how they build this in the shop (i.e. lots of tribal knowledge used to get the job done). A few questions:
1. For something like wire, angle, etc. (i.e. stuff with an unit of measure = "foot"), can you set up a part number (that you give it) for the material (e.g. "16ga-stran-cw-red" = 16 ga stranded copper wire, red), give it a UOM = ft, and then have multiple different vendors and their part numbers that all relate back to the one number? For instance, you might by it in a 250 ft or a 1000 ft roll, and might have McMaster Carr and Platt as different suppliers (so you could have two vendors each with two items, 4 items total, that are all ties to "16ga-stran-cw-red". You should be able to mark a preference/default (say to Platt, for a 250' roll) and then lookup other varieties if they are out of stock.
2. You should be able to then put your part number in the BOM or assembly, correct? This would be 16ga-stran-cw-red, 50'.
3. Can you have parts and assemblies tie into BOMs? Right now, I think they could get by with model number = one giant BOM = mostly a list of parts but maybe a few assemblies.
I might want to take this deeper but wanted to start out "shallow". If you've run into some limitations with Enterprise that go further, feel free to chime in. I don't know QB that well but don't want to take these guys down a bunny trail that will dead-end in a fox hole. These guys are advanced enough that they really could use a full-fledged ERP system but it would be nice if they could get another couple years out of QB while all the data is being created (i.e. not bring on two major changes at once).
Thanks,
The Dude
1. For something like wire, angle, etc. (i.e. stuff with an unit of measure = "foot"), can you set up a part number (that you give it) for the material (e.g. "16ga-stran-cw-red" = 16 ga stranded copper wire, red), give it a UOM = ft, and then have multiple different vendors and their part numbers that all relate back to the one number? For instance, you might by it in a 250 ft or a 1000 ft roll, and might have McMaster Carr and Platt as different suppliers (so you could have two vendors each with two items, 4 items total, that are all ties to "16ga-stran-cw-red". You should be able to mark a preference/default (say to Platt, for a 250' roll) and then lookup other varieties if they are out of stock.
2. You should be able to then put your part number in the BOM or assembly, correct? This would be 16ga-stran-cw-red, 50'.
3. Can you have parts and assemblies tie into BOMs? Right now, I think they could get by with model number = one giant BOM = mostly a list of parts but maybe a few assemblies.
I might want to take this deeper but wanted to start out "shallow". If you've run into some limitations with Enterprise that go further, feel free to chime in. I don't know QB that well but don't want to take these guys down a bunny trail that will dead-end in a fox hole. These guys are advanced enough that they really could use a full-fledged ERP system but it would be nice if they could get another couple years out of QB while all the data is being created (i.e. not bring on two major changes at once).
Thanks,
The Dude