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.
rosieposie123
Level 2

Quickbooks Enterprise Inventory

Hi there!

 

How do add different prices for different amount of items in QB inventory... Let's say if I order 1000 screws at 5 cents each, 500 screws will cost me 15 cents each... can someone help me out?

 

thanks!

2 Comments 2
MarkAngeloG
QuickBooks Team

Quickbooks Enterprise Inventory

Hi there, Rosie.

 

I'm here to guide you on how to set different prices for different quantities of items in your inventory. We can achieve this by using the Advanced Pricing feature in QuickBooks Enterprise.

 

You can refer to this article for more details about the steps in achieving this: Set up and use Advanced Pricing.

 

First, you'll need to enable Advanced Pricing, here's how:

 

  1. Go to Edit, then select Preferences.
  2. Go to Sales & Customers, and select the Company Preferences tab.
  3. In Custom Pricing, click the Enable Advanced Pricing checkbox.
  4. Select Set rounding on each price rule, then click OK.

 

You can proceed with Step 2, creating price rules with conditions based on your items. After that, proceed with creating a Qty Discount (quantity discount). This is the most important step to achieve your goal of setting prices for different quantities of inventory items.

 

Additionally, you can also learn how to set up Advanced Inventory in QuickBooks Desktop. This feature allows you to track inventory stored at different locations.

 

If you have additional queries about setting different prices for different quantities of your inventory items, please don't hesitate to reply below. We're always here to assist you.

Rainflurry
Level 15

Quickbooks Enterprise Inventory

@rosieposie123 

 

If you're referring to the purchase of inventory for resale, you just need to receive the items on a bill at their cost.  So, in your example, if you order 1,000 @ $0.05 and then 500 @ $0.15, enter a separate bill for each order at cost.  You can use a separate line item on the same bill but that would be odd.  That will put 1,500 into inventory at a total cost of $125.00.  This isn't a great example because it would be unusual to order the same item in two different quantities/cost before selling any but you get the point.  Then, when you sell the screws, QBE will expense them to COGS based on whether you use FIFO or average cost.  If you use FIFO, QB will sell the first 1,000 @ $0.05 and the next 500 @ $0.15.  If you use average cost, QB will sell all 1,500 @ $0.083, assuming you don't add any more screws to inventory before you sell all 1,500.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us