Thank you Sean.
The item in question has a "Quantity On Hand" of 0. Value is "N/A" and Average cost is "N/A"
If I try and convert a Purchase Order containing this item from "Order" to "Bill", I get the error "Processing this purchase would leave the item FCEASY120 with a positive on handh quantity and a negative value in inventory".
If I try to do an inventory adjustment to change the value of this item, I get the error "The value of your inventory may not be less than zero" and I cannot proceed further.
If I run an inventory Value Reconciliation (suggested in a previous post from someone else) I find that for some reason, this item with 0 quantity has a negative inventory value.
I don't know why it has a negative inventory value and I cannot make any changes to this item without MYOB throwing up some sort of error as described above.
I look forward to your further suggestions.
Hi sKrael
Due to bugs in MYOB sometimes you end up with zero on hand, however a negative or positive value for that zero on hand. This is why some amounts show as N/A, as you cannot divide a value by zero.
This does indicate a form of corruption in the file and sometimes MYOB staff offer to run a script to fix it. Not your moderator though.
Try doing an inventory adjustment to change the on hand count to 1 (or higher) and the value a larger number than the negative on hand value. So for example if the negative value is -$50, set the IAJ to On Hand 1 and Value adjust by say $52. This will set the onhand count to 1 and the value to $2. Once you get to this point you can make correcting adjustments as required.
Regards
Gavin
You're a legend, that sorted it thank you gavin12345
I did a +1 inventory adjustment for just over the negative value (by 23c), then a -1 adjustment to correct the quantity and value of -23c to get rid of the N/A and the inventory item is now back to zero.
Will I need to tell my accountant, or are there any other adjustments I should make so ensure the accounts are in order relative to these adjustments?
Hi sKrael,
I'm glad to know that you were able to resolve it. Thank you for the advise gavin12345. This will be helpful for other users experiencing this.
Please feel free to reach out to us again if you require further assistance.
Hello @sKrael,
I appreciate the screenshots you sent me. These are helpful to know more about the issue happening on your end. Can you please send me the following details below through private message so I can investigate further? Thank you for your patience on this matter.
