Skip to main content
iVentureTeam
Odoo Inventory & Logistics

Hospital Inventory Management Software: Odoo Lots, Expiry and Reorder

Hospital inventory management software in Odoo 19 and 20: lot and expiry tracking, FEFO, ward and branch stock, par levels, purchase approvals and limits.

Siddharth JambukiyaSiddharth JambukiyaOdoo Techno-Functional Consultant
November 22, 202613 min read0 views
Hospital Inventory Management Software: Odoo Lots, Expiry and Reorder cover

Most hospitals lose money on stock in two ways: medicines expire on a shelf, and wards run out of items the central store has plenty of. Our Odoo ERP for healthcare projects usually start with those two problems, because both are fixed with setup, not custom code.

Related service: Odoo for logistics — shipping, tracking and warehouse operations in one place.

This guide is for hospital administrators, pharmacy and store managers, and clinic owners comparing options. For the wider picture beyond stock, read why Odoo ERP suits the healthcare industry.

What should hospital inventory management software do?

Hospital inventory management software should tell you what you hold, where it is, when it expires and when to reorder it. Everything else is a refinement of those four answers.

A hospital inventory management system differs from a retail one: stock sits in dozens of small places, most items carry an expiry date, and running out can delay care. Medical supply inventory management is about control first, cost second.

RequirementWhy it matters in a hospitalOdoo feature
Lot and expiry trackingRecalls and expired stock put patients at riskLots, expiration dates, FEFO
Stock by ward and siteNurses need to know what is on their floorWarehouses and storage locations
Par level controlWards must never run out of core itemsReordering rules with min and max
Controlled purchasingSpend needs a second pair of eyesPurchase order approval
Fast, accurate issueStaff will not type batch numbersBarcode app with GS1 scanning
Audit and recall trailInspectors ask where a batch wentTraceability report, cycle counts

Can Odoo work as hospital inventory management software?

Hospital inventory in Odoo: What is standard and what needs work?

Yes, Odoo works as hospital inventory management software for stores, pharmacy stock and purchasing, but it is not a clinical system. Knowing where that line sits avoids most failed projects.

Odoo is a general ERP, not specialist healthcare inventory management software. The table shows what the standard Inventory, Purchase and Barcode apps give you and what needs more work.

AreaStandard OdooExtra work needed
Lots and expiry datesFour dates on every lotEnter the printed expiry at receipt
Expired stockWarning before the issue is confirmedQuarantine location or hard block
Ward and branch stockLocations, warehouses, resupply routesDesign of the location tree
Par levelsMin and max reordering rulesPar level review routine
Purchase approvalsOne level above a set amountMulti-step approval rules in Studio
Clinical recordsNot part of standard OdooConnect your HIS, EMR or pharmacy system

Standard Odoo has no patient-level administration record, no controlled drug register with witness sign-off, and no link to automated dispensing cabinets. Those need a custom module or an integration.

How does Odoo lot expiry tracking work for medicines and consumables?

Odoo lot expiry tracking stores four dates on every lot and uses them to drive picking, alerts and reports. It only works on products tracked by lots or serial numbers.

Odoo's expiration dates documentation lists four settings on the product form, each entered as a number of days.

DateWhat Odoo does with itHospital use
Expiration dateMarks the lot as expiredThe date printed on the pack
Best before dateShows when quality starts to dropRarely used for medicines
Removal dateDrives FEFO picking orderPull stock from wards before expiry
Alert dateRaises an activity for the responsible userReturn or use short-dated stock

By default Odoo computes the expiration date from the receipt date plus the days on the product form. For drugs and sterile items, the receiving clerk must instead enter or scan the expiry date printed on the pack.

The setup takes five steps:

  1. Turn on Lots & Serial Numbers and Expiration Dates in the Inventory settings.
  2. Set each medicine and consumable to tracking By Lots and tick Expiration Date.
  3. Enter removal and alert days per product, for example 30 and 60 days before expiry.
  4. Set a Responsible user on each product so alerts reach a named person.
  5. Assign lots to opening stock with an inventory adjustment before day one.

Use lots for medicines and consumables, and serial numbers for implants and devices. Our guide to Odoo lot and serial number traceability covers the choice in detail.

Does Odoo stop expired medicines from being issued?

No, Odoo warns before an expired lot is issued but lets the user confirm, so a hospital needs an extra control.

When a transfer contains an expired lot, Odoo shows a confirmation asking whether to proceed or to drop the expired lines. An Odoo staff member explained on the forum that the design choice was not to block users, because expired stock is still returned, donated or scrapped.

The second trap is the picking order. Odoo's default removal strategy is first in, first out. One forum user found that Odoo reserved the older lot with the later date until the strategy was changed to FEFO.

