Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

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?
Mitzy Tompkins
February 17, 2021
Question

Serial Numbers in Inventory Reports

  • February 17, 2021
  • 8 replies
  • 32 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,

8 replies

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.

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

ssmotorsports
February 9, 2023

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.


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.

 

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