ERP for FMCG Distributors & Van Sales in the GCC

 · 10 min read

Van sales route with salesman tablet, VAT invoice and van stock reconciliation

Ask the owner of a GCC food or FMCG distribution company what keeps them up at night and you hear the same list: vans that come back short, salesmen who give unapproved discounts, credit customers who stretch payments, and a warehouse that does not know what is really on the road. The business grows by adding vans, but control does not grow with it.

This case brief explains how a van sales and FMCG distribution ERP should work for distributors in the UAE, Saudi Arabia, Qatar, Kuwait and Bahrain, and how we set it up on ERPNext. It is written for owners and finance heads who are comparing systems, so it focuses on the business flow and the controls, not on code. There are no invented results here: what matters is whether the flow matches your trade.

Key takeaways

  • Treat each van as a warehouse. Loading is a stock transfer, every sale reduces van stock, and the end-of-day count closes the loop.
  • Price lists, schemes and credit limits must be in the system, not in the salesman's head, so discounts and credit are controlled on the road.
  • Invoices must be VAT-compliant at the point of sale in the UAE, Saudi Arabia and Bahrain. In Saudi Arabia, ZATCA e-invoicing rules apply too. Qatar and Kuwait have no VAT in force.
  • The daily settlement is the control point: stock returned, cash and cheques handed over, and credit invoices, all matched before the van leaves again.

Running vans on paper books and WhatsApp orders?

Tell us how many vans and routes you run. In a free 30-minute call we will map your day, from loading to cash handover, onto ERPNext.

Map my van sales → WhatsApp us: +91 8089051848

Or email info@nexeves.com

The typical day of a van salesman

Before choosing any system, write down the day as it really happens. For most GCC distributors it looks like this:

  1. Morning: the salesman receives a load sheet, either a fixed route load or one built from yesterday's orders. The warehouse loads the van.
  2. On the route: the salesman visits grocery stores, baqalas, mini-markets and HoReCa customers. He takes orders, sells from the van, collects cash or cheques, and takes back returns or expired stock.
  3. Some customers are on credit with limits; others are cash only. Promotions such as "buy 10 cartons, get 1 free" apply to certain items and customer groups.
  4. Evening: the van returns. Unsold stock, damaged returns, cash, cheques and credit invoices are counted and handed over to the cashier and storekeeper.
  5. Next morning: shortages, excesses and disputes are, in theory, resolved before the van is loaded again.

The ERP has to support every one of these steps. If even one step stays on paper, that is where leakage happens.

How the flow maps to ERPNext

Business step ERPNext setup
Van and route One warehouse per van, a Territory or custom Route field, and the salesman as a Sales Person linked to the van
Morning loading Stock Entry (Material Transfer) from the main warehouse to the van warehouse, created from a load sheet or from pending orders
Selling on the route Sales Invoice with Update Stock from the van warehouse, created on a tablet or phone through a POS or a custom van sales screen
Pre-sales orders Sales Order for next-day delivery, routed to the warehouse and delivery trip
Prices and promotions Customer-group price lists and Pricing Rules for discounts, slabs and free items
Credit control Credit limits and payment terms on the Customer, so a credit sale beyond the limit is blocked or needs approval
Collections Payment Entry against invoices for cash, cheques and bank transfers, with post-dated cheques tracked by date
Returns Sales return (credit note) into the van, then a transfer of damaged or expired stock to a returns warehouse
End of day Stock count of the van, transfer of unsold stock back to the main warehouse, and a cash settlement report per salesman

Most of this is standard ERPNext. The parts we usually build or configure on top are the load sheet, the mobile screen for the salesman and the end-of-day settlement report. The pricing logic is covered in our guide to pricing rules and price lists, and the commission logic in sales commission and incentives.

The mobile question: online, offline and printing

Van salesmen work in basements, industrial areas and remote routes where the signal drops. Ask any vendor these questions directly:

  • Does the salesman app work offline, and what happens when two devices sell the last carton at the same time?
  • Can it print a VAT invoice on a portable Bluetooth printer, in Arabic and English where needed?
  • Does it show the customer's outstanding balance and credit limit before the sale?
  • Can it capture GPS location and a photo of the signed delivery note or shelf?

ERPNext's standard POS is browser-based and works best with a stable connection. For routes with poor coverage, we either use POS Awesome, which has offline features, or a custom mobile screen, after testing the actual routes. We say this plainly because it is the most common gap between a demo and real van life. See POS Awesome for retail and ERPNext on mobile.

Want our van-day checklist?

We will send the loading, route and end-of-day reconciliation checklist we use when we set up van sales for distributors.

Send me the checklist → WhatsApp us: +91 8089051848

Or email info@nexeves.com

VAT and invoicing by country

