@seguinmachine 

Try running a Sales by Item Detail report, click 'Customize', under 'Columns', scroll down and check 'Entered/Last Modified', and click 'OK'.  See if that works for your needs.

I think you should consider an inventory system outside of QB.  For the price paid for QB, it is not capable of being the one and only solution for everything. I hope Rainflurry's input helps at the least. If you can get some meaningful data, you could also use Excel to do a lot of the work for you that QB cannot do.  I know your frustration as I have been there many times with QB, but....here we are still.

This is so close! It has the last modified date, but it combines it with every entry. If they could just pull the last modified date ONLY, it would be helpful. Customizing dates for this simply removes the transactions that have happened since, not the entire item. Doing a sales by item report for ours is showing 826 pages. We do a lot of transactions, so it's a mess. It's just SO CLOSE it's disappointing. I'm going to email myself an excel version of it and find some useful data validation or conditional formatting to try to get some answers. I'll share if I come up with anything useful.

Operations Monkey! Great! If you can't figure it out, I am sure there is a wiz kid near by that can! Excel is powerful.  Yes, keep us posted!

any updates on this?

Hi there, @flopower. I can see that gaining updates on the report that shows the last sold and the inventory that has not been retailed in the last months would greatly help your business.

Currently, this report is still unavailable in QuickBooks Desktop (QBDT), and we recognize that the information reflected here is an essential part of inventory tracking throughout the years.

With that in mind, I recommend submitting feedback to our product development team by going to the Help menu, selecting Send Feedback Online, and then Product Suggestion.

Once they see that it enhances our customers' experience in training inventory items, they can add this to our future product updates.

If you are done submitting, you can perform the workaround by running the Sales by Item Detail Report. You can customize the Columns and put a check mark on the Entered/Last Modified option to show last item sold. Check out this article for more details on how to modify it further: Customize reports in QuickBooks Desktop.

You can also look for a third-party application that can be integrated into QBDT and generate the report you want for your inventory items.

Tracking the items that are sold or unsold via a report is an important part of making sure that your business is doing well in sales. You can always return if you have additional questions about preparing an inventory report that reflects your business standing in the market.