A business can have a warehouse full of goods and still struggle to fulfil customer orders. The required product may be in another branch, reserved for someone else, awaiting inspection or recorded incorrectly. Meanwhile, purchasing may be ordering more of an item that is already sitting unsold on a shelf.

Inventory management brings these decisions together. It establishes what the business holds, where it is, what is committed, what is expected and what should happen next. The information supports customer promises, purchasing decisions, warehouse work and financial management.

For South African distributors, manufacturers and retailers, inventory management software should connect those activities in a workable process. This article explains what an inventory management system does, using Odoo examples to show how purchasing, stock, sales and accounting can work together. It also explains when Excel is sufficient, how scanning and traceability work, and what to assess when choosing software.

What Is an Inventory Management System?

An inventory management system combines records, processes and controls for managing goods and materials. The software maintains information about products, quantities, locations and movements, while employees follow agreed procedures for receiving, storing, using and dispatching stock.

Three related terms describe different levels of work:

A stock management tool within accounting software may be sufficient for straightforward buying and selling. A dedicated inventory application adds operational capabilities, while an integrated ERP connects inventory with purchasing, sales, manufacturing and finance. The exact scope of each product matters more than its category name.

Odoo provides an example of this connected approach. Inventory records stock movements, Purchase manages supplier orders, Sales manages customer orders, and Manufacturing manages production requirements. The business can begin with straightforward receipts and deliveries, then introduce additional warehouse steps where they serve a practical purpose.

Can You Use Excel for Inventory Management?

Yes. Excel can support inventory management when the product range is small, movements are infrequent and one person maintains a reliable record. A spreadsheet can record opening quantities, receipts, issues and balances, supported by physical stock counts.

The difficulty grows when several people buy, sell and move stock simultaneously. A salesperson may promise goods using yesterday’s balance while another employee dispatches them. Transfers, partial deliveries and customer returns introduce further opportunities for records to diverge from physical stock.

Consider a distributor with a Johannesburg warehouse and a shop in Pretoria. Ten units in a spreadsheet do not establish how many are in each location, which are reserved or whether two returned units are fit for resale. Adding more columns helps only if everyone consistently records every event.

The need for inventory management software becomes stronger when staff repeatedly recount goods before quoting, customers receive incorrect availability promises or purchasing cannot explain why stock is missing or excessive.

A connected system also needs disciplined recording. Its advantage is that employees can work from shared transactions and responsibilities, rather than reconstructing the position from separate spreadsheets, emails and invoices.

Connecting Purchasing, Replenishment and Receipts

Purchasing should consider stock available, customer demand, expected receipts and supplier lead times. Ordering whenever someone notices an empty shelf can create shortages; buying against an outdated balance can create excess stock.

Odoo supports replenishment rules that use forecast stock against defined minimum and maximum levels. With an appropriate purchasing route and supplier information, these can generate purchasing requirements. A buyer still needs to review quantities, supplier terms and affordability. Rules should reflect demand and lead times rather than remain unchanged indefinitely. Odoo 19.0 documentation

For a South African importer, the relevant lead time extends beyond a supplier’s dispatch date to when goods are expected to become usable stock. A locally sourced product may need a different purchasing policy from an imported item with a long replenishment cycle.

Receiving establishes what actually arrived. If a purchase order is for 100 units and the supplier delivers 80, record the 80 received and retain or cancel the outstanding quantity deliberately. Damaged goods need separate handling rather than inclusion in saleable stock.

Odoo receipts and backorders support this distinction between ordered and received quantities. Finance can then review the supplier bill against the purchase order and receipt, investigating differences instead of treating an invoice as proof that everything arrived.

Connecting Available Stock, Reservations and Sales

“We have stock” is incomplete without knowing where it is and what it is committed to. On-hand stock describes the physical quantity recorded. Unreserved stock excludes quantities allocated to other operations. Forecast stock also considers expected incoming and outgoing movements over time.

Suppose the distributor holds 20 units, with 12 reserved for confirmed customer orders. Eight remain unreserved in that location. Another 30 expected next week can support future planning, but cannot fulfil a collection today. Stock awaiting inspection must also be excluded from the locations used to fulfil sales.

Odoo supports reservation methods, including reserving available goods when an order is confirmed. The business must decide when reservations occur and who can change priorities. Recording a quotation should not be mistaken for a guarantee that goods have been allocated. Odoo saas-19.3 documentation

Picking identifies the goods to dispatch; delivery confirmation records what actually leaves. If only part of an order is supplied, the remainder needs an explicit backorder or cancellation, alongside communication with the customer.

Shared inventory helps coordinate shops, online sales and sales staff. Preventing overselling also requires suitable availability checks, channel settings and timely updates. A common database alone does not guarantee that every channel will block an unavailable sale.

Managing Multiple Warehouses, Locations and Stock Counts

A warehouse represents a site; locations provide more detail within or between sites. A business might distinguish receiving, storage bins, dispatch, goods in transit and returns awaiting inspection. That detail is useful when it reflects how employees actually work.

In Odoo, movements between locations create a record of where goods came from and where they went. When ten units leave Johannesburg for Pretoria, a transit stage can distinguish dispatch from arrival. The receiving branch confirms the quantity received, allowing shortages to be investigated.

Locations used for inspection need suitable movement and reservation rules so their stock is not picked for ordinary sales. Simply naming a shelf “quarantine” does not establish that control.

Physical counts remain necessary. A perpetual inventory system updates records through transactions, but goods can still be misplaced, damaged or moved without being recorded. Cycle counts check selected stock regularly; a full stocktake checks a wider scope at an agreed time.

If the system shows 50 units and staff count 46, first check pending movements, the unit of measure, neighbouring bins and recent receipts or deliveries. Authorised adjustments should record a reason. Repeated discrepancies should prompt process investigation, rather than routine changes that conceal the cause.

Serial Numbers, Barcodes and Mobile Scanning

A product code identifies a type of item. A lot or batch number identifies a group, while a serial number identifies an individual unit. These distinctions matter for recalls, warranties, repairs and identifying exactly what was supplied.

Odoo supports lot and serial tracking selected for each product. A distributor receiving serialised equipment records the unit identifiers at receipt and retains them through subsequent movements. Recording the serial supplied to a customer gives staff a basis for investigating a later return. Equipment with additional identifiers may require extra fields or a tailored process beyond one serial number. Odoo 19.0 documentation

Odoo’s Barcode application supports scanning products, locations and lot or serial identifiers in warehouse operations. Supported smartphone workflows can use the camera through the scanning interface; compatible tablets and dedicated scanners should be tested with the actual labels and operations. Odoo 19.0 documentation

A scan identifies information within a transaction. Staff must still establish the correct receipt, delivery or transfer, quantity and destination, then complete the operation. Scanning a product label alone does not prove that ten units arrived.

Camera scanning can suit occasional work. For repeated warehouse scanning, assess speed, lighting, label condition, battery life and handling. Match scanner capabilities to the codes used: 2D codes require a suitable reader.

Managing Returns, Repairs and Unsaleable Stock

A return has both a physical outcome and a financial outcome. Receiving goods back does not automatically make them fit for sale or complete the customer’s credit or refund.

Start by identifying the original delivery, product, quantity and serial or batch number where relevant. Record the goods received into an inspection location. Decide whether they can return to saleable stock, require repair, should go back to the supplier or must be scrapped.

Odoo supports return transfers linked to deliveries. The business must choose the destination and inspection process so returned goods do not become available prematurely. A customer credit note is handled through the relevant accounting process; an actual repayment is a further financial action. Odoo master documentation

For serialised equipment, the recorded identifier helps establish whether the unit received matches the one supplied. If a replacement is issued, record its outward movement and identifier too. Supplier returns require their own movement and follow-up on the expected supplier credit or replacement.

