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

Report showing all serial numbers for an item

Good afternoon

We are using Quick books enterprise... we are gearing up to do year end inventory... I cannot seem to get a report to print all the serial numbers for a product.  In some cases we have many serial numbers.  I need to be able to verify each unique serial number a total count is not good enough.  Hopefully someone has a solution for this.  Thank you

6 Comments 6
Trish_T
QuickBooks Team

Report showing all serial numbers for an item

Hi LMC6,

 

Welcome to Community!  QuickBooks Desktop is a powerful program for completing your tasks with peace of mind.  I'll be happy to provide some insight here so you can get back to what you love!

 

If you have Advanced Inventory and have serial numbers turned on, you'll see the column on your report for which you can also expand it for better viewing.  Go to Reports > Inventory Detail report, or your preferred report.

 

Please reach back out if you have any other questions.  We're glad to help!

 

 

LMC6
Level 1

Report showing all serial numbers for an item

Thanks I did try that but I cannot stretch the screen far enough... I have one product that has 81 serial numbers alone.  Any other suggestions?

 

Trish_T
QuickBooks Team

Report showing all serial numbers for an item

Hi LMC6,

 

Thanks for reaching back out!  When you customize your report, removing columns that aren't required for the report will allow you to expand other columns.  Another option would be to export the report as an excel workbook.  

 

Be sure to let us know if this helps. Your success is our goal!

 

 

LMC6
Level 1

Report showing all serial numbers for an item

Good morning

 

This solution also did not work.....  Is there a way I can somehow wrap the field in Quick books instead of expanding it... as I cannot expand far enough to include all serial numbers.  As mentioned I can have 100's of serial numbers for a particular product.  

Nick K
QuickBooks Team

Report showing all serial numbers for an item

Hi LMC6

 

At this point if you have 100's of serial numbers that you wish to see I recommend exporting your report to excel. This is so you can have all the information you need at a glance and showing in the proper sections. In order to export your reports into excel you can follow the steps in this article.

 

If you have any questions let us know and we'd be happy to help.

LMC6
Level 1

Report showing all serial numbers for an item

Thanks for your reply... sadly this does not work either... in fact when I export to excel it does not even bring in all the serial numbers that I see on the screen in QB....  Is their a bug in the software somehow that causes this solution to not work... as  would agree it certainly should work....  

Need to get in touch?

Contact us