Ask any business owner using an ERP what frustrates them most, and one answer comes up again and again:
“The stock in the system doesn’t match the stock in the warehouse.”
Sales staff promise goods that aren’t there. Purchase teams reorder items that are already on the shelf. The accountant can’t explain why the stock value changed. At year-end, the physical count reveals differences nobody can trace.
Most owners blame the software. In reality, Odoo and ERPNext both have powerful inventory features: batches, serial numbers, multiple warehouses, valuation methods, reorder rules and barcode support. The problem is almost always how the stock is entered, moved and counted by the team.
This guide explains how warehouse activity flows into stock and accounting reports, the most common mistakes, and why ERP inventory and warehouse training is one of the best investments a trading, distribution, retail or manufacturing business can make.
Why inventory accuracy matters so much
Inventory is often one of the largest assets on a company’s balance sheet, especially for traders, distributors, pharma companies, manufacturers and retailers. Inaccurate stock data affects almost every part of the business:
Area | Impact of wrong stock data |
|---|---|
Sales | Orders promised for stock that doesn’t exist, lost customers |
Purchasing | Over-ordering, under-ordering, cash tied up in slow stock |
Accounts | Wrong stock value, wrong cost of goods sold, wrong profit |
Tax | Mismatches between stock, sales and tax records |
Management | Bad decisions on pricing, reorders and expansion |
Compliance | Problems tracing batches, expiry dates and serial numbers |
Staff | Blame, distrust and a return to manual registers |
How warehouse activity flows into your ERP reports
In an integrated ERP, the warehouse team doesn’t just “move boxes.” Every stock transaction is also a financial transaction.
Here are the main documents and what they do:
Activity | ERPNext document | Odoo document | What it affects |
|---|---|---|---|
Receiving from a supplier | Purchase Receipt | Receipt | Stock quantity, stock value, payables (once billed) |
Delivering to a customer | Delivery Note | Delivery Order | Stock quantity, cost of goods sold |
Moving between warehouses | Stock Entry (Material Transfer) | Internal Transfer | Stock by location and branch |
Issuing for internal use or production | Stock Entry (Material Issue or Manufacture) | Consumption or Manufacturing Order | Stock, expenses, production cost |
Correcting after a physical count | Stock Reconciliation | Inventory Adjustment (Physical Inventory) | Stock quantity and value, stock adjustment account |
Adding freight, duty and clearing costs | Landed Cost Voucher | Landed Costs | Item cost, margins |
When the inventory system is linked to accounting (perpetual inventory), each of these documents creates accounting entries automatically. A wrong stock document is a wrong accounting entry.
For how these entries reach the general ledger, read ERP Accounts and Finance Training.
A simple example: how one mistake spreads
A distributor buys 100 cartons of a product, each with 12 pieces, at PKR 1,200 per carton (PKR 100 per piece). The item’s stock unit in the ERP is pieces.
Correct entry
The storekeeper receives 100 cartons, the system converts to 1,200 pieces, and the stock value is PKR 120,000.
Wrong entry
The storekeeper enters 100 in the pieces field instead of cartons.
The result:
The system shows 100 pieces in stock instead of 1,200
The sales team thinks stock is low and stops taking orders
The purchase team reorders goods that are already in the warehouse
The cost per piece is calculated wrongly, so margins and profit reports are distorted
At the next physical count, a “surplus” of 1,100 pieces appears and nobody knows why
One field, one wrong unit, and five departments are affected. This is exactly the kind of error that training prevents.
Stock valuation: why the warehouse affects profit
Both ERPs value stock using a method you choose:
ERPNext: FIFO, Moving Average and LIFO
Odoo: Standard Price, Average Cost (AVCO) and FIFO
The method decides how much each item costs when it’s sold, which directly affects cost of goods sold and gross profit.
Under any method, the cost is only correct if:
Goods are received with the correct quantity, unit and rate
Landed costs (freight, customs duty, clearing charges) are added to the right receipts
Stock is received into the correct warehouse and on the correct date
Returns are processed against the original documents, not as new random entries
If freight and duty are never added as landed costs, for example, your items look cheaper than they really are. Your profit reports then overstate margins, and you may price products too low without realising it.
The 10 most common inventory mistakes in ERPs
# | Mistake | What goes wrong |
|---|---|---|
1 | Wrong unit of measure (carton vs piece) | Quantities and costs off by large factors |
2 | Wrong warehouse or location | Branch stock wrong, transfers needed later, branch profit distorted |
3 | Delivering goods without entering the delivery | System shows stock that has already left |
4 | Receiving goods without entering the receipt | Stock exists physically but not in the system, and reorders are triggered |
5 | Allowing negative stock | Items sold before receipt, costs calculated wrongly |
6 | Not recording landed costs | Item costs understated, profit overstated |
7 | Wrong batch or expiry date | Expired stock sold, recalls impossible to trace |
8 | Duplicate items (same product created twice) | Stock split across two codes, wrong reorders |
9 | Returns entered as new receipts | Supplier balances and costs go wrong |
10 | Adjusting stock without investigating | Real problems such as theft, damage or wrong entries stay hidden |
Batches, serial numbers and expiry: where training is critical
For many industries, tracking which batch or serial number went to which customer isn’t optional.
Pharma distributors must track batches and expiry dates, and now handle GS1 DataMatrix codes under DRAP serialisation rules. See GS1 DataMatrix and DRAP Serialization and Pharma Distribution Software in Pakistan.
Food and FMCG businesses need expiry control and first-expiry-first-out picking.
Electronics and equipment sellers need serial numbers for warranties.
LPG businesses need to track cylinders moving between plant, distributors and customers. See LPG Plant and Gas Cylinder Business Software.
Textile and garment manufacturers track lots, sizes and colours. See Textile and Garment ERP.
The ERP can do all of this, but only if warehouse staff scan or select the right batch and serial every time. Without training, staff often pick “any batch” to finish the entry quickly, and traceability is lost.
Physical stock counts: doing them properly
Even well-run warehouses need regular counts. Trained teams count properly:
Freeze or pause movement for the items or locations being counted
Print or export count sheets from the system, or use barcode scanning
Count blind (without seeing system quantities) to avoid bias
Recount items with big differences
Investigate before adjusting: check for missing receipts, deliveries or transfers
Post the adjustment through Stock Reconciliation (ERPNext) or Inventory Adjustment (Odoo)
Review the stock adjustment account in accounts so finance understands the impact
Fix the root cause, whether training, process or controls
Cycle counting (counting a few items every week instead of everything once a year) catches errors early and keeps the system reliable all year.
For year-end counts, see the Year-End Closing Checklist.
Signs your team needs inventory and warehouse training
Stock differences appear at every physical count
Sales staff phone the warehouse to check stock instead of trusting the system
The system often shows negative stock
Items are duplicated under different names or codes
Purchase orders are created after goods arrive
Branch or warehouse stock reports are never correct
Expired stock is found that the system never flagged
Finance can’t explain changes in stock value or COGS
The warehouse still keeps a manual register “just in case”
What warehouse and inventory training should cover
For storekeepers and warehouse staff:
Receiving goods against purchase orders
Units of measure and conversions
Choosing the correct warehouse and location
Batches, serial numbers and expiry dates
Internal transfers between locations and branches
Deliveries, partial deliveries and returns
Barcode scanning and labelling
Physical counts and cycle counts
For purchase and sales teams:
How their orders affect stock availability
Reorder levels and reorder rules
Reserved stock and projected quantity
Why delivery and receipt dates matter
For accountants and managers:
Stock valuation methods
Landed costs
Stock adjustment and stock-in-hand accounts
Stock ageing, slow-moving and fast-moving reports
Matching stock reports to the balance sheet
Useful related reading: Inventory Management Software for Wholesalers and Traders and Excel to ERP.
How to roll out inventory training in your business
Step 1: Map your real stock flow. From supplier to warehouse, between branches, to customers and back for returns.
Step 2: Clean up master data first. Merge duplicate items and fix units of measure, warehouses and item groups. Training on bad data won’t fix much.
Step 3: Train by role. Storekeepers, purchase staff, sales staff and accountants each need different sessions.
Step 4: Practise in a training account. Let staff make mistakes safely, not in your live system.
Step 5: Create one-page guides. For example, “How to receive goods,” “How to transfer stock” and “How to process a customer return.”
Step 6: Switch off risky settings. Review whether negative stock should be allowed, and set user permissions so only trained staff can post stock documents.
Step 7: Start cycle counting. Count a few high-value items weekly and investigate every difference.
Step 8: Follow up after a month. The best questions come after people have used the system for real.
For students: a strong career path in supply chain and ERP
Inventory and warehouse skills are valuable for BBA (supply chain), BCom and commerce graduates. Companies need people who understand both stock operations and the ERP.
Entry-level roles include:
Inventory executive or controller
Warehouse or store officer using ERP
Supply chain or procurement executive
ERP support executive for inventory modules
Junior functional consultant (inventory and purchasing)
Read more in ERP Jobs for Fresh Graduates in Pakistan and How to Become an ERPNext or Odoo Consultant.
Learn ERP inventory with Bizloom Academy
Bizloom Academy is run by a team that implements Odoo and ERPNext for distributors, traders, pharma companies and manufacturers, so our training reflects real warehouse problems.
For individuals:
Live, instructor-led online classes, 60 minutes each
Your own training account to practise receiving, transfers, deliveries and counts
Exercises, case studies, assignments and a practical assessment
Learning support after the course
Functional Consultant: PKR 25,000 (10 live sessions). ERPNext | Odoo
Functional Consultant Program: PKR 40,000 for 4 courses and 26 sessions (PKR 65,000 if bought separately)
48-hour money-back guarantee after your first live session (see policy)
For companies:
Quote-based corporate training for warehouse, purchase, sales and finance teams, delivered live online with an individual training account for each participant. See ERPNext and Odoo Corporate Training for Teams or request a quote.
Stock already out of control? Book a free ERP assessment and we’ll help you find where the differences begin.
👉 Explore Bizloom Academy | WhatsApp us
FAQs
1. Why doesn’t my ERP stock match my physical stock?
Usually because of missing or wrong entries: deliveries or receipts not recorded, wrong units of measure, wrong warehouses, duplicate items or negative stock. Training and process fixes solve most of these.
2. How do stock entries affect accounts in Odoo and ERPNext?
With perpetual inventory, every receipt, delivery, transfer and adjustment creates accounting entries that affect stock value, cost of goods sold and profit.
3. Which stock valuation methods do Odoo and ERPNext support?
ERPNext supports FIFO, Moving Average and LIFO. Odoo supports Standard Price, Average Cost (AVCO) and FIFO.
4. What are landed costs, and why do they matter?
Landed costs are extra costs such as freight, customs duty and clearing charges. Adding them to item costs gives accurate margins. Leaving them out makes profit look higher than it really is.
5. Should we allow negative stock in our ERP?
Most businesses should keep negative stock switched off. It hides missing receipts and causes wrong cost calculations.
6. How often should we do physical stock counts?
At least once a year, but weekly or monthly cycle counts of key items catch errors much earlier.
7. Who in the company needs inventory training?
Storekeepers, warehouse staff, purchase and sales teams, accountants and managers, each focused on their own role.
8. Can Bizloom train our warehouse team online?
Yes. Our corporate training is live online, so teams in different cities or countries can join together.