Skip to main content
D
dshaver
January 4, 2024
Solved

Inventory Report with Serial Numbers Listed

  • January 4, 2024
  • 1 reply
  • 0 views

I am trying to generate a report with item numbers and serial numbers for those items listed in row format.  When I run the "Serial Numbers in Stock" report, the serial numbers are listed as comma separated, not in a row.  Is there a way to change this?

Best answer by AnneMariee

Hello there, @dshaver.

 

Currently, the option to run the Serial Numbers in Stock report where the numbers are in a row format is unavailable. I'd recommend exporting the report as an Excel worksheet and analyzing the data from there.

 

Here's how:

 

  1. On the Reports menu, click Reports Center.
  2. Open the Serial Numbers in Stock report.
  3. On the toolbar, click Excel. 
  4. If you're looking to begin a new Excel workbook, just click on Create New Worksheet. On the other hand, if you want to merge the data from the open report into an existing workbook, opt for Update Existing Worksheet. To locate the workbook on your computer, select Browse. It's important to note that this process will overwrite the existing workbook.
  5. Select Advanced if you're looking to format the data in a specific way. This is optional.
  6. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.
     

Please note that the report must have less than 256 columns. If you see a message that says your report has too many columns, select Advanced. Select and uncheck the Space between columns checkbox, then select OK.

 

Check out this article for more info on exporting reports in QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop.

 

You might want to save your report's customization settings for future use. Here's a guide on how to do it: Create, access, and modify memorized reports.

 

Keep in touch if you have any other questions about running reports in QuickBooks. I'll be around to help out.

1 reply

A
AnneMarieeAnswer
January 4, 2024

Hello there, @dshaver.

 

Currently, the option to run the Serial Numbers in Stock report where the numbers are in a row format is unavailable. I'd recommend exporting the report as an Excel worksheet and analyzing the data from there.

 

Here's how:

 

  1. On the Reports menu, click Reports Center.
  2. Open the Serial Numbers in Stock report.
  3. On the toolbar, click Excel. 
  4. If you're looking to begin a new Excel workbook, just click on Create New Worksheet. On the other hand, if you want to merge the data from the open report into an existing workbook, opt for Update Existing Worksheet. To locate the workbook on your computer, select Browse. It's important to note that this process will overwrite the existing workbook.
  5. Select Advanced if you're looking to format the data in a specific way. This is optional.
  6. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.
     

Please note that the report must have less than 256 columns. If you see a message that says your report has too many columns, select Advanced. Select and uncheck the Space between columns checkbox, then select OK.

 

Check out this article for more info on exporting reports in QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop.

 

You might want to save your report's customization settings for future use. Here's a guide on how to do it: Create, access, and modify memorized reports.

 

Keep in touch if you have any other questions about running reports in QuickBooks. I'll be around to help out.

Terms & ConditionsAccessibility statement