Stock Across UAE and KSA: Designing Multi-Country Inventory in Odoo 19

Stock across UAE and KSA: designing multi-country inventory in Odoo 19

Key takeaways

  • For a multi-country trader, the first stock problem is usually visibility: nobody sees every warehouse, incoming cargo and supplier performance together.
  • For TAM Trading, we designed four shipment types (direct, warehouse, intercompany and local) with their own stock rules.
  • The warehouse design includes locations for bulk, bagging, damaged and quarantined stock, FEFO picking with temperature logs, and separate tracking of customer-owned stock.
  • Odoo 19 supports FEFO with lots and expiry dates, stock owned by another party, and intercompany transactions between companies in one database [1][2][3].

Overview

TAM Trading ships direct from suppliers, through 3PL warehouses, intercompany from the UAE to KSA, or locally from stock. When we documented TAM’s requirements, procurement could buy new stock without checking other warehouses or regions, so one location had excess while another ran short. Older stock was sometimes picked last because it was harder to reach, and expired. Customer-owned stock sat alongside company stock without clear identification.

This article explains the stock design we wrote for TAM and how it maps to Odoo 19. It describes the agreed design, not results from a live system.

Why stock goes wrong for a multi-country trader

  • Each warehouse is a separate spreadsheet. Sales sees one location and promises stock that is in another country.
  • Incoming cargo is invisible. Goods on the water are not counted, so teams buy again.
  • Old stock is picked last. The newest pallets are at the front, and older batches expire at the back.
  • Customer stock looks like company stock. Goods a customer already paid for are offered to someone else.
  • 3PL data arrives late. Receipts and dispatches at a third-party warehouse are reported days later.
  • Units do not match. Stock is bought in tonnes, stored in bags and sold in either.

Each of these is a design question before it is a software question.

Four shipment types, four sets of rules

Every sales order is tagged with a shipment type, and the type decides how Supply Chain fulfils it:

TypeHow stock moves
DirectSupplier to customer through a virtual warehouse, so inventory reconciles without a physical receipt at TAM
WarehouseReceived into a 3PL or own warehouse, often bagged, then delivered
IntercompanyBetween TAM entities, for example UAE to KSA, with defined transfer margins
LocalPicked from physical stock and delivered with a weighbridge record
Four shipment types and how each moves stock: direct, warehouse, intercompany and local
The four shipment types in the TAM design.

Warehouses and locations

TAM’s design supports several warehouses, for example a UAE 3PL warehouse and a KSA warehouse. Each has internal locations for bulk stock, bagging, damaged stock and quarantine. Warehouse capacity is recorded for each warehouse so planners can see space as well as stock.

An illustrative location structure for one warehouse:

LocationUsed for
BulkProduct received loose or in jumbo bags before repacking
BaggingStock being repacked into 25 kg bags
Finished bagsBagged stock ready to sell
QuarantineStock waiting for quality release
DamagedStock that cannot be sold as normal
ConsigneeStock owned by customers, held for them

Because each location is separate in Odoo, a stock report can show what is available to sell, not just what is physically in the building.

FEFO and temperature logs

Chemicals expire. The design applies first-expired, first-out (FEFO) when allocating stock, and allows temperature readings at set intervals, linked to each batch. This addresses the problem of older stock being left behind until it can no longer be sold. Manufacturers use the same lot logic for film; see lot tracking in a packaging plant.

How to set up FEFO in Odoo 19

FEFO in Odoo works on lots with expiry dates [1]:

  1. In Inventory › Configuration › Settings, under Traceability, enable Lots & Serial Numbers, then Expiration Date.
  2. On each product, track inventory By Lots and enable expiration dates. Set the expiration, best before, removal and alert dates as needed.
  3. Assign lot numbers at receipt, or through an inventory count for existing stock.
  4. Set First Expiry First Out (FEFO) as the removal strategy on the product category or the stock location.
First Expiry First Out removal strategy set on a product category in Odoo 19
FEFO set as the removal strategy on a product category [4].

When a delivery is prepared, Odoo then proposes the lots with the earliest removal date first.

Detailed operations showing lots picked by FEFO in Odoo 19
Lots proposed by FEFO on a delivery [4].

Temperature logs per batch are not a standard Odoo feature. In TAM’s design they were specified as readings recorded against the lot.

Customer-owned (consignee) stock

Some TAM customers buy product that stays in TAM’s warehouse. The design tracks this consignee stock separately so it is never sold twice. For urgent local orders, it also allows temporary borrowing from consignee stock, recorded as a consignee stock shortfall to be replaced.

Odoo 19’s Consignment setting adds an owner to stock, so goods owned by another party are kept apart from your own [2]. It is described for supplier-owned stock, but the same owner field works for stock held for a customer. The borrowing and shortfall rule in TAM’s design needs configuration on top.

Consignment setting in Odoo 19 Inventory configuration
The Consignment setting in Inventory [4].

