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?
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.
If you see these results:
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.
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.