Positive stock on hand and negative value in inventory

Hi Richmond91,

That's a tricky one!  This That message can appear when changing inventory preferences if the item history causes the system to detect a negative on-hand quantity at a point in time, even if the current quantity now looks correct.
 

To help get this sorted, please reach out to our back-end team so they can help you fix this. You can reach them on Live Chat via our virtual assistant, MOCA or by submitting a support case via MyAccount.

Regards,
Earl

Unfortunately, the back-end team takes weeks to respond and MOCA is not much help as it never understands the question.

Hi Richmond91, 

You're right, we are currently seeing longer than usual wait times across our support channels at the moment.

As a first step, I’d suggest doing a stocktake on the affected item rather than just retrying the deletion. That means checking the item’s actual quantity on hand against what’s showing in AccountRight, then recording any adjustment needed so the stock count is brought back into line. Once that’s done, try removing the incorrect purchase/order line again.

If the error still appears after the stocktake and adjustment, then it’s likely the item’s inventory history still needs to be reviewed by support from the back end, so you would still need to connect with them to get it properly resolved. 

Regards,
Genreve

Hello Genreve,

I have done a stocktake - there is zero stock. 

System shows 3.15m in stock because of the error entry of 3.15m.  What adjustment should I make?

I still cannot delete the entry. 

I booked a call back with MYOB for 2.30 today.  It is now 3.15pm, no-one has called back. 

How do I speak to anyone at 'back-end' or how do I get them to call me?  Please do not tell me to submit a support case via 'My Account' because I have done that and they close the case before fixing the issue.

Can you please tell me how to solve it or get someone to call me?  Thanks,

No, it is not a 'tricky one' .  By viewing other enquiries, many people have the same issue but nobody is able to give us a response on this forum.  Everyone says we have to contact 'back-end'  I have submitted tickets, booked calls and nobody will call me to speak with me.

Very disappointed with MYOB in past 2 months.

Hi Richmond91​ , one option: if the purchase qty is in stock then the order has at least been received. If so, receive the incorrect line (which should be remaining on a purchase order), process both received items as bills and then enter a supplier credit for the incorrect line (using the stock value on hand). If you don't use the receive items process then you are only dealing with bills.  The net bills should match what you need to pay your supplier.

If you still can't record the credit then we'll need to know some specific cost numbers, eg value on hand, supplier unit cost.

This is the incorrect purchase order entry.  It needs to be deleted - item number is incorrect.

This is the stock and $ values on hand.

This is the error message I receive when trying to delete the entry in the PO.

I believe the issue is the $ value but I do not know how to fix it.

I have been going back and forth with ticket numbers, call backs, MOCA and no one will call me or provide a correct solution.

Your assistance would be appreciated.  It would be better if someone could call me to explain the situation.

Thanks,

Hi Richmond91​ , the error message suggests that the value in the purchase order line is greater than the on-hand value. Even a small difference would generate an error.

So one thing to try is using an inventory adjustment to increase ONLY the value on hand. So if the purchase line was actually for (10 x $3.15) $31.50, your adjustment would be for a qty of zero, and an amount of +$0.01, to bring the on-hand value to $31.50, matching the purchase order line. Then deleting the line may work.

(Date the adjustment as at the bill date and use an account code for stock adjustments in cost of sales).