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
Hi Zappy
MYOB reports can tell you which Items have been used in the past year (in a round about way), however not those 'not used'.
Also once an item has been used, in a Purchase, Sale, Order, Quote or adjustment, MYOB is designed NOT to allow you to delete it. So your question should be 'how can I delete all items I have never used?' - and the answer is as follows:
- Open each Item one by one from the Items list
- Select Edit and then Delete and click OK
- If the Item has never been used, MYOB will allow you to delete it. If it has ever been used, MYOB will advise you cannot delete it.
The above is the only way MYOB provides for you to delete Items.
The only other way to delete Items is to have someone with specialised software do this for you. Their software will allow you to delete all Items not used since a specified date. The software maintains database integrity by going through the entire database and replacing all references to the Item being deleted with a substitute Item. So you end up with one substitute item replacing the 1000 or so being deleted. Last time I checked cost was $275 for up to 5000 items.
Regards
Gavin
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
