Solution:
Two steps involved if Patient invoice is NOT messed up.
VMIS Clinicians/Staff has to do manual adjustment on Inventory stock for that product by checking exact numbers from Cubex machine.
IT staff has to run the database query to remove the duplicate rows from the table inventory_audit_log . (delete from inventory_audit_log where reason_id = 27 and product_id = productId and user_id = userid)
Make sure to check the Pharmacy report in VMIS for this product.