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:
- On the Reports menu, click Reports Center.
- Open the Serial Numbers in Stock report.
- On the toolbar, click Excel.
- 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.
- Select Advanced if you're looking to format the data in a specific way. This is optional.
- 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.
