Connect with and learn from others in the QuickBooks Community.
My goal is to create a report that will show me the items that have been sitting on my shelf for the last to years with no movement.
The report can be as simple as the date each item was last sold.
If anybody has any ideas or currently works with a report that shows this information, please let me know what you do.
Thanks a bunch!
I can share some details on running an inventory report.
We are unable to run a report for the date an item was last sold. However, I have a workaround to share. Run the QuickReport for each item to see the last transaction's date.
Check out this article for more details about customizing a report: Customize reports in QuickBooks Desktop.
That should get you on the right track. Let me know how that works for you. I'm always here to help if you have other concerns. Have a good day!
this third party utility might help, it is not specifically a last sold report, but there is a free trial
I am not affiliated
As stated this, (last used/sold) is one of several standard inventory reports missing in QB