Since Microsoft Dynamics NAV 2013 R2 version, we have available the standard functionality that allows us to disable the negative inventory record. It can be configured to block the registration of transactions that leave inventory levels below zero. This configuration can be done either by a specific article or for all articles.
You can put a check mark in the Avoid Negative Inventory field in the Inventory Settings, as shown in the following image.
If you mark the field “Avoid negative inventory” on the inventory configuration, it will be established for all the product listings, when the field with the same name Avoid negative inventory, has the value Default (Yes). You can change this value in each product file if you consider it necessary.
Likewise, if you uncheck the field Avoid negative inventory of the inventory configuration, it will be set for all product listings, when the field with the same name Avoid negative inventory, has the value Default (No); but this value can be changed in each product file if you consider it necessary.
You can check the value in the product sheet as shown in the following image. If you want to allow a product to record a negative Inventory, set No in this field to the item.
If you have checked the field “Avoid negative inventory” on the inventory configuration and in the products, if you try to register a transaction that has an insufficient inventory, you will receive an error message, since the system will not allow registering the negative inventory.
While it is a simple feature, making sure it is configured correctly from the beginning could save you time and frustration.
If you have any questions about this feature about any version, you can contact us here.