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
