Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
GeorgeIoak
Level 3

Reply to message

@Rustler @HoneyLynn_G 

 

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.

Need to get in touch?

Contact us