You are viewing an old version of this page. View the current version.
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
If you try to record a transaction that would result in a negative inventory balance (physical quantity or dollar value), you will receive a negative inventory balance alert like these:
To overcome this alert, you'll need to do an inventory adjustment for the items appearing in the negative.
- 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 Advanced.
- At the Items field, select the items you want included in the report.
- Select the option Include Zero Quantities.
- Click Run Report.
Compare the quantity and value of the item from the Items List [Summary] report, with those of the transaction. You will see that the quantity and/or value of the item on the transaction will exceed that of the report. Or, the quantity will be the same, but the dollar value will be greater or less.
For instance, Clearwater Pty Ltd want to return some chipped glasses to their supplier. 50 glasses need to be returned at a cost of $0.25 (tax exclusive). When they try to record the purchase debit note (a negative purchase), a negative inventory alert is given.
Note: Item cost is always tax exclusive.
The example below shows the Items List [Summary] report filtered for the glasses.
Comparing the purchase debit note (shown below) with the Items List [Summary] report, you can see that if the debit note was recorded, the quantity of glasses would drop to negative 3, and the total value of the glasses would drop to negative $0.75. As both these values are less than zero, the software will prevent the purchase debit note from being recorded.
From the comparison, the necessary adjustments can be calculated:
- The quantity needs to be increased by 3 glasses, and
- The total value needs to be increased by $0.75
An Inventory Adjustment is used to increase the quantity/dollar value of the items. The amounts will be that of the previous task.
You will get the negative inventory balance alert because any of the following 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 bill 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.
If you still get a negative inventory alert, it could be because AccountRight uses the average cost to value inventoried items, so if purchases and sales of inventoried items are not entered in the order they actually occur, the average cost of the items will be affected.
For example, on the following dates these transactions occured:
- 1 July - 10 items purchased for $10.00 each, so the average cost of the items is $10.00.
- 2 July - 3 items sold. The average cost of the items remains unchanged at $10.00. This can be calculated by dividing the total value of the items by the quantity of items on hand; $70.00 / 7 items=$10.00.
- 3 July - 10 items purchased for $12.00 each. There are now 17 items on hand. The total value of the items is $70.00 + $120.00=$190.00. The average cost of these items is now $190.00 / 17 items=$11.18.
If the two purchases were entered before the sale, then the resultant average cost of the Widgets would be as follows:
- Enter both purchases - Average cost of items=total value ($220.00) divided by the quantity (20 items)=$11.00.
- Enter the sale - The average cost of the items will be unchanged at $11.00. Total value=$187.00 divided by quantity 17 items=$11.00.
From this example, you can see that the average cost of an item is affected by the order in which sales and purchases are recorded. In some cases, this can result in a negative inventory alert when returning items.