Question

Purchasing Product in Different Quantities

Forum|Forum|7 years ago
February 26, 2019
12 replies
36 views

In order to get some volume discounts on a part I will purchase some in a case quantity of 2500 and then some in boxes of 50.

I have setup products before using units of measure but how do you keep track of the same part so it shows a total of the combined orders?

For instance if I order 1 case of 2500 pieces and then 4 boxes of 50 I will have an inventory amount of 2700 pieces of "product x".

QuickBooks Desktop

G

GeorgeIoakAuthor

I forgot to mention that my problem comes into play when I am creating an inventory assembly. When you create the assembly you need to select items and now I have 1 item for when I purchase 2500 pieces in a carton/case and another item when I purchase 50 in a box.

HoneyLynn_G

Level 6

Hi there, @GeorgeIoak.

Thank you for providing extra details about your concern. I can help you enter and set up the items in QuickBooks Desktop.

When entering the item, you must select the correct unit of measurement and groupings. I'll show you how:

Click Lists.
Choose Item List.
Right-click on your mouse, click New.
Choose Inventory Part for the item type.
Go to the Unit of Measure section and click Add New.
Select Count and Next.
Choose Each and Next.
Select Box and Case, then click Next.
Enter 50 each = 1 box and click OK.
Enter 2500 each =1 case.
Select the appropriate unit of measure.
Click Finish.
Select the income account.
Click OK to save the item.

You can create other items with different set of measurement, GeorgeIoak. For in-depth information, please refer to this article: Use single and multiple units of measure for items.

I'm still here to help you further if you have more questions about inventory. Just leave a comment or mention my name. Wishing you all the best!

L

LeizylM

QuickBooks Team

Hello,

I am in the process of setting up Enterprise for a manufacturing company, they manufacture concrete coatings. I am trying to setup a specific price rule for customer type, for example, Contractors receive a different price from Distributors. In addition I also need to setup up bulk pricing for purchases over 50 gals for the same customer type. Keep in mind both of these customer type prices are lower than the base price of the items.

I first created a price rule for Contractor and added special prices using price overrides. I then tried to add another rule on the Contractor price rule using the item that I setup with bulk pricing, but it doesn't seem to work. Any idea please?

Thank you for posting here on the Community page, bbacchus65

I'll share some clarification on how setting different pricing for different customers will work with Quickbooks Desktop Enterprise.

This works when using price rules which allows you to create a more precise condition on when the price of an item changes when you sell it to different customers. With this, you can use the Advanced Pricing feature so QuickBooks automatically changes the prices of items on sales forms according to the rules you create.

Here's how to enable this feature:

Select Preferences from the QuickBooks Edit menu.
Click Sales & Customers from the left pane, then click the Company Preferences tab.
Select Enable Advanced Pricing from the Custom Pricing section.
Choose how you want to handle price rounding.
Click OK.

Moreover, let me also attach this link to help you manage price rules in QuickBooks: Use Advanced Pricing.

If you have anything else I can help you with regarding pricing in QBDT, please don't hesitate to post them here. I'll be glad to help.

Rustler

Level 15

@GeorgeIoak

ahhh, to get to the point of the original question

QB keeps average cost for inventory items, in premier and pro there is no other option. When you sell an inventory item the average cost of that item is posted to COGS. Regardless of whether you buy one, 50, or 2500, QB calculates a new average cost. total value / total qty = average cost.

When you enter a purchase, you enter the qty and the actual amount you paid, average cost in QBDT spreads that out across the qty in stock.

In the assembly item you specify the item and qty.
The cost block on the assembly item does nothing in terms of impacting assembly item cost when you build it.
The cost block on the item screen does nothing either if you are entering a purchase of the item as required.

IF, if you have not turned on multiple unit of measure, I do not recommend using it, see this for why
http://onsale-apparel.com/Rustler/tag/um-good-and-bad

Without multiple u/m, you enter the qty actually receive, a case of 2500 would be entered as 2500 each and not one case.

G

GeorgeIoakAuthor

@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.

Rustler

Level 15

If you set up u/m as the base unit is each, then relate 50 each to a box, and 2500 to a case - you can buy and sell by the each, the box, or the case. Assuming those u/m definitions are for the same item.

Your wire item need the base unit set to inch, that is the lowest u/m you will use, then a spool is x=number of inches, you use/sell a qty of 4 to use/sell 4 inches

True QB only carries average cost to 5 decimal places, but only posts dollars and cents - nothing you can do to change that it is a limitation of QB.

Sign up

Login with SSO

Let's get you signed in

Login with SSO