The stock change screen is located in the Other Operations menu in Warehouse. Use this form to make a manual adjustment of material items’ stock quantities or stock values.
Inventory quantities can also be adjusted in bulk by using the Inventory data transfer spreadsheet, which is in the Other operations dashboard of the Warehouse menu. (Analysis reports extension is required).
To use the form, first select some criteria that will allow the display of a reasonable number of items. The list, of course, must include the item or items that you wish to adjust. Press Retrieve.
The current stock quantity and current FIFO cost is displayed. Enter a new quantity to one or more items and press Update. Only the items with a quantity specified will be updated.
There are a number of possibilities for controlling the cost of the adjustment. Note that the new cost of an adjustment will only apply to the transaction of the increased quantity unless the reset FIFO check box is selected.
| Quantity is adjusted up | The cost of the adjustment can be specified in the new cost column. The default is the current FIFO average cost of the current stock. |
| Quantity is adjusted down | The cost of the adjustment is according to a FIFO stock removal calculation. So the cost of the removed quantity will be the average of the oldest transactions in stock up to that quantity. |
| Reset FIFO value is selected | The cost of all stock will be reset to the value specified in the New cost column. This will result in two stock transactions, the first setting the stock quantity to zero which will zero out all the previous different value stock transactions, and the second to set the stock quantity back to the previous total at the cost specified. |
Enter the new values in one or more of the retrieved records. Press update to update all of the records that have a new quantity value.