Wanting a report of Items with zero sales

  • 2
  • Question
  • Updated 11 months ago
  • Answered
  • (Edited)
I'm wanting to generate a report that shows items that have had no sales over x period. Even a full item list with qty sold would be sufficient if I can sort it by qty sold. This doesn't seem to come under item reports or sales reports. Can you help?
Photo of Damon

Damon

  • 90 Points 75 badge 2x thumb

Posted 11 months ago

  • 2
Photo of David Robertson

David Robertson

  • 370 Points 250 badge 2x thumb
There is no report that will give you this information.

What you have to do is merge an item report with a sales report over the last whatever period you want covered

Give me a call if you want more details - David 0413 837 865

Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,496 Points 10k badge 2x thumb
Damon - if the items you are wanting to report on are Inventory Items - try running the Inventory Status by Item report - there is a column at the end which gives you Sales/Week for the period you select - if you send this report to Excel - you could sort it or filter it for all the 0 sales/week lines?  Probably as helpful as you will get?
Photo of Damon

Damon

  • 90 Points 75 badge 2x thumb
Thanks Linda. That does give me some information but unfortunately if only a few of an items have sold, the amount per week is rounded to 0 pretty quickly the longer the period I'm searching for (a year for instance) which doesn't give me correct information.

What I've done for a solution is:
- Made suitable memorised reports for Items and Sales.
- Created linked tables in MS Access
- Made an update query to tidy up the data
- Then a compare query to pull out the sold items out of the items list leaving me with just the unsold items over the chosen period.
- Made an instructions sheet for the girls in the office to follow the simplified steps to they can get their data to advertise the stock that hasn't sold.

Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,496 Points 10k badge 2x thumb
Understand.... but well done on your work around - I do agree that a report showing Last Sale Date - which could then be filter would be great!  cheers Linda