Invalid (negative) amount in Inventory Value Reconciliation report leading to error messages whe ...

sKrael

n recording purchase

I have had trouble receiving items due to the error "This purchase would leave you with a positive quantity but negative value" error.

 

I have discovered a negative inventory value against this item in the Inventory Value Reconciliation report, relating to a "Build Items" transaction in May 2023. As far as I can tell, this was done correctly with no "Out Of Balance" amount remaining.

 

I need to clear this error in order to proceed with booking in stock. Can anyone assist?

sKrael

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.