Report on OLD Stock
Options
[Deleted User]
Posts: 0 ✭
How would I build a report so that I can see all the old stock. I need to cull some
0
Comments
-
Do you have your stock as Inventory or Non-Inventory?0
-
Inventory
0 -
It is not going to be easy but you can run an inventory valuation detail report for a certain period of time, eg, 1 year, and scan the list looking for items that have not sold in the past few months.
If I was doing this job, I would run a stock take list, then run a Sales Item Summary and mark off the stock take list with items sold recently. I would then mark all other items on the stock take list to be sold off.
0 -
Thank you. I will give them both a try. Not easy either way.
0 -
Yes, it is a task of deduction anyway you do it.
An item movement report, similar to an ageing summary would be most helpful.
0 -
I would be inclined to export two spreadsheets and then use the VLOOKUP function in Excel to lookup the sales for each item on the inventory list. You could run 1 month, 3 month and 6 month sales reports. Dump each of these and then in your inventory report have a column for each one and use the VLOOKUP to lookup the from the sales spreadsheets.
Then you can easily see at a glance;- what your stock level is
- what your sales have been for 1 month, 3 months or 6 months (you could even average these if you want)
You can manipulate the info much more easily in Excel and it doesn't take that long to set it up.
0 -
Thank you Shayne. That sounds fantastic. Always good to hear new ways to do things.
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 2.9K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community