Country Position (check with your adviser) What the van invoice needs
UAE VAT at 5% Tax invoice or simplified tax invoice with TRN, VAT amount in AED, and Arabic on consumer invoices. UAE e-invoicing is being introduced in phases
Saudi Arabia VAT at 15%, ZATCA e-invoicing in force Arabic invoice with QR code; Phase 2 integration through a ZATCA add-on app for ERPNext
Bahrain VAT at 10% Tax invoice with VAT number and VAT amount
Qatar No VAT in force Commercial invoice; no VAT lines
Kuwait No VAT in force Commercial invoice; no VAT lines

One ERPNext site can run separate companies for each country, each with its own tax templates and invoice formats. For details see ERPNext for UAE VAT, UAE e-invoicing and ZATCA Phase 2.

Credit control on the road

In GCC distribution, credit is often where profit disappears. A customer takes goods on 30 days, pays in 90, and the salesman keeps selling because his target depends on it. The fix is not a stricter salesman but a system rule:

  • Set a credit limit and payment terms for every credit customer. ERPNext checks the limit when an invoice or order is submitted.
  • Allow a controlled override: the sales manager approves exceptions, and the approval is recorded. A hard block with no exception path tends to be bypassed. Our post on approval workflows shows the pattern.
  • Track post-dated cheques by maturity date and bounced cheques by customer.
  • Review the receivables ageing by salesman and route every week, not at month end.

The end-of-day settlement

This is the report that tells you whether the day was honest and accurate. For each van it should show:

Section What it compares
Stock Opening van stock + loaded − sold + returns = expected closing; compared with the physical count
Cash Cash invoices + cash collections against old invoices = expected cash; compared with the cash handed over
Cheques Cheques received, listed by bank and date
Credit Credit invoices issued and any over-limit approvals
Exceptions Discounts beyond the price list, free items outside schemes, voided invoices

Differences should be posted, not ignored: a stock shortage becomes a stock adjustment, and a cash shortage becomes a recoverable from the salesman, according to your policy. When this report is reviewed every evening, leakage drops because everyone knows it is reviewed.

Warehouse, expiry and returns

FMCG stock is about dates. Use batches with expiry dates for food and personal care items, pick FEFO (first expiry, first out) when loading vans, and keep a separate warehouse for near-expiry and damaged returns so they never get reloaded by mistake. Our guide to batch and serial numbers with expiry covers the setup, and multi-warehouse transfers explains how van warehouses fit in.

What owners should measure

  • Sales, gross margin and collections by salesman, route and customer group
  • Strike rate: visits that resulted in a sale
  • Average drop size per visit
  • Van stock differences and cash differences per week
  • Returns and expiries as a share of sales, by item
  • Overdue receivables by route

These come from ERPNext reports and a dashboard. For the analysis side, see customer and product profitability and ABC analysis and dead stock.

Questions to ask before you choose a van sales system

  1. Can it run our real route, with our real signal, for a full day in a pilot?
  2. Does van stock post to the same inventory as the warehouse, or is it a separate app that syncs later?
  3. Are price lists, schemes and credit limits enforced on the device?
  4. Does the invoice meet VAT and e-invoicing rules in every country we sell in?
  5. Who supports it locally, and how quickly can a new van be added?

For a wider view of options, read our comparison of the best ERP for small business in the UAE and GCC and our guide to ERP for trading companies in the UAE.

Frequently asked questions

Does ERPNext have a van sales module?

ERPNext does not ship a module named van sales, but it has the building blocks: van warehouses, stock transfers, POS and sales invoices with stock update, pricing rules, credit limits and payment entries. A partner typically adds a load sheet, a mobile screen and a settlement report.

Can van salesmen use ERPNext offline?

The standard ERPNext POS works best online. For routes with weak signal, options include POS Awesome, which has offline features, or a custom mobile app. Test on your real routes before you commit.

How is van stock reconciled at the end of the day?

Compare opening stock plus loading minus sales plus returns with the physical count, transfer unsold stock back to the main warehouse, and post any difference as a stock adjustment under your policy.

Can the van print VAT invoices in Arabic and English?

Yes. ERPNext print formats can be bilingual and sized for portable printers. In Saudi Arabia invoices must be in Arabic and carry a QR code, and Phase 2 e-invoicing needs a ZATCA add-on app.

Do we need VAT in Qatar or Kuwait?

Qatar and Kuwait have no VAT in force at the time of writing, so invoices there carry no VAT. ERPNext can run those companies without tax templates and add them later if rules change.

How do we stop unauthorised discounts by salesmen?

Put all prices and schemes into price lists and pricing rules, restrict manual rate changes by role, and review an exceptions report of discounts and free items every day.

Every van, every route, one set of numbers

Nexeves Technologies implements ERPNext for FMCG, food and beverage distributors in the UAE, Saudi Arabia, Qatar, Kuwait, Bahrain and India, including van sales, VAT and credit control.

Book a free demo → WhatsApp us: +91 8089051848

Or email info@nexeves.com

Nexeves Technologies serves India & the GCC: UAE (Dubai, Abu Dhabi), Saudi Arabia (Riyadh, Jeddah), Qatar (Doha), Kuwait and Bahrain.


No comments yet.

Add a comment
Ctrl+Enter to add comment