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.&nbsp;Then when we come back in stock, we are selling units, but it now takes a zero $ Amount out of the Current Value .&nbsp; SO the current value just sits there.&nbsp;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?&nbsp;Help.&nbsp;&nbsp;

jenniek · Answer

Hi AmandaRobertsC​&nbsp;
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.

amandarobertsc · Answer

thanks jenniek​ .&nbsp; NO journal entries, in the GL account.&nbsp; &nbsp;If I adjust its will mean a massive hit to our P&amp;L which doesn't look good.&nbsp; SOme accounts are out by $45K in the negtive.&nbsp; &nbsp;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 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.

Forum Discussion

Zero Units Sold but Negative Value Being taken

3 Replies

Looking for something else?

Learn, solve, grow

Related content

$ Value units

Rectify negative inventory value

Prepare Electronic Payments holds negative values

Unit Trust Validation Error

Negative payroll value in prepare Electronic payments

Hot Tip: Using Units Like a Pro

AccountRight Negative Inventory Value

Negative value on employee's Summary of Payments report