Zero Units Sold but Negative Value Being taken

Question

ANyone help me with this?

We have zero Stock on hand, so we have been out of stocking it on Invoices.

But it keeps taking a negative $ value out of the Inventory Current Value.

Then when we come back in stock, we are selling units, but it now takes a zero $ Amount out of the Current Value .  SO the current value just sits there.

Would this explain why when I do an inventory valuation report, we have massive differences between our Actual average inventory value, and the general ledger account the inventory sits in?

Help.

Negative Value Being Taken with Zero Units Sold.png

jenniek · Answer

Hi AmandaRobertsC

The scripts I have had run - tend to be around the rounding issues - where a value ends up with 4 to 5 decimal places. A script brings it back to 2 where it can then be seen It wouldn't be those sort of numbers you mention. Definitely sounds like it needs investigating.

RobertsEC · Answer

thanks @jenniek .  NO journal entries, in the GL account.   If I adjust its will mean a massive hit to our P&L which doesn't look good.  SOme accounts are out by $45K in the negtive.   I can get the script run but would really like to understand why it is doing it, because it means we basically can't trust our profit figures if we have to keep manually adjusting.

jenniek · Answer

Hi @RobertsEC

Are you using AccounRight or browser version? Have you checked the avg cost in the actual item itself? If it says N/A - then you will need to get MYOB to run a script over your file to fix it.

I would look at an inventory value reconciliation report to see whether it balanced to the General Ledger - if not - look in the GL account to see if there are journal entries in there that affect the balance - correct the two should match.