cancel
Showing results for 
Search instead for 
Did you mean: 
arcticnathan09
Level 2

Fixed assets report missing serial numbers

I have compiled all the data for the company fixed asset report. We put over 100 items in the listing, complete with serial numbers (and VINs). The serial numbers were all input in the QB generated Serial Number box and are visible when opening individual items; however, if you run a fixed asset list report and include the serial number column NO DATA shows up. Those fields show completely blank, unless you open the item, then the data is there. This makes it basically worthless for using when we go to the county assessor or try to pay registration taxes for the vehicles or other serialized items.

 

How do we get the data in the system to actually show up in a system generated report?

3 Comments 3
katherinejoyceO
QuickBooks Team

Fixed assets report missing serial numbers

Hello there, @arcticnathan09

 

I'm here to guide you with the reports in QuickBooks. 

 

When you run the Fixed assets report, you'll need to click the transactions manually to see the Serial Number. It's because custom fields are created on the item. Items don't show in the report unless you open the transaction and see the details.

 

If that doesn't work, you'll want to run the Verify Rebuild tool to help you resolve Potential Data Issues in QuickBooks Desktop. 

 

Here's how: 

 

  1. Go to the File menu.
  2. Choose Utilities.
  3. Click Verify Data.

 

If you see these results:

  • QuickBooks detected no problems with your data, no further action is needed.
  • When there's a specific error message, you can search it in our QuickBooks Desktop support site for specific instructions.
  • Your data has lost integrity, it indicates that there's data damage, we can follow the steps below to correct the problem:
  1. Choose the File menu.
  2. Select Utilities and then choose Rebuild Data.
  3. You'll receive a notification to backup your company file, and then click OK.
  4.  Once done, the Rebuild Data utility will start.
  5. When you get the message, Rebuild has completed, Click OK

 

For future reference, take a look at these articles about managing reports in QuickBooks Desktop:

 

 

Get back to me if you have additional questions. I'll be here to guide you more. 

 

arcticnathan09
Level 2

Fixed assets report missing serial numbers

Ah yes, another useless report from Quickbooks. This is NOT a custom field, it's a field that is embedded in the individual item, not a field we created. What's the point of having that field if it can't be populated on a report? Opening the individual item is a very impractical solution when dealing with a fixed asset report of any size. We have 30 vehicles to report to the county and want to show the listing with all necessary details ON THE SAME REPORT. Crazy I know! It's also very frustrating to locate a serial number for electronics as well.

arcticnathan09
Level 2

Fixed assets report missing serial numbers

Also, if this was a custom field the report would actually work, since it would show up when the column was selected!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us