Last sale date

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