Not allowing change due to no items on hand non-zero value

Question

Hi,

I have purchase that has a line that was put under the wrong part number. When I go to change the line to the correct part number I am getting the error "......no items on hand and a non-zero value in inventory"

Looking at the purchase it lists the item qty 8 at $125.50 total of $1,004. When I look at the item information it is showing the current value at $1,003.99 with average cost of $125.4988

There are no other transactions against the number, just the purchase.

When I attempt to change the values of the new number to $1,004 or $1,003.99 I get the error.

Error with correct PN.png

Item Registar.png

Change to Match item information.png

Item Information MYOB.png

Original Incorrect PN.png

Genreve_S · Answer

Hi @JSCHM41,

I ran a couple of fixes to your file, as suggested. If you still have the same issue after checking, I recommend creating a support ticket from the My Account page to get support assistance.

Regards,

Genreve

Mike_James · Answer

Hi @JSCHM41 , rounding problems are fairly common in inventory, precisely because the program does allow values with more than 2 decimal places. MYOB has developed a number of scripts to resolve these issues, and it may be that one of these would help.

JSCHM41 · Answer

Thanks @Genreve_S

I don't understand why MYOB has rounded past 2 decimal points? The item only has history of being entered into MYOB at $125.50. No other transactions against it, the next time is me attempting to change the line to the correct part number.

How can I now remove this item from MYOB? If i do a inventory adjustment against the item it will not allow me to delete the number as there is now transactions against it. If i was able to change the purchase to correct line it would allow me to delete the number.