Can I run a report for inactive product, sevices and non stock items to check if there are any sales against them
Thanks for checking in with us, bluebell81.
In QuickBooks Desktop, we can run the inactive inventory items on the report like the Transaction Detail by Account. Let me show you how:
We can also display inactive data in a report if a report has rows or columns that show only zero amounts. Though this option is not available for all reports. Here's how:
Open the report you'll want to run.
In the Customize Report window, click Advanced.
Under Display Rows and Display Columns select one of these options:
Active, to display only rows and columns that showed activity during the report period. Some amounts may be zero if there were transactions that canceled each other out.
All, to display all rows and columns, regardless of whether they showed activity during the period covered by the report.
Non-zero, to display only those rows or columns that show activity during the period covered by the report and contain at least one non-zero amount.
Click OK in both the Advanced Options and Modify Report windows.
To learn more about modifying reports, check out these articles:
Feel free to visit our Reports page for more insights about setting up reports to customise, run, and share.
I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.
I appreciate your time getting back here, bluebell81.
When navigating within my test file, I have see the Inactive Inventory Items option on the search field. Here's a sample screenshot for reference:
Since you don't have the option, we can do the Verify and Rebuild to check if the issue is caused by a damaged company file. Before doing so, please make sure to update your QuickBooks Desktop the latest release.
Then, follow the instructions in this article: Verify and Rebuild Data in QuickBooks Desktop.
To learn more about modifying reports, you can check the articles provided by my colleague above.
Please let me know how it goes. I want to ensure this is resolved for you. Just leave a reply below and I'll get back to you as soon as I can. Thanks.
Thanks for your prompt reply, bluebell81.
If you're using QuickBooks Online, then I'll be glad to share the steps:
You can run the same report which is the Transaction Detail by Account and customise the report by following these steps:
You will see a (deleted) word after the inventory item name. This means that it was made inactive.
Here's a sample screenshot for a visual guide:
For more information about customising or running other reports in QuickBooks Online, you can read these articles:
I'm always around if there's anything else you need. I'll you help you out again. Stay safe!