Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
Mitzy Tompkins
February 17, 2021
Question

Serial Numbers in Inventory Reports

  • February 17, 2021
  • 1 reply
  • 4 views

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,

1 reply

K
Klent
Level 8
February 17, 2021

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.

M
Mitzy TompkinsAuthor
February 17, 2021

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
MariaSoledadGQuickBooks Team
QuickBooks Team
February 17, 2021

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement