Specific steps are as follows:
1, in the first line enter the name of the material, the date, out of storage, storage and inventory information. As shown:
2, the balance of the use of the formula = the number of incoming + the number of incoming + ... - the number of outgoing - the number of outgoing ..., enter the formula to click on the enter button. The following material as long as the calculation has been completed by dragging down the lower left corner of the balance of the cell, that is, to generate the same formula.
Note: The general warehouse inventory form as long as the name of the material and inventory and other information written clearly, can be done at a glance, has reached the production of the form.