Skip to main content
January 23, 2024
Solved

Question regarding Inventory Items and quantities

  • January 23, 2024
  • 2 replies
  • 0 views

Hello Quickbooks users!

 

I am using QuickBooks Desktop for Mac.

 

QUESTION:

If I have two Inventory Part Items already set up,  Let's call them:

POSTER_SALES_RETAIL and POSTER_SALES_WHOLESALE

 

When I created the POSTER_SALES_WHOLESALE inventory item, i added the QUANTITY on hand as 30.  Which is the amount of posters I purchased to sell.

 

Since I sell them at WHOLESALE and RETAIL, I need Quickbooks to pull from the total inventory of 30 every time I make a sale wholesale or retail. 

 

Right now, since I added the QUANTITY on hand of 30 to the POSTER_SALES_WHOLESALE inventory item, I cannot get Quickbooks to pull inventory from the POSTER_SALES_RETAIL inventory item.

 

Is there a way to make this happen?  Maybe with a new Sub Parent inventory item POSTER_SALES and have this one reflect both?  What would the steps be to accomplish this?

 

So far, I have only used the POSTER_SALES_WHOLESALE inventory item for some sales I made last year, but this year I have the need to use the POSTER_SALES_RETAIL inventory item.

 

Thank you in advance for your help?

 

 

 

Best answer by GenmarieM

I am using QuickBooks Desktop 2021 for Mac.


Hello there, @billhdz.

 

I am here to share some insights about managing your inventory items and quantities in QuickBooks Desktop Mac 2021.

 

Please note that the previous post provided by my colleague was intended for the QuickBooks Desktop Mac 2024 users. I will walk you through the steps for QBDT Mac 2021.

 

  1. Go to Vendors, then Inventory Activities select Adjust Quantity/Value on Hand.
  2. Enter the name of the expense account where you track inventory loss and shortages in the Adjustment Account field. If you need to assign the expense to more than one account, enter a separate adjustment for each account. To enter additional adjustments, select Next
  3. Enter the new quantity of each inventory item. You can also enter the new quantity by entering the difference in the Qty Difference column. To enter a difference that reduces the quantity, type a minus sign before the number (for example, -25).
  4. (Optional) If you need to, edit the value of the inventory after adjusting the quantity. QuickBooks will recalculate the value based on average cost. When you edit a value, you change the average cost of the items in stock. To edit the value, select the Value Adjustment checkbox. In the New Value column, enter the value for each inventory item whose value you want to change.

 

Moreover, I'm adding this article to help you see the product cost, the product on hand, and more: Use reports to see your sales and inventory status.

 

Please don't hesitate to return to this post if you have other questions about managing your inventory in QuickBooks Desktop Mac. I'll be here to lend a hand.

2 replies

January 23, 2024

Thanks for visiting the Community today, @billhdz. I've got two options for you to handle your inventory items in your QuickBooks Desktop (QBDT) for Mac program.

 

The first option you can utilize is what you've mentioned above. You can set up a parent item for POSTER_SALES and make POSTER_SALES_WHOLESALE and POSTER_SALES_RETAIL inventory items as a subitem of POSTER_SALES. Here's how:

 

  1. Create a parent item named POSTER_SALES. If you won’t be using the parent item on invoices and sales forms, leave the rate or price of the parent item at zero. 
  2. For the subitem, add a new item or edit an existing one.
  3. Select the Subitem of check box and choose the name of the parent item. 
  4. Be sure the Type of the subitem is the same as the parent item.
  5. Click OK.

 

Another option you can use is to create a group item. 

 

  1. Choose Lists Items. Click the + menu at the bottom of the list and click New Item
  2. In the Type field of the New Item window, choose Group. 
  3. In the Group Name/Number field, enter a name or number for the group item. 
  4. In the Item column, select the items that you want to include in this group.
  5. In the Qty column, enter the quantity you want QuickBooks to enter for each individual item when you use the group item on a form. If you do not enter quantities, QuickBooks assumes that the quantity of each item is 1.

 

