cancel
Showing results for 
Search instead for 
Did you mean: 
Hdrnbot
Level 1

Sales & invoice

I want to have an inventory item that contains multiple units and have it show the number of units on the invoice at the point of billing.

 

Example: Batteries are sold by the box. A box of batteries contains 48 batteries, if we invoice 10 boxes then the invoice should say 10 boxes 480 units. 

Solved
Best answer January 07, 2020

Best Answers
ShiellaGraceA
QuickBooks Team

Sales & invoice

Welcome to Community Hdrnbot, and thanks for joining.

 

While this option isn't available in QuickBooks, you can add the units in the description column as a workaround. Let me guide you through how.

  1. Go to Lists, then Item List.
  2. Edit the inventory assembly item, then add a description on many units are there in a box under Description on Purchase Transactions.
  3. Hit OK.
  4. In your invoice, enter the calculated number of units in 10 boxes under Description.
  5. Click Save & Close. See attached sample screenshots below.

You can check this article for more information about setting up product's bill of materials.

 

I've also added these handy articles for your reference.

Please get back to me anytime if you have other questions. I'd be around for you. Have a nice day.

 

 

 

View solution in original post

3 Comments 3
ShiellaGraceA
QuickBooks Team

Sales & invoice

Welcome to Community Hdrnbot, and thanks for joining.

 

While this option isn't available in QuickBooks, you can add the units in the description column as a workaround. Let me guide you through how.

  1. Go to Lists, then Item List.
  2. Edit the inventory assembly item, then add a description on many units are there in a box under Description on Purchase Transactions.
  3. Hit OK.
  4. In your invoice, enter the calculated number of units in 10 boxes under Description.
  5. Click Save & Close. See attached sample screenshots below.

You can check this article for more information about setting up product's bill of materials.

 

I've also added these handy articles for your reference.

Please get back to me anytime if you have other questions. I'd be around for you. Have a nice day.

 

 

 

Hdrnbot
Level 1

Sales & invoice

I accept as an alternative however, I was more looking for something automated. is there any add-on available to do this?

MaryLandT
Moderator

Sales & invoice

Let me clarify this situation, Hdrnbot.

 

You can only see the number of items in each box when you hover over the quantity on the invoice. However, this won't show up on any reports. 

 

The screenshot below highlights this.
UM.PNGUM1.PNG

 

The steps below will show the complete set up of the item:

  1. Go to the Lists menu, then select Item List.
  2. Select Inventory Part from the Type drop-down list.
  3. Enter the name of the item.
  4. Choose Add new from the Unit of Measure drop-down list.
  5. Pick Count, then click Next.
    UM2.PNG
  6. Choose Each, then click Next.
    UM3.PNG
  7. Mark the box column, enter the number of items per box in the # OF EA field, then click Next.
    UM4.PNG
  8. Select the default UM, then click Next.
    UM5.PNG
  9. Set the name of the UM, then click Finish.
    UM6.PNG
  10. Complete other fields, then click OK.

You can also refer to this article, Use single and multiple units of measure for items to learn more about the steps above. It includes a complete description of the feature and how to use it in QuickBooks Desktop.

 

Let me know if you need additional information, and I'm happy to help you out.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us