Child pages
  • Error: Non-zero value

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
html
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
Managing a full inventory can sometimes be tricky. The MYOB Inventory Training Course is an excellent resource to better understand AccountRight's inventory and its features - helping you stock smarter

the value of the items you're adjusting would not return to zero.

For example, if you tried to return 7 glasses at $10.00 each for a total value of $70.00 but AccountRight shows the 7 glasses to be worth $63.64 in total, you'll see this message.

html-wrap
classcol span_3_of_5

If you try to record a transaction that would result in a non-zero inventory valuezero units on hand, you will receive a negative inventory balance might receive the following error.

Image Added

 

This means that , while your inventory quantity is will be zero, you still have a positive dollar value attached to the item.

Why would the average cost be different than the return price?

AccountRight uses the average costing method to track inventory values, which, unlike the first in first out (FIFO) method, calculates the cost of each item in your inventory by using the average cost of the whole group of items in stock.

As the price of the stock you buy changes over time, the average cost of your stock will also change. Problems can occur when your average price doesn't match the actual price of a transaction you're recording. For example, you need to return stock at the original price but it's different to the current average cost. See below for more examples.

UI Expand
titleUnderstanding average cost

AccountRight uses the average costing method of inventory, which values your individual inventory based on the average unit price. The formula for calculating an item's average cost is:

Average Cost = Total Value of the item divided by the Total Quantity of the items

For example, a purchase of 10 items for $10.00 (tax exclusive) will result in an average cost of $10.00 per item. If the following day another 10 items were purchased for $12.00 (tax exclusive), then:

  • The total quantity of the items on hand = 20 items.

  • The total value of the items = $ 220.00.

  • The average cost of the items = $11.00 ($220.00/20)

Complications can sometimes occur if differently priced items are taken out of the inventory and others are returned, while the item's average cost would remain the same.

In the example above, say after the second purchase, 10 items were sold, the 10 remaining items would retain their average cost of $11.00 ($110.00 Total Value). If the remaining 10 items were to be returned to the supplier at a price of $12.00 each ($120.00 Total Value), then the debit purchase note will result in a:

  • zero quantity, and
  • a less than zero dollar value.

Because of the less than zero value, the negative inventory error will be displayed. To correct this, an inventory adjustment will first be needed to increase the Total Value of the items. The inventory adjustment will show zero quantity, a zero unit cost and a positive $10.00 in the amount column.

UI Expand
titleTransactions that cause non-zero value errors

You will get the non-zero inventory value alert if any of these transactions have occurred:

  • An item type purchase debit note (negative purchase) which exceeds either or both the quantity/dollar value of an inventoried item.
  • Editing, reversing, or deleting a recorded item purchase which exceeds either or both the quantity/dollar value of an inventoried item.
  • Editing, reversing or deleting an item type sale credit note (negative sale). This will remove items from inventory, and as such, the credit note must not remove more quantity/dollar value than is on hand.
  • An Inventory Adjustment that attempts to adjust an item's quantity/dollar value to less than zero.
  • An Inventory Transfer which attempts to adjust an item's quantity/dollar value to less than zero.
UI Text Box
typetip
UI Text Box
typenote

How did this happen? Even if your inventory and transactions were entered correctly, this discrepancy can still appear because of AccountRight's average cost method of calculating your inventory value.

How can I fix it?

Before you can record this transaction, you need to adjust your inventory value by the amount that it's unbalanced by. Follow the steps below to find the adjustment amount and record the inventory adjustment.

UI Expand
title1. Find the out of balance transactionRun an inventory report

Run an inventory report

Run the Item List [Summary] report for the applicable items.

  1. Go to the Reports menu and choose Index to Reports.
  2. Click the Inventory tab.
  3. Click the Item List [Summary] report (under the Items sub-heading) then click Advanced.
  4. At the Items field, select the items you want included in the report.
  5. Select the option Include Zero Quantities.
  6. Click Run Report.
transactions
UI Expand
title2. Compare your inventory the report with your transaction

Compare the report with your

transaction

You'll now be able to compare the value of the items on the Items List [Summary] with those of the transaction which is generating the error. The quantity should be the same, but the dollar value will be greater or less.

Compare the value of the items from the Items List [Summary] report, with those of the transaction. You will see that the quantity will be the same (zero), but the dollar value will be greater or less.

For instance, Clearwater Pty Ltd want to return the remainder of their 100ml glasses to their supplier. 7 glasses need to be returned at their original cost of $10.00. When they try to record the return, a non-zero value alert is given.

The example below shows the Items List [Summary] report filtered for the 100ml glasses.

Image Modified

The list shows that the average cost total value of the glasses are $9is $63.0964. If the return was recorded, the total value of the glasses would drop below zero (-$6.36), even though the quantity would be 0zero.

Image Modified

This comparison shows that the total value needs to be increased by $6.36, so an inventory adjustment needs to be done.

UI Expand
title3. Make an Inventory Adjustment

Make an Inventory Adjustment

An inventory adjustment is used to increase the dollar value of the items. From the previous task, you'd increase the unit cost to $10.00.

Image Removed

Keep the quantity of the items at 0, because we don't want to add any more into the inventory. You can also ignore the unit cost because it will adjust automatically when you record the adjustment.

In the Amount column, enter the total value difference you found in the previous task. In our example, it was $6.36. If in your case you need to reduce the total value, enter the amount as a negative (minus).

Finally, you'd enter the account you want to assign the adjustment amount to. This account is usually a cost of sales or inventory adjustment account.

Image Added

UI Text Box
typetip

Learn from the experts

Managing a full inventory can sometimes be tricky. The MYOB Inventory Training Course is an excellent resource to better understand AccountRight's inventory and its features - helping you stock smarter.

Learn more about this course for Australia or New Zealand.

HTML
</span>
HTML-wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Error: Not enough items on hand to record this transaction

Inventory management in AccountRight

Inventory

Inventory reports

Customising inventory

Periodical inventory

Making inventory adjustments

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=negative+inventory&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap
classmorelinks

More »

...