0. Create an inventory period through the lifecycle operation. (Insert a lifecycle record to the lifecycle table)
1. input the basic inventory data through the warehouse receiving and picking operation (the same table is identified by billtype ).
2. Two tables are involved in warehouse receiving and picking. Two triggers are used to automatically modify the temporary inventory table from the table insertion and deletion. If the table is being inserted, the data is added to the warehouse receiving table, add the ending inventory and insert the warehouse picking order to add the warehouse picking data for the temporary table, and reduce the ending inventory.
3. Inventory check operation: the temporary inventory table has two spare fields. The inventory check operation is to fill in the current inventory to one of the fields called CheckInventory.
4. check and confirm the operation: puts the end value of the temporary table into another blank field EndtheoryAmount in the temporary table, and then fills in the value of the CheckInventory field into the end value of the temporary table.
5. Inventory settlement: An Inventory settlement table contains all the fields in the inventory temporary table and adds fields such as the lifecycle, inventory Settlement refers to the process of getting the current inventory period number, and then connecting the inventory temporary table to insert it into the inventory settlement table.
Note that all operations in many warehouses must have strict warehouse filter conditions.