ERPNext for FMCG Distribution in Qatar

FMCG distribution punishes small inaccuracies at scale. A one percent stock discrepancy in a business turning over its inventory twelve times a year is not a rounding error, it is a recurring loss. Add short shelf life, dozens of SKUs that look alike on a shelf, vans running routes with stock that nobody counts until evening, and suppliers who expect orders placed on a fixed weekly cycle, and the result is an operation where the numbers are always slightly behind reality.

Batch, expiry and FEFO

Items carry batch numbers with manufacturing and expiry dates. Picking follows first-expiry-first-out, so short-dated stock moves before it becomes a write-off rather than after. Expiry reporting shows what is approaching its date while there is still commercial time to act — discount it, push it through a promotion, or move it to a customer who will turn it faster.

Where a recall or a quality question arises, traceability runs both directions: from a batch to every customer who received it, and from a customer complaint back to the batch and the supplier receipt it came from.

Van sales, reconciled daily

Each van is its own warehouse. Morning loading is a stock transfer into the van. Sales, returns and free-goods issues during the route post against that warehouse. At the end of the day the reconciliation is arithmetic rather than argument: what was loaded, minus what was sold, minus what came back, should be zero — and where it is not, the variance is visible immediately against a specific van and a specific day.

Cash collection reconciles the same way, against the invoices raised on the route.

Multi-warehouse stock without the overnight lag

Main store, cold store, bonded area, vans, and any consignment stock held at customer premises each exist as separate warehouses with their own live balances. Stock transfers between them are recorded movements. Automated reorder levels raise material requests on their own when a location drops below its threshold, which matters most for fast-moving lines where a stockout costs a listing.

Procurement on a weekly cycle

FMCG buying is rhythmic — most suppliers expect orders on a cycle, and imports carry lead times measured in weeks. Material requests consolidate into purchase orders per supplier, quotations are compared in-system, and goods receipts match against the order. Landed-cost vouchers push freight, duty and clearing onto the item cost, so imported product margin is real rather than flattered by costs sitting in an expense account.

Promotions and trade terms

Pricing rules handle quantity breaks, customer-group pricing, time-bound promotional rates and free-goods schemes. The point is that the margin effect of a promotion is visible on the transaction, at the moment it is given, rather than reconstructed at month-end when the decision is long past.

Volume

Distributors ask, reasonably, whether an open-source system copes with thousands of invoices a month. It does — this is a sizing and configuration question, not a product ceiling. We establish expected transaction volume at scoping and size hosting, background job capacity and report design accordingly. Because there is no per-user licence, adding the whole sales and warehouse team costs nothing extra, which for a business with a large field force is a material difference against a licensed alternative.

Where it connects

FMCG implementations usually go live on accounting, inventory, buying and selling together, since separating them leaves exactly the reconciliation gap you are trying to close. The trading and distribution page covers the adjacent case with longer shelf life and lower volume, and data migration matters here more than most sectors because item catalogues in this industry are large and rarely clean.