Wanting a report of Items with zero sales
Damon_9860422
Member Posts: 2 ✭
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?
1
Comments
-
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
0 -
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?0
-
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.
0 -
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 Linda0
-
Hi guys,
I am looking to run a similar report for non inventory items.My (non-inventory) items list is getting too long and I would like to make inactive any item/part we have not used for 2 years. Do you think your process would work for me, and if so do you have any extra info that would help?
Bec
I am using the software version of Reckon Accounts 2019.
Thanks.
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community