Invalid (negative) amount in Inventory Value Reconciliation report leading to error messages when recording purchase

Question

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?

gavin12345 · Answer

Hi&nbsp;sKrael&nbsp;&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;RegardsGavin

sean_dc · Answer

Hello sKrael,
&nbsp;
Thank you for posting.&nbsp;
&nbsp;
AccountRight doesn't allow you to record an inventory adjustment that results in negative inventory values. If the transaction you were recording reduced either of these amounts to below zero you would receive the error you have encountered. You will need to increase the value of the item through an inventory adjustment. This will increase the total value of the item stated in the error.An example we like to give is let’s say you currently have 5 of this item at $6, totaling $30. If the credit you’re trying to record was for 4 items at $8, totaling $32 it won’t be able to be recorded. You’d need to record an inventory adjustment to bring the value to at least $32 so you can record the credit.
&nbsp;
To do the inventory adjustment, you can follow this Help Article on Making inventory adjustments.&nbsp;
&nbsp;
&nbsp;
Please feel free to post again. I'm happy to assist further.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users in finding this information.
&nbsp;

skrael · Answer

Thank you Sean.&nbsp;The item in question has a "Quantity On Hand" of 0. Value is "N/A" and Average cost is "N/A"&nbsp;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".&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;I look forward to your further suggestions.&nbsp;

skrael · Answer

You're a legend, that sorted it thank you gavin12345&nbsp;&nbsp;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.&nbsp;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?

sean_dc · Answer

Hello @sKrael,&nbsp;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.&nbsp;Serial NumberCompany File ID (Help &gt;&gt; About MYOB AccountRight)Account Name (Company Name)Your full name and email address&nbsp;

Forum Discussion

Invalid (negative) amount in Inventory Value Reconciliation report leading to error messages when recording purchase

Looking for something else?

Related content

Negative inventory account balances

Negative Inventory Value

Inventory - Showing negative stock

Negative inventory Value

negative inventory

Inventory value negative with positive Inventory item number

Rectify negative inventory value

negative inventory balance