Manufacturers also need to assess whether returned materials or products can be reused, reworked or scrapped. Retailers must consider condition, packaging and expiry. These decisions should leave a record of who inspected the goods and what happened to them.

Connecting Inventory with Accounting, Margins and Working Capital

Accurate quantities are only part of inventory control. Management also needs to understand the value held, the cost of goods sold and how much money remains tied up in stock.

An imported product’s supplier price may exclude freight, duties and other attributable acquisition costs. Odoo includes landed-cost functionality for allocating additional costs to eligible stock receipts. The finance team must agree which costs belong in inventory, the allocation basis and the applicable costing and accounting setup. Odoo 14.0 documentation

For illustration, a product bought for R500 and sold for R750 appears to provide R250 before other costs. If attributable acquisition costs add R100 per unit, that difference falls to R150. This still does not represent net profit after the wider expenses of running the business.

Stock quantity, stock valuation, purchasing commitments and cash flow answer different questions. Goods can be present but unpaid; goods can be paid for but still in transit. An invoice also does not establish that stock is available for dispatch.

Useful management information includes stock value by product and location, slow-moving items, shortages, outstanding supplier orders and stock turnover. Compare those reports with sales and accounting records. A full warehouse may represent money that the business needs elsewhere.

Online Inventory Management Across Distribution, Manufacturing and Retail

Online inventory management software lets authorised employees at different sites work with shared information. Buyers can review requirements, salespeople can check availability and warehouse staff can record movements using suitable computers, tablets or scanning devices.

That access depends on connectivity, permissions and usable workflows. Check wireless coverage where goods are handled, including receiving and dispatch areas. Establish a procedure for interruptions and later reconciliation; do not assume a mobile interface provides full offline operation.

The same stock principles apply across industries, but requirements differ. Distribution needs reliable purchasing, allocation and fulfilment. Retail needs coordination between store sales, online orders and replenishment. Manufacturing must connect raw materials and components with production, consumption and finished goods.

Odoo connects inventory with those functions through the relevant applications. A manufacturer needs appropriate bills of materials and manufacturing records, while expiry-sensitive businesses may also need expiry dates and removal rules that prioritise suitable stock.

When separate applications are connected, establish which system owns the stock balance, how quickly updates pass between them and how failed transfers are detected. Every sales channel displaying yesterday’s balance can produce conflicting promises, even when each application describes itself as integrated.

Choosing the Best Inventory Management Software for Your Business

The best inventory management software for a business is the system that handles its requirements reliably at an acceptable total cost. Ask providers to demonstrate a partial supplier receipt, a reserved customer order, a branch transfer, a serial-number return and a stock discrepancy using your examples.

Compare the inventory management system price over an agreed period. Include subscriptions, required applications, data preparation, configuration, integrations, scanners, label printers, training and support. Free inventory management software still needs assessment: check users, locations, transaction limits, traceability, connections and access to your data.

Implementation starts with clean product codes, units of measure, supplier details and location definitions. Establish reliable opening quantities and values, then agree responsibilities for receipts, reservations, dispatches, returns and adjustments. Test these processes with warehouse staff, purchasing, sales and finance before launch.

Ask who resolves operational problems, what support includes and how upgrades affect integrations. A staged rollout can begin with core purchasing and stock movements, adding more complex warehouse or manufacturing processes as the business is ready.

Software provides the record and workflow. Reliable inventory management depends on those tools supporting consistent physical operations and informed management decisions.

Take Control of Stock, Purchasing and Fulfilment

Hatton Locks helps South African businesses connect purchasing, inventory, sales, operations and accounting through better processes and integrated business systems.

We work with owners and their teams to understand where stock control breaks down, define practical responsibilities and implement systems that support reliable fulfilment and informed purchasing. Where Odoo is suitable, we help configure the relevant applications, prepare data, train users and improve the process as the business develops.

The objective is accurate availability, dependable customer commitments and better control over the money invested in stock.