Four Questions Your Inventory System Must Answer
For trading and manufacturing companies, inventory is often the largest asset on the balance sheet after cash and receivables, and sometimes ahead of them. Yet plenty of businesses still run millions of riyals of stock on spreadsheets, or on a basic stock module inside accounting software that knows only quantity and price. The symptoms are familiar: system balances that do not match the shelf, items that run out while the report says they are available, expired goods discovered at the year-end count, and a cost of sales figure nobody quite trusts.
A good inventory system is not measured by the length of the vendor's feature list. It is measured by whether it can answer four questions accurately at any moment: what do we have, where is it, what is it worth, and when do we need more? This guide walks through the features we consider essential, explains why each matters with a practical example, separates the universal must-haves from those that depend on your business, and ends with a test checklist for any system you evaluate. Numerical examples are hypothetical.
Foundation Features
1. A disciplined item master
Everything starts with the item record: code, Arabic and English names, category, base unit of measure, approved suppliers, last purchase price, reorder point and tracking method. A system that lets anyone create items freely ends up with "Engine oil 5L" and "Oil engine 5 ltr" as two items for one product. Look for mandatory fields, automatic numbering by category, and duplicate warnings.
2. Real-time balances
Balances must change with every movement: supplier receipt, customer issue, warehouse transfer, count adjustment, return. If balances update overnight or after manual posting, sales will sell stock that left an hour ago. The system should also separate on-hand, reserved for confirmed orders, available to promise, and on order from suppliers.
3. Multiple warehouses and locations
Even a single-branch company usually has several locations: main warehouse, showroom, delivery vans, a quarantine area for damaged or returned goods. Larger businesses need warehouses in several cities and bin locations within each by aisle, rack and shelf. A transfer should be a documented movement with a sender and a receiver, not a manual balance edit.
4. Multiple units of measure
You buy by the carton, store by the box and sell by the piece. Or you buy cable by the drum and sell it by the meter. The system needs conversion factors per item, automatic conversion on purchase and sale, and balances displayed in whichever unit the user chooses. Missing UoM support is one of the most common causes of count variances.
Accuracy and Control Features
5. Barcode and QR scanning
Manual entry of item codes and quantities produces errors, especially in a busy warehouse. Scanning at receipt, issue and count makes mistakes rare and work faster. Scanning has to work from handhelds or phones, because storekeepers work between racks, not behind desks. Our article on QR code inventory tracking goes deeper.
6. Batch and serial tracking
In food, pharmaceuticals, cosmetics and chemicals, you need the batch number of every quantity received and sold, so a defective batch can be pulled from the market within hours. For high-value equipment, each unit's serial number matters for warranty and service.
7. Expiry dates and FEFO
For perishables it is not enough to record expiry. The system should direct pickers to the batch that expires first, and warn early enough to sell the stock or return it to the supplier.
8. Cycle counting and documented adjustments
An annual full count is not enough on its own. A good system supports cycle counts by item group: high-value items monthly, the rest quarterly. Every variance becomes an adjustment with a reason and an approval, never a silent balance change. Saudi Arabia's Commercial Books Law requires year-end inventory to be recorded in the inventory book and books to be kept for ten years; the new Commercial Transactions Law approved by the Council of Ministers in October 2026 will replace it once in force.
Planning and Replenishment Features
9. Reorder points and safety stock
Each item gets a minimum level that triggers an alert or a purchase requisition. The standard formula:
Reorder point = average daily usage × lead time in days + safety stock
Hypothetical example: an item sells 40 units a day, supplier lead time is 15 days, and the company holds five days of safety stock, 200 units. Reorder point = 40 × 15 + 200 = 800. When available stock plus open purchase orders falls to 800, it is time to order. The classic mistake is to look at on-hand only and ignore what is already on order, so the order gets placed twice. More in our guide to the inventory reorder point.
10. Movement analysis
Reports that rank items by consumption value and flag slow-moving and dead stock with no movement in six or twelve months. These drive clearance decisions and tell you which items deserve daily attention.
Valuation and Finance Features
11. Approved valuation methods
IAS 2, applied in Saudi Arabia, allows first-in-first-out or weighted average cost for interchangeable items, and does not permit last-in-first-out. The system must support your chosen method, compute cost of sales automatically, and include freight and duty in the cost of purchases. Our article on inventory valuation compares the methods with examples.
Hypothetical example of why automatic landed cost matters: you hold 100 units at SAR 50, then receive 300 at SAR 54 with SAR 600 of freight and duty, a true cost of SAR 56 each. Weighted average: (100 × 50 + 300 × 56) ÷ 400 = (5,000 + 16,800) ÷ 400 = SAR 54.50. Sell 250 units and cost of sales is SAR 13,625. If the system ignored freight and used supplier price only, average cost would be SAR 53 and cost of sales SAR 13,250, overstating profit by SAR 375 on one transaction. Repeat that across thousands of transactions and reported margin drifts far from reality.
12. Automatic accounting entries
Every stock movement has an accounting effect. A receipt increases inventory and creates a supplier liability, a sale creates cost of sales and reduces inventory, an adjustment records a count variance. If these entries are keyed manually or imported from a separate tool, the inventory balance in the general ledger will not match the stock report. In an integrated system the entry is created with the movement itself.
13. Links to purchasing, sales and invoicing
A PO shows as expected stock, a receipt is created from the PO, a sales order reserves quantity, a delivery issues it, and a ZATCA-compliant e-invoice comes out of the same flow. Every break between these links means double entry and another chance for error.
Features That Depend on Your Business
14. Assembly and kits
If you sell products made of several items, such as gift sets or devices assembled from parts, the system must consume components and add the finished item at the correct cost. Tranquil supports assembly and pre-assemblies within its inventory module.
15. Advanced warehouse management
Large warehouses need defined storage locations, putaway rules, pick lists sorted by route, and batch picking of several orders together. These sit in warehouse management, built on top of the inventory foundation.
16. Returns handling
A return is not just a reversed sale. Returned goods may be resaleable and go back to stock, damaged and go to a write-off location, or defective and go back to the supplier. The system should link the return to the original invoice, record the reason, route the goods correctly and issue an e-invoicing-compliant credit note. Analyzing return reasons by item, customer and supplier surfaces quality and picking problems early.
Which Features Are Essential for You?
| Feature | General trading | Food and pharma | Manufacturing | Parts and equipment |
|---|---|---|---|---|
| Real-time, multi-warehouse balances | Essential | Essential | Essential | Essential |
| Multiple units of measure | Essential | Essential | Essential | Important |
| Barcode scanning | Important | Essential | Important | Essential |
| Batch tracking | Optional | Essential | Essential | Important |
| Expiry dates | Item-dependent | Essential | Material-dependent | Batteries, fluids |
| Serial numbers | Optional | Rare | For equipment | Essential |
| Assembly and BOM | For kits | Rare | Essential | For kits |
| Reorder points | Essential | Essential | For raw materials | Essential |
Use the table as a starting point, then check against your real processes. A food company without batch tracking is risking its reputation and compliance; a general trader buying a heavy serial-tracking system may pay for features nobody uses.
Reports You Should Get Without Effort
| Report | Used by | Decision it supports |
|---|---|---|
| Stock by warehouse and location | Warehouse, sales | Can we fill this order, and from where? |
| Items at reorder point | Purchasing | What do we order today? |
| Items nearing expiry | Warehouse, sales | What do we push or return? |
| Slow-moving and dead stock | Management, finance | What do we discount or clear? |
| Item movement history | Audit, accounting | Where did the variance come from? |
| Valuation at a given date | Finance | Does stock agree with the ledger? |
| Turnover by category | Management, purchasing | Are we holding too much? |
If any of these needs an Excel export and manual work, the system will struggle as volume grows.
Worked Example: The Cost of Inaccuracy
Hypothetical example: a trading company averages SAR 4 million of inventory. The annual count shows net variances of 1.5%, or SAR 60,000, from a mix of genuine loss, unit-of-measure mistakes and duplicate items. On top of that:
- Expired goods written off: SAR 35,000, because nobody was warned in time.
- Lost sales when the system showed items as out of stock that were actually on the shelf: estimated by the sales manager at SAR 50,000 of margin a year.
Total estimated cost: SAR 145,000 a year. No system removes all of it, but scanning, cycle counts, expiry alerts and correct units of measure each target one of those lines directly, and the figure gives you a benchmark against system cost.
Common Selection Mistakes
- Judging on a generic demo. Every system looks good on the vendor's sample data. Ask for your items, your units and your awkward cases.
- Ignoring daily users. If the receiving screen is slow, storekeepers will write on paper and key in later, and the errors come back.
- Tracking quantity but not value. A system that counts well but costs poorly solves half the problem.
- Buying features you do not need. Serial tracking for everything, or detailed bin management in a small store, adds steps without benefit.
Evaluation Checklist
- Create a new item: are key fields enforced, numbering automatic, duplicates blocked?
- Buy by carton, sell by piece: does the balance convert correctly?
- Receive a batch with an expiry date and sell from it: does the system suggest the earliest-expiring batch?
- Transfer between warehouses: does the quantity show in transit until the receiver confirms?
- Run a partial count of ten items: how are variances recorded and approved?
- Sell an item and open the journal entry: is cost of sales at your chosen method?
- Request the six-month dead stock report and the at-reorder-point report.
- Try scanning from a phone inside the warehouse.
A system that passes these eight tests on data like yours is a solid foundation. Tranquil's inventory management includes central inventory, assembly, pre-assemblies and multiple units of measure.
Frequently Asked Questions
What is the difference between standalone inventory software and an ERP inventory module?
Standalone software may handle warehouse tasks well but needs integration with accounting, purchasing and sales, and that integration is usually where variances come from. An ERP module shares one database, so accounting entries are created with the movement.
Do I need barcodes if I have few items?
With few items and slow movement you can start without them. But printers and scanners are relatively cheap and their effect on receiving and counting accuracy is large, so we recommend them once you pass a few hundred SKUs.
Which valuation method should I use?
FIFO suits items affected by expiry or changing prices; weighted average is simpler and steadier for homogeneous items. Consistency is what matters, and IFRS does not allow LIFO.
How often should I count stock?
A full count at least once a year, with monthly cycle counts for high-value or fast-moving items and quarterly or half-yearly counts for the rest. Cycle counting surfaces problems early instead of at year end.
Does Tranquil support multiple units of measure and assembly?
Yes. Tranquil's inventory module includes central inventory, assembly, pre-assemblies and multiple units of measure. Contact the Tranquil team to see it on data close to yours.