Stock and incoming cargo at the pre-sales review

Before a quotation is drafted, Supply Chain confirms current stock, incoming shipment ETAs and any batch restrictions as part of the pre-sales review. For local sales, the system checks FEFO-available stock in the selected warehouse before the order is confirmed. On partial shipments, it tracks the remaining quantity and blocks over-delivery. This check is part of the pre-sales review.

In Odoo, incoming purchase orders already show in the forecasted quantity of each product. The difference in TAM’s design is that the pre-sales review shows stock and incoming cargo for every warehouse and company together, so Sales does not have to ask.

If your sales team confirms delivery dates without seeing every warehouse, we can show how it would work in Odoo.

Supplier assessment after every delivery

TAM already had a supplier and 3PL delivery assessment form (TAM-F-014). In the design, Logistics creates a delivery assessment after each receipt. It covers quantity accuracy, quality condition, supplier cooperation and responsiveness, and quoted price compared with what actually happened. The Commercial team reviews it, the Head of Supply Chain approves it, and the results feed on-time-in-full reporting by supplier and route. Quantities are also matched on the vendor bill through three-way matching.

Intercompany: UAE to KSA

One TAM route runs from the UAE entity to the KSA entity. In the design, the KSA company’s purchase order is treated as a customer order by the UAE company, with transfer margins and payment terms. Goods leaving the Free Zone need the Free Zone clearance invoice, and invoices in KSA must follow ZATCA e-invoicing in Odoo.

Odoo 19’s Inter-Company Transactions feature can create the matching document in the other company automatically: a sales order when a purchase order is confirmed, a purchase order when a sales order is confirmed, or a vendor bill when an invoice is posted. It can also synchronise stock moves [3]. Note that warehouses for each additional company must be created manually [3].

On the finance side, TAM’s design includes shared cost allocation between entities, elimination of intercompany balances at consolidation, FX translation differences, and automatic 5% reverse-charge VAT on cross-border intercompany expenses.

Before go-live, test one intercompany order end to end: the KSA purchase order, the UAE sales order, both deliveries and receipts, both invoices, and the VAT on each side.

Checklist for multi-country stock in Odoo

  • Map every stock location (own, 3PL, consignee) to a warehouse and a company.
  • Decide how each shipment type moves stock, including direct shipments that never touch your warehouse.
  • Decide where FEFO applies and which products need lots, expiry dates and temperature logs.
  • Agree how 3PL receipts and dispatches reach Odoo, and how often.
  • Turn your supplier assessment into fields recorded after each receipt.
  • Test one intercompany order end to end, including invoices and VAT on both sides.

FAQ

Can Odoo manage stock for several companies in one database?

Yes. Each company has its own warehouses, which must be created for each company [3].

How do I set up FEFO in Odoo 19?

Enable lots and expiration dates, track products by lots, and set FEFO as the removal strategy on the product category or location [1].

Can Odoo keep stock owned by someone else separate?

Yes. The Consignment setting adds an owner to stock, so it is not mixed with your own [2].

Can Odoo handle direct shipments from supplier to customer?

Yes. TAM’s design routes them through a virtual warehouse so inventory reconciles without a physical receipt.

Does Odoo create intercompany orders automatically?

It can. With Inter-Company Transactions enabled, Odoo creates the matching document in the other company [3].

See all your stock before you promise it

If your sales team checks several spreadsheets before confirming a delivery date, we can show how the same check would work in Odoo 19. See how we approach Odoo for trading and distribution projects.

References

[1] Odoo, FEFO removal, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/shipping_receiving/removal_strategies/fefo.html

[2] Odoo, Consignment: buy and sell stock without owning it, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/shipping_receiving/daily_operations/owned_stock.html

[3] Odoo, Multi-company, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/general/companies/multi_company.html

[4] Screenshots: Odoo S.A., Odoo 19.0 documentation (FEFO removal, Consignment), licensed under CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/). https://www.odoo.com/documentation/19.0/

  • Kawser Ahmed is the Founder & CEO of Softeko, a global IT consultancy with offices in Dhaka and Dubai. A tech entrepreneur, investor, and AI enthusiast, he has led numerous software and web projects, including the successful ExcelDemy.com. Kawser holds an Odoo 18 Functional Certification and has deep expertise in business process management, finance, SEO, and software development. He's also a Technical Analysis trainer at Dhaka Stock Exchange Ltd., with popular online courses on AmarStock.com and Udemy. A lifelong learner, Kawser explores how business, technology, and global markets work.

    View all posts

Want to write an article for our blog? Read our requirements and guidelines to become a contributor.

Leave a comment

Your email address will not be published. Required fields are marked *

Get Free Consultancy
Odoo Consultant
Get Free Consultancy
Book a meeting with an expert → Shafiuddin Haider, Odoo ERP Consultant
☰
Table of Contents