Please keep in mind that if you change the quantity for the entire group, QuickBooks automatically adjusts the quantities of the individual items and recalculates the amount for each item. If you change the quantity of an individual item, the quantities and amounts of the other items remain unchanged.

 

Additionally, here's an article that answers the most frequently asked questions about managing your items: Add, edit, and delete items.

 

Please don't hesitate to add details below if there is anything else I can do for you. I'll be there to help. Stay safe and enjoy your day.

billhdzAuthor
January 23, 2024

@Kevin_C 

 

Thanks for the reply! 🙂
Here is a better sample illustrating what I am trying to do in Quickbooks ( see attached image ).

 

Base on this image shown, how can QUICKBOOKS somehow use the Qty on Hand of 42 in WCT_PostersW and share it with WCT_PostersR  if I set up a PARENT ITEM ( POSTER_SALES ) and make WCT_PostersW and WCT_PostersR a subitem of POSTER_SALES?

 

Thanks again!

Nicole_N
January 24, 2024

Thanks for your follow-up, billhdz, and I appreciate you for clarifying your concern regarding inventory items and quantities in QuickBooks Desktop Mac.

 

Based on your scenario, you can enter an inventory quantity adjustment. Here's how:

 

  1. Go to Vendors, select Inventory Activities then Adjust Quantity/Value on Hand.
  2. Click Adjustment Account to choose the expense account where you track inventory loss and shortages. If you need to assign the expense to more than one account, enter a separate adjustment for each account.
  3. Select Items or Find/Select Items to select inventory item(s) to adjust.
  4. Enter the new quantity of each inventory item in New Qty or value in New Value. You can also enter the quantity or value difference in Qty Diff or Value Diff. To enter a difference that reduces the quantity or value, type a minus sign before the number (for example, -25).

 

For more information, refer to this article: Adjust your inventory quantity or value in QuickBooks Desktop for Mac.


The Community is around 24/7 if you need anything else.

MJoy_D
January 24, 2024

Thank you for getting back to us, @billhdz.

 

You can set up your adjustment account, you can adjust a product’s quantity, value, or both. 

 

To adjust your inventory: 

 

  1. Go to the Vendors menu and select Adjust Qty/Value on Hand.
  2. Enter the name of the expense account where you track inventory loss and shortages. If you need to assign the expense to more than one account, enter a separate adjustment for each account. You can enter additional adjustments by clicking Next instead of OK.
  3. Enter the new quantity of each inventory item whose quantity has changed. You can also enter the new quantity by entering the difference in the Qty Difference column. To enter a difference that reduces the quantity, be sure to type a minus sign before the number (for example, -25).
  4. If you need to, edit the value of the inventory after adjusting the quantity. Most businesses can accept QuickBooks’ recalculation of the value, which is based on average cost. When you edit a value, you change the average cost of the items in stock. To edit the value, select the Value Adjustment check box. In the New Value column, enter the value for each inventory item whose value you want to change.

 

Refer to this article for more information: Adjust your inventory quantity or value in QuickBooks Desktop

 

From here, you can run Inventory Valuation Summary report to take a look at your inventory status reports and make sure everything looks good: Customize reports in QuickBooks Desktop

 

Let me know if you need more information or help with your inventory. I'm always here to help. Have a wonderful day!

billhdzAuthor
January 25, 2024

@MJoy_D 

 

So I make the adjustments and zero out the current 42 posters from WCT_PostersW and create an Inventory Part item for the Poster_Sales ( as a PARENT ITEM ) and add the 42 posters to this parent item so that whenever I enter an invoice and quantity sold it pulls from Poster_Sales which have WCT_PostersW and WCT_PostersR in it as sub items?  Is this what @JaeAnnC  is explaining in her post?
 
Thanks