Adjusting / Updating the Product Quantity in Inventory

About the Feature

Adjusting / Updating the quantity of a products in inventory.

The following steps are explained as per Odoo 10 available on Bahmni 0.92 release.

Used By

This feature is used by Pharmacist/Hospital Admin.

How is it Used?

1. Updating the product quantity on hand at product level

  1. Click on the “Inventory” menu appearing in the navigation menu at the top of the screen.

  2. Click on the “Products” option in the left panel appearing under the “Inventory Control” section, which will be listing all the products.

  3. Search the desired product by entering the product name in the search field appearing at the top right of the screen.

  4. Click on the searched product record and view various details of the respective product.

  5. Click on the “Update Qty On Hand” button appearing at the top left side of the screen, which will open “Update Product Quantity” popup.

     

  6. Select the desired “Location”, “New Quantity on Hand” & “Lot/Serial Number”, in which you want to update the quantity, in respective fields.

  7. You can also create a new lot/serial number from here by selecting the “Create and Edit” option in the “Lot/Serial Number” field.

  8. Click on the “Apply” button to apply the given quantity update details.

2. Adjusting the quantity of products using “Inventory Adjustments”

  1. Under the “Inventory” module, go to the “Inventory Adjustments” option in the left panel from “Inventory Control” section.

  2. Click on the “Create” button appearing at the top left side of the screen.

  3. Enter the “Inventory Reference”(For example March 2020 Stock from St.John’s Hospital) and select the desired “Inventory Location”, where you want to make the adjustments, in respective fields.

  4. Now accordingly select the desired “Inventory of” option-

    1. Select “All products” option, if you want to adjust all the products in selected inventory.

    2. Select “One Product Category” option, if you want to adjust products of a particular category and then select the respective category in “Inventoried Category”.

    3. Select “One Product Only” option, if you want to adjust a particular product and then select the respective product in “Inventoried Product”.

    4. Select “Select products manually” option, if you want to adjust the products of your choice selecting them manually after starting the Inventory.

    5. Select “One Lot/Serial Manually” option, if you want to adjust the products of your choice selecting them manually after starting the Inventory.

  5. Click on the “Start Inventory” button appearing at the top left side of the screen.

  6. Verify and update the adjustment details in the “Inventory Details” grid according to the selected “Inventory of” option.

     

  7. You can also create a new batch and update the quantity for the desired item by clicking in the “Lot/Serial Number” field under the grid and choosing the “Create and Edit” option.

  8. Click on the “Validate Inventory” button to apply the adjusted inventory.

3. Inventory Adjustment in bulk using CSV file upload

  1. To adjust the inventory using file upload, first create a csv file with respective details as shown below. Refer attached file (Adjustment Upload Sample.csv) for better understanding.

     

  2. Click on the “Import” button appearing at the top left corner of the “Inventory Adjustments“ screen and load the csv file.

  3. Click on the “Validate” button and then on the “Import” button, if everything seems valid.

     

  4. Once imported, a new record will appear in the grid with given Inventory Reference & “Draft” status.

  5. Click on the respective record, which will open the details of the imported records.

  6. Click on the “Start Inventory” button appearing at the top left side of the screen, which will bring the product details grid listing all the products added in the imported sheet.

  7. After verifying the details click on the “Validate Inventory” button and the adjustment will be done successfully.