Last sale date
Good evening everyone I want to delete all the items which have not been sold within a year What's the best way to do this? Kr +61407744914
Forum Discussion
Gavin thats great
So how do I find which items have not been sold in the past 12 months?
I feel like ive looked everywhere
Certainly accept what you say about deleting stock items. Poor phrasing. I should have said render inactive
Appreciate your response, especially on a weekend
Have an amazing Sunday
Kr
Hi Zappy
Like I said, MYOB only provides limited options here. For example you could generate a Sales Item Summary report for the past 12 months.
Export to excel and manipulate until you get just the used Item numbers in a column, for example if using the clearwater sample file, your column will look something like:
100
110
120
200
Next export all of your Items so you have a list of all item numbers in a column, eg
100
105
110
115
120
Then use vlookup in excel to look up each the the Item numbers in the complete list that are found in the 'sales' list. Excel will find 100 but not 105. You can safely assume that all those excel could not find have not been used (in a Sale). Use this info to make Inactive, either manually or by importing.
Cumbersome - however I am yet to find a better way - perhaps another user can suggest a better method - this is how I used to do it in the past - now I just send the file to FGH Tables.
What I found the hard way was the above only includes Sales invoices, it may not include Sales Orders or Sales Quotes. Then you need to do the same thing for Purchases. And then for inventory adjustments (to cover all bases).
Regards
Gavin
Appreciate your help Gavin
Ill give it a go and Ill let you know how i fare
Kr
