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 nowHi 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!
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:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here