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,

8 Comments 8
KlentB
Moderator

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! 

hryoung95
Level 1

Serial Numbers in Inventory Reports

I just wanted to add to this conversation that this report is vital in accomplishing year end inventory counting and yet this report is so unnecessarily difficult.  Even when exporting to excel it is made extremely difficult bc of how qb reports print out of excel.  We have many serial numbers and each one has to be accounted for during inventory and it is impossible to create an efficient report.  It's very disappointing that something like this causes so much frustration for your users.  Our report is 8 pages long for one of our sites and we have to print the 8 pages then match up page one with page 4 and page 2 with page 5 and so on and pray that you can figure it out. It's literally a disaster and makes counting inventory on serialized equipment take so much longer than it should.

ssmotorsports
Level 1

Serial Numbers in Inventory Reports

hryoung95, Were you able to finally figure this out, or find a program that would work the way you needed it to?

I am currently in need of such.

 

Mitzy Tompkins
Level 1

Serial Numbers in Inventory Reports

Yes, You need to pay for the Excel app in Right Networks. Once you have Excel connected to QuickBooks you can download reports with all serial numbers. 

Need to get in touch?

Contact us