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.

You'll now be able to compare the value of the items on the Items List [Summary] with those of the transaction. 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.

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.

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

An inventory adjustment is used to increase the dollar value of the items. Keep the quantity of the items at 0, because we don't want to add any more into the inventory. Next, you'd increase the amount by the 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 .

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.

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.