cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Creating a Last Sold report for inventory items

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! 

Dani 

2 Comments
Moderator

Re: Creating a Last Sold report for inventory items

Hello Dani,

 

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.

 

Here's how:

  1. Go to Lists at the top menu bar.
  2. Choose Item List.
  3. Right-click the Item.
  4. Choose QuickReport.

image.png

 

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!

Level 15

Re: Creating a Last Sold report for inventory items

this third party utility might help, it is not specifically a last sold report, but there is a free trial

http://www.q2q.us/itooverview.htm

I am not affiliated

 

As stated this, (last used/sold) is one of several standard inventory reports missing in QB

Need to get in touch?

Contact us