B2B Wholesale & FMCG Van-Sales, Route Accounting & Distributor Management Systems (DMS): Credit Limits, Empty-Crate Tracking, and Trade Promotions

Why FMCG Manufacturers and Distributors Lose Millions in the Last Mile of Route Sales

If your company manufactures or distributes Fast-Moving Consumer Goods (FMCG)—such as bottled beverages, bread and bakery products, dairy, cooking oil, flour, cosmetics, hardware, or pharmaceuticals—through a fleet of 15 to 200+ Van-Sales Representatives and regional Key Distributors (KDs), your revenue is won or lost on the daily sales route. Yet in most distribution businesses, morning van-loading sheets, route invoices, trade bonus promotions (e.g., "Buy 10 cartons, get 1 carton free"), and evening unsorted cash/M-Pesa reconciliations are still managed on carbon-copy receipt books or disconnected mobile apps.

Without a unified Distributor Management System (DMS) & Van-Sales Route Accounting Engine, three chronic leaks erode your net margin every day: 1. Promotional & Price-Tier Manipulation—where a van-sales rep sells 50 cartons to ten different small kiosks at the full KES 1,200 retail price, but combines them on the evening handover sheet as a single "Wholesale Tier" sale at KES 1,080 (pocketing the KES 120/carton price differential and the free promotional bonus stock); 2. Unauthorized Credit Over-Extension—where reps continue dropping goods on credit to a retailer who already has three overdue invoices; and 3. Returnable Packaging Loss—where thousands of plastic bread/soda crates, glass bottles, or beer kegs never come back from the field. At devManue FMCG & Distribution ERP Engineering, we build custom Van-Sales, Pre-Sales Order Taking, and Distributor Management Systems on Python, Django, and PostgreSQL.

1. Core FMCG Van-Sales, Route Accounting & DMS Modules & Build Costs

Because FMCG distribution requires equipping dozens or hundreds of van drivers, motorbike reps, and stockist clerks, our zero-per-user license model saves $30,000+ per year compared to per-seat SaaS tools:

2. Enforcing Channel Pricing, Free-of-Charge (FOC) Promo Rules, and Credit Limits

In our Route Accounting architecture, a Van-Sales Representative cannot manually type or alter a unit price, nor can they manually award "free bonus cartons." Each registered retail outlet is geocoded and assigned to a verified ChannelTier (e.g., TIER_1_WHOLESALER vs. TIER_3_RETAIL_KIOSK). When the rep checks in within 100 meters of the shop and enters the quantities ordered, the engine automatically applies that outlet's locked price list, calculates any active promotional free-goods entitlement (and sends an instant SMS to the shop owner confirming the exact price and free goods they received!), and verifies the retailer's credit limit and oldest unpaid invoice age before printing the receipt:

# Production FMCG Route-Sales Pricing, FOC Promotion & Credit-Limit Guard in Django
from datetime import timedelta
from decimal import Decimal, ROUND_HALF_UP
from django.db import transaction
from django.core.exceptions import PermissionDenied
from django.utils import timezone
from .models import RetailOutlet, VanStockBin, TradePromoRule, RouteSalesInvoice

@transaction.atomic
def create_route_van_sale_invoice(
    van_id: int,
    outlet_id: int,
    payment_mode: str,  # "MPESA_INSTANT" or "CREDIT_INVOICE"
    cart_items: list[dict],
) -> RouteSalesInvoice:
    """
    Validates outlet credit limits & invoice aging, applies locked channel pricing
    and deterministic Free-of-Charge (FOC) promo entitlements, and deducts van stock.
    """
    q2 = lambda v: v.quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
    outlet = RetailOutlet.objects.select_for_update().get(id=outlet_id)

    invoice_total = Decimal("0.00")
    line_payloads = []

    for item in cart_items:
        sku = item["sku"]
        paid_qty = int(item["qty"])
        unit_price = outlet.price_tier.get_locked_price_for_sku(sku)
        line_amount = q2(Decimal(paid_qty) * unit_price)
        invoice_total += line_amount

        # Evaluate deterministic Free-of-Charge (FOC) Trade Promotion (e.g., Buy 10 Get 1 Free)
        promo = TradePromoRule.objects.filter(sku=sku, is_active=True).first()
        foc_bonus_qty = (paid_qty // promo.buy_qualifying_qty) * promo.free_bonus_qty if promo else 0
        total_physical_units_to_deduct = paid_qty + foc_bonus_qty

        van_bin = VanStockBin.objects.select_for_update().get(van_id=van_id, sku=sku)
        if van_bin.good_stock_qty < total_physical_units_to_deduct:
            raise PermissionDenied(
                f"Insufficient van stock for {sku}: need {total_physical_units_to_deduct} "
                f"({paid_qty} sold + {foc_bonus_qty} FOC), available {van_bin.good_stock_qty}."
            )
        van_bin.good_stock_qty -= total_physical_units_to_deduct
        van_bin.save(update_fields=["good_stock_qty", "updated_at"])

        line_payloads.append((sku, paid_qty, foc_bonus_qty, unit_price, line_amount))

    # Strict Credit-Limit & Overdue-Invoice Aging Guard for Credit Sales
    if payment_mode == "CREDIT_INVOICE":
        if outlet.current_credit_balance + invoice_total > outlet.approved_credit_limit:
            raise PermissionDenied(
                f"Credit Limit Exceeded for {outlet.shop_name}: "
                f"Balance + Order = KES {outlet.current_credit_balance + invoice_total:,.2f} "
                f"(Limit: KES {outlet.approved_credit_limit:,.2f})."
            )
        oldest_unpaid_cutoff = timezone.now().date() - timedelta(days=outlet.max_credit_days)
        if outlet.has_unpaid_invoices_older_than(oldest_unpaid_cutoff):
            raise PermissionDenied(
                f"Credit Frozen: {outlet.shop_name} has overdue invoices beyond {outlet.max_credit_days} days."
            )
        outlet.current_credit_balance += invoice_total
        outlet.save(update_fields=["current_credit_balance", "updated_at"])

    return RouteSalesInvoice.objects.create(
        van_id=van_id,
        outlet=outlet,
        payment_mode=payment_mode,
        total_amount_kes=invoice_total,
        line_items_json=line_payloads,
        status="ISSUED_PENDING_MPESA" if payment_mode == "MPESA_INSTANT" else "POSTED_TO_AR",
    )

3. Evening Van Settlement in 5 Minutes Instead of 3 Hours

When a sales van returns to the depot at 5:30 PM, the warehouse clerk counts the physical unsold stock and empty crates on the truck and enters those two numbers into the tablet. Because every sale, FOC bonus, and M-Pesa payment during the day was already reconciled in real time, the system prints the Driver Gate Clearance Certificate in 30 seconds—or immediately highlights any exact SKU or cash shortage to be deducted from the representative's commission account.

Need to scale background route-sync and eTIMS receipt workers? Size your worker queues with our Celery & Redis Worker Capacity Planner or book a 30-Minute FMCG Route Accounting Discovery Call.

4. Frequently Asked Questions (FAQ)