Making inventory adjustments

From time to time you may need to adjust item quantities and values. For example, if your inventory gets damaged, you may have to write off some of your inventory or revalue it.

This section explains how to make a one-off adjustment to a single item or a few items. If you need to update the quantities of several items, see ‘Counting inventory’.

For examples of common inventory adjustments, see below.

note : Print the Items List Summary report

When making inventory adjustments, you may find it useful to print the Items List Summary report. This report displays on-hand quantities and values of items in your software.

To make an inventory adjustment

1	Go to the Inventory command center and click Adjust Inventory. The Adjust Inventory window appears.

2	Enter details of the adjustment.



A	Select the item number for the item you want to adjust. To do this, click in the Item Number column, press tab, and then select the item from the list that appears.
B	If you hold inventory at multiple locations, select the location where the item is stored. This field only appears if you have more than one location. For more information, see ‘Inventory locations’.
C	Type the quantity by which you want to increase or decrease the quantity held. Only type the quantity variation. Type the quantity in inventory units, not buying or selling units. If you enter a positive number, that number is added to your on-hand inventory. If you enter a negative number, that number is subtracted from your on-hand inventory.
D	The average cost of the item appears by default. The average cost is normally calculated as the total cost of the item divided by the number of units on hand, but if these are new items, type their purchase cost.
E	The Amount field displays the quantity multiplied by the unit cost. If you change it, the unit cost is recalculated automatically.
F	The allocation account is usually a cost of sales or expense account.

3	Click Record to save the inventory adjustment.

Examples of inventory adjustments

The following are some examples of inventory adjustments.

Example 1a

This inventory adjustment increases the number of items on hand by two and the total value of the items on hand by $700.

Example 1b

This inventory adjustment increases the number of items on hand by two but does not adjust the total value of the items. The average cost of the items will decrease as a result of this adjustment.

Example 2

This inventory adjustment increases the total value of the items on hand by $120 but does not change the number of items on hand. The average cost of the items will increase as a result of this adjustment.