MEDHIS Odoo Inventory Interface Workflow

MEDHIS Odoo Inventory Interface Workflow

Overview

Synchronizes medicine and medical-supply master data and stock movements between Odoo ERP and MEDHIS.

Interface Directions

flowchart LR
  Odoo[[Odoo ERP Inventory]]
  HIS[[MEDHIS Inventory / Pharmacy]]

  Odoo -- Product / Item Master --> HIS
  Odoo -- Goods Receipt --> HIS
  Odoo -- Stock Adjust --> HIS
  HIS -- Dispense / Dispense Return --> Odoo
  HIS -- Transfer / Issue / Expired / HIS Adjust --> Odoo

Steps: Odoo To MEDHIS

1. Odoo user creates/updates Product or completes Goods Receipt / Inventory Adjustment.
2. Odoo sends REST/JSON payload to HIS endpoint.
3. MEDHIS logs request.
4. MEDHIS validates Item, Store/Location, UOM, batch, expiry, and quantity.
5. MEDHIS creates or updates Item Master, Goods Receipt, Stock Ledger, or Stock Adjustment.
6. MEDHIS stores interface result and returns success/failure response.

Steps: MEDHIS To Odoo

1. HIS captures stock movement from Pharmacy/Inventory workflows.
2. End-of-day job selects daily movements such as Dispense, Dispense Return, Transfer, Issue, Expired Goods, and HIS-side Stock Adjust.
3. HIS generates outbound movement payload/log.
4. Odoo receives and validates movement against Product/Location/Lot mappings.
5. Odoo updates stock movement and accounting-relevant inventory state.
6. Errors are surfaced in ERP for mapping correction and rerun.

Movement Types

See Odoo Inventory Movement Types for sign rules, HN rules, batch/expiry behavior, and field-level movement mapping.

Important Rules

• HIS Store and Odoo Location must match for medicines and medical supplies.
• Goods Receipt quantity from Odoo to HIS must be positive.
• Stock Adjust quantity can be positive or negative.
• For medicines and medical supplies, users should perform internal movement in HIS; Odoo receives daily interface data.
• Batch/lot and expiry date should be included where available.

Modules Involved

• Inventory
• Pharmacy
• Odoo ERP
• HIS ERP Interface
• HIS ERP Interface Data Dictionary
• HIS ERP Interface Log and Error Handling