How to avoid "Send outgoing Stock" button in the Inventory Management causing the Product Qty <0?

Ragic provides the Free Inventory Management module which allows you to record the quantity of different products stored in each warehouse and effectively manage the process of warehousing, incoming stock, outgoing stock, and product transfers.

In the "Outgoing Stock" sheet, there is a "Send Outgoing Stock" button (you can refer to this article to know how to create this action button). Clicking this button will deduct the corresponding quantity from the inventory of the related product in the warehouse. However, there may be a situation where the product’s quantity is not sufficient for the deduction. To avoid this situation, you can follow these steps:

1. Enter the design mode of the "Location Balance", find the "Qty" field, and set the Validation of the field to ^\d+$, which means only non-negative integers is allowed. You can customize the return message below. If you don't know how to use regular expressions, you can also use the method written in this article: What if I can’t write regular expression?

2. Enter the design mode of the "Outgoing Stock" sheet, click on Form Tools > Custom Button > Update Value on Another Sheet > Send Outgoing Stock, and enter the settings of this action button.

3. Enter the advanced settings of this action button to check the option: Check fields "Validation" setting on target sheet. Remember to click "Create 'Update value on another sheet' button" below and save the form design as well.

After completing the settings, when you click the "Send Outgoing Stock" button in the "Outgoing Stock" sheet, if the product quantity in the warehouse is insufficient, the error message set in step 1 will pop up and the action button cannot be executed.