Forum Discussion

serkles's avatar
serkles
Contributing User
2 years ago

Unable to modify previously recorded Inventory Adjustment - Error despite no changes

I am trying to modify cost prices in an Inventory Adjustment that was made weeks ago. The problem is that when I open the inventory adjustment, I am unable to resave it due to an error "The value of ...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi serkles 

     

    Please carefully re-read all of the posts above. Everything I have written about Inventory Adjustment Journals applies equally to values as it does to the on hand count. So:

     

    "If current on hand count for an item is 0, there should not be any reason why you can't create a new inventory adjustment journal and change the on hand count to 10."

     

    can also be read as

     

    "If current value for an item is 0, there should not be any reason why you can't create a new inventory adjustment journal and change the value to 10."

     

    Regards

    Gavin

serkles's avatar
serkles
Contributing User

Hi Gavin,

 

Thank you for your response. 

 

The inventory values for the items in question are all 0. It was this inventory adjustment that made them 0 in the first place. 

 

The reason why I am thinking that there is something else going on like a bug or something, is that as I mentioned, I am not trying to change these values. I am simply opening an old inventory adjustment and saving it again. Even if I do not adjust anything, except the text in the memo, the error appears and it doesn't allow me to save it. 

All I want to do is add costing to some other items in this inventory adjustment. So basically there are a bunch of items that are becoming 0, and there are others that are being added to. I am simply trying to change the cost values of some of the ones being added to. I am not touching the ones that are becoming 0, but the error is saying these items (that are becoming 0) cannot be less than 0. They are already 0 and became 0 as a result of this inventory adjustment. 

Correct me if I am wrong here....
Let's say you have an item with 10 qty on hand. You then create an inventory adjustment, and make this item -10, and record it. Now the item is 0. If you then open this inventory adjustment and save it again, it should be able to save since when you open the adjustment, it is "techincally" adding the 10 back on when you open it, and then you save it, and it takes the 10 back off, so there should be no issue. Is this not how it works?

If that is how it works, then there is some other problem happening with my account. 

 

Thanks again

 

 

gavin12345's avatar
gavin12345
Ultimate User
2 years ago

Hi serkles 

 

Yes what you have outlined is how it is supposed to work.

 

However, MYOB's inventory module still has lots of bugs in it and this might include not correctly reversing before re-applying the adjustment. This is why I recommend using a new inventory adjustment for the specific change.

 

Another issue which could prevent correct reversal and re-application of the adjustment is if you have used  the Received Items function and have sold any of the Items since the original purchase.

 

Regards

Gavin

  • serkles's avatar
    serkles
    Contributing User
    2 years ago

    Hi Gavin, 

     

    Ok, so if I wanted to do another inventory adjustment to add costs to some products, how would this work exactly?

    If I want to simply adjust the cost of what is on hand, how can I do this for items that are already on hand, without modifying a previous inventory adjustment? 

     

    Would I remove it first, then add it again with the cost?

    -10 SKU My Product $0
    +10 SKU My Product $100 

     

    Thank you

    • gavin12345's avatar
      gavin12345
      Ultimate User
      2 years ago

      Hi serkles 

       

      An inventory adjustments is just like any other transaction. If you have 10 items and add 10 with an IAJ you will have 20. If you them do an IAJ to add 10 you will have 30. Same with value adjustments - they are cumulative, adding to or subtracting from the current value - they do no replace the current on hand amount or value. Always review the current On hand and Value from the Item Profile screen - ( however this is not always the correct amt).

       

      FYI if you have 0 on hand, the value must be also $0.

       

      Regards

      Gavin

      • serkles's avatar
        serkles
        Contributing User
        2 years ago

        Hi Gavin, 

         

        Ok, well then I still have a problem. 

         

        You see, I am trying to change the current value on hand. I have items in stock, but when I open the inventory items in question, I see $0 for Current Value and Average Cost. Here's a screenshot...



        Now please correct me if I am wrong, but isn't the only way to add value to a stock on hand, by adding it when the items go into the system via an IAJ. In fact, if I click on the arrow beside Current Value, it takes me to a list of inventory adjustments, where you can see when this stock came into the system, and that it was brought in with $0. This is the IAJ I am trying to modify to fix this.

         

        So if I can't edit the old IAJ, and I can't add value to stock on hand via a new IAJ, what option is left?

         

        Sorry if I am missing something here.

        Thanks

Looking for something else?

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

Community home

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