- Created by admin, last modified by BrianQ on Aug 22, 2017
If you try to record a transaction that would result in zero units on hand, you might receive the following error.
This means that while your inventory quantity will be zero, 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.
How did this happen? Even if your inventory and transactions were entered correctly, this discrepancy can still appear because of AccountEdge'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.
Run the Item List [Summary] report for the applicable items.
- Go to the Reports menu and choose Index to Reports.
- Click the Inventory tab.
- Click the Item List [Summary] report (under the Items sub-heading) then click Customise.
- At the Items field, select the items you want included in the report.
- Click the Finishing tab and select the option Include Zero Quantities.
- Click Display.
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.
The example below shows the Items List [Summary] report filtered for the 100ml glasses.
The list shows that the total value of the cooler is $2077.96. If the return was recorded, the total value of the glasses would not be $0 and would be $37.96, even though the quantity would be zero.
This comparison shows that the total value needs to be decreased by $37.96, 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. 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 -$37.96.
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.