1. According to the steps in the above two figures, please set the security to low first, then close EXCEL and reopen it to take effect.
2.excel invoicing table is divided into four warehousing and warehousing inventory systems.
The first step is to fill in your product number and name. The last three cumulative receipt, issue and inventory are automatically calculated by the formula. Every time it is filled in, it must be saved before the form starts to calculate the inventory. If you don't save, you can view the inventory, and the inventory has not changed.
4. After the first step is completed, you can select the commodity number and warehousing method in warehousing, and fill in the number, warehousing date and quantity/warehousing method.