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
- Odoo user creates/updates Product or completes Goods Receipt / Inventory Adjustment.
- Odoo sends REST/JSON payload to HIS endpoint.
- MEDHIS logs request.
- MEDHIS validates Item, Store/Location, UOM, batch, expiry, and quantity.
- MEDHIS creates or updates Item Master, Goods Receipt, Stock Ledger, or Stock Adjustment.
- MEDHIS stores interface result and returns success/failure response.
Steps: MEDHIS To Odoo
- HIS captures stock movement from Pharmacy/Inventory workflows.
- End-of-day job selects daily movements such as Dispense, Dispense Return, Transfer, Issue, Expired Goods, and HIS-side Stock Adjust.
- HIS generates outbound movement payload/log.
- Odoo receives and validates movement against Product/Location/Lot mappings.
- Odoo updates stock movement and accounting-relevant inventory state.
- 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.
| Movement | Meaning |
|---|
| Z01 | OPD sale |
| Z02 | OPD sale return |
| Z03 | IPD sale |
| Z04 | IPD sale return |
| 311 | Cross-store transfer |
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