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

Serial Numbers in Inventory Reports

Hi,

I would like some help in printing reports for an item that has multiple serial numbers. When I print the reports the serial numbers get cut off if there are too many serial numbers. How can I print a report that shows all of the serial numbers in stock by site?

 

Thanks,

5 Comments
KlentB
QuickBooks Team

Serial Numbers in Inventory Reports

Good day, Mitzy.

 

I'm here to help you print your reports.

 

To ensure that all of the serial numbers will be printed, we'll have to stretch the Serial Number column before printing the report. I'll show you how:

 

  1. Select Reports from the top menu bar.
  2. Go to Inventory.
  3. Choose Serial Numbers in Stock.
  4. Make sure to stretch the  Serial Number column until all serial numbers are shown.
  5. When you're ready, click the Print button.

Additionally, I recommend reading this article to help ensure that you'll get the most out of your QuickBooks reporting experience: Report Archives.

 

Do you have any other questions in mind? Feel comfortable dropping them in the comment section and I'll get back to you as soon I can.

Mitzy Tompkins
Level 1

Serial Numbers in Inventory Reports

Hi,

 

I have done that but some of the items have a lot of serial numbers. I can't stretch it far enough to include those serial numbers. Is there a solution for these types of situations?

Thanks,


Mitzy

MariaSoledadG
QuickBooks Team

Serial Numbers in Inventory Reports

I have another way so you can print your report with the complete serial number, Mitzy Tompkins.

 

You can try holding down the option key when you choose the Print menu. Keep holding the option key down as you click on the print buttons that come up in dialogs.  The option key clears some internal print settings. I've attached a screenshot for your visual guide:

 

However, if the serial number still cuts off, you'll want to export the report in Excel. From there, you'll be able to print the report with the complete serial number.

  1. Go to the Reports menu and find the report you want to export.
  2. Select Export.
  3. When the file opens, select File, then select Save As to save the file where you want it.

QuickBooks opens Excel workbooks with the default application you set. Here’s how to change it.

  1. Right-click on the file and select Get Info.
  2. From the Open With menu, select Microsoft Excel or Apple Numbers.
  3. Select Change All.

You can set your report preferences to change the file type that QuickBooks exports (.sylk or .xlsx). You'll also want to browse these help articles for more references.

 

Reach out to us if you need anything else about printing reports. It's our top priority to address all your concerns. Have a nice day and stay safe!

Mitzy Tompkins
Level 1

Serial Numbers in Inventory Reports

Hi,

 

This doesn't help me much. I have Quickbooks Desktop. The Desktop doesn't have Excel, therefore I cannot open the report within Quickbooks. I can download and email it to myself. I can't do much to the report within the Quickbooks desktop.

 

Thanks

Tori B
QuickBooks Team

Serial Numbers in Inventory Reports

Hey there, @Mitzy Tompkins

 

Thanks for following up with us. I appreciate all the details you've provided concerning your issue. 

 

Since the suggestions above aren't working for you, I've personally submitted a feedback request on your behalf to our product engineering team. This way, it can be considered in a future update. I've submitted a request for better options to show the serial numbers in Inventory reports when printing. 

 

You can follow all of our latest happenings and updates by using our Blog Site

 

Please let me know if there's anything else that I can do for you. I'm happy to help ya out. Feel free to reach out to the Community at any time. Take care and enjoy the rest of your day! 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us