With FEFO removal, Odoo picks by removal date, so the lot closest to expiry leaves first. Set it on the product category with Force Removal Strategy, which takes priority over the location setting.

Hospitals usually add three controls on top:

  • Quarantine location: a weekly task moves lots past their removal date into a non-pickable location.
  • Alert review: the pharmacy lead clears the Expiration Alerts filter on lots every week.
  • Hard block: a small customization that refuses to validate an issue with an expired lot.

How do you set up wards, pharmacy and branches in Odoo healthcare inventory?

Model each ward, theater and store room as a location, and each hospital site or clinic branch as a warehouse. That one rule keeps the Odoo healthcare inventory structure simple.

Stock pointModel it asWhy
Central storeMain warehouse stock locationReceipts from vendors land here
Ward or theater cupboardSub-location of the main warehouseQuick internal transfers, own par levels
Pharmacy counterLocation, or its own warehouse with POSDepends on whether it sells to patients
Second hospital site or clinicSeparate warehouseOwn receipts, resupply from the main site
Quarantine and expired stockSeparate locationKeeps bad stock away from picking
Vendor-owned implantsConsignment stock with an ownerPay only for what is used

For sites, Odoo's inter-warehouse replenishment uses a Resupply From field on the receiving warehouse. A reordering rule at the clinic then creates a transfer from the main store instead of a purchase.

In Odoo 20 that Resupply From list also accepts warehouses of other companies in the same database. For clinic inventory management in Odoo with one room and one cupboard, a single warehouse with a few locations is enough.

How do par level inventory and reordering rules work in Odoo?

A par level in Odoo is a reordering rule: a minimum and a maximum quantity for one product in one location. When forecast stock drops below the minimum, Odoo orders up to the maximum.

Par level inventory is the method most wards already use on paper. Odoo's reordering rules add three useful details:

  • Trigger: Auto creates the order when the scheduler runs, once a day by default; Manual lists the need on the Replenishment screen for review.
  • Route: Buy raises a request for quotation; a resupply route raises an internal transfer from the central store.
  • Multiple: orders are rounded up to the vendor's pack size, so a box of 50 is never ordered as 37 units.

Use Auto for ward top-ups from the central store and Manual for purchases, so a buyer reviews what goes to vendors.

Odoo 20 adds a Suggest button on the Replenishment list. It recomputes minimum and maximum levels from a demand period you pick, such as the last 30 days or the same month last year. Our post on reorder rules and safety stock in Odoo explains the math.

How do purchase approvals work for hospital stock in Odoo?

Odoo holds any purchase order above a set amount until a purchase manager approves it. The setting is called Purchase Order Approval and takes one minimum amount per company.

That gives one level of approval. Hospitals that need more, such as a pharmacist for drugs and a finance head above a higher limit, add approval rules in Odoo Studio. Each step names its approvers, and a filter decides when the step applies.

Wards should raise needs through reordering rules, so nurses never create purchase orders. The full buying cycle is covered in our Odoo purchase management guide.

Can Odoo scan GS1 barcodes with lot and expiry dates?

Yes, the Odoo Barcode app reads GS1 barcodes that carry the product, lot number and expiry date in one scan. This removes the typing that makes lot tracking software fail on busy wards.

Odoo's GS1 nomenclature maps application identifier 01 to the product, 10 to the lot and 17 to the expiration date.

Odoo reads and prints GS1 barcodes but does not issue the product numbers; those come from GS1. Items without a manufacturer barcode, such as repacked tablets, need labels printed in house. See our Odoo barcode scanning guide for scanner choices.

How do cycle counts and recalls work in a hospital inventory management system?

Odoo schedules counts per location and traces any lot from vendor receipt to the ward that used it.

For counts, each location has an Inventory Frequency in days. Odoo's cycle counts documentation uses 30 days as its example; without a frequency, the default is one count a year on 31 December.

For recalls, open the lot and click Traceability. Odoo 20 shows upstream and downstream moves in one report and highlights where the stock sits now. Read more on fixing stock discrepancies with cycle counts.

What changes between Odoo 19 and Odoo 20 for hospital stock?

Odoo 20 keeps the same lot, expiry and FEFO logic as Odoo 19 and adds planning and traceability help.

Change in Odoo 20What it means for a hospital
Suggested min and max levelsPar levels proposed from real demand
Traceability report in one treeFaster recall answers
Resupply from other companiesGroup sites can share one central store
Vendor reference on receiptsMatch goods to the vendor's paperwork

All four are described in our Odoo 20 Inventory release notes.

How much does Odoo cost as medical inventory management software?

Odoo costs a per-user subscription plus a one-time implementation project. That holds for any medical inventory management software built on Odoo.

