Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy now
Thanks for your inputs.
So I guess what I'm looking for isn't built-in to QB and I'll have to look at 3rd party solutions. I do have multiple unit of measure enabled so there's no turning back on that now without adding much more confusion.
My goal was to be able to define a different U/M for an item and have a separate default cost saved for each U/M for that item. I may receive a quote at the beginning of the year and then throughout the year make purchases. It would be convenient if I didn't have to refer to an old PO or dig up the quote just see what the different price levels are.
I initially just created a different item name when I purchased by the case but since I build assemblies I think this will mess up the inventory levels as I must choose an item to add to the assembly. Correct me if I'm wrong but I don't think you can create an inventory part that says it's just a bunch of another parts. So if I purchase a case (which has 2,500pcs) and then a box (50pcs) QB won't combine those and say that I have 2,550 units.
I also have a related issue. I buy a 500ft spool of wire. I may then use that in an assembly but use only 4in. I have U/M set for spool-500 and then a related U/M for feet. That's all well and good. The problem I have is that if I want to use inches as my base you then HAVE to enter the cost of the base unit even though you must purchase the whole spool. You may say so what, just calculate the cost.
A spool of 500ft of wire costs $32.485
That makes the cost per foot equal to $0.0650
Then you must calculate the cost per inch (32.485/500/12) = $0.005414
The problem is that QB doesn't store that many decimal places, I think only 4 so your cost changes if you drop the last 2 decimal places. $0.0054 * 500 * 12 = $32.40 but the cost is really $32.485. Right now I just use feet as the base unit but then in your assemblies you have to enter 4/12 for how much you are going to use.
So this is another case (pun intended) where assigning costs for each U/M makes perfect sense. I do electronics assembly and many components I purchase are on reels containing 10,000 pieces. In the old QB days it wouldn't even let you use that large of a U/M. The cost of these reels are less than $10 so your per unit cost is extremely low.
I guess my bottom line is if there's going to be a version specifically for Manufacturing then it should be able to handle situations like I describe. I honestly don't think what I'm trying to is outside the box.
I apologize if I'm still missing something but from what I'm learning I don't think I can do what I want.