I would like to set up a feature where the re-order quantity is automatically calculated based on the difference between the re-order level and the current stock level. This way, when the stock falls below the re-order level, the system will generate a re-order quantity that not only fulfills the stock gap but also ensures that the inventory is replenished to the desired re-order level.
Re-Order Quantity=Re-Order Level−Current Stock