Forum Discussion

KarlZimmermann's avatar
KarlZimmermann
Member
6 years ago
Solved

Deleting inventory showing stock on hand

I have some inventory items showing stock on hand that was set up by a previous employee, these items we have never had and I have no idea how he entered the stock quantity. I need to delete this ite...
Inventory
  • Neil_M's avatar
    Neil_M
    6 years ago

    HI KarlZimmermann 

     

    As its not possible to import in a stock count directly this is not how he would have done it. As I can only make an educated guess as to how he would have done it, in one form or another there would be a transaction somewhere along the line that added that inventory to the file.

     

    As there would be a transaction that impacted these items, you can only mark them as inactive not delete them as outlined previously.

Neil_M's avatar
Neil_M
Former Staff
6 years ago

HI KarlZimmermann 

 

As there is stock on hand it’s likely that at some point there was a transaction against that item, even if it was in a prior year, which would prevent the item from being deleted.

 

Instead you would have to record an inventory adjustment first to reduce the inventory item’s quantity and value to zero. You can then mark the item as inactive, which will stop it from being selected in future transactions.

 

You may also want to add “ZZZ” before the item name and number to group all the inactive items together at the bottom of any reports and lists

  • KarlZimmermann's avatar
    KarlZimmermann
    Member
    6 years ago

    Thanks Neil, 

     

    I actually don't know how he made this adjustment, somehow he went in a made all the stock counts 100, it was not through adjust inventory or via a purchase order so it is a real mystery. 

     

    I do know it would not have taken long or been time consuming because he was very lazy and took all shortcuts possible. 

     

    I thought maybe he exported everything out of MYOB into Excel, adjusted the stock count and then imported them all back into MYOB if this is a possibility.  

    • Neil_M's avatar
      Neil_M
      Former Staff
      6 years ago

      HI KarlZimmermann 

       

      As its not possible to import in a stock count directly this is not how he would have done it. As I can only make an educated guess as to how he would have done it, in one form or another there would be a transaction somewhere along the line that added that inventory to the file.

       

      As there would be a transaction that impacted these items, you can only mark them as inactive not delete them as outlined previously.

      • KarlZimmermann's avatar
        KarlZimmermann
        Member
        6 years ago

        Thanks Neil, I will work on this and just wonder how he did it. 

         

        Appreciate yuo getting back to me. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content