Here I am going to describe you about the Inventory Adjustment in Odoo and Enhancements to get the Stock Variance Report from Odoo.
Odoo has a feature for Managing inventory like stock with products and their quantity. We can use these products for sale and other operations according to the quantity remaining in stock. Accordingly, the quantity is get update when we purchase the product to our stock or by individually updating the qty on hand.
If the company has some products in hand but it is not shown in the system then we need an inventory adjustment for physical quantity updated to the system quantity. To do this initially we set up a virtual inventory adjustment location to store the physical quantity, and then it will be moved to system quantity during validation.
Creating inventory adjustment
Go to: Inventory → Inventory Adjustment
Providing Information for adjustments
Accordingly, create a new adjustment with desired products. In fact we can choose adjustments for specific products, specific category, single product, or choose specific products only.
After providing enough information actually we can start our inventory adjustment by pressing the Start Inventory button.
After starting the inventory adjustment it will move to progress state and the physical quantity can be update in this state. Especially now the virtual stock location will be with physical quantity.
Furthermore for validating the adjustments and press the button Validate inventory.
Or if we want to cancel the adjustments then press Cancel Inventory.
Similarly, we can see the adjustments with some products having theoretical quantity and physical quantity.
In the same way here we can see the variations, if we update the theoretical quantity that is system quantity then it will move the products to real physical location and calculate the variation in products and price.
The values can be obtain in report
In the same token, will get a report with variation in the system and real quantity and its variation price.
Similarly, information about product quantity update in stock can be seen under inventory adjustment tab.
Here we can see the product with the real quantity is move to physical location from virtual location.
Visit our website to Know more about us