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 your inventory may not be less than zero (Item Number ########)".
I understand what this error means but in my case it does not make sense. Here is why...
If I simply open the inventory adjustment, and simply add a fullstop to the memo of the inventory adjustment, witout actually changing any values in the adjustment, I still receive the error.
The error applies to items that have a negative value that result in the item having 0 items on hand. There are many items on the list that become 0 due to this inventory adjustmet because we made this adjustment to fix auto build issues but this is all irrelevant. All the items on the list that become 0 stock due to this adjustment, have the correct qty values to do this, hence why the adjustment was able to be recorded in the first place.
I believe the issue is related to decimal places that exist in the database. So MYOB thinks that the adjustments are bringing quantities of items below zero, when this is not the case. The qty adjustments all equal 0 exactly, which is why it was able to record the adjustment in the first place, weeks ago.
I have called MYOB twice regarding this issue with a total time on the phone of about 5 hours. Both times, some scripts were run, and diagnostics showed no issues, yet the issue/error is still appearing. The person actually hung up on me while I was on hold after trying to fix the problem for 3 hours. I didn't have time to call back and wait another 45 minutes in the que, not knowing if they could even fix the problem after 5 hours already on the phone.
I do not know what else to do so I am posting here hoping that someone can help me fix this problem.
Let me emphasize that the error is not related to what I am changing on the inventory adjustment. If I simply open and save the adjustment it works, because it is not recognizing any actual change. If I change something in the memo so that it does see a change, then try to save it, the error appears. This is what makes no sense because if I recorded it weeks ago and it worked, why is not working now?
Thank you in advance
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