On the Odoo pricing page, the US price billed yearly is US$31.10 per user a month for Standard and US$61.00 for Custom. In India it is Rs 725 and Rs 1,350. Custom is needed for Studio approval rules and multi-company.

Our published Odoo implementation cost ranges are $3k to $9k for a small rollout in 4 to 8 weeks, and $9k to $27k for a mid-size one in 8 to 14 weeks. Try the Odoo implementation cost calculator for your own numbers.

Which healthcare organizations fit Odoo inventory best?

Odoo fits clinics, clinic chains, small and mid-size hospitals, pharmacies and labs that want stock, purchasing and accounting in one system.

OrganizationPain or cost driverOdoo approachHow iVentureTeam helps
Single clinicExpired stock, no reorder routineOne warehouse, lots, par levelsQuick setup and staff training
Clinic chainEach branch orders on its ownWarehouse per branch, central resupplyDesign routes and branch rules
HospitalWard stock invisible to storesWard locations, barcode issueMap locations, connect the HIS
PharmacyBatch sales and short-dated stockFEFO, POS, expiry alertsConfigure POS and alerts
Diagnostic labReagents with short shelf lifeLots, removal dates, cycle countsSet dates per reagent group

How iVentureTeam helps with hospital inventory management software

Planning hospital stock in Odoo? Price the rollout first

iVentureTeam configures Odoo as hospital inventory management software around your formulary, locations and approval limits. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.

  • Stock design: warehouses, ward locations, quarantine areas and removal strategies mapped before any setup.
  • Master data: products, units, lots and expiry dates imported from your current system and checked.
  • Par levels: minimum and maximum quantities set per ward with your store manager, then tuned after the first month.
  • Controls: purchase approvals, expired stock blocks and count schedules, delivered through our Odoo implementation services.
  • Integration: links to your HIS, EMR or pharmacy software so issues to patients update stock.

Hospital inventory management software case study: KMF Technologies

This case is an inventory project, not a hospital: KMF Technologies is an IT hardware distributor in The Gambia. We include it because the stock problems were the same ones hospital stores describe.

KMF tracked products by hand, with no real-time stock visibility, which led to overstocking and stock-outs. We ran a seven-phase project over 8 weeks covering Sales, Purchase, Inventory and Accounting, with warehouses, stock locations and access rights defined.

KMF now runs a purchase-to-delivery workflow with real-time stock across warehouses and fewer entry errors. The project did not involve lots or expiry dates, so treat it as proof of the stock basics only. Read the KMF Technologies Odoo inventory case study.

The bottom line on hospital inventory management software

Odoo is a sound choice for hospital inventory management software when you need lots, expiry, par levels and purchasing tied to accounting, and you accept that clinical records stay elsewhere. Check the expired stock control before you sign.

Start with one store and two wards. Turn on lots and expiry dates, set FEFO, load par levels and scan every receipt for a month. If the screen matches the shelf, extend the design to the other wards and sites.

Ready to get expiry and ward stock under control?

Request a hospital stock review

Show us your item list and location map, and we will show you the Odoo setup that fits. Request a hospital stock review with our Odoo team, call +91-90235-15208, or email business@iventureteam.com.

Frequently Asked Questions

What is hospital inventory management software?

+

It records every medicine, consumable and device a hospital holds, by batch, expiry date and location. It also triggers reorders and keeps the audit trail for recalls.

Can Odoo be used for hospital inventory management?

+

Yes, for stores, pharmacy stock and purchasing. Clinical records and patient-level dispensing need your HIS or a custom module.

Does Odoo track expiry dates by lot?

+

Yes. Each lot holds an expiration, best before, removal and alert date. For medicines, enter or scan the printed expiry at receipt.

Does Odoo block expired products from being issued?

+

Not by default. Odoo shows a warning and lets the user confirm. Hospitals add a quarantine location or a small customization that blocks the issue.

What is a par level in inventory?

+

A par level is the quantity a ward or store should always hold. In Odoo it is a reordering rule with a minimum and a maximum per product and location.

Can Odoo manage stock across several clinics or hospital sites?

+

Yes. Each site is a warehouse resupplied from a central store through a resupply route. In Odoo 20 the supplying warehouse can belong to another company.

Which Odoo plan does a hospital need?

+

Standard covers Inventory, Purchase, Barcode and Accounting. Custom adds Studio, multi-company and the external API, often needed to connect clinical systems.

Free written answer from a certified consultant

Getting stock under control in Odoo?

Tell us how stock moves through your business. We map warehouses, routes and replenishment in Odoo and show what to configure first.

Free, with no obligation. A senior consultant replies within 12 business hours.

We use cookies to improve your experience

Essential cookies make the site work, and we use analytics to improve it. Choose “Only necessary” to turn analytics off. See our cookie policy.